SQL Server DBA Essentials for beginners

SQL Server DBA Essentials for beginners, available at $19.99, has an average rating of 3.95, with 30 lectures, based on 37 reviews, and has 638 subscribers.

You will learn about Setup security on SQL Server Monitor performance of SQL Server Backup database Restore database Update data Insert data Delete data Truncate data Drop table This course is ideal for individuals who are Aspiring DBA or Aspiring Data Analyst or Aspiring SQL developers or Data warehouse professionals It is particularly useful for Aspiring DBA or Aspiring Data Analyst or Aspiring SQL developers or Data warehouse professionals.

Enroll now: SQL Server DBA Essentials for beginners

Summary

Title: SQL Server DBA Essentials for beginners

Price: $19.99

Average Rating: 3.95

Number of Lectures: 30

Number of Published Lectures: 30

Number of Curriculum Items: 30

Number of Published Curriculum Objects: 30

Original Price: $139.99

Quality Status: approved

Status: Live

What You Will Learn

Setup security on SQL Server
Monitor performance of SQL Server
Backup database
Restore database
Update data
Insert data
Delete data
Truncate data
Drop table

Who Should Attend

Aspiring DBA
Aspiring Data Analyst
Aspiring SQL developers
Data warehouse professionals

Target Audiences

Aspiring DBA
Aspiring Data Analyst
Aspiring SQL developers
Data warehouse professionals

SQL Server is a relational database management system (RDBMS)
from Microsoft that’s designed for the enterprise environment.

A DBA ( Database administrator) has to perform several responsibilities to ensure the smooth running
of the SQL sever database.

Some of the key daily responsibilities of a SQL Server DBA includes:

Backups
Confirm that backups have been made and successfully saved to a secure location
Check the backup failure alerts, correct the errors and rerun the backups
Review the average duration of backup, any significant changes occurred investigates on this.
Most of the time it happens due to networking low bandwidth
Validate the backup files using restore verify only. Jobs can be created to take care of the task and to send a notification if it fails to verify any backup.

Performance
Regularly monitor and identify blocking issues.
Check Performance counters on all production servers and verify that all counters are within the normal range.
Throughout the day, periodically monitor performance by collecting relevant data
Create indexes to reduce the time it takes to get responses from the SQL Server after a T-SQLscript is executed.

Security
Check the auditing logs for failed logins and notify the audit team if necessary
Implement relevant permissions to prevent authorised access to SQL Server databases

T-SQL ( Transact -SQL )
Transact-SQL is central to using SQL Server. All applications that communicate with an instance of SQL Server
do so by sending Transact-SQL statements to the server, regardless of the user interface of the application.
T-SQL is Microsoft’s proprietary version of the standard SQL(Structural Query language)

Using T-SQL you can communicate with SQL Servers to perform task like:

Retrieving data from the database
Updating information
Inserting data into databases
Deleting data
Dropping a Table or database

Course Curriculum

Chapter 1: Introduction and Connecting to virtual lab

Lecture 1: Introduction

Lecture 2: What is SQL Server

Lecture 3: What is a DBA

Lecture 4: Database Concept

Lecture 5: MSDN Virtual Labs

Chapter 2: Database backup and restore strategy

Lecture 1: Copy Database

Lecture 2: Full Backup

Lecture 3: Differential Backup

Lecture 4: Transaction Backup

Lecture 5: Recovering a database

Lecture 6: Lab Exercise 1

Lecture 7: Lab exercise 2

Chapter 3: Implementing security and protecting the databases

Lecture 1: Enforcing Authentication

Lecture 2: Permission level access

Lecture 3: Auditing to check database integrity

Chapter 4: Monitoring SQL Server Performance

Lecture 1: Using Activity Monitor

Lecture 2: Data collection

Lecture 3: Activating Performance monitor

Lecture 4: Extended Events

Lecture 5: Using Indexes to improve performance

Chapter 5: T-SQL

Lecture 1: What is T-SQL

Lecture 2: SELECT Statement

Lecture 3: DELETE Statement

Lecture 4: UPDATE Statement

Lecture 5: INSERT Statement

Lecture 6: CREATE Statement

Lecture 7: ALTER Statement

Lecture 8: DROP Statement

Lecture 9: TRUNCATE Statement

Lecture 10: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 3 votes
2 stars: 3 votes
3 stars: 6 votes
4 stars: 13 votes
5 stars: 12 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu