 |
GET IN THE LEAD - get certified today!
Experience the benefits of classroom learning - anytime, anywhere! QuickCert's expert instruction and multi-media courses are to get you certified - or your money back!
Read why successful professionals choose QuickCert > |
This Quickcert 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.
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 Quickcert 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
QuickCert creates the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed. QuickCert is so certain this course meets and exceeds the exam objectives, we guarantee you will pass your exam!
Not sure what course is right for you?
Contact one of our Career Advisors at 888.840.2378 for assistance.
Your QuickCert Microsoft Exam 70-464: Developing Microsoft SQL Server 2012 Databases Certification Training Package Includes:
| Delivery Format |
Instructor Led Modules |
Hardbook Supplement |
Practice Exam Simulator |
Exam Pass Guarantee |
| DVDs or online |
|
|
|
|
Exam Pass Guarantee - Learn More
Free Product Upgrades
Toll Free Educational Support
Compatibility with:
98 | 2000 | ME | XP | 2003| Vista | Windows 7 | Windows 8
“I’m 100% satisfied with QuickCert’s training program. I love that it’s broken into manageable sections. This is an all-inclusive training solution… they give you the manuals, the lectures broken into short segments, and practice tests that really mirror the actual tests I’ve taken. I plan to renew my membership!!”
— Karen S., Network Administrator, Calabasas, California
Questions? Contact one of our Career Advisors at 888.840.2378 for assistance or email sales@quickcert.com.
Microsoft Exam 70-464: Developing Microsoft SQL Server 2012 Databases Certification Training Course Curriculum:
Instructor Introduction
Course Outline
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
Questions? Contact one of our Career Advisors at 888.840.2378 for assistance or email sales@quickcert.com.
