Microsoft SQL Server Training

accredited by

Our Microsoft training course is accredited by Microsoft

Online Instructor-led (3 days)

Classroom (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

Show moredown

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

This Microsoft Power BI Data Analyst PL300 Course in India 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 India 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 India 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 India 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 India, delegates will have the expertise to navigate Microsoft Power BI confidently, transforming raw data into actionable insights.

Show moredown

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

Show moredown

accredited by

Our Microsoft training course is accredited by Microsoft

Online Instructor-led (2 days)

Classroom (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

Show moredown

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

The Microsoft Power BI for End Users 55400AC Training in India 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 India 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 India 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 India 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 India, 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.

Show moredown

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

Show moredown

accredited by

Our Microsoft training course is accredited by Microsoft

Online Instructor-led (3 days)

Classroom (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

Show moredown

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

This Introduction to SQL Databases Training 10985C Course in India 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 India 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 India. 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 India 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 India, 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.

Show moredown

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

Show moredown

accredited by

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

Online Instructor-led (4 days)

Classroom (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

Show moredown

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

This Accelerated SQL Server 2016 Integration Services Training Course in India 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 India 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 India 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 India 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 India, delegates will emerge with a heightened proficiency in SQL Server Integration Services, enabling them to design and implement efficient ETL processes.

Show moredown

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

Show moredown

accredited by

Our Microsoft training course is accredited by Microsoft

Online Instructor-led (3 days)

Classroom (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

Show moredown

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

The Writing Analytical Queries for Business Intelligence 55232A Training in India 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 India 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 India. 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 India 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 India, 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.

Show moredown

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

Show moredown

accredited by

Our Microsoft training course is accredited by Microsoft

Online Instructor-led (5 days)

Classroom (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

Show moredown

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

The SQL Server Integration Services 55321AC Training in India 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 India 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 India. 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 India 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 India, 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.

Show moredown

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

Show moredown

accredited by

Our Microsoft training course is accredited by Microsoft

Online Instructor-led (4 days)

Classroom (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

Show moredown

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

The SQL Server 2014 Performance Tuning and Optimization 55144BC Training in India 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 India 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 India. 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 India 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 India, 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.

Show moredown

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

Show moredown

accredited by

Our Microsoft training course is accredited by Microsoft

Online Instructor-led (2 days)

Classroom (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

Show moredown

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

This Querying Data with Microsoft Transact-SQL DP080 Course in India 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 India 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 India. 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 India 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 India, 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.

Show moredown

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

Show moredown

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 +91 8037244591 or Enquire.

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

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.
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.
The prerequisites for each of these Microsoft SQL Server Training Courses vary. Please refer to our course pages for specific information.
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.
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.
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.
Yes, we provide corporate training for this Microsoft SQL Server Certification Training, tailored to fit your organization's requirements.
The duration of each Microsoft SQL Server Certification Course varies. Please refer to our course pages for specific information.
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.
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.
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.
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.
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.
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.
The Knowledge Academy is the Leading global training provider for Microsoft SQL Server Training.
The training fees for Microsoft SQL Server Training in India starts from INR181199
Show more down

Why we're the go to training provider for you

icon

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.

icon

Trusted & Approved

We are accredited by PeopleCert on behalf of AXELOS

icon

Many delivery methods

Flexible delivery methods are available depending on your learning style.

icon

High quality resources

Resources are included for a comprehensive learning experience.

barclays Logo
deloitte Logo
Thames Water Logo

"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

santander logo
bmw Logo
Google Logo
cross

BIGGEST
Christmas SALE!

red-starWHO WILL BE FUNDING THE COURSE?

close

close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

close

close

Press esc to close

close close

Back to course information

Thank you for your enquiry!

One of our training experts will be in touch shortly to go overy your training requirements.

close close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.