 |
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 designing database solutions for Microsoft SQL Server 2012.
This course is designed for Database professionals who design and build database solutions. These Database professionals are responsible for the creation of plans and designs for Database structure, storage, objects, and servers, as well as creating the plan for the environment in which the database solution runs. Primary responsibilities may include but are not limited to designing:
- Data compression strategies
- Database models
- Full-Text Search strategies
- High-availability solutions
- Maintenance strategy for database servers
- Management automation strategies
- Migration, consolidation, and upgrade strategies
- Database, schema, and object security parameters
This Quickcert training course on designing database solutions for Microsoft SQL Server 2012 prepares participants for the Microsoft Exam 70-465:
- 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-465: Designing Database Solutions for Microsoft SQL Server 2012 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-465: Designing Database Solutions for Microsoft SQL Server 2012 Certification Training Course Curriculum:
Instructor Introduction
Course Outline
Module 1
Course Introduction
Course Modules
Introduction to SQL Server 2012
SQL Server Instances
SQL Server Editions and Licensing
SQL Server Objects
System Databases
SQL Server Management Studio
SSMS Components
SQL Server Data Tools
SQLCMD
Working with SSMS
Working with SQLCMD
Exam Scenarios
Module Review
Module 2
Introduction to Databases
Database Files
Temp db
Working with Databases
Introduction to Filegroups and Files
Introduction to Log Files
Transactions
Moving Databases
Detaching and Attaching Databases
Backing Up and Restoring Databases
Copy Database Wizard
Database Catalog View
Creating and Configuring Databases
Exam Scenarios
Module Review
Module 3
Introduction to Data Types and Tables
Supported Data Types
Collations and Unicode Characters
Introduction to NULLS
Converting Data Types
Introduction to Tables
Normalization
Temporary Tables
Working with Tables
Schemas
Primary and Foreign Keys
UNIQUE Constraint/Index
Data Types in SQL Server Demonstration
Working with Tables Demonstration
Exam Scenarios
Module Review
Module 4
SQL Server Indexing
Introduction to Indexing
Heaps
Clustered Indexes
Non-Clustered Indexes
Maintaining Indexes
Index Fragmentation
SQL Server Profiler
Index Tuning
Working with Indexes Demonstration
SQL Server Tuning Advisor Demonstration
Exam Scenarios
Module Review
Module 5
Performance Considerations
Partitioning Function
Partition Scheme
Partitioned Table or Index
Introduction to Transaction
Implicit and Explicit Transactions
Locking
Working with Partition Tables, Transaction and Locks
Exam Scenarios
Module Review
Module 6
Backup and Restore
Database Data and Log Files
Recovery Model
Database Backups Types
Backup Compression and Mirrored Media Sets
Verifying Backups
Restoration Process
Restoring Backup Types
Restoring to a Point in Time
WITH STANDBY
Restoring a Database
Restoring System Databases
Restoring the Master Database
Backing Up and Restoring SQL Server
Exam Scenarios
Module Review
Module 7
Views and Functions
Types Of Views
Creating and Altering Views
Updatable and Indexed Views
Partitioned Views
Introduction to Functions
Function Types
Scalar and Table Valued Functions
Working with Views and Functions
Exam Scenarios
Module Review
Module 8
Stored Procedures and Triggers
Types of Stored Procedures
Parameters
Stored Procedure Compilation
Execution Context
Introduction to Triggers
Types of Triggers
Nested and Recursive Triggers
Trigger Firing Order
Working with Stored Procedures and Triggers
Exam Scenarios
Module Review
Module 9
SQL Server Security
SQL Authentication
SQL Logins
Accessing a Database
Authorization Across Servers
Server Roles
Database Roles
Application Roles
Authorizing Access
Configuring Access Using Schemas
Working with SQL Security
Exam Scenarios
Module Review
Module 10
Installing and Upgrading SQL
Server Resources
32 vs. 64 Bit
SQL Requirements
Software Requirements
Collations
Service Accounts
Installing SQL Server
Troubleshooting Installation
Upgrading SQL Server
Unattended Installations
Exam Scenarios
Module Review
Course Review
Questions? Contact one of our Career Advisors at 888.840.2378 for assistance or email sales@quickcert.com.
