Microsoft SQL for Beginners

A comprehensive course to teach you how to complete SQL queries using Microsoft SQL Server and the T-SQL language.

Created byBrewster Knowlton

Last updated 12/2020

English

Arabic [Auto],Bulgarian [Auto],

What you'll learn

Complete literal SELECT statements.
Complete basic SELECT statements querying against a single table
Filter data using the WHERE clause
Sort data using the ORDER BY clause
Learn about database design and normalization
Using joins, return columns from multiple tables in the same query
Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN
Complete SQL statements that use aggregate functions
Group data together using the GROUP BY clause
Filter groups of data using the HAVING clause

Course content

7 sections • 39 lectures • 3h 21m total length

START HERE: Introduction Lecture4:20
Learn the basics of SQL using Microsoft SQL Server 2012, covering select statements, where clause, order by, normalization, joins, group by and having, with practice problems and supporting documents.
How to Install Microsoft SQL Server Express3:00
Feel free to review this PDF or watch the next two video lectures that walk you through how to install SQL Server Express and configure the AdventureWorks database.
How to Download and Install SQL Server Express11:26
Learn how to download SQL Server Express, install the database engine and management tools, and load the AdventureWorks sample database using the included MDF file.
How to Attach the AdventureWorks Database4:45
Learn to attach the AdventureWorks2012 database to your SQL Server by copying the .MDF file to the data folder, removing the log row, and attaching via SQL Server Management Studio.
Introduction to T-SQL and Database Concepts4:13
Literal SELECT Statements - Part 16:38
Master literal select statements and run your first queries in AdventureWorks 2012 using management studio, returning strings with single quotes and creating multiple columns.
Literal SELECT Statements - Part 23:38
Literal SELECT Statement Practice Problems2:00
Basic SELECT Statements - Part 18:42
Basic SELECT Statements - Part 28:10
Master basic select techniques by using select star to view all columns, applying top to limit rows, and defining readable column aliases with brackets or quotes.
Basic SELECT Statements - Part 36:29
Query views as virtual tables to retrieve consolidated data easily, then practice selecting specific columns from views like human resources.v employee and sales.v individual customer.
Basic SELECT Statement Practice Problems2:00

Using the WHERE Clause - Part 15:33
Use the where clause to filter rows by column values, applying operators like greater than, less than, equal to, and not equal, with practical examples.
Using the WHERE Clause - Part 25:11
Using the WHERE Clause - Part 35:34
In this lesson, you will learn how to use the AND and OR logical operators to combine criteria within your WHERE clause.
Using the WHERE Clause - Part 48:16
Master building complex where clauses with and and or operators, and learn how parentheses affect evaluation order in SQL queries. Explore predicate logic and truth tables to verify results.
Using the WHERE Clause - Part 58:03
Explore how SQL evaluates boolean expressions in where clauses by using parentheses to control and/or precedence, with examples using ListPrice, Color, and StandardCost.
Using the WHERE Clause - Part 68:29
Master the in and between operators and like wildcards to filter data in HumanResources.vEmployee and Sales.vStoreWithDemographics, using percent and underscore for flexible name and sales range queries.
Using the WHERE Clause - Part 77:27
Master the where clause in SQL with wildcards, brackets, and ranges to filter data, and learn is null versus is not null for null values, using and or.
WHERE Clause Practice Problems3:00

Using the INNER JOIN - Part 18:15
Apply inner joins as intersections of tables to return columns in a single query. Use table aliases and join on product subcategory IDs to show product name and subcategory name.
Using the INNER JOIN - Part 28:05
Expand your understanding of inner joins by matching production.product with production.productSubcategory to reveal subcategory names and linking to production.productCategory for category names.
INNER JOIN Practice Problems3:00
Using the LEFT OUTER JOIN - Part 17:52
Using the LEFT OUTER JOIN - Part 210:25
Learn to use left outer joins and inner joins to combine sales order data with salesperson, employee, and territory names, showing totals even when a salesperson is missing.
Using the LEFT OUTER JOIN - Part 33:33
Learn to build a complete sql statement using from, inner and left outer joins, where, and order by, filtering the northwest territory and ordering by total due with table aliases.
LEFT/RIGHT OUTER JOIN Practice Problems16:00

Requirements

I assume you have absolutely NO SQL or database background before taking this course.
You will need to have a Windows-based computer to run Microsoft SQL Server.

Description

Do you want to learn a skill that can help you earn nearly $100,000 per year? If so, then this course is for you!

SQL (Structured Query Language) is the language we use to interact with databases that store data. This allows us to retrieve data with ease and simplicity. As terms like business intelligence and big data become more familiar, businesses will need more people to learn the SQL language.

This course will teach you how to use the SQL language within Microsoft SQL Server, one of the most popular database engines in the world.

You will have plenty of video lessons to teach you the majority of the content. Each section includes practice problems or additional e-books to help reinforce what you learn in the video tutorials.

Who this course is for:

Anyone who works with data, tables, or databases!
Those who work in organizations where the company typically uses Microsoft databases. This course uses Microsoft SQL Server and T-SQL (Microsoft SQL) variant of the SQL language. Those who work with Oracle, DB2, or MySQL might not gain as much from this course.
If you work in: marketing, finance, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects information
Someone who wants to learn skills that give them the potential to earn near SIX figures!

Microsoft SQL for Beginners

What you'll learn

Explore related topics

Course content

Introduction to SELECT Statements12 lectures • 1hr 5min

Filtering Data with the WHERE Clause8 lectures • 52min

Sorting Data with the ORDER BY Clause3 lectures • 16min

Querying Multiple Tables with Joins7 lectures • 57min

Aggregate Functions3 lectures • 14min

Grouping Data with the GROUP BY Clause3 lectures • 17min

Filtering Groups with the HAVING Clause3 lectures • 17min

Requirements

Description

Who this course is for: