SQL Server Core SuccessPath

Prerequisites
You should have a general knowledge of working with Microsoft Windows and of basic database terminology. No past experience with SQL Server is required.

Description
This path covers the core functions and features of SQL Server and is designed for someone with no SQL Server experience. You will begin by learning about the basic installation and configuration of SQL Server. You will explore the Microsoft SQL Management Studio, the tool used by both administrators and developers to control most of the core features in SQL Server. With this tool you will see how to create databases and tables based on sound design principles. You will then be introduced to constraints, triggers, and indexes. You will learn the basics of security so you can set up users and configure the necessary access rights to protect your data. You will explore the core syntax of the Transact-SQL (or T-SQL) language so you can add, view, update, and configure data within your tables. You will also learn basic sorting, grouping and filtering of data.


SQL Server Core

Course Path

SQL Server 2012 Core

17+ hours covering 49 topics

Course TitleTopicsRuntimeSkill LevelTrailer
SQL Server 2012: Tour and Installing
SQL Server 2012, Part 1: A Tour of SQL Server 9 2h 52m Intermediate
SQL Server 2012, Part 2: Installing 4 1h 43m Intermediate
SQL Server 2012: Management Studio
SQL Server 2012, Part 3: Working with Management Studio 4 1h 47m Intermediate
SQL Server 2012, Part 4: Designing and Creating a Database 6 2h 25m Intermediate
SQL Server 2012: Security Fundamentals
SQL Server 2012, Part 5: Security Basics 5 1h 39m Advanced
SQL Server 2012, Part 6: Permissions and Data Protection 5 1h 50m Advanced
SQL Server 2012: T-SQL Fundamentals
SQL Server 2012, Part 7: Introduction to T-SQL 7 2h 6m Intermediate
SQL Server 2012, Part 8: T-SQL Select, Where, and Clauses 5 1h 38m Intermediate
SQL Server 2012, Part 9: T-SQL Working with Data 4 1h 18m Intermediate


SQL Server 2014 Core

17+ hours covering 49 topics

Course TitleTopicsRuntimeSkill LevelTrailer
SQL Server 2014: Tour and Installing
SQL Server 2014, Part 1: A Tour of SQL Server 9 2h 52m Intermediate
SQL Server 2014, Part 2: Installing 4 1h 43m Intermediate
SQL Server 2014: Management Studio
SQL Server 2014, Part 3: Working with Management Studio 4 1h 47m Intermediate
SQL Server 2014, Part 4: Designing and Creating a Database 6 2h 25m Intermediate
SQL Server 2014: Security Fundamentals
SQL Server 2014, Part 5: Security Basics 5 1h 39m Advanced
SQL Server 2014, Part 6: Permissions and Data Protection 5 1h 50m Advanced
SQL Server 2014: T-SQL Fundamentals
SQL Server 2014, Part 7: Introduction to T-SQL 7 2h 6m Intermediate
SQL Server 2014, Part 8: T-SQL Select, Where, and Clauses 5 1h 38m Intermediate
SQL Server 2014, Part 9: T-SQL Working with Data 4 1h 18m Intermediate