SQL Essentials: The Beginner’s Guide to SQL Language

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

Created by: Vlad Burmistrov
Instructor for Data Analytics

What Will I 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

Requirements

• No prior knowledge/experience is required. Only your desire to learn.
• A PC/Laptop for lab exercises: Windows or MacOS
• No licenses: all the software we use is free

Target audience

• Data Analysts
• Data Scientists
• Data Engineers
• Database / Datawarehouse Developers and Designers
• Software Quality Engineers