The Complete SQL Bootcamp for Data Analysis – Level 2

Learn SQL A-to-Z for Data Analysis Projects

Data is Everywhere

What you’ll learn

  • Use SQL to query data in databases.
  • Perform data analysis and extract useful insights.
  • Combine Data from Multiple Tables.
  • Filter Data using Subqueries.
  • Perform Data Transformation using CASE statements.
  • Utilize Window Functions for data analysis.
  • Simplify Queries using Views and CTEs.

Course Content

  • Getting Started –> 4 lectures • 22min.
  • SQL – Combining Data from Multiple Tables –> 5 lectures • 24min.
  • SQL – Subqueries –> 5 lectures • 20min.
  • SQL – Conditional Logic (CASE) –> 3 lectures • 11min.
  • SQL – Window Functions –> 4 lectures • 11min.
  • SQL – Simplify Queries (Views, CTEs) –> 3 lectures • 10min.
  • Course Summary –> 2 lectures • 6min.

Auto Draft

Requirements

Data is Everywhere

It is not a secret that data is everywhere; data is collected, processed, and accumulated in massive databases across all industry domains. As the technologies for handling data are evolving rapidly, the industry challenge is more focused on data utilization than data collection and storage. As a result, many organizations are looking for the right mix of people, tools, and products to help them pick up those piles of data, extract valuable insights and constantly gain market advantage.

Becoming an SQL Wizard

SQL is the most popular language to extract, load, and query data from databases. If you master SQL, you gain the amazing and useful flexibility to explore, filter and aggregate almost any raw data in multiple dimensions. SQL Wizards are needed everywhere.

Level 2

The complete training program is divided into multiple sequential levels to let you grow your knowledge and understanding of SQL and data analysis.

Level 2 is a direct continuum of the topics we learned in level 1. It will extend your knowledge into more advanced SQL tools and capabilities. We will learn to combine data from multiple data sources, break complex queries into sub-queries, transform and classify data, analyze data with window functions, create views, CTEs, and more.

We will use quizzes and exercises to practice and sharpen your understanding of the learning objectives. In any case, I am here for any questions.

I wish you AWESOME learning and hope to see you inside!

Get Tutorial