Training Services
MPIT provides SQL Server training classes at all levels, both online and in class. In addition, we help you obtain high-paying jobs through our successful Workforce Development, Partner Programs, and on-going job support for up to three months. Also, we provide corporate on-site training for organizations. We can help improve the skill sets of your IT team in the following topics: T-SQL, High Availability and Disaster Recovery Solutions, Understanding the basics of SQL Server, Business Intelligence (BI) etc.
We Provide Expert Instructor-Led Hands-On Microsoft SQL Server Database Administration Training from Zero to Advance Level. If you are using or planning to use Microsoft SQL Server in your enterprise environment, we can help your team with all aspects of the SQL Server database management systems.
Whether you need to gain skills like designing, developing, maintaining, and analyzing databases or you are working toward a MS certification such as an MCSA in data platform or an MCSE in business intelligence, we have the SQL Server classes to help you get there.
MPIT has a variety of database classes such as:
- Microsoft SQL Server
- Power BI
- Azure Computing
COURSE OUTLINE
GETTING STARTED WITH MICROSOFT SQL SERVER
1.1 Overview of Microsoft SQL Server
1.2 Introduction to Virtual Machines (VMs)
1.3 Installing, Configuring, and Upgrading Microsoft SQL Server
2.1 DATABASE DESIGN [PART 1]
Designing SQL Server database
Designing tables
Understanding Views
2.2 DATABASE DESIGN [PART 2]
Table partitioning
Database snapshots
3.1 INTRODUCTION TO TRANSACT-SQL (T-SQL)
Writing a SELECT statement
Sorting results
Filtering data with the WHERE clause
Creating aliases
Using the JOIN operator to return data from multiple tables
Limiting the data returned in your result set
Using UNION to combine result sets
Pivoting and unpivoting data
Windowing
User-defined functions
4.2 Stored procedures
4.3 TRIGGERS
SQL Server MAINTENANCE
5.1 Database Back Up
5.2 Database Restore
5.3 Upgrade and Migration
5.4 SQL SERVER AUTOMATION
6.0 PERFORMANCE TUNNING
7.0 SQL SERVER SECURITY
8.0 HIGH AVAILABILITY AND DISASTER RECOVERY SOLUTIONS
8.1 SQL SERVER REPLICATION
8.2 TRADITIONAL FAILOVER CLUSTER
8.3 Configuring SQL Server AlwaysOn Availability Groups
8.4 Log shipping
8.5 Introduction to Azure Computing