SQL Essentials: The Beginner's Guide to SQL Language

SQL Essentials: The Beginner's Guide to SQL Language

The course has everything you need to start writing your own SQL queries.

Why learn SQL? Short answer is - if you know SQL well, you'll always be able to find a job! That's because it is used in a variety of different job roles:

- Data Analysts

- Data Scientists, Data Engineers

- Database / Datawarehouse Developers and Designers

- Software Quality Assurance Engineers

- And more!

The SQL language seems simple - and that's true. However, some topics can cause mistakes - things like NULL values, duplicate rows and missing rows, etc. This course covers the frequent mistakes, and how to avoid them.

You will learn SQL syntax applicable to most relational databases.  In the practice exercises you will use PostgreSQL, but the knowledge is easily transferable to other databases: PostgreSQL, Oracle, Microsoft SQL Server, MySQL, Teradata and so on.  The standard SQL is the same in all ANSI-compliant SQL databases.

Why this course? Because it was made based on the author's experience from the industry - so the course focuses on the topics and features that are really used on a day-to-day basis for data analysis.

Features:

- High-quality video lectures

- English subtitles (closed captions) hand-made for you (NOT auto-generated)

- Practice tests

- Practice exercises to test and enhance your knowledge (with explained solutions)

- And more!

I'll be happy to see you inside the course. Check out the free preview videos for more information!  

For any database: Oracle, MySQL, Microsoft SQL Server, PostgreSQL, Teradata, Google BigQuery, Spark SQL, Snowflake, etc.

Url: View Details

What you will learn

• Write SELECT queries for relational databases.
• Use SQL for data analysis
• Avoid common errors

Rating: 4.2

Level: Beginner Level

Duration: 7 hours

Instructor: Vlad Burmistrov