Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012 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 professionals who design and build database solutions.

  • 1-year e-learning access

  • Course completion certificate

  • 100% money-back guarantee

Online Self Learning USD 149 (USD 199) Enroll Now
Live Online Training -- Get Quote
Traditional Classroom -- Get Quote

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-465 course prepares you to pass the Microsoft 70-465 Designing Database Solutions for Microsoft SQL Server 2012 exam which validates your ability to create and alter tables, design, implement, and troubleshoot security, collect performance and system information and other related activities. This course is suitable for IT professionals and anyone aspiring for a Microsoft certification.

Course Outline

Course Introduction
Course Modules
Introduction Part1
Introduction Part2
SQL Server Instances
SQL Server Editions and Licensing
SQL Server Objects
System Databases
SQL Server Management Studio
SSMS Components Part1
SSMS Components Part2
SQL Server Data Tools
SQLCMD
Working with SSMS Part1
Working with SSMS Part2
Working with SQLCMD
Exam Scenarios
Module Review
465_01_01_02h
465_01_06_01h
Introduction Part1
Introduction Part2
Database Files Part1
Database Files Part2
Temp db
Working with Databases
Introduction to Filegroups and Files Part1
Introduction to Filegroups and Files Part2
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 Part1
Creating and Configuring Databases Part2
Exam Scenarios
Module Review
465_02_08_01h
Introduction Part1
Introduction Part2
Supported Data Types
Collations and Unicode Characters Part1
Collations and Unicode Characters Part2
Introduction to NULLS
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
Primary and Foreign Keys Part3
UNIQUE Constraint/Index
Data Types in SQL Server Demonstration Part1
Data Types in SQL Server Demonstration Part2
Working with Tables Demonstration Part1
Working with Tables Demonstration Part2
Exam Scenarios Part1
Exam Scenarios Part2
Module Review
Introduction Part1
Introduction Part2
Introduction to Indexing
Heaps
Clustered Indexes
Non-Clustered Indexes Part1
Non-Clustered Indexes Part2
Non-Clustered Indexes Part3
Maintaining Indexes Part1
Maintaining Indexes Part2
Index Fragmentation
SQL Server Profiler
Index Tuning
Working with Indexes Demonstration Part1
Working with Indexes Demonstration Part2
Working with Indexes Demonstration Part3
SQL Server Tuning Advisor Demonstration Part1
SQL Server Tuning Advisor Demonstration Part2
Exam Scenarios
Module Review
465_04_10_02c
Introduction Part1
Introduction Part2
Partitioning Function
Partition Scheme
Partitioned Table or Index
Introduction to Transaction
Implicit and Explicit Transactions
Locking
Working with Partition Tables, Transaction & Locks Part1
Working with Partition Tables, Transaction & Locks Part2
Working with Partition Tables, Transaction & Locks Part3
Exam Scenarios
Module Review
465_05_05_01h
Introduction Part1
Introduction Part2
Database Data and Log Files Part1
Database Data and Log Files Part2
Recovery Model
Database Backups Types Part1
Database Backups Types Part2
Database Backups Types Part3
Database Backups Types Part4
Database Backups Types Part5
Backup Compression and Mirrored Media Sets
Verifying Backups
Restoration Process
Restoring Backup Types Part1
Restoring Backup Types Part2
Restoring Backup Types Part3
Restoring to a Point in Time
WITH STANDBY
Restoring a Database
Restoring System Databases
Restoring the Master Database
Backing Up and Restoring SQL Server Part1
Backing Up and Restoring SQL Server Part2
Backing Up and Restoring SQL Server Part3
Backing Up and Restoring SQL Server Part4
Exam Scenarios
Module Review
465_06_14_02c
Introduction Part1
Introduction Part2
Introduction Part3
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 Part1
Working with Views and Functions Part2
Working with Views and Functions Part3
Exam Scenarios
Module Review
465_07_01_02h
Introduction Part1
Introduction Part2
Introduction Part3
Types of Stored Procedures
Parameters
Stored Procedure Compilation
Execution Context Part1
Execution Context Part2
Introduction to Triggers Part1
Introduction to Triggers Part2
Types of Triggers
Nested and Recursive Triggers
Trigger Firing Order
Working with Stored Procedures & Triggers Part1
Working with Stored Procedures & Triggers Part2
Exam Scenarios
Module Review
465_08_03_01h
Introduction Part1
Introduction Part2
SQL Authentication
SQL Logins
Accessing a Database
Authorization Across Servers
Server Roles
Database Roles
Application Roles
Authorizing Access Part1
Authorizing Access Part2
Configuring Access Using Schemas
Working with SQL Security Part1
Working with SQL Security Part2
Exam Scenarios
Module Review
Introduction Part1
Introduction Part2
Server Resources Part1
Server Resources Part2
32 vs. 64 Bit
SQL Requirements
Software Requirements
Collations
Service Accounts
Installing SQL Server
Troubleshooting Installation
Upgrading SQL Server Part1
Upgrading SQL Server Part2
Unattended Installations
Exam Scenarios
Module Review
Course Review
465_10_11_01h

CALL

Call us

CHAT

Live chat

CONTACT

Contact us
500 +

Expert Instructors

100 +

PROFESSIONAL Courses

150000 +

Professionals Trained

Got queries?

Acknowledgements