Learn SQL Made Simple

Install and launch SQL Server Management Studio, complete a new installation of SQL Server 2014, connect using Windows authentication, and note Adventure Works will be installed in the next lecture.

Download and install Adventure Works 2014, copy the files to a folder, restore the database in SQL Server Express, and prepare Adventure Works 2014 for future queries.

Understand what SQL stands for, structured query language, and how it retrieves, inserts, and updates data in a database using statements and clauses, producing results in rows and columns.

Explore how databases organize data into tables and columns, with rows storing data within those tables, illustrated by the Adventure Books 2014 database and the human resources job candidate table.

Learn to write a basic select statement using the asterisk for all columns, from the human resources employee table, and execute the query to view results.

Learn to select only the needed columns in SQL by listing column names, such as login id and job title, from the human_resources_employee table, using drag-and-drop and avoiding the asterisk.

Learn to select the top 50 * from a table in the query editor to retrieve the first 50 rows of all columns, then execute and review the results.

Select the top 50 rows from two chosen columns, such as job title and gender, from the human resources employee table, and execute the query to view the results.

Learn to rename a column in a select statement using the as alias, replacing 'job title' with 'position' via square brackets, and execute the query to view the updated output.

Learn how to write SQL comments with /* ... */ and --, annotate queries, and see how comments are ignored during execution and in the output.

Explore how to use the where clause in a select query to filter results by a numeric threshold, focusing on line total values greater than 100 in sales order details.

Demonstrate using the where clause with the equals operator to filter rows by a specific product_id, showing only values where product_id equals 7 7 6.

Apply the where clause with = and > to filter rows using the product idea equals 7 7 7 and line total greater than 200.

Apply the where clause with = and < using or to retrieve rows where either product ideas equals 709 or line total is less than 200.

Apply the between operator in the where clause to filter sales data where the business entity id is between 275 and 280, illustrating conditional and unconditional queries.

Learn to filter results with the where clause using the like operator and % wildcards to find rows where the name column contains the word manager, regardless of case.

Learn how to use the where clause to filter out null values in SQL queries, using is not null on address line 2 to return only rows with data.

Apply the where clause with is null in SQL to return rows with no values in a column, demonstrated through simple steps.

Learn to use the order by clause by sorting results by the column's position, using order by 1 for transaction_id, and confirming ascending order produces the same output.

Learn how to use the order by clause by aliasing transaction id as t i d and ordering by that alias in descending order.

Learn to combine where and order by clauses in a single SQL query, selecting from a table, filtering rows with a where condition and sorting by subtotal in ascending order.

Learns about the select statement, where clause with operators, and the order by clause, and demonstrates combining where with the all due by clause in a single query.