MS SQL Server 2016 Administrator

About the course

This day's, database administrators are responsible to manage the entire database installation, clustering, migration, backup, recovering, securing and tuning the performance of the entire database. MS SQL server now has released 2016 version, is one of the top RDBMS which is running from the entire world. Using MS SQL server it is possible to handle complex database, manage users, provide reporting, backup, securing and monitoring systems. To manage their complex databases, every company who runs MS SQL Server needs a specialized database administrator. And there is a lot of demand right now. So do not get late to specialize it.

What are the Requirements?

Anyone who is interested to be MS SQL server database administrator
Requires database fundamentals and database design concept.

What I am going to get from this course

Relational database management systems concept
Installing Microsoft SQL server 2016
Microsoft SQL server 2016 architecture
Creating database objects in the management studio
Securing Microsoft SQL server 2016
Session management on MS SQL server 2016
Backuping and recovering from MS SQL server
Backup to Azure (cloud)
Service packs and database upgrades
Export and import from MS SQL server 2016
Tuning SQL server 2016 performance

Training Highlights

Mentorship will be available through training and after training
You will practice on interview questions starting from day one

Curriculum

Module 1: Relational Database Management Systems Concept

1.1 Database and a Relational Database Management System (RDBMS)
1.2 Microsoft SQL Server Platform and Overview
1.3 Database Administrator Role and Responsibilities

Module 2: Installing Microsoft SQL Server 2016

2.1 Microsoft SQL Server 2016 and Editions?
2.2 Hardware and Software Prerequisites to Install SQL Server 2016
2.3 SQL Server 2016 Components
2.4 Adding Features to an Existing SQL Server 2016
2.5 Microsoft SQL Server 2016 Management Studio Installation

Module 3: Microsoft SQL Server 2016 Architecture

3.1 SQL Server System and Business (non-system) Databases
3.2 SQL Server Database Structure
3.3 Filegroups and Datafiles of SQL Server
3.4 Transaction Logs and Recovery Models of SQL Server
3.5 SQL Server Instance vs Database
3.6 Client to Server Sets of SQL Server

Module 4: Creating Database Objects On The Management Studio

4.1 Creating Database
4.2 Using SQL Server Management Studio (SSMS) and Create Table and Index
4.3 SSMS Index Management for Fragmentation Reduction
4.4 SSMS Primary Key and Foreign Key Setup
4.5 SSMS File Grouping

Module 5: Securing Microsoft SQL Server 2016

5.1 Understand Instance and Database-level Principles
5.2 Roles in Fixed Server of SQL Server
5.3 Creating New User and Mapping with Instance Login
5.4 Database Schemas in SQL Server and User Management
5.5 Grant and Revoking Database Users
5.6 Configuration Manager of SQL Server and Instance Ownership
5.7 Auditing Logins in SQL Server 2016

Module 6: Session Management on MS SQL Server 2016

6.1 Database Connections vs Sessions
6.2 Monitoring Database Activity
6.3 SSMS Killing Session or Terminals
6.4 SSMS Running Reports
6.5 Autocommit Transactions

Module 7: Backuping and Recovering from MS SQL Server

7.1 Backup and Recovery Concept and Strategies
7.2 Offline Mode on Database
7.3 Copy Database Wizard (CDW) to Copy Databases
7.4 SIMPLE and FULL Recovery Model for Full Backup
7.5 Backup History Information
7.6 Automating Backups Plan in SQL Server
7.7 Purging Old Backups Plans
7.8 Scheduling Backups From SQL Server Agent
7.9 Database Restore and Recovery Overview
7.10 Full Database Restore and Recovery
7.11 Recovering from SQL Server Transactional Logs
7.12 Using Time Based Recovery Option (STOPAT)

Module 8: Backup to AZURE (Cloud)

8.1 Creating Azure Account
8.2 Creating Storage Containers in Azure
8.3 Creating SQL Server Credentials and Use for Backup Authentication
8.4 Perform a Full Database Backup to URL
8.5 Delete the Database and Restore it from the URL

Module 9: Service Packs and Database Upgrades

9.1 SQL Server 2012 Service Pack 3 (SP3) to SQL Server 2012 RTM
9.2 SQL Server 2012 SP3 to SQL Server 2016 RTM

Module 10: Export and Import from MS SQL Server 2016

10.1 Partial Data Export and Import Using BCP Command Line Tools
10.2 Partial Data/import Through Wizards of GUI Tools

Module 11: Tuning SQL Server 2016 Performance

11.1 Indexing Concept to Boost Select Performance
11.2 Index Fragmentation and Maintaining to Improve Performance
11.3 Understanding SQL Server Database Statistics and Profiler
11.4 Creating SQL Server Traces and Server-Side Traces
11.5 Using Views to Improve MS SQL Performance

Request a detailed syllabus.

Get Answers (Answering their questions)

What kind of learning does ITlearn360.com provide?

ITlearn360.com offers instructor-led online live sessions and classroom-based corporate trainings and bootcamps for various courses and certifications to the learners.

Who are the instructors @ITlearn360.com?

@ITlearn360.com, we have an instructor community of industry professionals who are working in leading organizations and are veterans in their respective fields. These experts belong to various industries and are willing to share their talent with learners like you.

Are classes @ITlearn360.com conducted through online video streaming?

Yes, the classes @ITlearn360.com are conducted through online video streaming where there is two-way communication between users and instructors. The users can speak by using a microphone, chat by sending a message through a chat window and share their screens with an instructor. For better understanding, users also get recorded video of the class.