Popular Topics
Data Analyst
Introduction to Angular
Generative AI for Decision Makers
CompTIA Security+
Tableau
.NET Secure Coding
Generative AI for Architects
ASP .Net Web Applications Development
CSS
Tableau Server Administration
Introduction to Power BI
Real World Applications of Generative AI
Certified in Governance
CISSP
Risk and Compliance
Implementing AI in Automated Enterprise
Certified in Cybersecurity Training
Introduction to Jira
GitHub
Django
UX Design
Modern JavaScript
Cloud Computing
Attacking and Securing C#
CompTIA Cybersecurity Analyst
CSS3
Responsive Design
XML Course
.NET Programming
AWS
Tableau Desktop
Applying AI for Cost Savings & Efficiency
Microsoft Office 365 Online
Cybersecurity Analyst
CISSP Exam Preparation Course
Building a Voice Bot
Data Science and Big Data
Jira
Basic Java Programming
Java Programming
XML Learning
C++ 20 Programming
Implementing AI in Business
AI Automation Strategies
JavaScript Essentials'
CompTIA
Administering A SQL Database
Next Level Power BI
Automation with Ansible
ITIL 4 Foundation Certification Training
ITIL 4 Certification
HTM
Certified Cloud Security Professional
Penetration Testing Professional
JavaScript
Advanced React
ASP .NET Core
Cloud Operations on AWS
CompTIA A+ Core 2
Chief Information Security Officer
Certified Secure Software Lifecycle Professional
Kubernetes
Microsoft Azure
Voice Of Innovation
Introduction to Ansible
CompTIA IT Fundamentals
Generative AI
Network Defender
Azure AI Fundamentals
Strategic AI Dialogues
CompTIA Linux
UI/UX Design
Core Java Programming
AI Principles
SQL Server Integration
Advanced Angular
Git
AI Applications
SQL Data Warehouse
Microsoft Power BI Data Analyst
Customer Support with AI
Mastering React
SharePoint End User
Developing AWS Services and Tools
Hadoop
CompTIA Network
React Course
MVC Web Application Development by .NET
Professional Development
Microsoft Azure Data Fundamentals
SQL Server Performance Tuning
Microsoft Azure Certification
Prompt Engineering for Business Users
CompTIA Cloud
SQL Server Performance Optimization
CompTIA A+ Core 1
Azure Infrastructure Solutions
Python
AI Types
CompTIA Server
SQL Data Models
Citrix
CompTIA PenTest
Citrix Cloud with Amazon Web Services
CompTIA Data+
CompTIA Cloud Essentials+
Introduction to C++
Microsoft Azure for SAP Workloads
PL-600 Power Platform Solution Architect
CompTIA Project
Azure SQL Solutions
Advance C++ 20 Programming
Microsoft Azure Administrator
Microsoft Project 2016 Level 1
HTML5
Microsoft Project 2016: Level 2
Microsoft Azure Fundamentals Training Certification
Full Stack Web Development
SQL Database Infrastructure
Azure AI Solution
Introduction to GitHub
Citrix Endpoint Management
All `Live Courses by Practice Area Courses
Test descriptionFilter by Topic
Filter by Vendor
55321: SQL Server Integration Services
Course Description This instructor-led course is intended for IT professionals …
What you'll learn
Create sophisticated SSIS packages for extracting, transforming, and loading data
Use containers to efficiently control repetitive tasks and transactions
Configure packages to dynamically adapt to environment changes
Use Data Quality Services to cleanse data
Successfully troubleshoot packages
Create and Manage the SSIS Catalog
Deploy, configure, and schedule packages
Secure the SSIS Catalog
55315: Introduction To SQL Databases
Course Description This three-day instructor-led course is aimed at people …
What you'll learn
Describe key database concepts in the context of SQL Server
Describe database languages used in SQL Server
Describe data modelling techniques
Describe normalization and denormalization techniques
Describe relationship types and effects in database design
Describe the effects of database design on performance
Describe commonly used database objects
Developing SQL Data Models
Course Description The focus of this 3-day instructor-led course is …
What you'll learn
Components, architecture, and nature of a BI solution
Create a multidimensional database with analysis services
Implement dimensions in a cube
Implement measures and measure groups in a cube
Use MDX syntax
Customize a cube
Implement a tabular database
Use DAX to query a tabular model
Use data mining for predictive analysis
55353: Administering A SQL Database Infrastructure
This instructor-led course provides students who administer and maintain SQL …
What you'll learn
Authenticate and authorize users
Assign server and database roles
Authorize users to access resources
Protect data with encryption and auditing
Describe recovery models and backup strategies
Backup SQL Server databases
Restore SQL Server databases
Automate database management
Configure security for the SQL Server agent
Manage alerts and notifications
Managing SQL Server using PowerShell
Trace access to SQL Server
Monitor a SQL Server infrastructure
Troubleshoot a SQL Server infrastructure
Import and export data
M55144: SQL Server Performance Tuning And Optimization
In this course, you will learn practical tuning and optimization …
What you'll learn
SQL 2014 Architecture including the new Cardinality Estimator
Memory-optimized tables
Startup stored procedures
Database structures
Instant File Allocation
Table internals and valued parameters
Concurrency, transactions, and isolation levels
SQL Server locking architecture
Partitioned tables and indexes
Resource Governor, Activity Monitor, Transact-SQL, and performance data management views (DMVs)
Performance Monitor Tool, execution plans, Data Access Operators, MDW and viewing reports
Create, utilize, manage and monitor indexes
Cardinality Estimator, incremental statistics, computed column statistics, filtered statics, and maintenance
In-Memory OLTP engine, restrictions, the Analyze Migrate Report tool, and in-memory (DMVs)
55316: Administering A SQL Database
This instructor-led course provides students who manage SQL Server and …
What you'll learn
Authenticate and authorize users
Assign server and database roles
Authorize users to access resources
Use encryption and auditing features to protect data
Describe recovery models and backup strategies
Backup and Restore SQL Server databases
Automate database management
Configure security for the SQL Server agent
Manage alerts and notifications
Managing SQL Server using PowerShell
Trace access to SQL Server
Monitor a SQL Server infrastructure
Troubleshoot a SQL Server infrastructure
Import and export data
Diversity, Equity, Inclusion, & Belonging (DEI&B) An Overview
Course Description This training provides participants with the foundational knowledge …