The SQL Programming Essentials Immersive Training

Outline sql statement types: dml (select, delete), ddl (create, alter, drop), dcl (grant, revoke), and tcl (begin, commit, rollback); cover semicolon use and comments (## single-line, /* ... */ multi-line).

Explore how to use the select statement to retrieve data from a database or table. Learn to select one or more columns and view the result set.

Learn to use the select statement in SQL, retrieving all data with * and selecting specific columns like name and country from the seller table, with outputs displayed.

Master the select distinct statement to return only unique values from a dataset, using the syntax select distinct column(s) from table; end with a semicolon.

Engage in hands-on practice with select distinct to retrieve unique values, select columns, and count distinct values on the seller table.

Discover how the where statement filters records by a condition in a select query, extracting specific columns from a table using the syntax select, from, and where.

Master the where clause in SQL by filtering rows with select * from seller using conditions like country = Germany or UK and number comparisons such as greater than five.

Learn to use the count function in SQL to return the number of rows that satisfy a given condition, using a select statement and from clause to target a table.

Learn to count rows using the count function, counting all records with the asterisk and applying conditions, then explore count(distinct) for columns like country.

Learn how to insert data into a table using the insert into statement, specifying column names and values, with syntax guidance for inserting new rows.

Practice inserting a new record into the seller table using insert into and the values statement, handle auto-incremented ids, and verify results with a select query.

Explore how null values work in sql, why null is not zero or space, and use is null or is not null to test nulls in a select.

Master null and is not null operators in sql with hands-on examples testing empty and non-empty values in the seller table's name and number fields.

The update statement modifies existing records in a table by setting column values, optionally using a where clause to target specific records; without a where clause, all records update.

Practice updating data records with update statements and where clauses, changing fields such as name from nonce to Alice, and verify results with select queries.

Learn how to use the delete from statement to remove records from a table. Include a condition to target specific rows and avoid deleting all records.

Learn how to delete records from a table using the delete from statement with a condition, including checking results with browse data and ensuring a semicolon ends the statement.

Explore the IN and NOT IN operators in SQL, which specify multiple values in a condition. They act as shorthand for multiple OR statements, with practical examples to follow.

Learn how the in and not in operators filter data by multiple values in sql queries, using a select from seller example to show country matches and exclusions.

Explore sql logical operators and, or, not, and learn how and requires all conditions, how or selects any true condition, and how not inverts a condition.

Learn to apply and, or, and not logical operators to filter records in the seller table, using where conditions and equals checks in SQL queries.

Master arithmetic operations in SQL by using select statements to perform addition, subtraction, multiplication, division, and modulus with +, -, *, /, and %; view integer results from simple examples.

Explore SQL comparison operators in action, filtering table data with >, >=, <, <=, =, and != to reveal practical query results.

Explore the SQL between operator and not between, with examples on the seller table to select values between seven and 12, including both ends.

Explore the full spectrum of SQL data types, including exact numerics, approximate numerics, date and time, character and Unicode strings, and binary data types, with practical table creation examples.

Explore ordering sql query results with the order by clause, covering ascending and descending options, and the optional asc or desc keywords with a select from table syntax.

Leverage the order by clause in SQL to sort data by name, code, or country, in ascending or descending order, and view results as new result sets.

Learn how to use the limit keyword to fetch the first n records from seller table, including applying a where condition (country = Germany) to return the first matching rows.

Use min and max functions to find the smallest and largest values in a column, alias results with as, and practice on the seller table.

Learn to count records in SQL using count(*) for the entire table and count(column) for a specific column, with aliases and practical examples on the seller table.

Practice calculating averages with the average function on numeric columns, using select and from clauses, and assign an alias to the result header for a clear output.

Apply the sum function to a numeric column to compute its total, replacing the average function and using from and as to name the result alias.

Create a database and customer table with id, name, city, and code using create table, then add orders with id, name, and price, insert data, browse data, and import CSV.

Use the drop table statement to delete an existing table, such as new orders. Be aware that dropping a table results in data loss.

Learn to use the alter table statement to add, drop, or modify columns in an existing table, demonstrated on the customer table with a new column and verification.

Learn how to rename a table with alter table, changing the customer table to buyers, verify in the database or browse data tab, and insert into with values.

Discover how constraints enforce data rules in SQL by defining not null, unique, primary key, foreign key, check, and default values for columns in an existing table.

Set sql constraints on a table with the DB Browser for SQLite, including not null, unique, primary key, check, default, and create index on the buyers table.

Join records from the orders and seller tables with an inner join on the number column to create a combined result set, selecting number, name, and country.

Learn to combine results from multiple select statements using union and union all, ensuring matching columns and data types, filtering duplicates, and ordering the final results.

Explore how to rename columns and tables in SQL using aliases with the as keyword, including inline aliases and square-bracket forms, through hands-on examples on the seller and orders tables.

Demonstrates using case when to set conditions in a select, returning a value for the first met condition, and aliasing the result as no_text in the results set.

Create a users table with five columns: user ID, first name, last name, email, and phone number; then insert a single record and select all data from the table.

Create a users table with an integer id and text fields for first name, last name, email, and phone; enforce not null on fields, insert a sample record, and select.