Microsoft SQL Server Training - United States

Microsoft SQL Server Training

Our Microsoft training

course is accredited by Microsoft

Microsoft SQL Server is a relational database management system (RDBMS), used to manage and store data. Our Microsoft SQL Server Training in the United States equips you with key skills in server management, networking, and security, enhancing your professional value.

REASONS TO CHOOSE

Learn database management in Microsoft SQL Server Training
Enhance your knowledge in implementing advanced data analytics
Acquire expertise in database security and disaster recovery in the United States
Understand data integration and business intelligence features
Gain proficiency in managing and optimizing SQL Server performance

View courses

Our Microsoft training

course is accredited by Microsoft

Microsoft SQL Server Training

accredited by

Our Microsoft training course is accredited by Microsoft

Duration

Online Instructor-led (3 days)

Online Self-paced (24 hours)

Microsoft Power BI Data Analyst PL300 Course Outline

Module 1: Discover Data Analysis

Introduction
Overview of Data Analysis
Roles in Data
Tasks of a Data Analyst

Module 2: Get Started Building with Power BI

Introduction
Use Power BI
Building Blocks of Power BI
Tour and Use the Power BI Service

Module 3: Get Data in Power BI

Introduction
Get Data from Files
Get Data from Relational Data Sources
Create Dynamic Reports with Parameters
Get Data from a NoSQL Database
Get Data from Online Services
Select a Storage Mode
Get Data from Azure Analysis Services
Fix Performance Issues
Resolve Data Import Errors
Exercise - Prepare Data in Power BI Desktop

Module 4: Clean, Transform and Load Data in Power BI

Introduction
Shape the Initial Data
Simplify the Data Structure
Evaluate and Change Column Data Types
Combine Multiple Tables into a Single Table
Profile Data in Power BI
Use Advanced Editor to Modify M Code
Exercise - Load Data in Power BI Desktop

Module 5: Design a Data Model in Power BI

Introduction
Work with Tables
Create a Date Table
Work with Dimensions
Define Data Granularity
Work with Relationships and Cardinality
Resolve Modelling Challenges
Exercise - Model Data in Power BI Desktop

Module 6: Add Measures to Power BI Desktop Models

Introduction
Create Simple Measures
Create Compound Measures
Create Quick Measures
Compare Calculated Columns with Measures
Exercise - Create DAX Calculations in Power BI Desktop

Module 7: Add Calculated Tables and Columns to Power BI Desktop Models

Introduction
Create Calculated Columns
Learn About Row Context
Choose a Technique to Add a Column

Module 8: Use DAX Time Intelligence Functions in Power BI Desktop Models

Introduction
Use DAX Time Intelligence Functions
Additional Time Intelligence Calculations
Exercise - Create Advanced DAX Calculations in Power BI Desktop

Module 9: Optimise a Model for Performance in Power BI

Introduction to Performance Optimization
Review Performance of Measures, Relationships, and Visuals
Use Variables to Improve Performance and Troubleshooting
Reduce Cardinality
Optimize Directquery Models with Table Level Storage
Create and Manage Aggregations

Module 10: Design Power BI Reports

Introduction
Design the Analytical Report Layout
Design Visually Appealing Reports
Report Objects
Select Report Visuals
Select Report Visuals to Suit the Report Layout
Format and Configure Visualizations
Work with Key Performance Indicators
Exercise - Design a Report in Power BI Desktop

Module 11: Configure Power BI Report Filters

Introduction to Designing Reports for Filtering
Apply Filters to the Report Structure
Apply Filters with Slicers
Design Reports with Advanced Filtering Techniques
Consumption-Time Filtering
Select Report Filter Techniques
Case Study - Configure Report Filters Based on Feedback

Module 12: Enhance Power BI Report Designs for the User Experience

Design Reports to Show Details
Design Reports to Highlight Values
Design Reports that Behave Like Apps
Work with Bookmarks
Design Reports for Navigation
Work with Visual Headers
Design Reports with Built-In Assistance
Tune Report Performance
Optimize Reports for Mobile Use
Exercise - Enhance Power BI Reports

Module 13: Perform Analytics in Power BI

Introduction to Analytics
Explore Statistical Summary
Identify Outliers with Power BI Visuals
Group and Bin Data for Analysis
Apply Clustering Techniques
Conduct Time Series Analysis
Use the Analyse Feature
Create What-If Parameters
Use Specialized Visuals
Exercise - Perform Advanced Analytics with AI Visuals

Module 14: Create and Manage Workspaces in Power BI

Introduction
Distribute a Report or Dashboard
Monitor Usage and Performance
Recommend a Development Life Cycle Strategy
Troubleshoot Data by Viewing Its Lineage
Configure Data Protection

Module 15: Manage Datasets in Power BI

Introduction
Use a Power BI Gateway to Connect to On-Premises Data Sources
Configure a Dataset Scheduled Refresh
Configure Incremental Refresh Settings
Manage and Promote Datasets
Troubleshoot Service Connectivity
Boost Performance with Query Caching

Module 16: Create Dashboards in Power BI

Introduction to Dashboards
Configure Data Alerts
Explore Data by Asking Questions
Review Quick Insights
Add a Dashboard Theme
Pin a Live Report Page to a Dashboard
Configure a Real-Time Dashboard
Configure Data Classification
Set Mobile View
Exercise - Create A Power BI Dashboard

Module 17: Implement Row-Level Security

Introduction
Configure Row-Level Security with the Static Method
Configure Row-Level Security with the Dynamic Method
Exercise - Enforce Row-Level Security in Power BI

More information

See dates & prices

Who should attend this Microsoft Power BI Data Analyst PL300 Training Course?

This Microsoft Power BI Data Analyst PL300 Course in the United States is designed for professionals who work with Data Analysis, Business Intelligence, and those responsible for creating insightful reports and dashboards for decision-making. This training course is especially beneficial for these professionals:

Data Analysts
Business Analysts
Data Engineers
Business Intelligence Professionals
IT Professionals
Managers
Team Leads

Prerequisites of the Microsoft Power BI Data Analyst PL300 Training Course

