We may not have the course you’re looking for. If you enquire or give us a call on +44 1344 203 999 and speak to our training experts, we may still be able to help with your training requirements.
close
Press esc to close
close
Press esc to close
close
Fill out your contact details below and our training experts will be in touch.
If you wish to make any changes to your course, please log a ticket and choose the category ‘booking change’
Back to Course Information
Online Instructor-led (2 days)
Online Self-paced (16 hours)
Within this Microsoft training course, you will learn the following modules:
Module 1: Introduction to Transact-SQL
Module 2: Sort and Filter Results in T-SQL
Module 3: Combine Multiple Tables with JOINs in T-SQL
Module 4: Write Subqueries in T-SQL
Module 5: Use Built-In Functions and GROUP BY in Transact-SQL
Module 6: Modify Data with T-SQL
(344 remaining)
This Querying Data with Microsoft Transact-SQL DP080 Course 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:
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.
Transact SQL is a query language exclusive to Microsoft SQL and Sybase that extends SQL (Structured Query Language) with features such as row processing, variable declaration, transaction control, and exception handling. Studying Querying Data with Microsoft Transact-SQL DP080 Training course help learners to effectively querying data with T-SQL. It allows users to incorporate programming logic into the database. It helps individuals to uniform and secure the data access from the database in nature. This training will help learners to expand their skills and to undertake a variety of tremendous job opportunities in various international companies.
This 2-day Querying Data with Microsoft Transact-SQL DP080 training course will cover necessary topics to help delegates become fully familiar with the T-SQL. During this training, they will learn about how to use built-in functions. They will also learn about scalar functions, sort and filter data returned by SELECT queries, get started with SQL Server query tools, write queries in T-SQL, group aggregated results, sort query results, insert data into tables, and many more. Our highly professional trainer with years of experience in teaching Microsoft courses will conduct this training course and will help you get a complete understanding of T-SQL.
This training will cover various essential topics, such as:
After attending the Querying Data with Microsoft Transact-SQL DP080 Training course, delegates will be able to sort and filter data returned by SELECT queries. They will also be able to modify and delete data.
Online Instructor-led (3 days)
Online Self-paced (24 hours)
Module 1: Discover Data Analysis
Module 2: Get Started Building with Power BI
Module 3: Get Data in Power BI
Module 4: Clean, Transform and Load Data in Power BI
Module 5: Design a Data Model in Power BI
Module 6: Add Measures to Power BI Desktop Models
Module 7: Add Calculated Tables and Columns to Power BI Desktop Models
Module 8: Use DAX Time Intelligence Functions in Power BI Desktop Models
Module 9: Optimise a Model for Performance in Power BI
Module 10: Design Power BI Reports
Module 11: Configure Power BI Report Filters
Module 12: Enhance Power BI Report Designs for the User Experience
Module 13: Perform Analytics in Power BI
Module 14: Create and Manage Workspaces in Power BI
Module 15: Manage Datasets in Power BI
Module 16: Create Dashboards in Power BI
Module 17: Implement Row-Level Security
(344 remaining)
This Microsoft Power BI Data Analyst PL300 Course 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:
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.
This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.
Online Instructor-led (2 days)
Online Self-paced (16 hours)
Module 1: Introduction to Power BI
Lab: Getting Ready
Module 2: Requirements Gathering
Lab: Build a Report in Power BI Web
Module 3: Extract, Transform, and Load Data
Lab: Starting a Project in Power BI Desktop
Module 4: Creating a Data Model
Lab: Designing a Data Model
Module 5: Designing Reports
Lab: Creating a Report
Module 6: Using Workspaces and Dashboards
Lab: Publish and Share Reports and Dashboards
(344 remaining)
The Microsoft Power BI for End Users 55400AC Training is designed to be accessible, making it a good fit for professionals at various levels of an organisation who are looking to make data-driven decisions.
The following professionals will benefit the most from this course:
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.
This course is for individuals that are looking to learn how to use the range of Microsoft Power BI tools to refine and model their data into a visual and interactive format. You will be taken on a journey from the concepts of a Power BI project right through to the result in an engaging and structured format. You will get hands on with a wealth of data to practise the techniques taught by this course.
Online Instructor-led (4 days)
Online Self-paced (32 hours)
Module 1: Introduction to Microsoft Data Analytics
Lab: Get Started
Module 2: Understand How to Prepare Data in Power BI?
Lab: Preparation of Data in Power BI Desktop
Module 3: Cleaning, Transforming, and Loading Data in Power BI
Lab: How to Transform and Load Data?
Module 4: How to Design a Data Model in Power BI?
Lab: Data Modelling in Power BI Desktop
Lab: Advanced Data Modelling in Power BI Desktop
Module 5: Build Measures with DAX in Power BI
Lab: Fundamentals of DAX in Power BI Desktop
Lab: Introduction to Advanced DAX in Power BI Desktop
Module 6: How to Optimise the Model Performance?
Module 7: Overview of Creating Reports
Lab: Designing a Report in Power BI
Lab: Enhance Power BI Reports with Interaction and Formatting
Module 8: How to Create Dashboards?
Lab: Develop a Report in Power BI Desktop - Part 1
Module 9: Create Paginated Reports in Power BI
Lab: Create a Paginated Report
Module 10: Implement Advanced Analytics
Lab: Data Analyzing in Power BI Desktop
Module 11: Create and Manage Workspaces
Lab: Publish and Share Power BI Content
Module 12: Manage Datasets in Power BI
Module 13: Row-Level Security
(344 remaining)
The Analyzing Data with Power BI DA100 Course is aimed at harness the robust capbilities of Power BI for data visualisations. This course can be helpful for various professionals, including:
The prerequisites required for the Analyzing Data with Power BI DA100 Course are:
Power BI (Business Intelligence) is a business analytics interactive service which is provided by Microsoft and assists individuals to turn data into a business opportunity with the help of data visualisation and analytics tools for BI. This service allows users to derive better business decisions by analyzing their enterprise data. By using Power BI service, individuals can create dashboards or reports that will track the metrics, and it will also help them to get a variety of data in the cloud systems. Microsoft’s Power BI is a powerful analytics tool that allows companies or enterprises of all sizes to analyse data and share different insights. With this Microsoft service, enterprises can monitor their business performance more closely and get immediate results with real-time dashboards available for every device. This is an extremely vast field which is currently being implemented in most of the organisations.
This 4-day Analyzing Data with Power BI (DA-100) training course will provide delegates with comprehensive knowledge of basic as well as advanced concepts such as what is data analytics, acquiring data from various sources, and how to create reports. They will get familiar with setting measures using DAX (Data Analysis Expressions), how to create dashboards, managing workspaces and datasets in Power BI. This training will contain different labs with different topics which will help you to get hands-on practical experience and knowledge as well.
Delegates will also learn the following essential topics:
After attending this Analyzing Data with Power BI (DA-100) training course, delegates will gain knowledge about creating, transforming, and loading data with the help of Power BI tool. Delegates will be able to optimise the performance, resolve data errors, and improve the reports for the business growth. They will also be able to work on advanced DAX, different hierarchies for the data model, perform advanced analytics, and more which will help them to enhance their knowledge and skills for getting a job in this technical field.
Online Instructor-led (4 days)
Online Self-paced (32 hours)
Module 1: SSIS Overview and Core Features
Module 2: Data Warehousing
Module 3: SSIS Control Flow Objects and Features
Module 4: Extracting, Transforming and Loading Data Using SSIS Data Flows
Module 5: Working with Files, Importing and Exporting File Data
Module 6: Optimising Data Extraction and Data Loading
Module 7: Data Quality and Cleansing
Module 8: Advanced Enterprise Information Management
Module 9: Dimension ETL with SSIS
Module 10: Fact ETL with SSIS
Module 11: Project Deployment Model: Execution and Reporting
Module 12: Processing SSAS Objects in SSIS
Module 13: Project Deployment
Module 14: Package Deployment
Module 15: Transactions and Restartability
Module 16: Optimisation and Scalability
(344 remaining)
This Accelerated SQL Server 2016 Integration Services Training Course 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:
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.
SSIS (SQL Server Integration Services) is part of the Microsoft SQL Server software data utilised for various data migration tasks. SQL (Structured Query Language) Server Integration Service is a quick and adaptable data warehousing tool applied to extract, transform, and load data. It presents easy to load the data from one database to a different database like Oracle, Excel file, SQL Server, etc. We can say that the SSIS tool is used for data migration and used to perform a wide variety of integration tasks and transformations. Many companies use SSIS because it assists them in joining data from multiple data stores and filling data to various objectives quickly and effectively. Having in-depth knowledge of SSIS is very important in this digital era. Individuals with advanced SQL knowledge are one step ahead of the rest and work as highly paid posts in various multinational investigation organisations.
This 4-day Accelerated SQL Server 2016 Integration Services training course provides delegates with a comprehensive knowledge of SQL Server Integration Services and its various features. This training will provide in-depth knowledge about how to add and configure a flat file connection manager. They will get to know about Excel connection manager, data quality and cleansing, dimension ETL with SSIS, SSIS slowly changing dimension wizard, and many more things. This course will be taught by our expert trainers who have years of experience in teaching technical courses.
This course will cover various essential topics, such as:
At the end of this training, delegates will be able to use SQL Server Integration Services and its feature effectively. They will extract, transform, and load data using SSIS data flow without facing any issues. They will also be able to restart packages by using checkpoints.
Online Instructor-led (5 days)
Online Self-paced (40 hours)
Module 1: SSIS Overview
Module 2: Working with Solutions and Projects
Module 3: Basic Control Flow
Module 4: Common Tasks
Module 5: Data Flow Sources and Destinations
Module 6: Data Flow Transformations
Module 7: Making Packages Dynamic
Module 8: Containers
Module 9: Troubleshooting and Package Reliability
Module 10: Deploying to the SSIS Catalog
Module 11: Installing and Administering SSIS
Module 12: Securing the SSIS Catalog
(344 remaining)
The SQL Server Integration Services 55321AC Training 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:
There are no formal prerequisites for attending this SQL Server Integration Services 55321AC course.
Microsoft's SQL Server Integration Services (SSIS) is a data integration solution that enables programmers to create and implement intricate ETL (Extract, Transform, and Load) processes for projects. It is used to handle errors and exceptions during package execution when it moves on to SSIS event handling. Studying this training helps individuals learn how to deploy and schedule SSIS packages, which are used to automate package execution. This training helps learners implement real-time data integration solutions and optimise SSIS package performance and efficiency. Pursuing this training helps individuals get equipped with the necessary skills and techniques to enhance their career opportunities and ultimately increase their earnings.
In this 5-day SQL Server Integration Services 55321AC training course, delegates will gain a comprehensive understanding of SSIS to create and deploy SSIS packages. During this training, they will learn about configuring logging and auditing features in SSIS packages and how to use them to troubleshoot issues. They will also learn about how to build complex ETL (Extract, Transform, and Load) workflows using SSIS. The Knowledge Academy’s highly professional and knowledgeable tutor, who has years of teaching experience, will conduct this training.
Course Objectives
At the end of this training course, delegates will be able to create dynamic and reusable SSIS packages using package configurations. They will also be able to work with different types of SSIS data sources, including flat files and Excel spreadsheets.
Online Instructor-led (4 days)
Online Self-paced (32 hours)
Module 1: SQL 2014 Architecture
Lab: SQL 2014 Architecture
Module 2: Database Engine
Lab: Database Engine
Module 3: SQL Performance Tools
Lab: SQL Performance Tools
Module 4: Query Optimising and Operators
Lab: Query Optimising and Operators
Module 5: Understanding Indexes
Lab: Understanding Indexes
Module 6: Understanding Statistics
Lab: Understanding Statistics
Module 7: In-Memory Database
Lab: In-Memory Database
Module 8: SQL Profiler and SQL Trace
Lab: SQL Profiler and SQL Trace
Module 9: Query Issues and Hints
Lab: Query Issues and Hints
(344 remaining)
The SQL Server 2014 Performance Tuning and Optimisation 55144BC Training is intended for database professionals and IT personnel responsible for managing and maintaining SQL Server 2014 databases. This course is particularly suitable for:
There are no formal prerequisites for attending SQL Server 2014 Performance Tuning and Optimisation 55144BC Training course.
SQL (Structured Query Language) is a programming language designed for managing and manipulating relational databases to retrieve, update, and manage data stored in database systems. It is important for enhancing the overall performance and efficiency of SQL Server databases. Studying this training helps individuals effectively optimise SQL Server databases, troubleshoot performance issues, optimise queries, and design efficient database structures. This training helps organisations maximise the performance of their SQL Server databases, leading to increased productivity, reduced downtime, and improved scalability. Pursuing this training helps individuals to become database administrators and developers, enabling them to contribute significantly to database performance and optimisation initiatives in various organisations.
The Knowledge Academy’s 4-day SQL Server 2014 Performance Tuning and Optimisation 55144BC Training course provides delegates with in-depth knowledge and skills to enhance the performance and efficiency of SQL Server databases. During this training, they will learn how to analyse query execution plans and identify and resolve performance bottlenecks. They will also learn about how to optimise SQL Server configurations and effectively manage memory and disc resources. This course will be led by our highly skilled and knowledgeable trainer, who has years of experience in teaching and will help delegates get a complete understanding of this course.
Course Objectives
After attending this training, delegates will be able to analyse and resolve performance issues and bottlenecks effectively. They will also be able to utilise performance monitoring tools to manage and tune SQL Server and enhance overall system performance.
Online Instructor-led (3 days)
Online Self-paced (24 hours)
Module 1: Introduction to Databases
Lab 1: Use the SELECT Statement to Retrieve Data from a Database
Module 2: Database Tables
Lab 1: Create and Alter a Table in Microsoft SQL Server
Lab 2: 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
Module 3: Add and Update Data
Lab 1: Add and Change Data in SQL Server
Lab 2: Create and use Stored Procedures in Microsoft SQL Server
Module 4: Entity Relationships
Lab 1: Create an Entity Relationship Diagram in Microsoft SQL Server Management Studio
Module 5: Normalization and Denormalization
Lab 1: Denormalize a Table by Adding a Redundant Column of Computed Data
Module 6: Query Performance and Safety
Lab 1: Create Indexes and Consult Execution Plans in Microsoft SQL Server Management Studio
(344 remaining)
This Introduction to SQL Databases Training 10985C Course 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:
There are no formal prerequisites for this Introduction to SQL Databases Training 10985C Course.
SQL (Structured Query Language) is the most common language for organising and extracting data stored in a relational database. It is used to build, read, edit, and remove relational databases and tables. Organisations use SQL monitoring tools to plan the diagnosis and tuning of various components to discover server issues in a simplified manner. Excelling in this Introduction to SQL Databases training course will allow you to expand your technical abilities and open up numerous new career prospects. This obtained information from this training course will lead you to attain many job roles such as database administrator, quality assurance tester, software engineer, and many other highly paid reputed designations.
The Knowledge Academy’s 3-day Introduction to SQL Databases training course will upgrade the delegates’ ability to explore and sort queries regarding SQL server databases. During this training, delegates will learn how to create, read, update and delete relational databases and tables. Furthermore, delegates will understand fundamental database types, database languages, and database design.
It also accommodates the delegates with more SQL related concepts, such as:
At the end of this training course, delegates will be able to know the key database concepts and languages used in SQL Server. They will be eligible to perform each type of data modelling technique and the normalisation and denormalisation techniques. Our highly expert trainer with abundant knowledge has curated this training course to handle vast volumes of structured data and standardise your data to create and manage various data servers.
Online Instructor-led (3 days)
Online Self-paced (24 hours)
Module 1: Introduction to TSQL for Business Intelligence
Module 2: Turning Table Columns into Variables for Analysis: SELECT List Expressions, WHERE, and ORDER BY
Module 3: Combining Columns from Multiple Tables into a Single Dataset: The JOIN Operators
Module 4: Creating an Appropriate Aggregation Level Using GROUP BY
Module 5: Subqueries, Derived Tables and Common Table Expressions
Module 6: Encapsulating Data Retrieval Logic
Module 7: Getting Your Dataset to the Client
(344 remaining)
The Writing Analytical Queries for Business Intelligence 55232A Training 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:
In this Writing Analytical Queries for Business Intelligence 55232A Training course, there are a few prerequisites that delegates need to fulfil. They must have:
Business Intelligence (BI) is a technology-driven process for evaluating data and delivering actionable information to leaders, managers, and employees to help them make better business choices. Organisations use analytical queries to integrate data from numerous inquiries from the same or other data sources into a single return set. Delegates will lay their hands-on the TSQL queries that are written for database reporting, analysis, and business intelligence. Excelling in this training course will lead you to attain many greater designations such as Business Systems Analysts, Tableau Developers, Business Analyst Consultants, Business Developers, and numerous highly skilled job profiles to upgrade your career positions ahead.
In this 3-day Writing Analytical Queries for Business Intelligence 55232-A Training Course delegates will obtain adequate knowledge about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. Delegates will come to know about the identification and connection between measurement levels and column data types. Our highly expert trainer with abundant knowledge will make the delegates to experience a consistent, straightforward, and intentional learning route throughout the training.
It also accommodates the delegates to cover numerous essential topics, such as:
At the end of this training course, delegates will be able to combine JOIN operations with WHERE and ORDER BY. They will also be able to allow a user with read-only access to use views, table-valued functions, and store procedures.
Speak to a training expert for advice if you are unsure of what course is right for you. Give us a call on +44 1344 203 999 or Enquire.
Our training experts have compiled a range of course packages to compliment a variety of categories in order to help fast track your career. The packages consist of the best possible qualifications in each industry and allows you to purchase multiple courses at a discounted rate.
Total without package: €9190
Package price: €5495 (Save €3695)
Retired: Administering a SQL Database Infrastructure M20764€4595
Total without package: €9190
Package price: €5495 (Save €3695)
Total without package: €9190
Package price: €5495 (Save €3695)
Swipe for more. Don’t miss out!
You won't find better value in the marketplace. If you do find a lower price, we will beat it.
We are accredited by PeopleCert on behalf of AXELOS
Flexible delivery methods are available depending on your learning style.
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