SQL Fundamentals for Data Analysts

Overview

Class Central Tips

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

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.