Designing Business Intelligence Solutions with Microsoft SQL Server 2014 vD

Overview

This training course teaches database and business intelligence (BI) professionals how to plan and design a BI solution that is based on Microsoft SQL Server 2014 and other Microsoft BI technologies.

Pre-Requisites

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

  • A basic understanding of dimensional modeling (star schema) for data warehouses
  • Basic server hardware knowledge
  • The ability to create Integration Services packages that include control flows and data flows
  • The ability to create a basic multidimensional cube with Analysis Services
  • The ability to create a basic tabular model with PowerPivot and Analysis Services
  • The ability to create Reporting Services reports with Report Designer
  • The ability to implement authentication and permissions in the SQL Server database engine, Analysis Services, and Reporting Services
  • Familiarity with SharePoint Server and Microsoft Office applications – particularly Excel

Day(s):5

Course Code:M20467

Delivery Methods:

Public Classroom

Online Training

 

Want to find out more about this course? Apply below and you will get a breakdown of the content.

Microsoft .NET Fundamentals

Overview

This three-day MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-372, and build an understanding of these topics: .NET Framework Concepts, Namespaces and Classes in the .NET Framework, .NET Code Compilation, I/O Classes in the .NET Framework, Security, .NET Languages, and Memory Management. This course leverages the same content as found in the Microsoft Official Academic Course (MOAC) for this exam.

Day(s):3

Course Code:M40372

Delivery Methods:

Public Classroom

Online Training

 

Want to find out more about this course? Apply below and you will get a breakdown of the content.

Microsoft CRM 2016 Customer Service

Overview

This course introduces the capabilities of Service Management in Microsoft Dynamics CRM 2016. Focuses on how an organization can nurture customer satisfaction through automation of business processes within Microsoft Dynamics CRM 2016. Provides an insight into all of the powerful Customer Service and Service Scheduling functionality capabilities within Microsoft Dynamics CRM 2016. Guides you through the process of working with your customers in Microsoft Dynamics CRM 2016, including: resolution of customer complaints and services issues cost effectively, and provides insight on managing all related correspondence, documents, contacts and conversations.

Pre-Requisites

 

  • General knowledge of Microsoft Windows.
  • General knowledge of Microsoft Office.
  • An understanding of Customer Relationship Management solution processes and practices.

Day(s):1

Course Code:T4CRM036

Delivery Methods:

Public Classroom

Online Training

 

Want to find out more about this course? Apply below and you will get a breakdown of the content.

Querying Microsoft SQL Server with Transact-SQL

Overview

The Querying Microsoft SQL Server with Transact-SQL course covers the basics of the SQL language as implemented by Microsoft SQL Server. The course is designed to give delegates practical experience in writing Transact-SQL statements using the SQL Server Management Studio (SSMS) development environment. The basic Transact-SQL statements,including the use of many built-in Transact-SQL functions are covered on this course. This course covers Microsoft SQL Server up to version 2016.

Pre-Requisites

There are no formal pre-requisites,although an understanding of databases and exposure to information technology in general would be useful.

Day(s):3

Course Code:TSQLI

Delivery Methods:

Public Classroom

Online Training

 

Want to find out more about this course? Apply below and you will get a breakdown of the content.

Microsoft SQL Server with Transact-SQL

Overview

The Microsoft SQL Server with Transact-SQL course covers the basics of the SQL language and more as implemented by Microsoft SQL Server. The course is designed to give delegates practical experience in writing Transact-SQL statements by hand using the SQL Server Management Studio (SSMS) development environment. The basic Transact-SQL statements,including the use of many built-in Transact-SQL functions will be covered along with more advanced coding techniques required by Database Administrators,Database Developers and BI professionals. This course covers Microsoft SQL Server up to version 2016.

Pre-Requisites

There are no formal pre-requisites,although an understanding of databases and exposure to information technology in general would be useful.

Day(s):5

Course Code:TSQL

Delivery Methods:

Public Classroom

Online Training

 

Want to find out more about this course? Apply below and you will get a breakdown of the content.

Managing Projects with Microsoft Project Server 2010

Overview

Learn to take project management to the next level using Microsoft Project Server 2010.
In this course, you will learn to use Microsoft Project 2010 Pro in the Microsoft Project Server 2010 environment, creating a truly collaborative project management information system. You will learn to use Microsoft Project 2010 Pro to build projects at your desktop and publish your project information and task assignments to the Project Server 2010 databases.

