Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases

4k learners

This course is specifically for participants to measure their knowledge and skills on making the appropriate job role decisions around Developing Microsoft SQL Server 2012 Databases.

  • 100% money-back guarantee

  • 1-year e-learning access

  • Course completion certificate

Online Self Learning $99 ($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

Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases Training course overview

This course is designed for Database developers who build and implement databases across the organization, while ensuring high levels of data availability. They perform tasks including creating database files, create data types, tables, plan create and optimize indexes, implement data integrity, implement views, stored procedures and functions, manage transactions and locks. Primary responsibilities may include:

  • Optimizing and tuning queries
  • Creating and altering indexes and stored procedures
  • Maintaining database integrity
  • Optimizing indexing strategies
  • Creating and altering tables
  • Maintaining indexes
  • Creating and modifying constraints
  • This training course on developing Microsoft SQL Server 2012 Databases prepares participants for the Microsoft Exam 70-464

This course will provide all the skills and knowledge for the following areas:

  • Creating and altering tables (complex statements)
  • Designing, implementing, and troubleshooting security
  • Designing the locking granularity level
  • Maintaining indexes
  • Implementing data types
  • Creating and modifying constraints (complex statements)
  • Working with XML Data
  • Writing automation scripts
  • Designing and implementing stored procedures
  • Designing T-SQL table-valued and scalar functions
  • Creating, using, and altering user-defined functions (UDFs)
  • Creating and altering views (complex statements)
  • Designing tables
  • Designing for concurrency
  • Creating and altering indexes
  • Designing data integrity
  • Designing for implicit and explicit transactions
  • Optimizing and tuning queries
  • Troubleshooting and resolving performance problems
  • Optimizing indexing strategies
  • Capturing and analyzing execution plans
  • Collecting performance and system information

 

The registration process

Once you have completed our simplified enrolment process, you’ll receive an email confirmation with your payment receipt in your registered email ID. You can then access the entire content of the online student portal immediately by logging in to your account on our site. Should you require any assistance please reach out to us via email (support@greycampus.com) or via our online chat system.

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