There are no formal prerequisites for this Microsoft Power BI Data Analyst PL300 Course. However, experience in working with data in the cloud can be beneficial for the delegates.

Understanding core data concepts
Knowledge of working with relational data in the cloud
Knowledge of working with non-relational data in the cloud
Knowledge of data analysis and visualization concepts

Microsoft Power BI Data Analyst PL300 Course Overview

The Microsoft Power BI Data Analyst PL300 Course in the United States offers a comprehensive exploration of Power BI, Microsoft's business analytics tool that empowers organizations to visualize and analyze their data effectively. The ability to derive insights from data is paramount in today's data-driven business landscape.

Mastering Microsoft Power BI is essential for professionals in business intelligence, data analysis, and reporting. As organizations grapple with ever-growing volumes of data, the demand for skilled Power BI analysts is on the rise. This course in the United States caters to those aiming to harness the capabilities of Power BI to create compelling visualizations, conduct data analysis, and generate insightful reports.

The Knowledge Academy's 3-day training on Microsoft Power BI Data Analyst PL300 in the United States equips delegates with hands-on experience utilizing Power BI for data analysis and visualization. Delegates will learn to create interactive dashboards, connect to various data sources, and execute complex data transformations.

Course Objectives

To understand the fundamental concepts of Microsoft Power BI for data analysis
To acquire skills in connecting Power BI to various data sources
To learn the essentials of creating interactive dashboards and reports in Power BI
To gain proficiency in transforming and shaping data using Power BI tools
To explore advanced features of Power BI for in-depth data analysis
To acquire practical knowledge in sharing and collaborating on Power BI reports

Upon completing this course in the United States, delegates will have the expertise to navigate Microsoft Power BI confidently, transforming raw data into actionable insights.

More information

See dates & prices

What’s included in this Microsoft Power BI Data Analyst PL300 Training Course?

World-Class Training Sessions from Experienced Instructors
Microsoft Power BI Data Analyst PL300
Digital Delegate Pack

More information

See dates & prices

More information

See dates & prices

accredited by

Our Microsoft training course is accredited by Microsoft

Duration

Online Instructor-led (2 days)

Online Self-paced (16 hours)

Querying Data with Microsoft Transact-SQL DP080 Course Outline

Module 1: Introduction to Transact-SQL

Introduction
Work with Schemas
Explore the Structure of SQL Statements
Examine the SELECT Statement
Work with Data Types
Handle NULLs
Exercise - Work with SELECT Statements

Module 2: Sort and Filter Results in T-SQL

Introduction
Sort Your Results
Limit the Sorted Results
Page Results
Remove Duplicates
Filter Data with Predicates
Exercise - Sort and Filter Query Results

Module 3: Combine Multiple Tables with JOINs in T-SQL

Introduction
Understand Joins Concepts and Syntax
Use Inner Joins
Use Outer Joins
Use Cross Joins
Use Self Joins
Exercise - Query Multiple Tables with Joins

Module 4: Write Subqueries in T-SQL

Introduction
Understand Subqueries
Use Scalar or Multi-Valued Subqueries
Use Self-Contained or Correlated Subqueries
Exercise - Use Subqueries

Module 5: Use Built-In Functions and GROUP BY in Transact-SQL

Introduction
Categorize Built-In Functions
Use Scalar Functions
Use Ranking and Rowset Functions
Use Aggregate Functions
Summarize Data with GROUP BY
Filter Groups with HAVING
Exercise - Use Built-In Functions

Module 6: Modify Data with T-SQL

Introduction
Insert Data
Generate Automatic Values
Update Data
Delete Data
Merge Data Based on Multiple Tables
Exercise - Modify Data

More information

See dates & prices

Who should attend this Querying Data with Microsoft Transact-SQL DP080 Training Course?

This Querying Data with Microsoft Transact-SQL DP080 Course in the United States is designed for individuals who want to develop proficiency in querying and manipulating data using the Transact-SQL language within Microsoft SQL Server. This training course is especially beneficial for the following professionals:

Database Developers
Database Administrators
Data Analysts
Data Engineers
IT Administrators
DevOps Engineers
Business Analysts

Prerequisites of the Querying Data with Microsoft Transact SQL DP080 Training Course

There are no formal prerequisites for this Querying Data with Microsoft Transact SQL DP080 Course. However, basic familiarity with database concepts and SQL concepts would be beneficial for the delegates.

Querying Data with Microsoft Transact-SQL DP080 Training Course Overview

The Querying Data with Microsoft Transact-SQL DP080 Training in the United States delves into the essential skills of querying and managing data using Transact-SQL, the language used for interacting with Microsoft SQL Server databases. The ability to query data efficiently is paramount in database management and data analysis. This course introduces delegates to the fundamentals of Transact-SQL and its relevance in extracting valuable insights from databases.

Proficiency in querying data with Transact-SQL is crucial for Database Administrators, Data Analysts, and Developers managing and extracting information from SQL Server databases in the United States. The course is designed to cater to the needs of professionals aiming to master the art of writing efficient and effective queries to retrieve, manipulate, and analyze data.

The Knowledge Academy's 2-day training on Querying Data with Microsoft Transact-SQL in the United States equips delegates with hands-on experience writing and optimizing Transact-SQL queries. Through theoretical insights and practical exercises, delegates will gain proficiency in data retrieval, filtering, and analysis.

Course Objectives

To understand the fundamental concepts of Microsoft Transact-SQL
To acquire skills in writing and executing efficient Transact-SQL queries
To learn the essentials of data retrieval and manipulation using Transact-SQL
To gain proficiency in filtering and sorting data in Transact-SQL
To explore advanced Transact-SQL features for complex data analysis
To acquire practical knowledge in optimizing and troubleshooting Transact-SQL queries

Upon completing this Microsoft SQL Server Training in the United States, delegates will possess the expertise to navigate and manipulate data within Microsoft SQL Server databases using Transact-SQL. This training empowers professionals to leverage the full potential of SQL Server databases for extracting valuable insights.

More information

See dates & prices

What’s included in this Querying Data with Microsoft Transact SQL DP080 Training Course?

