MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


Take me to MyPage
I'm not curious

IT Career Development Platform

IT Career Development, Progression, Coaching, Jobs | MyTechLogy
You are here: Home / IT Courses / IT Course View

MS SQL Server DBA Training and Certification Course

Intellipaat

Course Summary

Intellipaat SQL Server DBA training helps you learn the detailed aspects of database design, implementation, support and maintenance. You will work on architecting and scaling database and ensuring security, availability and performance of SQL Server databases.


  • +

    Course Syllabus

    MS SQL Server DBA Course Content

    Starting with SQL Server
    Responsibilities of Database Administrator, Types of DBAs, History of SQL Server, Editions of SQL Server, Tools of SQL Server, Differences between Standard and Enterprise editions, Instances types in SQL Server, Default Instance, Named Instance, SQL Server Services, Instance aware services, Instance unaware services
    Installing SQL Server
    Pre-requisites, Installation of Server, Post Installation configuration and verificationHands-on Exercise – Install SQL Server on Linux, Install SQL Server on Windows, Configure the Server and verify that it is up and running
    Functioning of Databases
    Describe Database, Types of Database and Brief explanation, System Databases, User Database, Sql Server Database Architecture, Pages, Extents, File groups, Transaction Architecture, Creating Database, Modifying Database, Adding Files, Moving and renaming of Database files, Database modes, Real time ScenarioHands-on Exercise – Create a database schema in SQL Server, Create a table to store details of a student personal information, Add dummy data to the table, Move database file to another location, Rename database file
    Importing and Exporting Data
    What is Import and Export of table data, Copy or Move a database, Tools and Techniques for data transferHands-on Exercise – Import a table from a saved database file in the workspace, Export data from workspace to save in a database file
    Security
    Authentication Types in SQL Server, Types of Login, Windows Login, SQL Login, Creating Users and Logins, Server roles, Password policy, Understanding Database and Server Roles, Permissions, Working on access level issues, Orphan users Finding and FixingHands-on Exercise – Use SQL Server Management Studio, Create a login, Create database users, Assign different roles (owner, reader, accessadmin, securityadmin, denydatawriter, denydatareader), Provide permission level and access level, Create an orphan user, Find the orphan user
    Database Backups
    Database Backups, Why we need backups, Types of Backup, Full Backup, Differential Backup, Transaction Log Backup, Copy-only, Mirrored, Split and Tail log Backups, Differences between backups, Backup Strategy, Understanding how the data moving from Log to Data File,CHECKPOINT, Monitoring the space usage of Log File and fixing, Checking the backup files VALID or CORRUPTED, Backup storage tablesHands-on Exercise – Perform database backup, Check transaction log backup, Monitor space usage of Log files, Use backup storage table
    Recovery and Restoration of Database
    Types of Recovery Models, Full, Bulk Logged, Simple, Differences between Recovery Models, Setting Recovery Models according to the Scenarios with examples, Performing Restorations, Types of Restoration, Attach and Detach, Shrinking files, Point-in-Time RecoveryHands-on Exercise – Set a recovery model, Perform point-in-time recovery, Perform restoration from the last saved state
    Monitoring SQL Server 2014
    What is monitoring sql server, Dynamic Management Views (DMV), Dynamic Management Functions (DMF), Performance Monitor, Activity Monitor, Configure database mails, alerts and notificationHands-on Exercise – Create a DMV, Write Functions to monitor sql server activity dynamically, Configure mails, alerts and notification, Generate alerts and notification, Send email
    Tracing SQL Server Activity
    SQL Server Profiler, SQL Trace stored procedures, Using Traces, Optimize SQL Server workloadsHands-on Exercise – Use SQL server profiler, Create trace stored procedures and run them Optimize workloads of server
    Auditing Data Access and Encrypting Data
    SQL server audit feature, Implement audit, Audit data access, Implement encryptionHands-on Exercise – Implement audit, Audit data access, Implement encryption
    Database Maintenance
    Common database maintenance tasks, Ensuring database integrity, Maintaining Indexes, Automating common tasksHands-on Exercise – Create index on table column, Update index after inserting new records
    Automating SQL Server 2014 Management
    Implementing and Managing SQL Server Agent Jobs, Managing job on multiple serversHands-on Exercise – Implement Server Agent Jobs Manage Jobs on same server
    MS SQL Server DBA Project
    Project – SQL Server AuditTopics – This project is involved with implementing an SQL Server audit that includes creating of the TestDB database, triggering audit events from tables, altering audit, checking, filtering, etc. You will learn to audit an SQL Server instance by tracking and logging the events on the system. You will work with SQL Server Management; learn about database level and Server level auditing.

Course Fee:
USD 132

Course Type:

 Self-Study

Course Status:

 Active

Workload:

 1 - 4 hours / week

This course is listed under Data Centre Management , Development & Implementations , Data & Information Management , Networks & IT Infrastructure , IT Security & Architecture , Project & Service Management , Quality Assurance & Testing and Server & Storage Management Community

Attended this course?

Best Practices of MySQL Encryption
Are you new to MyTechLogy?
Click here to learn more

Back to Top

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url