Learn SQL with Microsoft SQL Server

Download and install SQL Server 2016 from the official Microsoft SQL Server page, choose the basic setup with a 180-day evaluation, then install SSMS to manage data and run commands.

Download and install SSMS after installing SQL Server 2016, then accept defaults as the installer downloads dependencies like .NET and Visual Studio; restart if prompted.

Explore system databases in SQL Server, including master, model, msdb, and tempdb. Master stores logins and system information; model provides templates; msdb handles mail and backups; tempdb stores query results.

Create a database and design a current_customer table for the Acme company, defining columns like first name, last name, email, city, state, and zip code.

Learn to add data to a table in SQL Server using the edit top 200 rows view, and commit changes by moving to the next row.

Learn the basics of sequel, the structured query language for databases. Query, insert, update, and delete data, create tables and databases, and set permissions using Microsoft SQL Server 2016.

Use the where clause to filter SQL results with comparison operators. Explore like, between, and not equal to refine selects and extend to update and delete statements.

Learn to combine SQL conditions with and, or, and not in where clauses. See practical examples using age and first name to build precise queries and results.

Learn how to order query results with order by, choosing ascending or descending for columns like last name and age, see default behavior, and apply ordering to any field.

Explains how the having clause works with group by to filter aggregates, since where doesn't apply to aggregates; use having with count(state) and order by state.

Learn to use the top clause to return the top records from the current customers table, by number or percentage, and optionally order by age.

Learn how select distinct returns unique records and filters duplicates, using state values and Illinois appearing twice as the example.

Explore built-in sql functions like data length, lower, upper, count, average, max, and sum to transform data and compute statistics in sql server.

Master the insert into syntax to add data to a table by listing columns and corresponding values. Learn to ensure column-value counts match and execute to insert rows programmatically.

Learn how to use the update statement in SQL Server to modify specific records, using set and where clauses, with a Matt Brown example showing city and state updates.

Learn to delete records in SQL Server using delete from table where condition, including examples like removing a customer, and the risk of deleting all rows without a where clause.

Alter a table programmatically to add, change, and drop columns, demonstrated by adding country, changing its data type, and then removing it, with existing rows initially null.

Learn how to manage nullability in SQL Server by using alter table to switch a column between null and not null, understanding the constraints when existing data contains nulls.

Create a table customer_orders in SQL Server with four columns: first_name varchar, last_name varchar, green_widget int, purple_widget int; by default, nulls are allowed and you can insert data programmatically.

explains the difference between delete and drop in SQL, and shows how to delete table data with a where clause and how to drop a table entirely.

Learn to join two tables by creating a primary key id, add an identity id to current customers, populate it, split data into customers and orders tables, and understand normalization.

Learn how to create and drop indexes in SQL Server to speed up searches on large tables. See practical examples like indexing email and age on the current customers table.

Unlock a lifetime membership with a $200 discount using coupon code Udemy to access 60+ courses, PDFs, and future additions, plus a 30-day money-back guarantee.