Learn the basics of databases, tables, and records, and how SQL enables querying, inserting, updating, and deleting data across multiple tables.

Connect to the MySQL server using the workbench, explore the world database and its city table, and write SQL queries to retrieve data.

Create a database using SQL commands, then set up and test tables in a SQL workbench, verify creation via logs, and prepare data testing for the new database.

Point to a database with use command, then create a table employee info with columns name, id, location, and age, using varchar for names and integers for id and age.

Explore SQL table schema using describe, learn about data types and constraints such as not null and default values, and insert records with correct quotes for testing.

Learn to add and modify a table column using SQL by altering the employee info table to include gender, changing data types, and observing effects like zero rows affected.

Drop a column from a table using alter table and verify the deletion with describe, while noting that DDL alters schema, not data.

Learn how to update data in a table using the sql update command, including setting a column value and using where clauses to target rows such as name = Sam.

Learn to delete rows with where conditions, update data, and modify table structures using drop, alter, and drop database commands, and use a sample database.

Discover how to use the select statement to retrieve data, choose specific columns or all columns, and apply distinct to get unique names from the employee info table.

Explore sql logical operators and or, learn to use brackets for correct precedence, and apply the in operator to filter by age ranges and locations.

Master the between and not between SQL operators to filter data, using age and id ranges and the in operator for concise, efficient queries.

Discover essential SQL operators such as where, and, or, in, between, not, and group by, plus the basics of regular expressions using percentile and underscore for pattern matching.

Explore wildcards in SQL using the like operator with percent and underscore, applying simple regular expression patterns to filter city and country data by starting or specific letter positions.

Learn how group by and aggregate functions in SQL consolidate transactions by month, calculating monthly totals and understanding group-based results through practical examples.

Master SQL querying with practical exercises on group by, where, having, and aggregate functions to analyze February branch transactions and identify totals above 4000.

Learn to use subqueries to fetch ages by location across the citizens and citizen location tables, using a common column like name.

Discover how joins merge two tables on a common column to produce a single table, enabling a single query instead of multiple subqueries.

Learn to join two tables, citizens and citizen location, on the name column. Select name, location, and age using aliases like c and c1, and note that joins outperform subqueries.

Learn how to join two tables and use group by and having to compute the total employee count for companies established in 1990.

Demonstrate how inner, left, and right joins connect student details with exam results by ID, showing how a left join returns all appeared students with null grades.

Explore SQL string functions including replace, length, trim, substring and concatenate, with practical examples; compare top and limit for retrieving rows across SQL Server and MySQL.

Explore string functions in SQL, including length and trim, with practical examples like select length(name) from company and trim of spaces; compare top and limit across SQL Server and MySQL.