Learn how to use SQL quickly and effectively with this course! You'll learn how to read and write complex queries to a database using one of the most in demand skills - PostgreSQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more.

If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but comprehensive introduction to MySQL, one of the most highly in-demand skills in the business sector today.

If you need to understand how to query relational databases, this Learning Path will get you up and running quickly. Commands, joins, and views are the most fundamental elements of SQL (Structured Query Language) and with them you can make powerful insights into your data. In the just an hour and a half, you will learn how to use SQL to manage data that is held in relational databases. This Learning Path is designed for beginners who have no previous experience with SQL of any kind. Working files are included, allowing you to follow along with the instructor.

Extract, Transform, and Load (ETL) processes have become a necessity in IT today. Being able to move data from one place to another has become a cornerstone in just about every company worldwide. SQL Server 2016 provides Integration Services (SSIS) that allow database administrators (DBAs) and developers alike to create and deploy advanced ETL packages to leverage the data within their organizations.

Introduced as part of Oracle 12, Oracle JSON SQL makes it possible to convert the JSON data world of keys and values into the relational data world of columns and rows. At its core, this course teaches you how to use Oracle JSON SQL.

Apache Kudu is a required skill in the Big Data world because it addresses problems that are difficult or impossible to implement on current generation Hadoop storage technologies. Big data developers, architects, and engineers looking to add this skill can do so with this easy to understand hands-on exploration of Kudu's basics.

Business users and analysts want quick, practical knowledge. Regarding SQL and database topics, they are more interested in how to use data rather than create it (this means the SELECT statement is highly relevant to them). As they progress they will likely want to know how to create their own databases, but only to a certain extent. The business logic of database design is likely what they are interested in. They may want to understand basic table design principles and a high-level understanding of normalization. But security, administration, data theory, and other DBA/engineering tasks will likely not be relevant to them. Typically when business users prototype a database for their business needs, they might hand it off to a DBA to put in production if it is deemed critical for the business.