Get started

By signing up, you agree to our Terms of Use and Privacy Policy.
Reset your password
Enter your email and we'll send you instructions on how to reset your password.

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.

  • Access to GreyCampus platform

  • GreyCampus Course completion certificate

Subscribe to this course + 29 courses
USD 50

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

Download full course agenda/brochure

CALL

Call us

CHAT

Live chat

CONTACT

Contact us
500 +

Expert Instructors

100 +

PROFESSIONAL Courses

150000 +

Professionals Trained

Got any queries?
By submitting, you agree to our Terms of Use and Privacy Policy.

Acknowledgements

Our Accreditations

Call us

USA +1 518 302 6767
UK +44 20 8144 4436
IND +91 741 666 4433
HKG +852 8192 9294