Description


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.

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.




In this course, you will:


Learn the ins and outs of SQL syntax


Generate reports using sales and user data


Analyze data using Aggregate Functions


Run complex queries using MySQL logical operators and string functions


Write all the common SQL joins


Work with large datasets containing thousands of entries


Design and implement complex database schemas


Write Javascript code to generate fake data sets


Get started with PostgreSQL and PgAdmin , two of the world's most popular SQL tools


Learn the basics of SQL syntax


And more!


Enroll