248-489-0408

Microsoft Database

Home > Training Programs > Database Administration and SQL Training > Microsoft Database

Microsoft SQL Server Database & Business Intelligence Training at Michigan Technology Services

Michigan Technology Services offers a wide variety of instructor led Microsoft SQL Server DBA & Microsoft Business Intelligence courses, including new SQL Server 2019, SQL Server 2016, SQL 2014, and older SQL 2012 classes.  The training can take place at our location in Farmington Hills, 20 miles outside of Detroit, where you will sit in a room with one of our instructors, onsite at your office anywhere throughout the United States, or if you prefer, instructor led live online.

Don’t see what you are looking for? Call Michigan Technology Services for additional Microsoft technical course listings – 248-489-0408.

  • SQL Server 2019

    All SQL 2019 courses available.  Call 248-489-0408 for details.

    SQL Server 2016

    • Introduction to SQL Databases
    • Administering Microsoft SQL Server 2016 Databases
    • Implementing a Data Warehouse with SQL Server 2016
    • Developing Microsoft SQL Server 2014 Databases
    • Updating Your Skills to Microsoft SQL Server 2016This three-day instructor-led course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.
    • Advanced T-SQL Querying, Programming and Tuning for SQL Server 2012, 2014 and SQL 2016
    • Performance Tuning and Optimizing SQL DatabasesThis four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.  After completing this course, students will be able to: Describe the high level architectural overview of SQL Server and its various components.
    • Provisioning SQL Databases
    • Querying Data with Transact-SQLThe main purpose of this 3 day instructor led  course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

  • SQL Server 2014

    • Fundamentals of SQL QueryingIn this 2-day instructor led course students will learn what SQL is and how it can help them query a database to answer business questions. This course will combine instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.
    • Querying Microsoft SQL Server 2014This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014.
    • Administering Microsoft SQL Server 2014 Databases This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.
    • Implementing a Data Warehouse with SQL Server 2014 This five-day instructor-led course describes how to implement a data warehouse platform to support a BI solution.
    • Developing Microsoft SQL Server 2014 Databases This 5-day instructor-led course introduces SQL Server 2014 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions.
    • Updating your Database Skills to Microsoft SQL Server 2014This five-day instructor-led course teaches students how to use the enhancements and new features that have been added to SQL Server and the Microsoft data platform since the release of SQL Server 2008. The course focuses on teaching individuals how to use SQL Server 2014 product features and other Microsoft data platform components.
    • Performance Tuning and Optimizing SQL DatabasesThis four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.
    • Designing Solutions for Microsoft SQL Server 2014The focus of this three-day instructor-led course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies.
    • Implementing Data Models and Reports with SQL Server 2014The focus of this 5 day instructor-led course is on creating managed enterprise BI solutions.
    • SQL Server High Availability

SQL Server 2012 and SQL 2012 R2

  • Querying Microsoft SQL Server 2012
  • Administering Microsoft SQL Server 2012 Databases
  • Implementing a Data Warehouse with Microsoft SQL Server 2012
  • Developing Microsoft SQL Server 2012  Databases
  • Updating your Database Skills to Microsoft SQL Server 2012

SQL Server 2012 Business Intelligence

  • Implementing Data Models and Reports with Microsoft SQL Server 2012
  • Designing Business Intelligence Solutions with Microsoft SQL Server 2012
  • Designing BI Report Solutions with SQL Server 2012 Reporting Services and SharePoint 2010
  • Updating your Business Intelligence Skills to Microsoft SQL Server 2012
  • SQL Server 2012 Analysis Services
  • Additional SQL Server 2012 BI courses will be announced as they are released.

SQL Server 2008 R2

  • Implementing a Microsoft SQL Server 2008 R2 Database
  • Maintaining a Microsoft SQL Server 2008 R2 Database
  • LearnBlock: SQL Administration Survival Skills

SQL 2008 Business Intelligence

  • SQL Server 2008 Reporting Services
  • SQL Server 2008 Analysis Services
  • Advanced SQL Server 2008 R2 Analysis Services
  • SQL Server 2008 Integration Services
  • Advanced SQL Server 2008 R2 Integration Services

SQL Server 2008 and SQL Server 2005

  • Implementing a Microsoft SQL Server 2008 or 2005 Database
  • Maintaining a Microsoft SQL Server 2008 or 2005 Database
  • Designing Microsoft SQL Server 2005 Databases
  • Updating Your SQL Server 2005 Skills to SQL Server 2008

Student Successes

  • The Certified ScrumMaster and Certified Scrum Developer courses that Michigan Technology Services set up for our organization were great. The instructors (Mark and Angela) were outstanding.

    - SF, Senior Software Developer – Hewlett Packard Enterprise

  • The instructors were top notch and made the courses exciting. I have taken Cisco CCNA, Linux and SQL admin classes and I find myself using the knowledge gained every day. If you value getting quality content that will be relevant for years to come, take these courses with Michigan Technology Services.

    - SP, Detroit Network Team Manager – Global Advertising Company

  • I have taken the Scrum Alliance Certified ScrumMaster and Product Owner classes from Michigan Technology Services and thoroughly enjoyed the class content and instructors. I found the ScrumMaster class particularly engaging and energizing as the instructor was top notch. Both classes fueled my passion for agile project management and team dynamics which I have used to drive change in the way my department executes and thinks about running software development projects. I highly recommend Robert and his company.

    - Daniel King, Senior Project Manager – AAA Michigan – Auto Club Group

  • In February of 2015, the Detroit Housing Commission reached out to Michigan Technology Services to request Microsoft Office Excel training for the staff. Within a few days, Rob was able to set up the services at a very reasonable expense. The trainer was superb, knowledgeable and very patient with the students.  It was one of the best trainings that we have ever had.

    - De’Onna Henderson, Director of Asset Management – Detroit Housing Commission

  • We had an excellent experience working with Rob at Michigan Technology Services. He went above and beyond helping us to design three days of onsite customized SharePoint training for our associates. The trainer was beyond knowledgeable and instrumental in the success of the project. If customized training is what you are looking for, we are confident that you need not look any further than MTS for your business training needs.

    - Brooke F., Business Systems Administrator – Gestamp North America

Programs and Certifications