World-Class Training Sessions from Experienced Instructors
Querying Data with Microsoft Transact SQL DP080 Certificate
Digital Delegate Pack

More information

See dates & prices

More information

See dates & prices

accredited by

Our Microsoft training course is accredited by Microsoft

Duration

Online Instructor-led (2 days)

Online Self-paced (16 hours)

Microsoft Power BI for End Users 55400AC Course Outline

Module 1: Introduction to Power BI

What is Business Intelligence?
Introducing Power BI
Power BI Tools and Services
Power BI Report Server
Power BI (Online)
Power BI Desktop
Case Studies
Support and Information
Data Stories

Lab: Getting Ready

Sign in to Office 365
Download Course Files
Place Data Sources into OneDrive
Create Further User Accounts

Module 2: Requirements Gathering

Welcome to House Rules Board Games
Beginning a BI Project
Grain Statements
Data Discovery
Refining Information
Modeling Data
Building Reports
Roles
Publishing
Creating Dashboards
Choosing Workspaces
Create and Share a Report in Power BI

Lab: Build a Report in Power BI Web

Connect to an Excel Spreadsheet
Build Visualizations
Create a Dashboard for Desktop and Mobile Users
Share Your Report and Dashboard

Module 3: Extract, Transform, and Load Data

Creating a Project with Power BI Desktop
Pinning an Active Project
What is in a PBIX File?
Connecting to Data Sources
Managing Data Connections
Refine Data with Power Query
Applied Steps
M Code Language
Designing Your Query
Choose Columns
Rename Columns
Moving Columns
Formatting Columns
Replacing Values
Expanding Related Columns
Star Schemas
Merge Columns
Split Columns
Custom and Conditional Columns

Lab: Starting a Project in Power BI Desktop

Creating a New PBIX Project File
Connecting to Data Sources
Use the Query Editor to Refine Data
Review the Table Relationships
Optional – Connect to an Azure SQL Database

Module 4: Creating a Data Model

Understanding Relationships
Cardinality
Cross Filter Direction
Hiding Tables and Columns
Formatting Columns
Introducing DAX
Designing Calculated Columns
Creating Measures
Adding Lookup Tables
Structuring Data with Dimensional Hierarchies
Roles and Row Level Security

Lab: Designing a Data Model

Hide and Format Table Columns
Create Calculated Columns
Create Measures
Using Geographical Data and Lookup Tables
Create a Dimensional Hierarchy

Module 5: Designing Reports

Adding Pages and Navigation Buttons
Using Shapes, Text, and Images
Creating a Theme
Adding Visualizations
Using Filters and Slicers
Controlling Filters
Adding Drill Throughs
Adding Custom Visualizations
Configure Phone Layouts
Report Tips

Lab: Creating a Report

Creating New Pages and Adding Basic Content
Adding and Configuring Visualizations
Design Slicers
Create Bookmarks and Navigational Buttons

Module 6: Using Workspaces and Dashboards

Power BI Licensing
My Workspaces
App Workspaces
Premium Capacity Workspaces
Creating a New Workspace
Publishing a Project
Parallels with Microsoft Excel
Publishers and Viewers
Reconnecting with Data Sources
Introducing the On-Premises Data Gateway
Scheduling the Data Refresh Frequency
Assigning Security Roles
Creating and Populating Dashboards
Customizing Dashboard Tiles
Creating Tiles Using Q&A and Quick Insights
Creating a Mobile Dashboard
Sharing Reports and Dashboards
Publishing Apps in a Workspace
Publishing Content to Websites

Lab: Publish and Share Reports and Dashboards

Publish Your Project to Power BI
Create a Dashboard
Use Quick Insights and Pin Visuals
Use Q&A to Query Your Data Source
Share Your Dashboard with Marketing

More information

See dates & prices

Who should attend this Microsoft Power BI for End Users 55400AC Training?

The Microsoft Power BI for End Users 55400AC Training in the United States is designed to be accessible, making it a good fit for professionals at various levels of an organization who are looking to make data-driven decisions. The following professionals will benefit the most from this course:

Business Analysts
Data Enthusiasts
Excel Users
Non-technical Staff
Managers and Executives
Sales and Marketing Professionals
HR Professionals

Prerequisites of the Microsoft Power BI for End Users 55400AC Training

For the Microsoft Power BI for End Users 55400AC Training, prerequisites generally include basic computer literacy, familiarity with Microsoft Office applications like Excel, and an understanding of fundamental data concepts like tables and charts.

Microsoft Power BI for End Users 55400AC Course Overview

The Microsoft Power BI for End Users 55400AC Course in the United States is a comprehensive introduction to the versatile world of Power BI, Microsoft's cutting-edge business analytics tool. This course empowers end users by providing a solid foundation for utilizing Power BI for data analysis and visualization. In an era where data-driven insights are paramount, Power BI is critical in transforming raw data into meaningful reports.

Understanding Microsoft Power BI is essential for professionals who want to harness the power of data without delving into complex coding or technical intricacies. Business analysts, managers, and decision-makers will find this course in the United States beneficial for interpreting data, creating compelling visualizations, and deriving actionable insights.

The Knowledge Academy's 2-day training on Microsoft Power BI for End Users 55400AC in the United States is crafted to provide delegates with practical skills for effective data analysis. Delegates will gain proficiency in navigating Power BI's user-friendly interface, creating insightful reports, and sharing interactive dashboards. The course emphasizes a user-centric approach, ensuring delegates learn to leverage Power BI for impactful decision support.

Course Objectives:

To navigate and utilize Power BI's user-friendly interface for effective data analysis
To create visually compelling reports and dashboards tailored to end-user needs
To understand the principles of data visualization and apply them using Power BI
To explore and leverage Power BI's interactive features for dynamic reporting
To interpret complex data sets and extract insights for decision-making
To collaborate and share insights effectively with team members using Power BI

Upon completing this course in the United States, delegates will possess the skills to analyze and visualize data independently using Microsoft Power BI. This Microsoft SQL Server Training enables them to generate impactful reports, make data-driven decisions, and effectively communicate insights to their teams.

