SQL Fundamentals for Data Analysts

Focus on the skills you need to get started with SQL as a data analyst, allowing you to read & transform data and gather insights from a company database. • Learn the basic SQL syntax that will help you access a whole new world of data. • Focus on the read-only functionality that matters for a data analyst, and get to insights quickly. • Perform the basics of data sorting, filtering, and aggregation in SQL to start uncovering valuable insights • Solidify your understanding through real-world scenarios, applying your newfound SQL skills in a variety of practical exercises

• Getting Started
• Welcome to the SQL Fundamentals course.
• Basic SQL Queries
• In this module, we will learn to retrieve and filter data using basic SQL queries.
• Manipulating Values with Functions
• In this module, we will learn manipulate data with the help of numerical date and text functions.
• SQL Theory
• In this module, we will learn the difference between OLTP and data warehouse and also understand the essential terminology related to SQL.
• Working with Multiple Tables
• In this module, we will learn to combine data from multiple tables using a single query. Additionally, we will understand how SQL databases deal with many-to-many relationships.
• Advanced Functions and Queries
• In this module, we will learn how to use SQL in popular BI tools and create summary reports using advanced functions.
• Qualified Assessment