SQL Made Easy for Beginners

Practice SQL without installing software using online W3Schools databases, querying preloaded tables like customers, orders, and products, and resetting data with a backup.

Learn how the select command in SQL made easy for beginners retrieves data from a table, using all columns or specific columns such as customer name, city, and postal code.

Explore using the distinct keyword in SQL to retrieve unique values from one or more columns, such as country or country and postal code, by applying select distinct from customers.

Learn that SQL is not case sensitive; practice select statements across lowercase, uppercase, and mixed case, and still get the same results from the table.

Discuss when to end SQL statements with a semicolon, why it’s optional or mandatory across different RDBMS, and how semicolons separate multiple statements.

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.

Explore how to use relational operators in a where clause to filter data, including =, >, <, >=, <=, and not equal, with price examples from a products table.

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.

Discover how to use the between operator with numbers and with text, including inclusive endpoints and ascending order. See practical examples with country names and not between to exclude values.

Learn how to use the in operator to simplify SQL queries by listing multiple values for the same column, reducing repetitive conditions and clarifying filters.

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 the limit keyword improves performance by restricting the number of records in select statements, using practical examples on large tables to display a subset on a page.

Learn why and how to break lengthy sql statements into multiple lines to improve readability, with practical examples using select from customers, country, city, and limit clauses.

Discover MySQL built-in functions across string, numeric, date and time, and aggregate categories, and learn how scalar and aggregate functions power SQL statements.

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 lower function converts text to lowercase across string data in MySQL, with practical examples on selecting and aliasing columns, and applying it to multiple fields.

Learn how to use the length function in MySQL to measure string length and apply it in select statements with practical name and country examples.

Learn how the MySQL instr string function finds the position of a substring within text, with examples on country names and first names, including using column aliases and select statements.

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 the mod() function in MySQL to compute remainders, demonstrated with a numeric column and examples like 9 mod 3 equals 0.

Discover how to use greatest and least in MySQL to extract the maximum and minimum from numeric and string data. Explore practical examples with lists of numbers and alphabetical order.

Explore the truncate() function in MySQL's numeric functions, learning how to limit decimals, handle negative digits, and apply precise decimal places to numeric data.

Explore MySQL numeric functions, including power() and sqrt(), and learn how to apply them in select statements to perform exponentiation and square roots.

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 MySQL date time functions year(), month(), day, monthname(), and dayname() with practical demos on sample statements and an employees table.

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.

Explore arithmetic operators in SQL, including plus, minus, multiply, divide, and modulus, and see how to compute expressions in select statements on tables like price.

Install MySQL server and MySQL Workbench on a Windows machine to practice SQL, connect the Workbench to the local server, and run basic queries.

Learn to create, delete, view, and use databases in sql, including creating new databases, dropping existing ones, show databases, and using a selected database.

Learn to create, view, describe, and delete tables in a database, including defining columns such as id, name, and experience, and inspecting table schemas.

Learn how to insert data into tables using insert into statements, including inserting into specific columns (id, name, experience) with values and handling nulls.

Explore how to use data types in SQL create table statements, covering text, numeric, boolean, and date/time types, column constraints, and data insertion rules.

Learn how null values occur in SQL, and how to use is null and is not null operators to filter records with null or non-null experience.

Learn how to delete records from a table using the SQL delete statement, with and without where clauses, and understand how it empties a table while preserving its structure.

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.

Learn how to rename a table using the rename statement and to keyword, with practical demos renaming a table from employees to Emv and exploring related commands.

Master the alter statement to add, modify, rename, and drop columns, and use describe to inspect table structure, with practical examples on a sample employees table.

Discover how set autocommit controls when inserts become permanent, and learn to view tables, insert records, and toggle autocommit on or off to manage persistent versus temporary changes.

The lecture explains how to use a commit statement and how automatic and manual commits control temporary versus permanent changes in database tables.

Learn how the rollback statement undoes temporary changes on a table, restoring it to its original state. Understand when rollbacks work and why permanent changes cannot be reversed.

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 how to use single line and multi-line comments in SQL statements, and understand their purpose for explaining underlying statements.

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.