More information

See dates & prices

What’s included in this Microsoft Power BI for End Users 55400AC Training?

World-Class Training Sessions from Experienced Instructors
Microsoft Power BI for End Users 55400AC
Digital Delegate Pack

More information

See dates & prices

More information

See dates & prices

accredited by

Our Microsoft training course is accredited by Microsoft

Duration

Online Instructor-led (3 days)

Online Self-paced (24 hours)

Introduction to SQL Databases Training 10985C Course Outline

Module 1: Introduction to Databases

Introduction to Relational Databases
Retrieve Data from a Relational Database by using SQL

Lab 1: Use the SELECT Statement to Retrieve Data from a Database

Use the SELECT Statement to Retrieve Data from a Database

Module 2: Database Tables

Identify and use Microsoft SQL Server Data Types
Create Tables with SQL
Altering and Dropping a Table
Collect Information from Multiple Tables by using Joins and Views

Lab 1: Create and Alter a Table in Microsoft SQL Server

Create and Alter a Table in Microsoft SQL Server
Create and Retrieve a View that Uses the JOIN Statement in Microsoft SQL Server

Lab 2: Create and Alter a Table in Microsoft SQL Server

Create and Alter a Table in Microsoft SQL Server

Lab 3: Create and Retrieve a View that Uses the JOIN Statement in Microsoft SQL Server

Create and Retrieve a View that Uses the JOIN Statement in Microsoft SQL Server

Module 3: Add and Update Data

Insert, Update, and Delete Information

Lab 1: Add and Change Data in SQL Server

Add and Change Data in SQL Server

Lab 2: Create and use Stored Procedures in Microsoft SQL Server

Create and use Stored Procedures in Microsoft SQL Server

Module 4: Entity Relationships

Model Entity Relationships
Design for Referential Integrity What is Referential Integrity?

Lab 1: Create an Entity Relationship Diagram in Microsoft SQL Server Management Studio

Create an Entity Relationship Diagram in Microsoft SQL Server Management Studio

Module 5: Normalization and Denormalization

Normalization
Denormalization

Lab 1: Deformalize a Table by Adding a Redundant Column of Computed Data

Deformalize a Table by Adding a Redundant Column of Computed Data

Module 6: Query Performance and Safety

Indexes
Write Performant SQL Code
Concurrency

Lab 1: Create Indexes and Consult Execution Plans in Microsoft SQL Server Management Studio

Create Indexes and Consult Execution Plans in Microsoft SQL Server Management Studio

More information

See dates & prices

Who should attend this Introduction to SQL Databases Training 10985C Course?

This Introduction to SQL Databases Training 10985C Course in the United States is designed for individuals who want to develop a foundational understanding of working with SQL databases and querying data. This training course is beneficial for the following professionals:

Administrative Assistants
Database Administrators
Data Analysts
IT Professionals
Clerical Staff
Web Developers
Researchers

Prerequisites of the Introduction to SQL Databases Training 10985C Course

There are no formal prerequisites for this Introduction to SQL Databases Training 10985C Course.

Introduction to SQL Databases Training 10985C Course Overview

Introduction to SQL Databases Training 10985C in the United States provides a foundational understanding of SQL databases, emphasizing their pivotal role in managing and retrieving data. The course explores the relevance of SQL databases in modern information systems, serving as the backbone for data-driven applications and effective information storage.

IT, Database Administration, and Software Development Professionals must master SQL databases to proficiently design, query, and maintain databases in the United States. This knowledge is paramount for developers, database administrators, and analysts seeking to harness the power of SQL databases for efficient data management, retrieval, and analysis.

The Knowledge Academy's 3-day training course in the United States immerses delegates in practical skills to navigate SQL databases effectively. Participants gain hands-on experience in creating, querying, and managing databases, ensuring a solid foundation in SQL. This training is tailored to empower delegates to immediately apply their knowledge, enhancing their proficiency in working with SQL databases.

Course Objectives

To comprehend the fundamentals of SQL databases
To master the creation and management of SQL databases
To understand SQL querying for efficient data retrieval
To explore database normalization principles for effective data organization
To grasp the importance of data integrity and security in SQL databases
To apply learned skills through practical exercises and case studies

Upon completing this Microsoft SQL Server Training in the United States, delegates benefit from a strong foundational knowledge of SQL databases, enabling them to design, query, and manage databases proficiently, enhancing their capabilities in data-driven roles and contributing to organizational efficiency.

More information

See dates & prices

What’s included in this Introduction to SQL Databases Training 10985C Training Course?

World-Class Training Sessions from Experienced Instructors
Introduction to SQL Databases Training 10985C Certificate
Digital Delegate Pack

More information

See dates & prices

More information

See dates & prices

accredited by

Our Microsoft Certifications (Microsoft Partner) course is accredited by Microsoft

Duration

Online Instructor-led (4 days)

Online Self-paced (32 hours)

Accelerated SQL Server 2016 Integration Services Course Outline

Module 1: SSIS Overview and Core Features

Introduction to Business Intelligence (BI)
Tools for Business Intelligence (BI)
Introduction to Data Integration
SSIS Features

Module 2: Data Warehousing

Dimensional Modelling
Dimensional Modelling Rules
Data Preparation for Advanced Analytics

Module 3: SSIS Control Flow Objects and Features

What is Control Flow?
Control Flow Concepts
Types of Control Flow Elements
SSIS Control Flow Tasks
SSIS Control Flow Containers
Control Flow Objects
Group or Ungroup Components
Using the Control Flow to Orchestrate SSIS Execution

Module 4: Extracting, Transforming and Loading Data Using SSIS Data Flows

SSIS Data Flow Task
Data Flow Path
Data Connection Managers
Data Flow Components

Module 5: Working with Files, Importing and Exporting File Data

File Connection Manager
Add and Configure a Flat File Connection Manager
Loading Data into Files
Excel Connection Manager

Module 6: Optimizing Data Extraction and Data Loading

Change Tracking
Change Data Capture

Module 7: Data Quality and Cleansing

Data Quality
Data Profiling
Data Quality Services
Fuzzy Lookup Transformation
Data Profiling Task in SSIS

