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.
Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.
• 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
This course is part of the BI Essentials for Finance Analysts (Power BI Edition) Specialization.
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