Complete SQL Training & Certification

Explore basic SQL concepts, including statements, tables, fields, rows, constraints, and key operations like select and delete, plus views, joins, procedures, triggers, and functions.

Master sql data types and literals by exploring numeric, string, and date/time categories, with examples like int, varchar, blob, date, and timestamp.

Explore arithmetic, comparison, logical, and bitwise operators in SQL through hands-on examples with real-time data, including date div, current date, round, and pattern matching.

Explore the five types of SQL statements—DDL, DML, DQL, DCL, and TCL—and learn the commands to create, modify, query, grant, revoke, and manage transactions.

Learn to create databases and tables in SQL using create syntax and MySQL Workbench, define structure with data types, columns, and constraints, and describe tables to view schema.

Master the alter table command to add, drop, or modify columns and constraints, rename tables or columns, and apply changes with practical MySQL workbench examples using a student data table.

Explore the difference between truncate and drop in SQL, showing how truncate removes data while preserving table structure, and how drop completely removes tables or databases.

Explore SQL constraints and learn to apply not null, default, unique, check, primary key, and foreign key rules, including composite keys, to ensure data integrity.

Learn how indexes speed up data retrieval by locating rows quickly on large tables. Create or drop indexes on columns used for retrieval or joins, and avoid columns with nulls.

Insert data into tables using three methods: full-column inserts, selective-column inserts, and multi-record inserts. Demonstrate these techniques in MySQL Workbench with practical examples.

Learn how to update existing data with the SQL update command, using where conditions to target single or multiple records, and how to add new columns with alter table.

Use the delete command to remove specific records with a where clause from a table. Compare delete with truncate and drop, and learn about rollback, triggers, and performance.

Master the MySQL select statement to fetch data from a table, selecting specific columns or all fields with star. Use the employee table to show region, branch, and distinct results.

Filter records with the where clause in a select statement, using conditions on department, salary, region, and hire date in MySQL, and learn about operators and multiple conditions.

Learn to use group by and having with aggregate functions to summarize data by region or department, including joining tables and filtering with having conditions.

Learn how to use the order by clause with select statements to sort data ascending or descending across single or multiple columns, with where, group by, having, and year-based insights.

Learn how to grant and revoke permissions in sql to manage user privileges on tables, views, and other database objects, create users, and review grants with show grants.

Withdraw specific or all privileges using the data control language revoke command in MySQL, learning how to revoke from a user and verify grants with show grants.

Define a transaction as a unit of DML statements that must all succeed or all fail, and demonstrate commit, rollback, save point, start transaction, and auto commit in MySQL workbench.

Use the rollback command in MySQL workbench to revert a transaction, undoing inserts, updates, and deletes before committing. Note that once committed, rollback cannot affect those changes.

Learn how savepoints divide a transaction into units, enabling rollback to a specific point without undoing earlier commands, with hands-on MySQL examples of start transaction, insert, update, delete, and commit.

Discover how subqueries work in SQL, including inner and outer queries, their rules and operators, and how to nest them in select, insert, update, and delete statements.

Explore set operators in MySQL, including union, union all, intersect, and except (oracle uses minus), to combine query results, remove duplicates, and identify common or unique rows.