Module 8: Advanced Enterprise Information Management

Script Task and Script Component
Text Mining
Advanced Analytics

Module 9: Dimension ETL with SSIS

Dimension ETL Theory
SQL Server Temporal Tables
SSIS Slowly Changing Dimension Wizard
Slowly Changing Dimension Transformation

Module 10: Fact ETL with SSIS

Fact Table ETL Theory
Advanced Fact Table Techniques

Module 11: Project Deployment Model: Execution and Reporting

Pivot Transformation

Module 12: Processing SSAS Objects in SSIS

SSAS Tabular and Multidimensional
Tabular Model Designer
DAX for Multidimensional Models
Processing Methods in SSIS

Module 13: Project Deployment

Project Deployment Model
Create the SSIS Catalog
Monitoring
SSIS Master Package

Module 14: Package Deployment

Package Deployment Model
Deployment to the SSIS Package Store
Monitor Running Packages

Module 15: Transactions and Restartability

Using Breakpoints in SSDT
Implementing Transactions in SSIS
Using SQL Server Database Snapshots
Restart Packages by Using Checkpoints
Responding to Events

Module 16: Optimization and Scalability

Leveraging the Data Flow
Transact-SQL
Data Flow Tasks
SSIS Optimization Techniques
SSIS Performance Troubleshooting

More information

See dates & prices

Who should attend this Accelerated SQL Server 2016 Integration Services Course?

This Accelerated SQL Server 2016 Integration Services Training Course in the United States is designed for professionals who work with Data Integration, ETL development, and those who need to efficiently design and manage data workflows using SSIS (SQL Server Integration Services). This training course is beneficial for the following professionals:

ETL Developers
Data Engineers
Data Analysts
Database Developers
IT Administrators
Business Analysts
DevOps Engineers

Prerequisites of the Accelerated SQL Server 2016 Integration Services Course

There are no formal prerequisites for this Accelerated SQL Server 2016 Integration Services Course. However, a foundational understanding of database and SQL concepts would be beneficial for the delegates.

Accelerated SQL Server 2016 Integration Services Course Overview

The Accelerated SQL Server 2016 Integration Services Course in the United States offers a comprehensive exploration into the realm of SQL Server Integration Services (SSIS), a critical component of Microsoft's SQL Server. This course is designed to equip delegates with a deep understanding of SSIS and its relevance in the seamless integration and transformation of data.

Mastering SQL Server 2016 Integration Services in the United States lies in its pivotal role in data integration, ETL (Extract, Transform, Load) processes, and data warehousing. IT professionals, database administrators, and data engineers will find this course indispensable for gaining expertise in designing and implementing robust data integration solutions.

The Knowledge Academy's 4-day training on Accelerated SQL Server 2016 Integration Services in the United States is tailored to empower delegates with practical skills in SSIS. Participants will delve into the intricacies of SSIS through hands-on exercises and real-world scenarios, gaining proficiency in creating data-driven workflows and managing complex ETL tasks.

Course Objectives:

To understand the fundamentals of SQL Server Integration Services (SSIS)
To design and implement efficient ETL processes using SSIS
To explore advanced features of SSIS for complex data transformations
To troubleshoot and optimize SSIS packages for performance
To integrate SSIS with other components of the SQL Server ecosystem
To apply best practices in SSIS development for robust data integration solutions

Upon completing this Microsoft SQL Server Training in the United States, delegates will emerge with a heightened proficiency in SQL Server Integration Services, enabling them to design and implement efficient ETL processes.

More information

See dates & prices

What’s included in this Accelerated SQL Server 2016 Integration Services Course?

World-Class Training Sessions from Experienced Instructors
Accelerated SQL Server 2016 Integration Services Certificate
Digital Delegate Pack

More information

See dates & prices

More information

See dates & prices

accredited by

Our Microsoft training course is accredited by Microsoft

Duration

Online Instructor-led (3 days)

Online Self-paced (24 hours)

Writing Analytical Queries for Business Intelligence 55232A Training Course Outline

Module 1: Introduction to TSQL for Business Intelligence

Module 2: Turning Table Columns into Variables for Analysis: SELECT List Expressions, WHERE, and ORDER BY

Turning Columns into Variables for Analysis
Column Expressions Data Types and Built-in Functions
Column Aliases
Data Type Conversions
Built-in Scalar Functions
Table Aliases
The WHERE Clause
ORDER BY
Lab 2 - Write Queries

Module 3: Combining Columns from Multiple Tables into a Single Dataset: The JOIN Operators

Primary Keys Foreign Keys and Joins
Understanding Joins:

Part 1: CROSS JOIN and the Full Cartesian Product
Part 2: The INNER JOIN
Part 3: The OUTER JOINS
Part 4: Joining more than Two Tables
Part 5: Combining INNER and OUTER JOINs

Combining JOIN Operations with WHERE and ORDER BY
Lab 3 - Write SELECT Queries

Module 4: Creating an Appropriate Aggregation Level Using GROUP BY

Identifying Required Aggregation Level and Granularity
Aggregate Functions
GROUP BY
HAVING
Order of Operations in SELECT Queries
Lab 4 - Write Queries

Module 5: Subqueries, Derived Tables and Common Table Expressions

Non-Correlated and Correlated Subqueries
Derived Tables
Common Table Expressions
Lab 5 - Write Queries

Module 6: Encapsulating Data Retrieval Logic

Views
Table-Valued Functions
Stored Procedures
Creating Objects for Read-Access Users
Creating Database Accounts for Analytical Client Tools
Lab 6

Module 7: Getting Your Dataset to the Client

Connecting to SQL Server and Submitting Queries from Client Tools
Connecting and Running SELECT Queries from:

Excel
Power BI
RStudio

Exporting Datasets to Files using
Results Pane from SSMS
The bcp Utility
Import/Export Wizard
Lab 7

More information

See dates & prices

Who should attend this Writing Analytical Queries for Business Intelligence 55232A Training?

The Writing Analytical Queries for Business Intelligence 55232A Training in the United States is typically intended for individuals who work in roles that involve using data analysis and business intelligence tools to extract valuable insights from data. This training is suitable for:

