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

Learn Practical Database Management Skills

What you'll 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:
BackupsConfirm that backups have been made and successfully saved to a secure locationCheck the backup failure alerts, correct the errors and rerun the backupsReview the average duration of backup, any significant changes occurred investigates on this.Most of the time it happens due to networking low bandwidthValidate 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.
PerformanceRegularly 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 dataCreate indexes to reduce the time it takes to get responses from the  SQL Server  after a T-SQL Script is executed.
SecurityCheck the  auditing  logs for failed logins and notify the audit team if necessaryImplement 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.

Who this course is for:
Beginner Database Administrator
Data Analyst
Data Scientist

More Info