Library

Course: SQL Server DBA 2017 - Beginners to Moderate Level - A Guide

SQL Server DBA 2017 - Beginners to Moderate Level - A Guide

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
About this Course

Hello aspiring Learner,

Greetings !

Here I am industry veteran having experience of 18+ years, Introducing new job oriented course which will help you to introduce yourself as SQL Server DBA in industry.  Microsoft SQL Server DBA is a traditional database technology which are very popular in IT space. Industry are using this technology since year 1997 when Microsoft came out with their first release of SQL server.

I would encourage and recommended to aspiring learners to go ahead with this course who would like to build career as SQL DBA or those who are working as SQL DBA and having less than <=3 years of experience.

Basic knowledge

Who should take this course -

  • Those who would like to build their career as SQL Server DBA OR  Students /IT Graduates/MBA/MCA with basic computer knowledge.
  • Existing DBA/IT professional who would like to know more about SQL server as Database professional
  • Any other professional with basic IT skills
What you will learn

What aspiring learner will achieve after completion of this course -

  • He/She Will be professional SQL DBA till moderate/Intermediate level
  • Complete course to enter in an organisation as SQL Server DBA (L1 & L2)
  • Free additional recommendation by instructor those who will enrol for course
Curriculum
Number of Lecture: 24
Total Duration: 06:25:59
SQL DBA - Chapter 1 - Course Content
  • SQL DBA - Chapter1 - Course content  

    Course topics I am going to cover during this course duration.

Sql Dba-Chapter2 - Introduction - SQL Server 2017
  • SQL DBA Chapter2 - Introduction - SQL Server 2017  
Sql DBA - Chapter 3 - Installation - SSMS2017
  • Sql DBA - Chapter 3.1 - Installation - SSMS2017 - DB Engine  
  • Sql Dba-Chapter3.2-Installation -Ssms2017-Db Engine  
  • Sql Dba-Chapter3.3-Installation Ssms2017-User Interface  
Sql DBA - Chapter4- Authentication & Service Pack Installation
  • Sql Dba - Chapter 4.1 - Authentication  
  • Sql Dba-Chapter4.2 - Service Pack Installation  
Sql DBA - Chapter5 - Sql Server Security-Sql Server Login & Roles
  • Sql Dba-Chapter 5.1 - Sql Server Security-Sql Server Login & Roles  
  • Sql Dba-Chapter 5.2 - Sql Server Security-Database Login & Roles  
Sql Dba-Chapter6 -Understanding User & System Database & Backup
  • Sql Dba-Chapter 6.1 - Understanding User & System Database  
  • SQL DBA-Chapter 6.2 - Understanding database Backup  
Sql Dba-Chapter7 - Creating Database And Tables
  • Sql Dba-Chapter 7.1 - Creating Database And Tables-New  
  • Sql Dba-Chapter 7.2 - Creating & Managing Database And Tables  
Sql Dba-Chapter8 - Database Auditing, Indexes & Locks
  • Sql DBA - Chapter 8.1 - Database Auditing  
  • Sql Dba-Chapter 8.2 - Indexes And Locks-New  
Sql Dba-Chapter9-Database Snapshot & SQL Statement
  • Sql DBA - Chapter 9.1 - Database Snapshot  
  • Sql DBA - Chapter 9.2 - SQL Statement  
Sql Dba-Chapter10.1-Database Mail And Alert
  • SQL DBA - Chapter 10.1 - Database Mail and alert configuration  
  • Sql Dba - Chapter 10.2 - Database Mail And Alert Configuration  
Sql Dba-Chapter11 - Linked Server And Import Export
  • SQL DBA - Chapter 11.1 - Linked server and import export  
Sql Dba-Chapter12 - Performance And Monitoring Utility
  • SQL DBA - Chapter 12.1 - Performance and Monitoring utility  
Sql Dba-Chapter13 - DBCC & DMV's command and System SP
  • SQL DBA-Chapter 13.1 - DBCC and System Store procedure Command  
  • SQL DBA-Chapter 13.2 - Dynamic Management Views  
SQL DBA - Chapter14 - A Recap
  • SQL DBA - Chapter14 - A Recap  
Reviews (0)