SQL DBA For Beginners
3.8 (9 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
59 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL DBA For Beginners to your Wishlist.

Add to Wishlist

SQL DBA For Beginners

Learn the Lucrative skills of a DBA
3.8 (9 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
59 students enrolled
Created by Skill Tree
Last updated 5/2016
English
Curiosity Sale
Current price: $10 Original price: $125 Discount: 92% off
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Backup and Restore Databases
  • Write basic T-SQL Queries
  • Identify Server Objects
  • Setup Performance Monitoring
  • Automate Tasks
  • Identify instances of SQL Server
View Curriculum
Requirements
  • Browser and internet access
Description

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

Who is the target audience?
  • Anyone with basic Database and T-SQL Knowledge
  • Not suitable for advanced database users
Students Who Viewed This Course Also Viewed
Curriculum For This Course
37 Lectures
03:27:23
+
Getting Started
5 Lectures 27:36


SQL Server Instances
05:59

Installed Databases
04:52

Server Objects
03:19
+
Backing Up and Restoring Databases
10 Lectures 50:08
Introduction
01:30

Importing and Exporting Data
09:10

Database Copy
03:02

Full Database Backup
09:17

Differential Database Backup
08:42

Transaction Log Backup
06:55

How to Recover Database
07:13

Lab Practice 1
02:30

Lab Practice 2
00:34

Summary
01:15
+
Performance Monitoring and Tuning
7 Lectures 32:49
Introduction
00:42

Activity Monitor
02:38

Gathering Data
08:34

Performance Monitor
06:19

Extended Events
07:15

Using Indexes to Improve Performance
06:03

Automating Task
01:18
+
T-SQL Refresher
10 Lectures 59:58
What is T-SQL
02:51

Writing a T-SQL SELECT Query
09:27

Using T-SQL UPDATE Query
05:31

T-SQL DELETE Query
05:13

T-SQL INSERT Query
11:24

T-SQL CREATE Query
11:10

T-SQL ALTER Query
04:39

T-SQL DROP Query
02:49

T-SQL TRUNCATE Query
03:38

Summary
03:16
+
Administering Database Security
5 Lectures 36:52
Introduction
03:10

Authentication
11:43

Controlling Access with Permissions
09:20

Enabling Auditing
10:13

Conclusion
02:26
About the Instructor
Skill Tree
4.3 Average rating
291 Reviews
7,707 Students
19 Courses
Skill based learning

We are experienced company that provides quality video based training .
Our courses are easy to follow and understand and will take you from
an absolute beginner with no technical skills to being efficient and confident with various technical skill like SQL and databases.
We have worked with companies of various sizes and provided consultancy services at various levels.
Thank you for learning with us and we hope your experience will be pleasant.