IT 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

  1. PERFORMANCE TUNNING
  2. SQL SERVER SECURITY
  3. 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

Leave a comment

Minimum 4 characters