The Complete SQL Course: From Zero to Data Analyst

Explore the fundamental database structure, including tables, rows, and columns; create a simple customers table with a primary key, and perform insert and select queries.

Create your first sql query in sql server management studio by defining an employees table with employee_id as primary key, and name, department, and salary decimal, then query the data.

Create a simple employees table with a primary key, then use select, insert, update, and delete to manage data with sql.

Learn how SQL data types define column values from integer and text to decimal, date, and binary, using customer, product, and orders tables as examples.

Explore how to sort data in sql with order by, including ascending salary, descending names, and multi-column sorts by department and salary. See practical examples using the employees table.

Learn how to limit query results in MySQL with limit and in PostgreSQL with fetch first, including skipping rows and retrieving the next set.

Learn to create a table, insert data, and use aggregate functions—count, sum, avg, min, max—to analyze orders, calculate total revenue, and determine average order value.

Group and summarize sales data by product and by customer using group by, calculating total quantity sold and total revenue, and filter groups with having revenue greater than 3000.

Create two sql tables, customers and orders, and practice inserting data. Master inner, left, right, and full outer joins, including join on multiple conditions.

Design and optimize a relational database schema by implementing one-to-one, one-to-many, and many-to-many relationships with primary and foreign keys, including data across users, profiles, customers, orders, and enrollment bridge table.

Learn to define primary keys, foreign keys, and one-to-many relationships by creating customer and order tables and linking them.

Learn how database normalization improves data integrity by applying 1NF, 2NF, and 3NF to separate orders, order details, products, customers, and locations.

Create, modify, and delete databases and tables using Server Management Studio, including creating a database, creating a table, inserting data, altering tables to add columns, and dropping objects.

Enforce data integrity in SQL by applying not null, unique, and check constraints on a customers table, including primary key, email uniqueness, and age validation.

Learn how indexing improves SQL performance by creating and dropping indexes on the orders table, including primary key automatic indexing, and reducing full table scans.

Learn to create and manage SQL views (virtual tables) to filter IT department data from the employees table, apply a 10% salary increase, and drop views.

Explore stored procedures and functions in SQL Server, including creating tables and inserting data; learn to execute pre-compiled SQL blocks, use parameters, return values to boost performance and code reuse.

Explore triggers and events in SQL, including after insert triggers, alter and instead of triggers, and salary change auditing to automatically track salary updates.

Explore differences among MySQL, PostgreSQL, SQL Server, and SQLite, highlighting open-source roots, use cases, and features like auto-increment primary keys and advanced data types.

Demonstrates connecting a SQL server with Python using iodbc and pyodbc, creating a connection, and executing a table creation with commit.

Learn to connect SQL Server with Tableau and Power BI, query employee data, create charts, and build interactive dashboards for department insights and salary analysis.