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

4k learners

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.

  • 1-year e-learning access

  • Course completion certificate

  • 100% money-back guarantee

Online Self Learning USD 99 (USD 129) Enroll Now
Live Online Training -- Get Quote
Traditional Classroom -- Get Quote

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.

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.


Course Introduction
Course Modules
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
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
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
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
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
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
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
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
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
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

CALL

Call us

CHAT

Live chat

CONTACT

Contact us
500 +

Expert Instructors

100 +

PROFESSIONAL Courses

150000 +

Professionals Trained

Got queries?

Acknowledgements