What you'll learn:
- Write SELECT queries for relational databases.
- Use SQL for data analysis
- Avoid common errors
- Be comfortable putting SQL on your resume
- Write complex SQL queries, getting data from multiple tables
- Aggregate data using GROUP BY
- Lead your way in the database world
- Enhance your SQL skills, filling any gaps you might have
The course has everything you need to start writing your own SQLqueries.
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 SQLlanguage seems simple - and that's true. However, some topics can cause mistakes - things like NULLvalues, duplicate rows and missing rows, etc. This course covers the frequent mistakes, and how to avoid them.
You will learn SQLsyntax 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 SQLdatabases.
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!
