Buy and Download - OReilly Media Infinite Skills Up and Running with Microsoft SQL Server Training Video

2016
O'Reilly Media / Infinite Skills
Wes Higbee
4:30
English

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.

01. Install And Setup MSSQL
0101 Is This Course For Me
0102 About The Author
0103 MSSQL Versions And Editions
0104 Installing MSSQL - Part 1
0105 Installing MSSQL - Part 2
0106 The Adventureworks Sample Database
0107 SQL Server Management Studio (SSMS)
0108 Restoring The Adventureworks DB
0109 How To Access Your Working Files
02. Exploring Adventureworks With SSMS
0201 Exploring A Foreign Database
0202 Browsing The Database With Object Explorer
0203 SSMS Query Editor
0204 Selecting Data About Pay Rates
0205 Limiting Number Of Rows Returned
0206 Is My Query Valid
0207 Query Result Formats
0208 Documentation In Extended Properties
0209 Creating A Project To Organize Scripts
0210 The Query Designer
03. Answering Questions By Querying A Database
0301 Answering The Question Of Pay Inequality
0302 Inspecting Dependencies
0303 Inspecting Foreign Keys
0304 Executing Multiple Queries In Query Editor
0305 Counting Results From A Query
0306 Select Distinct
0307 Group By And Having
0308 Joining Tables
0309 Aliasing Tables In A Query
0310 Validating Joins And Join Types
0311 Computing The Average Pay Rate
0312 Order By
0313 Where
0314 Variables
0315 Querying Current Rate Change Date
0316 Join To A Sub Query
0317 Inequality In Current Wages
0318 Recap
04. Advanced Querying To Answer Subtleties
0401 Organizational Level And Pay Equity
0402 Common Table Expressions
0403 REFactoring For Readability
0404 Case When And Calculated Columns
0405 Over Rank Functions
05. Reporting From A Database
0501 Getting Information To Those That Need It
0502 Connecting Excel To MSSQL
0503 Creating Views
0504 Extracting CSVS With SQL CMD
0505 SSRS Report Builder
0506 SSRS Report Web Access
06. Creating Databases
0601 National Stock Number Extract
0602 Create Database
0603 Drop Database
0604 SSMS Table Designer
0605 Create Table
0606 Drop Table
0607 Data Types
0608 Create Table National Stock Numbers
0609 Stored Procedures - SP_Rename
0610 Alter Table
0611 Importing Data - National Stock Number Extract
0612 Troubleshooting Importing Data
0613 Import Alternatives
0614 Backing Up The Database
0615 Backup With Select Into
07. Developing Applications With MSSQL
0701 Visual Studio Community Edition
0702 New Console Application
0703 Connecting To MSSQL
0704 Querying Data Old School
0705 Create Table In Code
0706 Create A Foreign Key
0707 Inserting Data Old School
0708 Installing Entity Famework
0709 Querying With Entity Framework
0710 SQL Server Profiler - What Is EF Doing
0711 EF Querying Data
0712 EF Inserting Data
0713 EF Updating Data
0714 EF Deleting Data
0715 Other Programming Languages
0716 Course Wrap Up

oreilly.com, infiniteskills.com/training/up-and-running-with-microsoft-sql-server.html