About the Academy

This day's, database administrators are responsible to manage the entire database installation, clustering, migration, backup, recovering, securing  and tuning performance of the entire database. MS SQL server, now has released 2016 version, is one of the top RDBMS which are running from the entire world. Using MS SQL server it is possible to handle complex database, manage users, provide reporting, backuping, 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 demand right now. So do not get late to specialize it.

What I am going to learn throughout this course? You will learn

  • Relational database management systems concept
  • Installing microsoft SQL server 2016
  • Microsoft SQL server 2016 architecture
  • Creating database objects on 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

Audience and Requirements

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

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.

Sign for next demo class