on-demand course

Up and Running with Microsoft SQL Server

with Wes Higbee

December 2015

Beginner

4h 18m

English

Infinite Skills

Watch now

Unlock full access

Includes

Earns Badge

Course outline

Is This Course For Me
3m 23s
About The Author
55s
MSSQL Versions And Editions
2m 40s
Installing MSSQL - Part 1
2m 42s
Installing MSSQL - Part 2
4m 51s
The Adventureworks Sample Database
2m 5s
SQL Server Management Studio (SSMS)
3m 43s
Restoring The Adventureworks DB
5m 26s
Exploring A Foreign Database
4m 23s
Browsing The Database With Object Explorer
4m 15s
SSMS Query Editor
5m 55s
Selecting Data About Pay Rates
3m 55s
Limiting Number Of Rows Returned
1m 21s
Is My Query Valid
59s
Query Result Formats
2m 8s
Documentation In Extended Properties
4m 24s
Creating A Project To Organize Scripts
4m 13s
The Query Designer
3m 36s
Answering The Question Of Pay Inequality
1m 49s
Inspecting Dependencies
2m 26s
Inspecting Foreign Keys
2m 50s
Executing Multiple Queries In Query Editor
3m 25s
Counting Results From A Query
1m 56s
Select Distinct
2m 4s
Group By And Having
3m 35s
Joining Tables
3m 50s
Aliasing Tables In A Query
2m 54s
Validating Joins And Join Types
5m 29s
Computing The Average Pay Rate
2m 58s
Order By
3m 14s
Where
1m 18s
Variables
1m 47s
Querying Current Rate Change Date
5m 11s
Join To A Sub Query
7m 16s
Inequality In Current Wages
2m 27s
Recap
1m 55s
Organizational Level And Pay Equity
4m 57s
Common Table Expressions
2m 27s
REFactoring For Readability
3m 28s
Case When And Calculated Columns
6m 29s
Over Rank Functions
6m 7s
Getting Information To Those That Need It
1m 16s
Connecting Excel To MSSQL
4m 43s
Creating Views
3m 58s
Extracting CSVS With SQL CMD
6m 5s
SSRS Report Builder
4m 17s
SSRS Report Web Access
3m 14s
National Stock Number Extract
36s
Create Database
3m 52s
Drop Database
1m 2s
SSMS Table Designer
5m 18s
Create Table
4m 47s
Drop Table
55s
Data Types
5m 37s
Create Table National Stock Numbers
3m 56s
Stored Procedures - SP_Rename
1m 37s
Alter Table
2m 11s
Importing Data - National Stock Number Extract
6m 15s
Troubleshooting Importing Data
5m 50s
Import Alternatives
2m 9s
Backing Up The Database
2m 16s
Backup With Select Into
51s
Visual Studio Community Edition
1m 22s
New Console Application
1m 31s
Connecting To MSSQL
3m 45s
Querying Data Old School
5m 29s
Create Table In Code
4m 4s
Create A Foreign Key
4m 58s
Inserting Data Old School
2m 44s
Installing Entity Famework
2m 36s
Querying With Entity Framework
5m 53s
SQL Server Profiler - What Is EF Doing
2m 20s
EF Querying Data
1m 56s
EF Inserting Data
2m 57s
EF Updating Data
2m 36s
EF Deleting Data
2m 4s
Other Programming Languages
2m 16s
Course Wrap Up
40s

Overview

In this Up and Running with Microsoft SQL Server training course, expert author Wes Higbee will teach you how to use Microsoft SQL for storage, querying, reporting, and development. This course is designed for the absolute beginner, meaning no previous Microsoft SQL experience is required.

You will start by learning how to install and setup MS SQL, then jump into exploring AdventureWorks with SSMS. From there, Wes will teach you how to answer questions by querying a database, including inspecting dependencies and foreign keys, counting results from a query, and joining tables. This video tutorial also covers advanced querying to answer subtleties, reporting from a database, and creating databases.

Finally, you will learn how to develop applications with MS SQL, including how to create a foreign key and query with Entity Framework. Once you have completed this computer based training course, you will have learned how to use MS SQL for storage, querying, reporting, and development. Working files are included, allowing you to follow along with the author throughout the lessons.