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

  • 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-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.
  • 1-year access to audio-video lectures
  • GreyCampus course completion certificate

Course Outline

  • Designing Database Solutions for Microsoft SQL Server 2012
    Course Introduction
    Course Modules
  • Introduction to SQL Server 2012
    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 to Databases
    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 to Data Types and Tables
    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
    • SQL Server Indexing
      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
    • Performance Considerations
      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
    • Backup and Restore
      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
    • Views and Functions
      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
    • Stored Procedures and Triggers
      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
    • SQL Server Security
      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
    • Installing and Upgrading SQL
      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

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