SQL Querying for Beginners: From Basics to Advanced Data

Explore the basics of sql, including querying data, filtering with criteria, joining across tables, and exporting results, while learning how sql's standard structure applies across platforms.

Install sql server express from Microsoft and set up SQL Server Management Studio to connect via Windows authentication, using the Object Explorer and default instance.

Explore SQL keywords and reserved words, focusing on select and from to generate a result set, create tables, and filter results with the where clause.

Learn to connect to a SQL Server database using SQL Server Management Studio, create the Northwind sample database, and run queries with the new query editor while handling errors.

Explore Northwind in SQL Server Management Studio, focusing on tables, columns, data types, and not null values. Build, run, and save queries, including top 1,000 rows, and fix syntax errors.

Learn how to filter data with a where clause using multiple conditions, and/or operators, and how to select specific columns or all columns in SQL, with practical editor shortcuts.

Learn how to refine SQL queries with and/or conditions to filter employees by country, city, and name, and practice applying and/or clauses through guided exercises.

Explore null and not null filters in SQL to retrieve records with or without values, using the orders table's ship region column and is null and is not null syntax.

Explore using the between and in clauses to filter data with a where clause, including examples for unit price between 18 and 22 and supplier IDs in (1,2,5).

Learn to filter data with between and in clauses using where, including range queries on unit price and multiple supplier IDs, and an introduction to wildcard usage.

Explore wildcard characters in SQL, using the percent sign and like to filter the orders table, matching customer IDs and ship names; later, learn to alias column headings.

Format dates and other data values in SQL Server to produce user-friendly results, and use aliases to maintain clear, labeled headers in the result set.

Master date calculations in SQL Server by using DateDiff and DateAdd to derive differences and future values from order, required, and ship dates, covering days, weeks, and other units.

Master financial aggregate functions in SQL by calculating average, sum, count, min, and max on fields like unit price in the products table and the order details table.

Master text manipulation with concat and substring to join fields and extract specific characters, such as forming formal names and formatting USA phone numbers.

Learn how to use order by and group by to sort and aggregate unit prices, summarize by order and supplier, and preview ranking and the having clause.

Apply ranking with the rank function to prioritize results by country, ordering them ascending or descending. Use the having clause to filter aggregated data after grouping and summing values.

Apply mathematical functions on data to compute a 20% markup on unit price, derive the sales price, and compute total unit value and stock versus order.

master the pivot function in sql to transpose rows into columns, counting products by category ids and displaying totals in a pivot table, and prepare for future lessons on joins.

Explore inner, left, and right joins in the Northwind database, linking on region ID and using aliases to combine territories with regions.

Learn to use inner, left, and right joins to combine orders and shippers, display vendor names, and include all records without duplicates.

Learn to combine two queries with union and union all, producing unique results or all values from customers and suppliers by city and country.

Use the except clause to return ship cities and ship countries from orders excluding those also found in suppliers, as shown with Boise.

Explore subqueries with two tables, using aliases and inner joins to retrieve specific customer and order data, and troubleshoot duplicates by inspecting order IDs.

Learn to export query results from SQL Server using simple options—copy with headers into a spreadsheet or save results as CSV or TXT—so your user community can access the data.