Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases

299 USD 18.99 USD 94%
Test scorm

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. 

read more

Module 1

  • 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 Scenarios
  • Module Review

Module 2

  • Introduction to Data Types and Tables
  • 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

Module 3

  • SQL Server Indexing
  • Introduction to Indexing
  • Clustered Indexes
  • Non Clustered Indexes
  • Maintaining Indexes
  • Index Fragmentation
  • Index Tuning
  • Creating and Altering Indexes
  • Exam Scenarios
  • Module Review

Module 4

  • Query Performance
  • Execution Plans
  • Reading Execution Plans
  • Execution Plan Operators
  • Plan Reuse
  • Query Performance
  • Exam Scenarios
  • Module Review

Module 5

  • Common Language Runtime (CLR) Integration
  • Assemblies
  • Permissions
  • CLR Objects
  • Integrating the CLR within SQL Server
  • Exam Scenarios
  • Module Review

Module 6

  • 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

Module 7

  • Views and Functions
  • Types of Views
  • Working with Views
  • Introduction to Functions
  • Working with Functions
  • Working with Views and Functions
  • Exam Scenarios
  • Module Review

Module 8

  • Stored Procedures and Triggers
  • Working with Stored Procedures
  • Introduction to Triggers
  • Working with Triggers
  • Stored Procedures and Triggers Demo
  • Exam Scenarios
  • Module Review

Module 9

  • Working with XML
  • XML Concepts
  • Schemas and Schema Collections
  • FOR XML Clause
  • FLOWR Queries
  • Working with XML in SQL Server
  • Exam Scenarios
  • Module Review

Module 10

  • Transactions
  • Implicit Transactions
  • Explicit Transactions
  • Locking
  • Working with Transactions and Locking within SQL
  • Exam Scenarios
  • Module Review
  • Course Review
  1. Module 1
6
Start
SQL Editions
7
Start
SQL Server Tools
8
Start
SQL Server Management Studio
9
Start
SQL Data Tools
10
Start
SQL Command
11
Start
Utilizing SQL Server Tools
11
Start
Utilizing SQL Server Tools
12
Start
Exam Scenarios
12
Start
Exam Scenarios
13
Start
Module Review
  1. Module 2
14
Start
Introduction to Data Types and Tables
14
Start
Introduction to Data Types and Tables
14
Start
Introduction to Data Types and Tables
15
Start
Collations
16
Start
Unicode Characters
17
Start
Null Values
18
Start
Converting Data Types
19
Start
Introduction to Tables
19
Start
Introduction to Tables
20
Start
Normalization
21
Start
Temporary Tables
22
Start
Working with Tables
23
Start
Schemas
24
Start
Primary and Foreign Keys
24
Start
Primary and Foreign Keys
25
Start
UNIQUE Constraint/Index
26
Start
In Depth Look
26
Start
In Depth Look
26
Start
In Depth Look
26
Start
In Depth Look

No reviews for this course !

Add New Discussion

How do you rate this product?

Select currency