Database Administrator MS SQLT-SQLAzure SQLSSMS

Database Administrator – MS SQL/T-SQL/Azure SQL/SSMS, available at $64.99, has an average rating of 4.45, with 98 lectures, based on 24 reviews, and has 1074 subscribers.

You will learn about 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 This course is ideal for individuals who are Beginner Database Administrator or Data Analyst or Data Scientist It is particularly useful for Beginner Database Administrator or Data Analyst or Data Scientist.

Enroll now: Database Administrator – MS SQL/T-SQL/Azure SQL/SSMS

Summary

Title: Database Administrator – MS SQL/T-SQL/Azure SQL/SSMS

Price: $64.99

Average Rating: 4.45

Number of Lectures: 98

Number of Published Lectures: 98

Number of Curriculum Items: 98

Number of Published Curriculum Objects: 98

Original Price: $79.99

Quality Status: approved

Status: Live

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

Who Should Attend

Beginner Database Administrator

Data Analyst

Data Scientist

Target Audiences

Beginner Database Administrator

Data Analyst

Data Scientist

Database Administration consists of everything required to manage a database and make it available as needed. The database administrator (DBA) is the personwho 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.

Course Curriculum

Chapter 1: Microsoft SQL Database Server Setup

Lecture 1: Introduction

Lecture 2: What is SQL Server

Lecture 3: Hardware and Software Requirements

Lecture 4: SQL Server Editions

Lecture 5: SQL Server Download

Lecture 6: SQL Server Installation

Lecture 7: SQL Server Configuration Manager

Lecture 8: SQLCMD Utility

Lecture 9: Installing SSMS

Lecture 10: Connecting to SQL Server with SSMS

Lecture 11: Creating a new user account in SQL Server

Lecture 12: Resetting SA Account

Lecture 13: Install Sample adventureWorks Database

Lecture 14: Install Sample adventureWorksDW Database

Lecture 15: Install Worldwide Importers Database

Lecture 16: Install Worldwide ImportersDW Database

Lecture 17: SQL Server Data Files

Chapter 2: Creating Databases and Tables with SSMS

Lecture 1: Create and configure a new database

Lecture 2: Create a new table

Lecture 3: Editing table structure

Lecture 4: Inserting data into table

Lecture 5: Importing data from CSV File

Lecture 6: Create a table from a flat file

Chapter 3: Database Tables Design Properties

Lecture 1: Column Properties

Lecture 2: Creating identity column

Lecture 3: Primary keys

Lecture 4: Setting default values

Lecture 5: Check constraints

Lecture 6: Unique Constraints

Lecture 7: Foreign Keys

Lecture 8: Creating relationships between tables

Chapter 4: MS SQL CRUD Operations | Database Backup & Restore

Lecture 1: What is CRUD

Lecture 2: What is SQL

Lecture 3: What is T-SQL

Lecture 4: Creating a new database

Lecture 5: Creating a new table

Lecture 6: Inserting records

Lecture 7: Retrieving data from database

Lecture 8: Table Views

Lecture 9: Updating Records

Lecture 10: Deleting Records

Lecture 11: Truncating table

Lecture 12: Stored Procedures

Lecture 13: Dropping a table

Lecture 14: Dropping a database

Lecture 15: Backing up a database

Lecture 16: Restoring a database

Chapter 5: Some MS SQL (T-SQL Commands)

Lecture 1: TOP Command

Lecture 2: GO Command

Lecture 3: USE Command

Lecture 4: DISTINCT Command

Chapter 6: Filtering Data with MS SQL (T-SQL | SQL )

Lecture 1: Introduction

Lecture 2: Filtering data with equality filters

Lecture 3: Filtering data with comparison filters

Lecture 4: Filtering data with logical comparison

Lecture 5: Filtering data with String comparison

Lecture 6: Filtering data with NULL Values

Chapter 7: Sorting Data

Lecture 1: Introduction

Lecture 2: Order By Clause

Lecture 3: Sorting by ascending

Lecture 4: Sorting by descending

Lecture 5: Sorting by multiple columns

Chapter 8: Extracting data from multiple tables

Lecture 1: Introduction

Lecture 2: Why Table joins are useful

Lecture 3: INNER Join

Lecture 4: LEFT OUTER Join

Lecture 5: RIGHT OUTER JOIN

Chapter 9: Aggregating Data

Lecture 1: Introduction

Lecture 2: COUNT Aggregate Function

Lecture 3: AVG Aggregate Function

Lecture 4: MAX Aggregate Function

Lecture 5: MIN Aggregate Function

Lecture 6: SUM Aggregate Function

Lecture 7: Grouping Data

Chapter 10: Database Performance Monitoring

Lecture 1: Introduction

Lecture 2: Using the activity monitor

Lecture 3: Collecting data

Lecture 4: Using performance monitor

Lecture 5: Using extended events

Lecture 6: Using indexes

Chapter 11: Database Security

Lecture 1: Enforcing Authentication

Lecture 2: Applying Permission level access

Lecture 3: Using Audits to check database integrity

Chapter 12: Azure Setup

Lecture 1: What is Azure

Lecture 2: What is Azure SQL

Lecture 3: Create an Azure account

Lecture 4: Accessing Azure Services

Lecture 5: Create a database in Azure

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 0 votes

2 stars: 2 votes

3 stars: 1 votes

4 stars: 6 votes

5 stars: 15 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!