HOT
blank

Learn SQL Server DBA Skills from Scratch

Development

Rating4
Enroll Now

Learn SQL Server DBA Skills from Scratch, available at $54.99, has an average rating of 3.95, with 99 lectures, based on 246 reviews, and has 1899 subscribers.

You will learn about Backup a database Recover a database Secure a database Install SQL Server Instance Create ETL Package with SSIS Create dashboard reports with SSRS Monitor SQL Server Database Write T-SQL queries Use SQL Server Tools like SSMS This course is ideal for individuals who are Support Engineers or Aspiring DBA'S or Aspiring Programmers or Aspiring Developers or Aspiring Data Warehouse professionals or Data Analyst or Data Scientist or Graduate looking for career in IT It is particularly useful for Support Engineers or Aspiring DBA'S or Aspiring Programmers or Aspiring Developers or Aspiring Data Warehouse professionals or Data Analyst or Data Scientist or Graduate looking for career in IT.

Enroll now: Learn SQL Server DBA Skills from Scratch

Summary

Title: Learn SQL Server DBA Skills from Scratch

Price: $54.99

Average Rating: 3.95

Number of Lectures: 99

Number of Published Lectures: 84

Number of Curriculum Items: 99

Number of Published Curriculum Objects: 84

Original Price: $139.99

Quality Status: approved

Status: Live

What You Will Learn

  • Backup a database
  • Recover a database
  • Secure a database
  • Install SQL Server Instance
  • Create ETL Package with SSIS
  • Create dashboard reports with SSRS
  • Monitor SQL Server Database
  • Write T-SQL queries
  • Use SQL Server Tools like SSMS

Who Should Attend

  • Support Engineers
  • Aspiring DBA'S
  • Aspiring Programmers
  • Aspiring Developers
  • Aspiring Data Warehouse professionals
  • Data Analyst
  • Data Scientist
  • Graduate looking for career in IT

Target Audiences

  • Support Engineers
  • Aspiring DBA'S
  • Aspiring Programmers
  • Aspiring Developers
  • Aspiring Data Warehouse professionals
  • Data Analyst
  • Data Scientist
  • Graduate looking for career in IT

SQL Server DBA Skills are in  hot demand due to the growth  and reliance on data.SQL Server is a relational database management system 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-SQL Script is executed.

Security
Check the  auditing  logs for failed logins and notify the audit team if necessary
Implement relevant permissions to prevent authorized 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 data
Inserting data into databases
Deleting data

Course Curriculum

Chapter 1: Getting Started with SQL Server

Lecture 1: Introduction

Lecture 2: Please Read

Lecture 3: What is a DBA

Lecture 4: Database Concepts

Chapter 2: SQL Server 2019 Local Environment Setup

Lecture 1: What is SQL Server

Lecture 2: SQL Server 2019 Hardware | Software Installation Requirements

Lecture 3: SQL Server Editions

Lecture 4: Download SQL Server 2019 Developer Edition

Lecture 5: SQL Server 2019 Developer Edition Installation

Lecture 6: Installing SQL Server Management Studio

Lecture 7: Connecting to SQL Server with SSMS

Lecture 8: SQL Server Configuration Manager

Lecture 9: Install adventureworks 2016 database

Lecture 10: Install adventureworksDW 2016 database

Lecture 11: Enabling Log shipping

Chapter 3: SQL Server Reporting Services Setup

Lecture 1: Installing Reporting Services

Lecture 2: Configure Report Server

Lecture 3: Accessing Report Server Web Portal Locally

Lecture 4: Accessing Report Server Web Portal Remotely

Lecture 5: Configure SSMS for local SSRS administration

Lecture 6: Adding users and groups to SSRS Web Portal

Lecture 7: Installing Report Builder

Chapter 4: Visual Studio 2019 and SSIS Setup

Lecture 1: What is Visual Studio

Lecture 2: Minimum Installation Requirements for Visual Studio 2019

Lecture 3: Installing Visual Studio

Lecture 4: Installing SQL Server Data Tools (SSDT)

Lecture 5: Installing Designers for SSIS,SSAS,SSRS

Chapter 5: SQL Server Integration Services -SSIS

Lecture 1: What is SSIS

Lecture 2: Create new SSIS Project with Visual studio 2019

Lecture 3: Create new Integration Project

Lecture 4: Adding Flat file connection manager

Lecture 5: Remapping Column Data Types

Lecture 6: Adding and Configuring OLE DB Connection Manager

Lecture 7: Add a Data Flow Task to a Package

Lecture 8: Add and configure Flat File Source

Lecture 9: Add and configure Lookup Transformation

Lecture 10: Add and configure Lookup Key for DateKey Transformation

Lecture 11: Add and Configure OLE DB Destination

Lecture 12: Testing SSIS Package

Chapter 6: SQL Server Reporting Services -SSRS

Lecture 1: Using SSRS to create Executive Dashboards

Lecture 2: Create a basic report – part 1

Lecture 3: Create a basic report – part 2

Chapter 7: Creating a Column Chart with SSRS

Lecture 1: Create the data source

Lecture 2: Create the data sets

Lecture 3: Add the column chart

Lecture 4: Add extra data to a column chart

Chapter 8: Creating a Pie Chart with SSRS

Lecture 1: Create the data source

Lecture 2: Create the data sets

Lecture 3: Add the Pie Chart

Chapter 9: Using SSRS to add Indicators to Reports

Lecture 1: Create the data source

Lecture 2: Create the data sets

Lecture 3: Add the Indicators

Chapter 10: Adding a Gauge with SSRS

Lecture 1: Create the data source

Lecture 2: Create the data sets

Lecture 3: Add the Gauge

Chapter 11: Adding Maps to Reports with SSRS

Lecture 1: Create the data source

Lecture 2: Create the data sets

Lecture 3: Add the Map

Chapter 12: Database Backup and Recovery

Lecture 1: Copy Database

Lecture 2: Performing a Full Database Backup

Lecture 3: Performing a Differential Database Backup

Lecture 4: Performing a Transaction Database Backup

Lecture 5: Recovering a Database

Lecture 6: Lab Exercise 1

Lecture 7: Lab Exercise 2

Chapter 13: Monitoring SQL Server Performance

Lecture 1: Introduction

Lecture 2: Using Activity Monitor

Lecture 3: Collecting Data

Lecture 4: Using Performance Monitor

Lecture 5: Using Extended Events

Lecture 6: Using Indexes to improve performance

Chapter 14: Database Security

Lecture 1: Enforcing Authentication

Lecture 2: Applying Permission level access

Lecture 3: Using Audit to check database integrity

Chapter 15: Transact-SQL -T-SQL

Lecture 1: What is T-SQL

Lecture 2: Writing a basic SELECT Statement

Lecture 3: Removing records with T-SQL

Lecture 4: Modifying Data with T-SQL

Lecture 5: Add data to database with T-SQL

Lecture 6: Create a database object with T-SQL

Lecture 7: Alter Database Structure with T-SQL

Lecture 8: Deleting Database Objects with T-SQL

Lecture 9: Stripping a database table of data with T-SQL

Lecture 10: Thank You

Instructors

Rating Distribution

  • 1 stars: 13 votes
  • 2 stars: 12 votes
  • 3 stars: 48 votes
  • 4 stars: 94 votes
  • 5 stars: 79 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!

You may also like

Top 10 Ethical AI Courses to Learn in November 2024

Top 10 Game Development Courses to Learn in November 2024

Top 10 Software Testing Courses to Learn in November 2024