SQL SERVER Online Training

SQL SERVER Training Overview
SQL Server 2012 Administration Training Objectives
• Install and configure Microsoft SQL Server online training 2012
• Understand the new features of Microsoft SQL Server 2012
• Manage and monitor SQL Server
• Create databases and tables
• Implement indexes and partitions
• Take database snapshots
• Secure SQL Server instances and databases
• Back up and recover data
• Automate administrative tasks with the SQL Server Agent
• Performance tune and monitor your SQL Server instance
• Use Dynamic Management Views to monitor the database and troubleshoot problems
SQL Server 2012 Administration Training Outline
• Welcome
• Conclusion
• Types of Replication
• Replication Agents
• Configuring Replication
• Monitoring Replication
• Replication

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

2. Installing SQL Server 2014
   • Installation prerequisites
   • Basic installation
   • Advanced installation options
3. Post-Install
   • Using SQL Server Configuration Manager
   • Basics of SQL Server Management Studio
   • More about SQL Server Management Studio
4. Creating and Configuring Databases
   • Creating a database
   • Advanced options of database configuration
   • Installing sample database
5. Creating Tables in a Database
   • Creating a table using Management Studio
   • Understanding data column options
   • Creating a table using T-SQL
   • Creating relationships between tables
   • In memory tables
6. Working with SQL
   • What is SQL?
   • Basic SELECT statement
   • Filtering results with a WHERE clause
   • Using wildcards in a WHERE clause
   • Sorting results with ORDER BY
   • INSERT statements
   • UPDATE statements
   • DELETE statements
7. Creating Views in Databases
   • Creating a view
   • Understanding advanced options of views
8. .Understanding Programmeability
   • Stored procedures
   • Parameterized stored procedures
   • Built-in functions
   • Scalar functions
9. Working with XML
   • Intro to XML
   • Writing queries to return XML
   • Shredding XML
   • Working with XML schemas
   • Storing XML
10. Backup and Restore
    • Overview of backups in SQL Server
    • Basic backups
    • Basic restore
    • Differential backup and restore
    • Creating maintenance plans to automate backups
    • Adding a cleanup task to a maintenance plan
11. Monitoring SQL Server
    • Review logs in SQL Server 2014
    • Auditing logins
    • Using Performance Monitor
    • Understanding dynamic management views
    • Using DBCC
12. Security
    • Overview of authentication in SQL Server
    • Instance-level logins
    • Database-level users
    • Encrypting data
13. Importing and Exporting Data
    • Exporting data
    • Importing data
    • Importing and exporting Unicode data
14. Performance
    • Basics of indexes
    • Creating an index
    • Exploring execution plans