Business Analysts
Data Analysts
Reporting Professionals
Business Intelligence Developers
Data Scientists
Data Enthusiasts
Database Administrators

Prerequisites of the Writing Analytical Queries for Business Intelligence 55232A Training

In this Writing Analytical Queries for Business Intelligence 55232A Training course, there are a few prerequisites that delegates need to fulfil. They must have:

Knowledge of data analysis and business intelligence situations in context
Basic understanding of the Windows operating system and its key features, including file system navigation
A fundamental grasp of the function of relational database management systems such as SQL Server

Writing Analytical Queries for Business Intelligence 55232A Training Course Overview

Writing Analytical Queries for Business Intelligence 55232A Training in the United States focuses on crafting effective queries to extract valuable insights from data. It highlights the relevance of query writing in business intelligence, where precise analysis is vital for educated decision-making and strategic planning in today's data-driven corporate landscape.

Business Intelligence, Data Analysis, and Reporting professionals must master analytical query writing in the United States. This skill is crucial for extracting meaningful information from databases and aiding decision-makers in understanding trends, patterns, and opportunities. Analysts, Data Engineers, and Business Intelligence Professionals will find this training invaluable for advancing their careers.

The Knowledge Academy's 3-day training in the United States equips delegates with practical skills to construct analytical queries efficiently. Participants learn to navigate databases, use SQL tools, and optimize queries for better performance. This tailored training ensures that delegates can immediately apply their knowledge, enhancing their ability to extract valuable insights for strategic business decision-making.

Course Objectives:

To understand the importance of analytical query writing in business intelligence
To master the construction of effective queries for data analysis
To optimize queries for improved performance and efficiency
To explore SQL tools and techniques for analytical purposes
To gain hands-on experience in crafting queries for specific business scenarios
To apply learned skills through practical exercises and case studies

Upon completing this Microsoft SQL Server Course in the United States, delegates benefit from enhanced analytical query-writing skills, enabling them to extract valuable insights efficiently. This proficiency contributes to informed decision-making, empowering professionals to shape successful business strategies and outcomes.

More information

See dates & prices

What's Included in this Writing Analytical Queries for Business Intelligence 55232A Training?

World-Class Training Sessions from Experienced Instructors
Writing Analytical Queries for Business Intelligence 55232A Certificate
Digital Delegate Pack

More information

See dates & prices

More information

See dates & prices

accredited by

Our Microsoft training course is accredited by Microsoft

Duration

Online Instructor-led (5 days)

Online Self-paced (40 hours)

SQL Server Integration Services 55321AC Training Course Outline

Module 1: SSIS Overview

Import/Export Wizard
Exporting Data with the Wizard
Common Import Concerns
Quality Checking Imported/Exported Data
Lab

Module 2: Working with Solutions and Projects

Working with SQL Server Data Tools
Understanding Solutions and Projects
Working with the Visual Studio Interface
Lab

Module 3: Basic Control Flow

Working with Tasks
Understanding Precedence Constraints
Annotating Packages
Grouping Tasks
Package and Task Properties
Connection Managers
Favorite Tasks
Lab

Module 4: Common Tasks

Analysis Services Processing
Data Profiling Task
Execute Package Task
Execute Process Task
Expression Task
File System Task
FTP Task
Hadoop Task
Script Task Introduction
Send Mail Task
Web Service Task
XML Task
Lab

Module 5: Data Flow Sources and Destinations

Data Flow Task
Data Flow SSIS Toolbox
Working with Data Sources
SSIS Data Sources
Working with Data Destinations
SSIS Data Destinations
Lab

Module 6: Data Flow Transformations

Transformations
Configuring Transformations
Lab

Module 7: Making Packages Dynamic

Features for Making Packages Dynamic
Package Parameters
Project Parameters
Variables
SQL Parameters
Expressions in Tasks
Expressions in Connection Managers
After Deployment
How It All Fits Together
Lab

Module 8: Containers

Sequence Containers
For Loop Containers
Foreach Loop Containers
Lab

Module 9: Troubleshooting and Package Reliability

Understanding MaximumErrorCount
Breakpoints
Redirecting Error Rows
Logging
Event Handlers
Using Checkpoints
Transactions
Lab

Module 10: Deploying to the SSIS Catalog

SSIS Catalog
Deploying Projects
Working with Environments
Executing Packages in SSMS
Executing Packages from the Command Line
Deployment Model Differences
Lab

Module 11: Installing and Administering SSIS

Installing SSIS
Upgrading SSIS
Managing the SSIS Catalog
Viewing Built-in SSIS Reports
Managing SSIS Logging and Operation Histories
Automating Package Execution
Lab

Module 12: Securing the SSIS Catalog

Principals
Securables
Grantable Permissions
Granting Permissions
Configuring Proxy Accounts
Lab

More information

See dates & prices

Who should attend this SQL Server Integration Services 55321AC Training?

The SQL Server Integration Services 55321AC Training in the United States is designed for individuals and professionals who are interested in learning how to use SQL Server Integration Services (SSIS) to design, implement, and manage data integration solutions. This course is particularly suitable for:

Data Engineers
ETL (Extract, Transform, Load) Developers
Database Administrators
Business Intelligence Developers
Data Analysts
Data Integration Specialists
Database Architects

Prerequisites of the SQL Server Integration Services 55321AC Training

There are no formal prerequisites for attending this SQL Server Integration Services 55321AC course.

SQL Server Integration Services 55321AC Training Course Overview

SQL Server Integration Services (SSIS) 55321AC Training in the United States provides a comprehensive overview of SSIS, a vital component in database management. It explores data integration and workflow applications, showcasing its relevance in optimizing data handling for businesses, ensuring efficiency, and informed decision-making.

Mastering SSIS is crucial for Database Administrators, Data Engineers, And Business Intelligence Professionals in the United States. Understanding SSIS empowers them to efficiently design, deploy, and manage data integration solutions. Professionals aiming for excellence in data management, reporting, and analytics will find this training instrumental in enhancing their skill set.

