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

2 Comments

  • Victor Anogwih
    Posted July 23, 2021 3:23 pm 0Likes

    Hi am interested in training with your organization. Am the CEO of Zarvich OSH Nigeria Limited, an ICT company based in Nigeria. We provide ICT services that cover Hotel Management Software, Systems Networking, CCTV and Mikrotik Server deployment for WLAN and LAN

    I am interested in joining your training and eventually joining your team. This is because I need to acquire database skills that will expand the opportunities we have as a company.
    Most of our software have been outsourced to private programmers who eventually leave when we need them most. I have suffered alot of losses and I feel its time to acquire these programming skills.

    Hoping to hear from you soon

    Thanks

  • Dunstan
    Posted September 7, 2021 2:48 pm 0Likes

    Am from Nigeria and wish to know how much this is course

Leave a comment

Minimum 4 characters