Udemy – Practical SQL For Data Analysis 2024-11

Updated August 10, 2026 3.4 GB

Download

About this item

Description

Practical SQL For Data Analysis. This course teaches data analysts and technology enthusiasts the essential skills to work with relational databases. The course begins with a foundation in data modeling and key concepts such as primary and foreign keys. Participants then learn how to create databases and manage tables using tools such as MySQL Workbench, including data types, null values, and default constraints. It then covers relationships between tables, including one-to-one, one-to-many, and many-to-many relationships, and introduces more advanced techniques such as cascading updates and deletes to automate relationship management. The course emphasizes mastering the core commands, including INSERT, SELECT, UPDATE, and DELETE, for efficient data manipulation and retrieval. It also teaches how to create and manage clustered and nonclustered indexes to improve performance. Participants’ skills will be enhanced by learning about Views to simplify analysis, Triggers to automate actions, as well as creating stored procedures and scheduling events. Finally, the course concludes with advanced techniques for extracting insights from data using SQL, preparing participants to design, manage, and analyze databases and pursue a successful career in the data field.

What you will learn

Database modeling.
Understand the concepts of Primary Key and Foreign Key.
Creating databases using MYSQL Workbench and Query.
Create and manage tables – data type, length, Null and Default constraints.
Create and manage table relationships – one-to-many, one-to-one, and many-to-many relationships.
The concept of cascading update and cascading delete.
Working with data – Insert, Select, Update, Delete commands.
Create and manage indexes – Clustered Index and Non-Clustered Index.
Create and manage views.
Create and manage triggers.
Create and manage stored procedures.
Create and manage events.
Data analysis using SQL.

This course is suitable for people who:

For data analysts and aspiring data scientists looking for a solid foundation in SQL.
This course is also suitable for software and data engineers who need a deeper knowledge of SQL.