The Knowledge Academy's 5-day SSIS 55321AC Training in the United States equips delegates with practical skills to navigate SSIS tools effectively. Delegates gain hands-on experience designing data flow solutions, enabling them to streamline data processes. This training is tailored to enhance proficiency, ensuring delegates can immediately apply their knowledge in real-world scenarios.

Course Objectives

To comprehend the fundamentals of SQL Server Integration Services
To master the design and deployment of SSIS packages
To understand data flow and control flow in SSIS
To gain proficiency in error handling and logging
To explore advanced SSIS features for complex data scenarios
To apply learned skills through practical exercises and case studies

Upon completing this Microsoft SQL Server Training in the United States, delegates benefit from enhanced SSIS proficiency, enabling them to design and manage efficient data integration solutions, ultimately improving organizational data workflows and decision-making processes.

More information

See dates & prices

What's Included in this SQL Server Integration Services 55321AC Training?

World-Class Training Sessions from Experienced Instructors
SQL Server Integration Services 55321AC Certificate
Digital Delegate Pack

More information

See dates & prices

More information

See dates & prices

accredited by

Our Microsoft training course is accredited by Microsoft

Duration

Online Instructor-led (4 days)

Online Self-paced (32 hours)

SQL Server 2014 Performance Tuning and Optimization 55144BC Training Course Outline

Module 1: SQL 2014 Architecture

New Cardinality Estimator
Memory-Optimized Tables
Understanding Performance for Developers
Understanding Start-up Parameters
Start-up Stored Procedures
Database Structures
Instant File Initialization
How SQL Stores Data?
How SQL Locates Data?

Lab: SQL 2014 Architecture

Configuring Compatibility Level
Start-up Parameter
Start-up Stored Procedure
Instant File Initialization

Module 2: Database Engine

Four Important Concepts
Temporary Tables Internals
Concurrency
Transactions
Isolation Levels
SQL Server Locking Architecture
SQL and Storage Area Networks (SAN)
SQL on VMs
SQLIO Utility
Partitioned Tables and Indexes

Lab: Database Engine

Table-Valued Parameter
Transactions
Vertically Partitioned Table Using Code
Partitioning with Filegroups
Partitioning Wizard

Module 3: SQL Performance Tools

Resource Governor
Activity Monitor
Live Query Statistics
Monitoring SQL with Transact-SQL
Dynamic Management Objects (DMOs) and Performance Tuning

Lab: SQL Performance Tools

Resource Governor
Activity Monitor
sp_who2
Performance DMVs

Module 4: Query Optimizing and Operators

Tuning Process
Performance Monitor Tool
SQL Query Processing Steps
Understanding Execution Plans
SET STATISTICS TIME and SET STATISTICS IO
Data Access Operators
Troubleshooting Queries

Lab: Query Optimizing and Operators

Performance Monitor (perfmon)
Estimated vs Actual Plans and XML Plans
Viewing a Non-Trivial Execution Plan
SET STATISTICS TIME and SET STATISTICS IO
Data Access Operators
DMVs
View Information About Extended Events
Wizard Templates
Creating a Session Without a Wizard
Configuring MDW and Viewing Reports

Module 5: Understanding Indexes

Introduction to Indexes
Index Types by Storage
Index Types by Column Designation
Creating and Altering Indexes
Metadata
Data Management Views for Indexing
Database Engine Tuning Advisor
Index Data Management Objects
SQL Server Fragmentation
Patterns
Index Storage Strategies
Indexed Views
Monitoring Indexes
Index Dynamic Management Objects (DMOs)

Lab: Understanding Indexes

Create Indexes
Index Metadata
Database Tuning Advisor
Missing Index DMOs
Fragmentation and Page Splits
Data Compression
Indexed Views
DMO Index Stats

Module 6: Understanding Statistics

Statistics
Cardinality Estimator
Incremental Statistics
Computed Columns Statistics
Filtered Statistics
Maintenance

Lab: Understanding Statistics

Statistics Objects
Histogram
New Vs Old Cardinality Estimator
Incremental Statistics
Computed Columns
Filtered Statistics
Ascending Keys
Statistics Maintenance Plan

Module 7: In-Memory Database

Architecture
Tables and Indexes
Natively Compiled Stored Procedures
Restrictions
Analyse Migrate Report Tool
In-Memory Data Management Views (DMV)

Lab: In-Memory Database

Creating an In-Memory Enabled Database with Code and SSMS
Creating a Memory-Optimized Table
View Hash Index
Natively Compiled Stored Procedure
AMR Tool
In-Memory DMVs

Module 8: SQL Profiler and SQL Trace

SQL Trace
SQL Trace Architecture
SQL Server Profiler

Lab: SQL Profiler and SQL Trace

SQL Trace Default Template
SQL Profiler Tuning Template
Create a Template for Slow Running Queries
Identifying Long Running Queries
Using Profiler to Detect Deadlocks
Use Profiler to Detect a Blocked Process

Module 9: Query Issues and Hints

Query Hints
Plan Guides
Plan Freezing
Join Orders

Lab: Query Issues and Hints

Create and Test a Plan Guide
Allow SQL Profiler to Help Create a Plan
Plan Freezing

More information

See dates & prices

Who should attend this SQL Server 2014 Performance Tuning and Optimization 55144BC Training?

The SQL Server 2014 Performance Tuning and Optimization 55144BC Training in the United States is intended for database professionals and IT personnel responsible for managing and maintaining SQL Server 2014 databases. This course is particularly suitable for:

Database Administrators
SQL Server Developers
Systems Administrators
Database Analysts
IT Managers
Database Architects
Application Developers

Prerequisites of the SQL Server 2014 Performance Tuning and Optimization 55144BC Training

There are no formal prerequisites for attending SQL Server 2014 Performance Tuning and Optimization 55144BC Training course.

SQL Server 2014 Performance Tuning and Optimization 55144BC Training Course Overview

SQL Server 2014 Performance Tuning and Optimization 55144BC Training in the United States delves into optimizing database performance, addressing key aspects of SQL Server 2014. It emphasizes relevance by ensuring databases operate efficiently, providing enhanced speed and responsiveness critical for modern, data-driven organizations.