You will learn to use the intuitive web-based Project Server interface to automatically notify resources of task assignments through Outlook and to update task status. You will learn how to view project status, task status, and resource allocation across the entire enterprise.

Day(s):1

Course Code:SML100E

Delivery Methods:

Public Classroom

Online Training

 

Want to find out more about this course? Apply below and you will get a breakdown of the content.

Selling Microsoft Lync (GK Exclusive)

Overview

Today’s workplace is a complex environment. Teams are geographically distributed, mobile and cross-functional collaboration is a daily requirement. Despite technological investments, most organizations struggle to provide effective collaboration tools to connect their employees and even their customers and suppliers. Customers need helping selecting and implementing a solution that increases productivity and drives business performance. The Selling Microsoft Lync 1-day workshop has been designed to help sales professionals understand how to start conversations with their customers about bringing collaborative communication together in a single interface, deploying it as a unified platform, and administering it through a single management infrastructure.

Day(s):1

Course Code:SML100E

Delivery Methods:

Public Classroom

Online Training

 

Want to find out more about this course? Apply below and you will get a breakdown of the content.

Mastering Microsoft Flow and PowerApps in Dynamics 365

Overview

This course takes an accelerated approach to covering all the major aspects of Microsoft Flow and PowerApps in a Microsoft Dynamics 365 Sales and Customer Services environment.

Pre-Requisites

Before attending this course, students must have:

  • General knowledge of Microsoft Windows.
  • General knowledge of Microsoft Office.

Day(s):2

Course Code:T4D114

Delivery Methods:

Public Classroom

Online Training

 

Want to find out more about this course? Apply below and you will get a breakdown of the content.

Microsoft Azure Fundamentals vD

Overview

Get hands-on instruction and practice implementing Microsoft Azure in this two day Microsoft Official Course. You will be presented with Basic cloud computing concepts as well as specific Microsoft Azure features used in day to day administration of cloud resources. You will learn key Microsoft Azure concepts and basic implementation of Azure subscriptions, websites, virtual machines, storage, virtual networks, databases and Microsoft Azure Active Directory. This course is intended for information technology (IT) professionals who have a limited knowledge of cloud technologies and want to learn more about Microsoft Azure. This course provides the underlying knowledge required by all IT professionals who will be using Microsoft Azure, regardless of whether they are an administrator, developer, or database administrator. While this course does not map to an exam, it does provide you with the prerequisite knowledge for taking courses 20532B:Developing Microsoft Azure Solutions & 20533B:Implementing Microsoft Azure Infrastructure Solutions.

Pre-Requisites

  • Professional experience in information technology.
  • An understanding of websites.
  • A basic understanding of Active Directory concepts such as domains, users, and domain controllers.
  • A basic understanding of database concepts, including tables and simple queries.

 

Day(s):2

Course Code:M10979

Delivery Methods:

Public Classroom

Online Training

 

Want to find out more about this course? Apply below and you will get a breakdown of the content.

Microsoft Dynamics CRM 2013 Installation and Deployment vA

Overview

This two-day training course provides individuals with the skills to install and deploy Microsoft Dynamics CRM 2013. The training material focuses on the components used within a Microsoft Dynamics CRM deployment, the hardware and software requirements needed to successfully deploy Microsoft Dynamics CRM, and the installation instructions for the primary Microsoft Dynamics CRM components: the Microsoft Dynamics CRM Server, the E-Mail Router, and Microsoft Dynamics CRM for Office Outlook. The course also covers upgrading from earlier versions,  configuring an Internet-facing Deployment and administration tasks.

Pre-Requisites

Before attending this course, students must have a working knowledge of:

  • Microsoft Windows Server
  • Active Directory
  • Internet Information Services (IIS)
  • Microsoft Exchange
  • Microsoft SQL Server
  • Microsoft Outlook

Some experience using Microsoft Dynamics CRM 2011 or Microsoft Dynamics CRM 2013 is desirable but not required.

 

Want to find out more about this course? Apply below and you will get a breakdown of the content.

Day(s):2

Course Code:M80539

Delivery Methods:

Public Classroom

Online Training

 

Want to find out more about this course? Apply below and you will get a breakdown of the content.

Introduction to Web Development with Microsoft Visual Studio 2010

Overview

This five-day instructor-led course provides knowledge and skills on developing Web applications by using Microsoft Visual Studio 2010.

Pre-Requisites

