Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012

4k learners

This 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.

  • 100% money-back guarantee

  • 1-year e-learning access

  • Course completion certificate

Online Self Learning $149 ($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

Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012 Training course overview

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 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

 

The registration process

Once you have completed our simplified enrolment process, you’ll receive an email confirmation with your payment receipt in your registered email ID. You can then access the entire content of the online student portal immediately by logging in to your account on our site. Should you require any assistance please reach out to us via email (support@greycampus.com) or via our online chat system.

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