Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
4 Hour(s) 24 Minute(s)
Language
English
Taught by
Skill Tree
Rating
Course Overview
Learn the Lucrative skills of a DBA
Databases are everywhere and the demand for database administrator has increased.
The role of a database administrator includes backing up database for safety and having the skills to restore the database if required.
This SQL DBA beginners course will teach you the basic functions that DBA's has to perform.In this course you will not have to install any software as we will be using a ready made virtual lab environment provided my Microsoft.
The virtual labs is ideal because it is free and gives you an environment that mirrors a real world production SQL Server environment. I strongly urge you to take advantage of this opportunity as I do not know how long Microsoft will have these virtual labs available for. All you require to access the virtual labs is a web browser . It does not matter if you are using a mac , Pc or Linux and there is absolutely nothing for you to install. The lab exercise you will perform in this course using the virtual labs are similar to a real world SQL Server production environment.
What you will learn in this course includes:
- How to use Virtual Labs
- T-SQL quick Guide
- Importing and Exporting Data
- How to use Activity monitor
- How to use Performance monitor
- How to backup database
- How to restore database
- How to monitor database
- How to improve performance
- How to authenticate users and groups
- How to set up Permissions
- How to setup Auditing
I look forward to seeing you on the course.
Thank You
Course Content
- 6 section(s)
- 49 lecture(s)
- Section 1 Getting Started
- Section 2 SQL Server 2019 Local Setup
- Section 3 Backing Up and Restoring Databases
- Section 4 Performance Monitoring and Tuning
- Section 5 T-SQL Refresher
- Section 6 Administering Database Security
What You’ll Learn
- Backup and Restore Databases, Write basic T-SQL Queries, Identify Server Objects, Setup Performance Monitoring, Automate Tasks, Identify instances of SQL Server
Skills covered in this course
Reviews
-
SSultana Abushareeda
Amazing course, please do some more courses for DBA.
-
MMayank Sharma
Can be more descriptive and with proper practical steps to demonstrate. Else, just for an overview to understand SQL DBA it's good to go.
-
MMohammad Alsolaiman
It's nice as it's a basic level. It gives you a good interview about SQL Server & what parts does it compose of, & how to install these parts.
-
AAnonymized User
its a good course. but he should explain scenarios where those things in teaches will be use in real life situation.
