IIRF Online > Development > Database Design & Development > SQL Server > Microsoft SQL Server Certification Training
Microsoft SQL Server Certification Training by Edureka
Skills you will learn!
Curriculum
8 Topics
Database Systems
RDBMS
Properties of Databases
Introduction to SQL
E-R Model
Client Server Model
MS SQL Server
Microsoft SQL Management Studio (SSMS)
7 Topics
Normalization
Operation on Keys
SQL Commands
Merge
Alter
Select
Joins
4 Topics
Aggregate Functions
Scalar Operators
SQL Server Operators
T-SQL
6 Topics
Views
Sub Queries
Set clause
Case Expressions
Stored Procedures
Concurrency Control
6 Topics
Ranking Functions
Date and Time Functions
UDFs (User Defined Functions)
Backup and Restore Databases
Triggers
Index
5 Topics
Introduction to Optimization
Understanding Performance
Optimizing Queries
Indexing for Performance
Performance Tuning
6 Topics
Architecture of Security Model
Server Authentication Modes
Managing Users Roles and Logins
Permissions (GRANT DENY REVOKE)
Understanding Server Agents
Server Agent Jobs and Schedules
5 Topics
Database Mails via Server Agents
Activity Monitor
Log Shipping
Configuring Log Shipping
Transparent Data Encryption
6 Topics
Introduction to Azure
Creating Azure Account
Creating and configuring Azure VMs
Azure SQL Database
Accessing Azure Services
Query SQL database in Azure
5 Topics
Introduction to Microsoft Data Migration Assistant
Setting up Migration Assistant
Migrate Local SQL Server Database to Azure SQL Database
Migration Data Checks
Best Practices
5 Topics
Introduction to SSRS
Create deploy and manage reports
Paginated Reports
Setting up SSRS
SSRS GUI
Microsoft SQL Server Certification Training
Related SQL Server Courses
Thank You!
Your review has been submitted successfully.