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

Learn Practical Database Management Skills

Created by: Bluelime Learning Solutions
Making Learning Simple

What Will I 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

Requirements

• Basic database concepts advised but not mandatory

Target audience

• Beginner Database Administrator
• Data Analyst
• Data Scientist