Learn SQL Server DBA Skills from Scratch
4.1 (26 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.
1,070 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn SQL Server DBA Skills from Scratch to your Wishlist.

Add to Wishlist

Learn SQL Server DBA Skills from Scratch

A guide to becoming an SQL Server Database Administrator - DBA
Best Seller
4.1 (26 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.
1,070 students enrolled
Last updated 3/2017
English
Current price: $10 Original price: $165 Discount: 94% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 7.5 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
Requirements
  • You should be able to use a PC at a beginner level
  • Basic knowledge of Database Concepts
  • Basic SQL knowledge
Description

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

Who is the target audience?
  • Support Engineers
  • Aspiring DBA'S
  • Aspiring Programmers
  • Aspiring Developers
  • Aspiring Data Warehouse professionals
  • Data Analyst
  • Data Scientist
  • Graduate looking for career in IT
Compare to Other SQL Server Courses
Curriculum For This Course
73 Lectures
07:38:31
+
Getting Started with SQL Server
12 Lectures 01:05:09







Download and attach AventureworksDW Database 2014
06:39

Installing Multiple SQL Server Instance
09:25

Connecting to named instances of SQL Server
03:44

MSDN Virtual Labs
10:44

What is log shipping
05:03
+
SQL Server Integration Services -SSIS
15 Lectures 01:32:45
What is SSIS
03:24

Computer requirements to install Visual studio
03:08

Download and install visual studio
07:47

Completing and configuring visual studio installation
05:09

Download and Install SQL Server Data Tools -SSDT
06:03

Create new Integration Project
05:35

Adding Flat file connection manager
06:26

Remapping Column Data Types
11:12

Adding and Configuring OLE DB Connection Manager
03:39

Add a Data Flow Task to a Package
05:02

Add and configure Flat File Source
04:28

Add and configure Lookup Transformation
11:29

Add and configure Lookup Key for DateKey Transformation
09:28

Add and Configure OLE DB Destination
07:53

Testing SSIS Package
02:02
+
SQL Server Reporting Services -SSRS
5 Lectures 33:00
Using SSRS to create Executive Dashboards
01:57

Using Microsoft TechNet Virtual Labs
04:45

Connecting to Virtual Lab
08:01

Create a basic report - part 1
06:57

Create a basic report - part 2
11:20
+
Creating a Column Chart with SSRS
4 Lectures 22:09
Create the data source
06:21

Create the data sets
03:40

Add the column chart
06:46

Add extra data to a column chart
05:22
+
Creating a Pie Chart with SSRS
3 Lectures 16:11
Create the data source
06:21

Create the data sets
04:09

Add the Pie Chart
05:41
+
Using SSRS to add Indicators to Reports
3 Lectures 25:03
Create the data source
06:21

Create the data sets
07:24

Add the Indicators
11:18
+
Adding a Gauge with SSRS
3 Lectures 22:29
Create the data source
06:21

Create the data sets
07:24

Add the Gauge
08:44
+
Adding Maps to Reports with SSRS
3 Lectures 16:23
Create the data source
06:21

Create the data sets
03:53

Add the Map
06:09
+
Database Backup and Recovery
7 Lectures 38:14
Copy Database
03:02

Performing a Full Database Backup
09:18

Performing a Differential Database Backup
08:42

Performing a Transaction Database Backup
06:55

Recovering a Database
07:13

Lab Exercise 1
02:30

Lab Exercise 2
00:34
+
Monitoring SQL Server Performance
6 Lectures 31:32
Introduction
00:42

Using Activity Monitor
02:38

Collecting Data
08:34

Using Performance Monitor
06:19

Using Extended Events
07:16

Using Indexes to improve performance
06:03
2 More Sections
About the Instructor
Bluelime Learning Solutions
4.0 Average rating
1,761 Reviews
38,768 Students
92 Courses
Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.