Learn how to use the having clause with group by to filter aggregated results, with examples like counting countries per continent.

Demonstrate the SQL clause order: where, group by, having, then order by. Illustrate with a country table, filter by area, group by continent, apply having, and sort by count.

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

Learn how the union operator in SQL combines two tables, eliminates duplicates, and how to align column counts and names when using union across multiple selects.

Learn how to use union and union all in SQL for beginners, understand when duplicates are eliminated, and compare set operators through practical examples.

Learn how the intersect operator finds common records between two tables, using a practical example with an id column, and compare it with union and minus in SQL.

Explore the minus operator in SQL, its behavior across set operations, and why it’s not supported by MySQL, with practical workarounds and examples.

Learn to use table aliases to simplify queries and join data across multiple tables. Practice referencing aliased columns to resolve ambiguity and retrieve last names efficiently.

Master how to use joins to combine data from two tables, including inner, left, right, full, and self joins, with examples. See when joins retrieve records via a common column.

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 the in operator in SQL helps beginners filter rows by multiple values, such as selecting customers from USA, UK, France, and Spain.

Learn to use the in operator with a multi-row subquery to filter products by category, handling single and multiple row results across two tables.

Explore how to use the any operator in a multi-row subquery to compare a value against all results, with practical sql examples and guidance.

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 how to use the exists operator with subqueries to filter results, and see practical demonstrations with customers and orders to illustrate true versus false outcomes.

Use subqueries to retrieve records from two tables with a common column, such as city and country, and learn how to handle one-to-many relationships where a country has many cities.

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 the unique integrity constraint in SQL, showing how unique keys prevent duplicates, enforce single and multi-column uniqueness, with practical table examples and insert outcomes.

Explore the primary key integrity constraint, combining not null and unique rules, including composite keys, and learn how inserts enforce values, prevent duplicates, and handle nulls.

Learn how foreign keys enforce referential integrity between a parent and child table, using a common column and primary key, with insert rules and on delete cascade.

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.

Explore how the auto_increment keyword automatically advances a table's id column by one with each insert, starting from a defined value and ensuring unique primary keys.

Learn how to use insert into to copy records from one table to another, create new tables, and copy specific columns by selecting data from the source table.

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.

Discover what a delimiter is, why the semicolon is the default, and how to change it to symbols such as the double slash for scripts and stored procedures.

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.

Discover how to use SQL views to display data from one or multiple tables without creating new tables, and see how underlying table changes reflect in the view.

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.

Connect to a MySQL database from Java programs using JDBC, and learn to set up Java, Eclipse, and MySQL Workbench, create tables, and perform select, insert, update, and delete operations.

Explore connecting to MySQL databases via ODBC and JDBC, configure DSN data sources, install drivers, and run SQL operations on tables from Java and SQL tools.

Learn to connect to a MySQL database via the MySQL shell command line, switch to sql mode, and manage databases, tables, and simple queries.

Learn to connect to MySQL databases via the command line client, navigate databases and tables, and perform SQL operations using the MySQL command line and related tools.

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.

Learn to create and manage temporary tables in SQL, including session-based lifetimes. Understand how temporary tables differ from permanent ones and how to insert and query data in a session.

Learn to use show statements such as show databases, show tables, show columns, show indexes, show privileges, and show grants to inspect databases, tables, and user permissions.

Master how to insert null values in sql by omitting values or explicitly using null, with practical examples of inserting into single or multiple columns.

Apply the trim function to remove leading and trailing spaces and corner characters from table column values, with practical examples on single-column and multi-column tables.

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.

Explore database objects and learn how to create them with SQL create statements, including tables, views, indexes, and stored procedures, with practical examples across a database.

Learn how to create a Linux virtual machine on a Windows host using VirtualBox, install Ubuntu, and prepare for MySQL installation inside the virtual environment.

Learn to install and secure MySQL on a Linux Ubuntu machine, connect as root, create databases and tables, and perform basic data operations from the Linux environment.

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