Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
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.5 out of 5(401 ratings)
12,206 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
English [Auto],

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

    Discover how to install SQL Server 2019 on your laptop with the developer edition, and learn basic SQL Server administration using Visual Studio 2019, for free non-production use.

  • INTRODUCTION TO SQL SERVER ADMINISTRATION5:56

    Discover how to become a SQL Server database administrator, covering server management, backups, and restores. Learn T-SQL basics, SSMS usage, and practical tasks like creating databases and tables.

  • SQL SERVER APPLICATION13:45

    Learn to install SQL Server 2019 Developer Edition, set up SSMS and Visual Studio 2019 Community Edition, and understand domain versus standalone server architecture for SQL Server administration.

  • 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

    Master how to create databases and tables using t sequel language, use the master database, and manage mdf and ldf files while inserting and querying data.

  • SELECT AND WHERE STATEMENTS12:58

    Master the select statement and where clause in SQL Server, learning how to retrieve data, filter rows with and/or operators, and use aliases, calculated fields, and concatenation.

  • 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

    Install the escudo reporting services and configure the report server to publish ssrs reports locally in visual studio, then design, deploy, and view the report in the web portal.

  • CREATE A SSIS PACKAGE7:49

    Learn to create an SSIS package in Visual Studio to migrate data from SQL Server Adventure Works 2019 to a new EDL database, with source, destination, and mapping.

  • BONUS VIDEO LIST OF COURSES7:53

    Discover a bonus list of 20 SQL Server courses guiding you from junior to senior DBA, with recommended order, virtualization, backups, migration, and new feature updates.

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