Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases

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.

Request a quote Review training schedules

Learn more about the course below.

TRAINING SCHEDULES

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.

The course curriculum

The curriculum for this Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases training incorporates all updates a list of broad topics covered

  • Course Introduction
  • Course Modules
  • Introduction to SQL Server 2012
  • SQL Instances
  • SQL Editions
  • SQL Server Tools
  • SQL Server Management Studio
  • SQL Data Tools
  • SQL Command
  • Utilizing SQL Server Tools
  • Exam Scenario
  • Module Review
  • Collations
  • Unicode Characters
  • Null Values
  • Converting Data Types
  • Introduction to Tables
  • Normalization
  • Temporary Tables
  • Working with Tables
  • Schemas
  • Primary and Foreign Keys
  • UNIQUE Constraint/Index
  • In Depth Look
  • Exam Scenarios
  • Module Review
  • SQL Server Indexing
  • Introduction to Indexing
  • Clustered Indexes
  • Non Clustered Indexes
  • Maintaining Indexes
  • Index Fragmentation
  • Index Tuning
  • Creating & Altering Indexes
  • Exam Scenarios
  • Module Review
  • Query Performance
  • Execution Plans
  • Reading Execution Plans
  • Execution Plan Operators
  • Plan Reuse
  • Query Performance
  • Exam Scenarios
  • Module Review
  • Common Language Runtime (CLR) Integration
  • Assemblies
  • Permissions
  • CLR Objects
  • Integrating the CLR within SQL Server
  • Exam Scenarios
  • Module Review
  • Transact-SQL (T-SQL) Error Handling
  • Error Severity
  • TRY CATCH Error Handling
  • TRY PARSE and TRY CONVERT
  • @@ ERROR
  • Alerts
  • Error Handling in T-SQL
  • Exam Scenarios
  • Module Review
  • Views and Functions
  • Types of Views
  • Working with Views
  • Introduction to Functions
  • Working with Functions
  • Working with Views and Functions
  • Exam Scenarios
  • Module Review
  • Stored Procedures and Triggers
  • Working with Stored Procedures
  • Introduction to Triggers
  • Working with Triggers
  • Stored Procedures & Triggers Demo
  • Exam Scenarios
  • Module Review
  • Working with XML
  • XML Concepts
  • Schemas & Schema Collections
  • FOR XML Clause
  • FLOWR Queries
  • Working with XML in SQL Server
  • Exam Scenarios
  • Module Review
  • Transactions
  • Implicit Transactions
  • Explicit Transactions
  • Locking
  • Working with Transactions & Locking within SQL
  • Exam Scenarios
  • Module Review
  • Course Review