Explore sql queries and syntax, noting case-insensitive keywords and the convention of uppercase keywords with lowercase identifiers. Learn that crud—create, read, update, delete—are the four basic operations for relational databases.

Master the select statement to retrieve data from a database, selecting single or multiple columns, or whole tables, and view results in a result set through practical examples.

Learn to use the select statement in SQL to retrieve data from an existing PostgreSQL database, including importing tables employees and players one and selecting all columns from players one.

Use the select statement to retrieve a single column from an existing table, such as player id from players one, and explore other columns like first name or rating.

Learn how to return only distinct values from a table using the select distinct statement, its syntax with column and table names, and the importance of avoiding duplicates.

Learn to fetch only unique records with the select distinct statement and count distinct to tally unique values in the player id column, illustrated on a players table.

Learn how to filter records with the where clause in sql, using conditions to select all data or specific columns from the players table, such as player_id and first_name.

Learn how SQL logical operators and, or, and not help filter records with where or having clauses, using select syntax and conditions.

Explore filtering data with and, or, and not in PostgreSQL queries using the players01 table. Select three columns: player_id, first_name, and team, and learn how conditions influence result sets.

Learn how to use aliases in SQL to rename columns and tables for clearer query results; aliases are temporary and created with the as keyword in select and from statements.

Use as keyword to rename columns and create temporary headers in the result set, then concatenate first name and last name with double pipe to form a full name alias.

Master the limit keyword to fetch only a subset of records instead of entire tables, boosting performance in PostgreSQL and MySQL; combine where to limit results by condition.

Execute insert into with values to add a complete row to a table without listing column names, ensuring values match the column order, then verify the insertion.

Master multi-record inserts in PostgreSQL by using insert into with values to add several rows to an existing table, specify column names, and read results with select.

Master updating data in SQL by using the update, set, and where keywords to modify one or many records with a conditional where clause.

Learn how to annotate SQL code using comments to explain statements, insert hints, or prevent execution, with single-line comments using -- and multi-line comments using /* */.

Explore SQL operators, including arithmetic, comparison, and logical types, and practical uses of any, between, exists, in, like, some, and is null in where clauses.

Master SQL comparison operators and use them in select statements and where clauses to compare values and filter data. Alias the result with as and observe true or false outcomes.

Learn how to drop a table using the drop table statement to remove a table and all its data, and how delete from and truncate remove only data.

Learn how the alter table statement in SQL adds, drops, and modifies columns, renames tables, and manages constraints, with syntax and semicolon usage.

Explore SQL any and all operators that compare a column to multi-value subqueries. Any returns true if any value meets the condition; all returns true if all values.

Learn the all operator in SQL, which compares a value to all values in another table and returns a boolean for matches; use it with select to list matched records.

Perform a hands-on exploration of the sql all operator, comparing two tables with subqueries to filter players by conditions like player id greater than seven.

Use the having clause to filter query results with or without aggregate functions, and learn how to apply group by and the count function to filter teams.

Learn to use the SQL case statement with when and else to assign labels like excellent, very good, and good to player ratings, displaying results in a red nodes column.

Master the left join in SQL by combining two tables on a common column, selecting matching and left table rows, using aliases, and optionally ordering results.

Learn how to use the right join in SQL to combine two tables on a common column, returning matching rows and all right table rows, with practical examples.

Master creating and managing SQL views as virtual tables, using create view and create or replace view with where filters, querying with select, and dropping views.