Before attending this course, students must have at least one month of experience in .NET technologies. In addition to their professional experience, students who attend this training should have the following technical knowledge:

  • Knowledge of HTML or DHTML, including:
  • Tables
  • Images
  • Forms
  • Programming experience using Visual Basic .NET or Visual C# .NET, including:
  • Declaring variables
  • Using loops
  • Using conditional statements
  • The completion of Course 2667, Introduction to Programming, satisfies the preceding prerequisite programming skills requirement.

Day(s):5

Course Code:M10267

Delivery Methods:

Public Classroom

Online Training

 

Microsoft Specialist: Implementing Microsoft Azure Infrastructure Solutions Boot Camp

Overview

This immersive and extended-hour boot camp, led by Global Knowledge Azure experts, will provide you with the knowledge and skills required for understanding the architecture, services, tools, and portals of Microsoft Azure. You will then capitalize on those skills and accelerate your Azure experience at the end of each day.

The evening hours of this boot camp are designed to reinforce what was learned during the day through targeted real-world scenarios, guided group exercises, and competency-based challenges. These activities will help you understand how to best address this ever changing cloud service and how to immediately apply Azure best practices to your enterprise environment. 

Additionally, this boot camp will assist in your Microsoft Specialist 70-533 exam preparation, as the scenarios address specific exam objectives. It includes access to our Microsoft Boot Camp Exclusives, providing indispensable certification exam prep and you will also receive the exam voucher required for certification.

 

Virtual Learning

 

This interactive training can be taken from any location, your office or home and is delivered by a trainer. This training does not have any delegates in the class with the instructor, since all delegates are virtually connected. Virtual delegates do not travel to this course, Global Knowledge will send you all the information needed before the start of the course and you can test the logins.

 

Pre-Requisites

Experience with or knowledge of:

  • Network configuration including TCP/IP, DNS, virtual private networks (VPNs), firewalls, and encryption technologies
  • Creating, configuring, deploying, and monitoring a website on IIS
  • Active Directory concepts including domains, forests, domain controllers, replication, Kerberos, and LDAP
  • Database concepts including tables, queries, SQL, database replication, and database schemas
  • Resilience and disaster recovery including backup and restoration, operations, and clustering

Day(s):5

Course Code:GK4479

Delivery Methods:

Public Classroom

Online Training

 

Upgrading Your SQL Server Skills to Microsoft SQL Server 2014 vB

Overview

This 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.

Pre-Requisites

  • Experience of building and managing database, data warehouse, and business intelligence (BI) solutions with SQL Server 2008.
  • Familiarity with the Windows Server 2012 operating system and networking.
  • Familiarity with Microsoft Excel and Microsoft SharePoint Server 2013.

Want to find out more about this course? Apply below and you will get a breakdown of the content.

Day(s):4

Course Code:GK M10977

Delivery Methods:

Public Classroom

Online Training

 

Microsoft Specialist: Developing Microsoft Azure Solutions Boot Camp

Overview

This immersive and extended-hour boot camp, led by Global Knowledge Azure experts, will provide you with the knowledge and skills required to take existing ASP.NET MVC application and expand its functionality to the Microsoft Azure platform. You will then capitalize on those skills and accelerate your Azure experience at the end of each day.

The evening hours of this boot camp are designed to reinforce what was learned during the day through targeted real-world scenarios, guided group exercises, and competency-based challenges. These activities will help you understand how to best address this ever changing cloud service and how to immediately apply Azure best practices to your enterprise environment.
 
Additionally, this boot camp will assist in your Microsoft Specialist 70-532 exam preparation, as the scenarios address specific exam objectives. It includes access to our Microsoft Boot Camp Exclusives, providing indispensable certification exam prep and you will also receive the exam voucher required for certification.

 

Virtual Learning

 

This interactive training can be taken from any location, your office or home and is delivered by a trainer. This training does not have any delegates in the class with the instructor, since all delegates are virtually connected. Virtual delegates do not travel to this course, Global Knowledge will send you all the information needed before the start of the course and you can test the logins.

 

Pre-Requisites

  • Experience with the Microsoft Azure platform that includes a basic understanding of its services including implementation and monitoring
  • Experience in building vertically scaled applications
  • Experience with ASP.NET and C#

Required knowledge can be obtained through the following courses:

  • Developing ASP.NET 4.5 MVC Web Applications (M20486)
  • Microsoft Azure Fundamentals (M10979)

 

Day(s):4

Course Code:GK4480

Delivery Methods:

Public Classroom

Online Training

 

Your new job awaits.

Start the process →