Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases

About this course

This course is in preparation for the Microsoft 70-464 Developing Microsoft SQL Server 2012 Databases exam. This course covers logical table design, indexing and query plans, and focuses on the creation of database objects including views and stored procedures, along with parameters and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course.

Course Outline

SQL 2012 And The 464 Test

•  1.1 Introduction
•  1.2 Intro To SQL Server 2012 Part 1
•  1.3 Intro To SQL Server 2012 Part 2
•  1.4 Management Studio Demo Part 1
•  1.5 Management Studio Demo Part 2
•  1.6 Management Studio Demo Part 3
•  1.7 Other SQL Server Tools

Working With Data Types

•  2.1 Working With Data Types Part 1
•  2.2 Working With Data Types Part 2
•  2.3 Working With Data Types Part 3
•  2.4 Other Data Types

Tables

•  3.1 Tables
•  3.2 Creating Tables

Data Constraints

•  4.1 Data Constraints Part 1
•  4.2 Data Constraints Part 2

Planning In Indexing

•  5.1 Planning In Indexing Part 1
•  5.2 Planning In Indexing Part 2
•  5.3 Planning In Indexing Part 3
•  5.4 Planning In Indexing Part 4

Table Structures

•  6.1 Table Structures
•  6.2 Working With Clustered Indexes
•  6.3 Clustered Indexes
•  6.4 Designing Effective Clustered Indexes

Improving Performance with NonClustered Indexes

•  7.1 Improving Performance With NonClustered Indexes Part 1
•  7.2 Improving Performance With NonClustered Indexes Part 2
•  7.3 Improving Performance With NonClustered Indexes Part 3

Using Indexes And Execution Plans

•  8.1 Using Indexes
•  8.2 Execution Plans Part 1
•  8.3 Execution Plans Demo
•  8.4 Execution Plans Part 2

Working with Views

•  9.1 Working With Views Part 1
  9.2 Working With Views Part 2

 

Reviews