Database administration and development professionals must master performance tuning to ensure SQL Server 2014 operates at peak efficiency in the United States. This knowledge is essential for database administrators, developers, and IT professionals aiming to maximize database performance, responsiveness, and overall system efficiency.

The Knowledge Academy's 4-day training in the United States equips delegates with practical skills to optimize SQL Server 2014. Participants learn performance-tuning techniques, query optimization strategies, and indexing methods. This training empowers delegates to proactively identify and resolve performance issues, enhancing their ability to maintain high-performing SQL Server environments.

Course Objectives:

To understand the principles of SQL Server 2014 performance tuning
To master query optimization techniques for improved database responsiveness
To implement effective indexing strategies for enhanced query performance
To identify and troubleshoot common performance issues in SQL Server 2014
To optimize database storage and memory usage for optimal performance
To apply learned concepts through hands-on exercises and real-world scenarios

Upon completing this Microsoft SQL Server Training in the United States, delegates benefit from heightened expertise in SQL Server 2014 performance tuning, enabling them to optimize databases, enhance system responsiveness, and proactively address performance challenges in dynamic business environments.

More information

See dates & prices

What's Included in this SQL Server 2014 Performance Tuning and Optimization 55144BC Training?

World-Class Training Sessions from Experienced Instructors
SQL Server 2014 Performance Tuning and Optimization 55144BC
Digital Delegate Pack

More information

See dates & prices

More information

See dates & prices

Not sure which course to choose?

Speak to a training expert for advice if you are unsure of what course is right for you. Give us a call on +1 7204454674 or Inquire.

Package deals for Microsoft SQL Server Training

Our training experts have compiled a range of course packages on a variety of categories in Microsoft SQL Server Training, to boost your career. The packages consist of the best possible qualifications with Microsoft SQL Server Training, and allows you to purchase multiple courses at a discounted rate.

Swipe for more. Don’t miss out!

Microsoft SQL Server Training FAQs

What is Microsoft SQL Server?

Microsoft SQL Server refers to a database management system (RDBMS) developed by Microsoft. It provides a platform for storing and handling data, supporting various data types, and facilitating efficient data retrieval and manipulation through SQL queries and stored procedures.

What are the benefits of this Microsoft SQL Server Certification?

This Microsoft SQL Server Training Course offers several benefits, including enhanced career opportunities, recognition of expertise in database management, and access to a community of professionals and resources for continuous learning and development in database administration. Learn SQL Server Online with The Knowledge Academy’s comprehensive Microsoft SQL Server Courses.

Are there any prerequisites needed for this Microsoft SQL Server Course?

The prerequisites for each of these Microsoft SQL Server Training Courses vary. Please refer to our course pages for specific information.

What is included in this Microsoft SQL Server Training Course?

This Microsoft SQL Server Course comes with a training session from experienced trainers, a digital delegate pack, and a certificate upon completion of the course.

Do you provide self-paced SQL Server Online Training Courses?

The Knowledge Academy provides flexible self-paced training for this Microsoft SQL Server Course. Self-paced training is beneficial for individuals who have an independent learning style and wish to study at their own pace and convenience.

What will I learn in this Microsoft SQL Server Training Course?

In this Microsoft SQL Server Certification Training, you'll learn database fundamentals, SQL querying, design, performance tuning, security, backup and recovery, business intelligence integration, high availability, advanced features, troubleshooting, and cloud integration.

Do you provide corporate training for this Microsoft SQL Server Training and Certification?

Yes, we provide corporate training for this Microsoft SQL Server Certification Training, tailored to fit your organization's requirements.

What is the duration of this Microsoft SQL Server Training Course?

The duration of each Microsoft SQL Server Certification Course varies. Please refer to our course pages for specific information.

What kinds of jobs can I expect based on this Microsoft SQL Certification?

With this Microsoft SQL Server Training Certification, you can pursue various roles such as Database Administrator, SQL Developer, Business Intelligence Developer, Data Analyst, Database Architect, Systems Analyst, and IT Manager.

What are the levels of difficulties for these Microsoft SQL Server Training Courses?

These Microsoft SQL Server Courses offer varying difficulty levels, from fundamental concepts for beginners to advanced topics for experienced professionals. These courses cover database fundamentals, SQL querying, design, performance tuning, security, and specialized areas, catering to diverse skill levels and career goals.

Do you offer 24/7 support for the Microsoft SQL Server Training Course?

Yes. The Knowledge Academy offers 24/7 support for delegates before, during, and after these Microsoft SQL Server Courses. Should you encounter any difficulties accessing the Microsoft SQL Server Training Certification Course materials, our customer support team is available to assist and promptly resolve any issues you may encounter.

How can I get certified in Microsoft SQL Server Training?

To get certified in Microsoft SQL Server Training, you can register for our courses and then pass the corresponding certification exams to demonstrate your proficiency in SQL Server technologies.

How can Microsoft SQL Server training help advance my career in database administration?

To get certified in Microsoft SQL Server Course, you can enroll in official courses offered by Microsoft or authorized training partners, and then pass the corresponding certification exams to demonstrate your proficiency in SQL Server technologies.

What will be the primary roles and responsibilities after getting certified in Microsoft SQL Server Course?

After completing the Microsoft SQL Server Training, primary roles may include database administrator, and SQL developer, responsible for database management, optimization, and ensuring data integrity within organisations.

What are the best Microsoft SQL Server Training courses in the United States?

Please see our Microsoft SQL Server Training courses available in the United States

Which is the best training institute/provider of Microsoft SQL Server Training in the United States?

The Knowledge Academy is the Leading global training provider for Microsoft SQL Server Training.

What is the cost/training fees for Microsoft SQL Server Training in the United States

The training fees for Microsoft SQL Server Training in the United States starts from $2895

Why we're the go to training provider for you

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

Trusted & Approved

We are accredited by PeopleCert on behalf of AXELOS

Many delivery methods

Flexible delivery methods are available depending on your learning style.

High quality resources

Resources are included for a comprehensive learning experience.

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water