The Ultimate Guide in Becoming a SQL Server DBA Part 2

Everything you wanted to know about becoming a SQL Server DBA but were afraid to ask using SQL Server 2019 - part 2
New
Rating: 4.8 out of 5 (26 ratings)
4,702 students
The Ultimate Guide in Becoming a SQL Server DBA Part 2
New
Rating: 4.8 out of 5 (26 ratings)
4,702 students
At the end of this course, the student will have most of his/her questions answered as to what it takes to become a SQL DBA and the courses that will help them get a career in SQL Server environment. Note: This course is an update to how to install, configure SQL Server 2019 Developer Edition

Requirements

  • All material such as SQL Server 2019 Developer Edition is free to download and install. All documentation will be provided. The student needs a desktop or a laptop

Description

This course is an UPDATE to The Ultimate Guide in Becoming a SQL Server DBA.

The primary purpose of this course is to give the student a sample of what the SQL Server 2019 Developer Edition administration is about, what are the requisites courses in becoming a SQL DBA, some guidelines as to what to expect from the job, and get some hands on experience in installing and navigating through SQL Server management studio. The course will provide a summary of courses needed that will enable the student to prepare for the real-world IT industry. These courses are Learn T-SQL, SQL Administration part 1, SQL Administration part 2, SQL Administration part 3, SSRS part 1, SSRS part 2, and SSIS. Collectively, it's all that a SQL dba needs to secure a job.

Who this course is for:

  • Anyone who want to know what are the requisites to becoming a SQL Server DBA, what courses to take, what are the benefits of being an IT industry

Course content

1 section • 13 lectures • 1h 50m total length
  • Introduction
    04:15
  • INTRODUCTION TO SQL SERVER ADMINISTRATION
    05:56
  • SQL SERVER APPLICATION
    13:45
  • INSTALL SSMS AND ADVENTUREWORKS2019 DB
    06:44
  • CREATING A DATABASE AND TABLE
    09:09
  • SELECT AND WHERE STATEMENTS
    12:58
  • UPDATE STATEMENT
    08:59
  • DELETE STATEMENT
    06:41
  • BACKUP AND RESTORE DATABASE
    09:08
  • INSTALL VISUAL STUDIO 2019
    05:38
  • CREATE A SSRS REPORT
    11:34
  • CREATE A SSIS PACKAGE
    07:49
  • BONUS VIDEO LIST OF COURSES
    07:53

Instructor

Production SQL Database Administrator
Raphael Asghar
  • 4.5 Instructor Rating
  • 13,305 Reviews
  • 94,767 Students
  • 22 Courses

Worked as a Production SQL Database Administrator and developer for over 15 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen.  Want to help those students that want more that the basic SQL Language.  Creating real life courses for those students who want a simple path to becoming a SQL DBA.  I love SQL Administration and all that is involved in managing and creating a stable SQL architecture environment. I want to pass that experience and information to my students.