Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases Training Course

This course is designed to measure the knowledge and skills of participants in making suitable career choices in developing Microsoft SQL Server 2012 Databases. It is intended for Database developers who develop and implement databases across the company while ensuring high levels of data availability.

Subscribe to this course +

USD 50

Subscribe Now

Group Training

Looking for a personalized training for a group (3 or more participants) at your preferred location?
Contact us

Course Overview

The Microsoft 70-464 exam is for people working as SQL Server Database administrators, System engineers, and experienced Data Warehouse developers. Here we bring you the best-in-class course that prepares you to take up the Microsoft 70-464 exam, which tests your skills and knowledge of writing queries.

1-year access to audio-video lectures
GreyCampus course completion certificate

Course Outline

Alignment

This course is aligned to help you become an expert in working with databases

Outcome

After the completion of this course, you will be able to successfully develop and create database files, data types, tables etc.

Developing Microsoft SQL Server 2012 Databases

Course Introduction

Course Modules
Module 1

Introduction to SQL Server 2012 Part1

Introduction to SQL Server 2012 Part2

SQL Instances

SQL Editions

SQL Server Tools

SQL Server Management Studio

SQL Data Tools

SQL Command

Utilizing SQL Server Tools Part1

Utilizing SQL Server Tools Part2

Exam Scenarios Part1

Exam Scenarios Part2

Module Review
Module 2

Introduction to Data Types and Tables Part1

Introduction to Data Types and Tables Part2

Introduction to Data Types and Tables Part3

Collations

Unicode Characters

Null Values

Converting Data Types

Introduction to Tables Part1

Introduction to Tables Part2

Normalization

Temporary Tables

Working with Tables

Schemas

Primary and Foreign Keys Part1

Primary and Foreign Keys Part2

UNIQUE Constraint/Index

In Depth Look Part1

In Depth Look Part2

In Depth Look Part3

In Depth Look Part4

Exam Scenarios Part1

Exam Scenarios Part2

Module Review
Module 3

SQL Server Indexing Part1

SQL Server Indexing Part2

Introduction to Indexing

Clustered Indexes

Non Clustered Indexes Part1

Non Clustered Indexes Part2

Non Clustered Indexes Part3

Non Clustered Indexes Part4

Maintaining Indexes Part1

Maintaining Indexes Part2

Index Fragmentation

Index Tuning

Creating & Altering Indexes Part1

Creating & Altering Indexes Part2

Creating & Altering Indexes Part3

Exam Scenarios Part1

Exam Scenarios Part2

Module Review

464_03_04_01h

Module 4

Query Performance Part1

Query Performance Part2

Execution Plans

Reading Execution Plans

Execution Plan Operators

Plan Reuse

Query Performance Part1

Query Performance Part2

Query Performance Part3

Exam Scenarios

Module Review

464_04_03_01h

464_04_01_01h
Module 5

Common Language Runtime (CLR) Integration Part1

Common Language Runtime (CLR) Integration Part2

Assemblies

Permissions

CLR Objects

Integrating the CLR within SQL Server

Exam Scenarios Part1

Exam Scenarios Part2

Module Review

464_05_06_02h
Module 6

Transact-SQL (T-SQL) Error Handling Part1

Transact-SQL (T-SQL) Error Handling Part2

Error Severity

TRY CATCH Error Handling

TRY PARSE and TRY CONVERT

@@ ERROR

Alerts

Error Handling in T-SQL Part1

Error Handling in T-SQL Part2

Exam Scenarios Part1

Exam Scenarios Part2

Module Review

464_06_02_01h
Module 7

Views and Functions Part1

Views and Functions Part2

Types of Views

Working with Views Part1

Working with Views Part2

Introduction to Functions Part1

Introduction to Functions Part2

Working with Functions

Working with Views and Functions Part1

Working with Views and Functions Part2

Working with Views and Functions Part3

Exam Scenarios Part1

Exam Scenarios Part2

Module Review

464_07_05_01h
Module 8

Stored Procedures and Triggers Part1

Stored Procedures and Triggers Part2

Working with Stored Procedures

Introduction to Triggers Part1

Introduction to Triggers Part2

Working with Triggers

Stored Procedures & Triggers Demo Part1

Stored Procedures & Triggers Demo Part2

Stored Procedures & Triggers Demo Part3

Exam Scenarios Part1

Exam Scenarios Part2

Module Review

464_08_06_02h
Module 9

Working with XML Part1

Working with XML Part2

XML Concepts Part1

XML Concepts Part2

Schemas & Schema Collections Part1

Schemas & Schema Collections Part2

FOR XML Clause Part1

FOR XML Clause Part2

FLOWR Queries

Working with XML in SQL Server Part1

Working with XML in SQL Server Part2

Exam Scenarios Part1

Exam Scenarios Part2

Module Review
Module 10

Transactions Part1

Transactions Part2

Implicit Transactions

Explicit Transactions

Locking Part1

Locking Part2

Working with Transactions & Locking within SQL Part1

Working with Transactions & Locking within SQL Part2

Exam Scenarios Part1

Exam Scenarios Part2

Module Review

Course Review