Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
The Ultimate Guide in Becoming a SQL Server DBA Part 2
Rating: 4.6 out of 5(399 ratings)
12,194 students

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
Created byRaphael Asghar
Last updated 7/2020
English

What you'll learn

  • 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

Course content

1 section • 13 lectures • 1h 50m total length

  • Introduction4:15
  • INTRODUCTION TO SQL SERVER ADMINISTRATION5:56
  • SQL SERVER APPLICATION13:45
  • INSTALL SSMS AND ADVENTUREWORKS2019 DB6:44

    Install SQL Server Management Studio, download and restore the Adventure Works 2019 database, and run basic T-SQL queries to view the top 1000 rows.

  • CREATING A DATABASE AND TABLE9:09
  • SELECT AND WHERE STATEMENTS12:58
  • UPDATE STATEMENT8:59

    Explore how the update statement modifies table data, why the where clause is essential, and how to backup before updating one or multiple columns with concrete examples.

  • DELETE STATEMENT6:41

    Learn how to use the delete statement to remove specific rows with a where clause, compare it to truncate, and master safe backup practices for SQL Server databases.

  • BACKUP AND RESTORE DATABASE9:08

    Learn to backup and restore SQL Server databases using GUI and T-SQL, including creating a names table and recovering data from Adventure Works 2019 backups.

  • INSTALL VISUAL STUDIO 20195:38

    Install Visual Studio 2019 and the required extensions for SQL Server Reporting Services and Integration Services, then configure data storage and processing tools for SSRS and SSIS work.

  • CREATE A SSRS REPORT11:34
  • CREATE A SSIS PACKAGE7:49
  • BONUS VIDEO LIST OF COURSES7:53

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

Report abuse