SQL for Data Analysis v1.0

This course will teach you how to use SQL, the industry-standard language for databases. Learn essential SQL skills for modern development and data analysis, enabling you to extract, manipulate, and analyze data effectively.

Course curriculum

1. SQL for Data Analysis Syllabus
1. SQL Tutorbot
1. 1.1 SQL Definition
2. 1.2 Importance of SQL
3. 1.3 Types of Databases
4. 1.4 SQL Standards
5. Test Your Knowledge
1. 2.1 Installing SQL Server / MySQL / PostgreSQL
2. 2.2 Configuring IDEs for SQL
3. 2.3 Connecting to Databases
4. Test Your Knowledge
1. 3.1 SELECT Statements
2. 3.1.1 Exercise
3. 3.2 Filtering Data with WHERE Clause
4. 3.2.1 Exercise
5. 3.3 Sorting Data with ORDER BY
6. 3.3.1 Exercise
7. 3.4 Limiting Results with LIMIT / OFFSET
8. 3.4.1 Exercise
9. Test Your Knowlegde (Update)
10. Practical Project: SELECT Statement with Sakila
1. 4.1 Advanced SQL Commands Aggregate Functions
2. 4.1.1 Exercise
3. 4.2 Grouping Data with GROUP BY
4. 4.3 Joining Tables
5. 4.3.1 Exercise - Basic JOINS
6. 4.3.2 Exercise - Multiple Table JOINS
7. 4.4 Subqueries
8. 4.5 Common Table Expressions (CTEs)
9. Test Your Knowledge
10. Practical Exercise - F1 Database Challenge
11. Practical Exercise - Solutions
12. Practical Project: Aggregations with Sakila
1. 5.1 Introduction to Database Design
2. 5.2 Entity-Relationship Model (ER Model)
3. 5.3 Normalization (1NF, 2NF, 3NF)
4. 5.4 Denormalization
5. 5.5 Keys (Primary, Foreign, Candidate)
6. Test Your Knowledge
1. 6.1 Creating Tables
2. 6.2 Altering Tables
3. 6.3 Dropping Tables in SQL
4. 6.4 Constraints (Primary Key, Foreign Key,Unique, Not Null)
5. 6.5 Indexes
6. Test Your Knowledge
7. Practical Exercise - Design a Relational Database
8. Practical Exercise - Solution
1. 7.1 INSERT Statement
2. 7.2 UPDATE Statement
3. 7.3 DELETE Statement
4. 7.4 Transactions and ACID Properties
5. Test Your Knowledge
6. Practical Exercise - Manage an Ecommerce Database
7. Practical Exercise - Solution
1. 8.1 GRANT Statement
2. 8.2 REVOKE Statement
3. 8.3 Roles and Privileges
4. Test Your Knowledge (Update)
5. Practical Exercise - Manage a Student Information System Database
6. Practical Exercise - Solution
1. 9.1 Creating Views
2. 9.2 Indexes for Performance Optimisation
3. 9.3 Stored Procedures
4. 9.4 User-Defined Functions
5. Test Your Knowledge
6. Practical Exercise - Manipulate a Student Information System Database
7. Practical Exercise - Solution
1. 10.1 Triggers
2. 10.2 Cursors
3. 10.3 Dynamic SQL
4. 10.4 Handling Errors
5. 10.5 Performance Optimisation Techniques
6. Test Your Knowledge
7. Practical Exercise - Advanced Database Operations
8. Practical Exercise - Solution
1. 11.1 SQL in Web Development (Integration with Python)
2. 11.2 Security Best Practices
3. 11.3 Backup & Recovery Strategies
4. 11.4 Scaling Databases
5. Test Your Knowledge
1. 12.1 Building a Simple Database Application for Data Analysis
2. 12.2 Analysing and Optimising Queries
3. 12.3 Designing a Database Schema for a Real-world Scenario
4. Test Your Knowledge
1. 13.1 Final Assessment and Certification
2. 13.2 SQLite Data Analysis Practice
1. Capstone Project : SQL Basics with Sakila
2. Capstone Project : Using DS3 Database
3. Capstone Project : Using Sakila Database
1. Select & From
2. WHERE, ORDER BY, GROUP BY & LIMIT
3. HAVING
4. JOINS
5. Date & Time Functions
6. String & Mathematical Functions
1. Course Feedback Form

About this course

96 lessons
10 Hours of video content

ITonlinelearning Academy

SQL for Data Analysis v1.0

Course curriculum

Course Syllabus

Tutorbot

Module 1

Module 2

Module 3

Module 4

Module 5

Module 6

Module 7

Module 8

Module 9

Module 10

Module 11

Module 12

Module 13

Capstone Project

SQL Syntax Explainers

Course Feedback

About this course

Discover your potential, starting today