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
Overview
Syllabus
- 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
Taught by
CFI (Corporate Finance Institute)
