Learn Practical Database Management Skills
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
Perfog 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
Basic database concepts advised but not mandatory
Database Administration consists of everything required to manage a database and make it available as needed.
Preview
1 image
Download File
