Learn how to use the where clause in select statements to filter data with conditions, using the equal operator, and explore practical examples like country and city filters.

Learn how to use logical operators in sql queries to filter data by combining multiple conditions with and, or, not, illustrated with country and city examples to narrow results.

Learn how to use the between operator in SQL to filter records within a range, such as ages 50 to 60 or prices 10 to 30, including not between alternatives.

Sort sql query results using the order by clause with ascending and descending options. Practice multi-column sorting on country and city using ASC and DESC.

Master the like operator and wildcard characters in SQL to perform pattern matching with underscore and percent, enabling starts with, ends with, and contains queries.

Learn to use the AS keyword to alias table column names in SQL queries, including multi-word labels with brackets, without altering the underlying data.

Learn how to use the upper function in MySQL to convert text to uppercase, apply it to table columns, and alias results for clear display.

Explore how the substr function in MySQL extracts a portion of text from strings or table columns by specifying a start position and length, including negative positions.

Learn how to use the concat() function in MySQL to combine first name and last name into a full name, including spaces, and display the full name.

Learn how to use the trim function in MySQL to remove leading and trailing spaces, and see its effect on length and data quality.

Learn how the abs() function in MySQL returns the absolute value of a number, turning negative prices into positive values and applying to numeric columns.

Learn how to use MySQL date and time functions, including current_date, curdate, current_time, curtime, now, and sysdate, and understand how time zones influence server versus local times.

Explore how avg, max, min, count, and sum as MySQL aggregate functions operate across all records, using a price example to calculate minimum, maximum, average, total, and count.

learn to update table records using the update statement and set keyword, applying changes to specific rows via conditions or to all rows when no condition is provided.

Compare delete from and truncate table; delete may remove specific rows and is reversible in transactions, while truncate permanently deletes all rows. Understand autocommit implications in deletions.

Learn to use the group by clause to group records, apply aggregates like count and sum, and generate summaries such as country counts by continent.

Explore set operators in SQL, including union, union all, intersect, and minus, to combine results from multiple select statements across two tables.

Explore SQL subqueries, including single-row subqueries, and see how inner queries feed results into outer queries with practical examples like finding customers from the same city.

Learn how to use the ALL operator in a multi-row subquery, contrasting it with ANY, and apply it to filter records with multiple conditions in SQL.

Learn to use multiple subqueries in a single SQL statement to solve problems by extracting records based on maximum and minimum values, with practical film-table examples.

Learn how integrity constraints enforce data validity in SQL by applying not null, unique, primary key, foreign key, and check rules to table columns during creation and insertion.

Discover the not null integrity constraint in sql, showing how it prevents inserting null values and demonstrates insert behavior with a sample table.

Explore how check constraints enforce data rules on columns, such as experience greater than five or location in (India, USA, UK), by creating tables, defining check conditions, and validating inserts.

Demonstrates how the default integrity constraint auto-fills a column with a predefined value when no data is inserted, using table examples like experience, country, and joining date.

Use the as keyword to create a new table from an existing one, copying all records and columns, or selecting only specific columns for a partial copy.

Learn to use the IfNull function in SQL to replace null salaries with zero and perform arithmetic safely in select and insert operations.

Learn to use the case, when, then, and end keywords to build conditional logic in SQL select statements, with practical examples using product names and prices.

Explore how delimiters govern stored procedures in SQL, showing how to replace semicolons with double slashes, define and call procedures and functions, and manage begin end blocks.

Learn how indexes speed up data retrieval by indexing table columns, see practical demonstrations of creating and using indexes, including automatic indexes for primary keys and unique columns.

Use the default Windows command prompt to connect to a MySQL server, log in, select a database, view tables, and perform create, insert, and update operations on tables.

The lecture outlines five types of SQL statements, explains data manipulation language, data definition language, transaction control language, and data control language, with examples like select, create, rollback, and grant.

Learn how to use grant and revoke statements to manage database permissions in mysql workbench, granting select, insert, update, and delete rights on specific tables or databases, including multi-user grants.

Explore how to use wild cards as normal characters in sql, including underscores and percent, and learn escaping rules with backslashes and dollars to match literal values in queries.

Learn to use Putty to connect from a Windows laptop to a remote Linux machine with a MySQL server, then perform SQL operations remotely.