SQL Server 2012 Administration

Have Queries? Ask us +91 72592 22234

Course Overview


Xpertised Offers Advanced and Personalized Instructor Led Online Classroom training on SQL Server 2012 Administration which gives you the opportunity to interact with a SQL Server 2012 Administration instructor and help you enhance yourself to meet the demands of the industry.

Learn from our instructors from the convenience of your home or office. Interact and learn live with trainers and other participants.

Course Content


  • Introduction
  • Overview of Microsoft SQL Server 2012
    • Business Intelligence Overview
    • Database Engine
    • T-SQL Programming Interface
    • Security subsystem
    • Replication
  • Installing, Configuring, and Upgrading Microsoft SQL Server 2012
    • Editions of SQL Server 2012
    • Before Installation
    • Installing SQL Server
    • After Installation
    • How to Upgrade to SQL Server 2012
  • Using SQL Server 2012 Administration and Development Tools
    • Using SQL Server Books Online
    • Using SQL Server Management Studio
    • Using SQL Server Data Tools
    • Using SQL Server Configuration Manager
  • Designing SQL Server Databases
    • Understanding SQL Server System Databases
    • Understanding the SQL Server Database Structure
    • Creating Databases
    • Adding Files and Filegroups
    • Detaching and Attaching Databases
    • Understanding Database Recovery Models
  • Creating your First Table
    • Understanding Schemas
    • Understanding SQL Server Data Types
    • Creating and Altering Tables
    • Adding Constraints
  • Building and Maintaining Indexes
    • Index Structure Overview
    • Creating Indexes
    • Adding Index Options
    • Disabling and Dropping Indexes
  • Table Compression
    • Understanding Row Compression
    • Understanding Page Compression
    • Estimating Effects of Compressions
    • Compression Considerations
  • Backups
    • Understanding Backup Devices
    • Full Database Backups
    • Differential Database Backups
    • Transaction Log Database Backups
    • Restoring Databases
  • Managing and Maintaining Indexes and Statistics
    • Checking Index Fragmentation
    • Defragmenting Indexes
    • Creating and Updating Database Statistics
  • Maintenance Plans
    • Performing Database Consistency Checks
    • Creating Maintenance Plans
  • SQL Server Profiler and Extended Events
    • Understanding SQL Server Profiler
    • Creating Traces
    • Understanding the Extended Event Architecture
    • Creating and Configuring an Extended Events Session
  • SQL Server Security
    • Understanding Principals
    • Creating Server Logins
    • Creating User-defined Server Roles
    • Creating Database Users
    • Creating Database Roles
    • Assigning Permissions
    • Configuring Contained Databases
  • SQL Server Agent
    • SQL Server Agent Components
    • Creating Operators
    • Configuring Alerts
    • Creating Jobs
    • Working with Proxies
  • Database Snapshots
    • Understanding Database Snapshots
    • Creating and Viewing Database Snapshots
    • Dropping Database Snapshots
    • Reverting t a Database Snapshot
  • Dynamic Management Objects
    • Retrieving SQL Server Metadata from DMOs
    • Querying SQL Server Performance Statistics
    • Querying Server Information
    • Querying Indexing Statistics
  • Overview of Views, User-defined Functions, and Stored Procedures (If Time Permits)
    • What are Views
    • Creating Indexed Views
    • Understanding Scalar Functions
    • Understanding Table-Valued Functions
    • Working with Stored Procedures
    • Using the EXECUTE Keyword
  • Replication (If Time Permits)
    • Types of Replication
    • Replication Agents
    • Configuring Replication
    • Monitoring Replication
  • Conclusion

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234