Database Administrator - MS SQL/T-SQL/Azure SQL/SSMS

Learn Practical Database Management Skills

4.00 (21 reviews)
Udemy
platform
English
language
Databases
category
Database Administrator - MS SQL/T-SQL/Azure SQL/SSMS
1,065
students
10 hours
content
Nov 2021
last update
$64.99
regular price

What you will learn

Install and Setup Microsoft SQL Server

Connect to SQL Server using SSMS

Install Sample Databases

Create databases and Tables

Creating table relationships

Implementing Table Constraints

Performing CRUD Operations

Creating Views

Backing Up and Restoring Databases

Query database using Microsoft SQL | T-SQL

Filtering Data

Sorting Data

Extracting data from multiple tables

Aggregate Data using Aggregate Functions

Implementing Database Performance Monitor

Implementing Database Security

Creating and querying Azure SQL databases

Description

Database Administration consists of everything required to manage a database and make it available as needed. The database administrator (DBA) is the person who manages, backs up and ensures the availability of the data produced and consumed by today's organizations via their IT systems.

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.

Content

Microsoft SQL Database Server Setup

Introduction
What is SQL Server
Hardware and Software Requirements
SQL Server Editions
SQL Server Download
SQL Server Installation
SQL Server Configuration Manager
SQLCMD Utility
Installing SSMS
Connecting to SQL Server with SSMS
Creating a new user account in SQL Server
Resetting SA Account
Install Sample adventureWorks Database
Install Sample adventureWorksDW Database
Install Worldwide Importers Database
Install Worldwide ImportersDW Database
SQL Server Data Files

Creating Databases and Tables with SSMS

Create and configure a new database
Create a new table
Editing table structure
Inserting data into table
Importing data from CSV File
Create a table from a flat file

Database Tables Design Properties

Column Properties
Creating identity column
Primary keys
Setting default values
Check constraints
Unique Constraints
Foreign Keys
Creating relationships between tables

MS SQL CRUD Operations | Database Backup & Restore

What is CRUD
What is SQL
What is T-SQL
Creating a new database
Creating a new table
Inserting records
Retrieving data from database
Table Views
Updating Records
Deleting Records
Truncating table
Stored Procedures
Dropping a table
Dropping a database
Backing up a database
Restoring a database

Some MS SQL (T-SQL Commands)

TOP Command
GO Command
USE Command
DISTINCT Command

Filtering Data with MS SQL (T-SQL | SQL )

Introduction
Filtering data with equality filters
Filtering data with comparison filters
Filtering data with logical comparison
Filtering data with String comparison
Filtering data with NULL Values

Sorting Data

Introduction
Order By Clause
Sorting by ascending
Sorting by descending
Sorting by multiple columns

Extracting data from multiple tables

Introduction
Why Table joins are useful
INNER Join
LEFT OUTER Join
RIGHT OUTER JOIN

Aggregating Data

Introduction
COUNT Aggregate Function
AVG Aggregate Function
MAX Aggregate Function
MIN Aggregate Function
SUM Aggregate Function
Grouping Data

Database Performance Monitoring

Introduction
Using the activity monitor
Collecting data
Using performance monitor
Using extended events
Using indexes

Database Security

Enforcing Authentication
Applying Permission level access
Using Audits to check database integrity

Azure Setup

What is Azure
What is Azure SQL
Create an Azure account
Accessing Azure Services
Create a database in Azure
Query SQL Database in Azure

Connect SSMS to Azure SQL Database

Connect to Azure SQL with SSMS
Inserting Data into Azure SQL Database
Updating Data in Azure SQL Database
Delete data from Azure SQL Database
Create tables in Azure SQL
Create database diagrams
Install Command line Utilities
Bulk Load Data using BCP
Query data with SSMS

Coupons

DateDiscountStatus
11/20/2021100% OFF
expired

Charts

Price

Database Administrator - MS SQL/T-SQL/Azure SQL/SSMS - Price chart

Rating

Database Administrator - MS SQL/T-SQL/Azure SQL/SSMS - Ratings chart

Enrollment distribution

Database Administrator - MS SQL/T-SQL/Azure SQL/SSMS - Distribution chart
4376186
udemy ID
11/1/2021
course created date
11/4/2021
course indexed date
Bot
course submited by