SQL Essentials (SQL01)

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 Essentials Syllabus
1. SQL Tutorbot
1. Lesson 1 - SQL Definition
2. Lesson 2 - Importance of SQL
3. Lesson 3 - Types of Databases
4. Lesson 4 - SQL Standards
5. Test Your Knowledge
1. Lesson 1 - Installing SQL Server / MySQL / PostgreSQL
2. Lesson 2 - Configuring IDEs for SQL
3. Lesson 3 - Connecting to Databases
4. Test Your Knowledge
1. Lesson 1 - SELECT Statements
2. Lesson 2 - Filtering Data with WHERE Clause
3. Lesson 3 - Sorting Data with ORDER BY
4. Lesson 4 - Limiting Results with LIMIT / OFFSET
5. Test Your Knowledge
1. Lesson 1 - Advanced SQL Commands Aggregate Functions
2. Lesson 2 - Grouping Data with GROUP BY
3. Lesson 3 - Joining Tables
4. Lesson 4 - Subqueries
5. Lesson 5 - Common Table Expressions (CTEs)
6. Test Your Knowledge
7. Practical Exercise - F1 Database Challenge
8. Practical Exercise - Solutions
1. Lesson 1 - Introduction to Database Design
2. Lesson 2 - Entity-Relationship Model (ER Model)
3. Lesson 3 - Normalization (1NF, 2NF, 3NF)
4. Lesson 4 - Denormalization
5. Lesson 5 - Keys (Primary, Foreign, Candidate)
6. Test Your Knowledge
1. Lesson 1 - Creating Tables
2. Lesson 2 - Altering Tables
3. Lesson 3 - Dropping Tables in SQL
4. Lesson 4 - Constraints (Primary Key, Foreign Key,Unique, Not Null)
5. Lesson 5 - Indexes
6. Test Your Knowledge
7. Practical Exercise - Design a Relational Database
8. Practical Exercise - Solution
1. Lesson 1 - INSERT Statement
2. Lesson 2 - UPDATE Statement
3. Lesson 3 - DELETE Statement
4. Lesson 4 - Transactions and ACID Properties
5. Test Your Knowledge
6. Practical Exercise - Manage an Ecommerce Database
7. Practical Exercise - Solution
1. Lesson 1 - GRANT Statement
2. Lesson 2 - REVOKE Statement
3. Lesson 3 - Roles and Privileges
4. Test Your Knowledge
5. Practical Exercise - Manage a Student Information System Database
6. Practical Exercise - Solution
1. Lesson 1 - Creating Views
2. Lesson 2 - Indexes for Performance Optimisation
3. Lesson 3 - Stored Procedures
4. Lesson 4 - User-Defined Functions
5. Test Your Knowledge
6. Practical Exercise - Manipulate a Student Information System Database
7. Practical Exercise - Solution
1. Lesson 1 - Triggers
2. Lesson 2 - Cursors
3. Lesson 3 - Dynamic SQL
4. Lesson 4 - Handling Errors
5. Lesson 5 - Performance Optimisation Techniques
6. Test Your Knowledge
7. Practical Exercise - Advanced Database Operations
8. Practical Exercise - Solution
1. Lesson 1 - SQL in Web Development (Integration with Python)
2. Lesson 2 - Security Best Practices
3. Lesson 3 - Backup & Recovery Strategies
4. Lesson 4 - Scaling Databases
5. Test Your Knowledge
1. Lesson 1 - Building a Simple Database Application for Data Analysis
2. Lesson 2 - Analysing and Optimising Queries
3. Lesson 3 - Designing a Database Schema for a Real-world Scenario
4. Test Your Knowledge
1. Lesson 1 - Final Assessment and Certification
2. Lesson 2 - SQLite Data Analysis Practice
1. Course Feedback Form

About this course

78 lessons
10 Hours of video content

ITonlinelearning Academy

SQL Essentials (SQL01)

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

Course Feedback

About this course

Discover your potential, starting today