by | Released December 2015 | ISBN: 9781771375825

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. Show and hide more Publisher resources Download Example Code

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