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
- Installing SQL Server 2014
• Installation prerequisites
• Basic installation
• Advanced installation options - Post-Install
• Using SQL Server Configuration Manager
• Basics of SQL Server Management Studio
• More about SQL Server Management Studio - Creating and Configuring Databases
• Creating a database
• Advanced options of database configuration
• Installing sample database - 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 - 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 - Creating Views in Databases
• Creating a view
• Understanding advanced options of views - .Understanding Programmeability
• Stored procedures
• Parameterized stored procedures
• Built-in functions
• Scalar functions - Working with XML
• Intro to XML
• Writing queries to return XML
• Shredding XML
• Working with XML schemas
• Storing XML - 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 - Monitoring SQL Server
• Review logs in SQL Server 2014
• Auditing logins
• Using Performance Monitor
• Understanding dynamic management views
• Using DBCC - Security
• Overview of authentication in SQL Server
• Instance-level logins
• Database-level users
• Encrypting data - Importing and Exporting Data
• Exporting data
• Importing data
• Importing and exporting Unicode data - Performance
• Basics of indexes
• Creating an index
• Exploring execution plans