Popular Topics
CSS
.NET Secure Coding
Introduction to Angular
Data Analyst
Tableau
Real World Applications of Generative AI
Introduction to Power BI
CompTIA Security+
Generative AI for Decision Makers
Generative AI for Architects
Jira
Tableau Server Administration
CISSP
AI
Risk and Compliance
Applying AI for Cost Savings & Efficiency
ASP .Net Web Applications Development
GitHub
Certified in Governance
Ethics and AI
Building a Voice Bot
Automation with Ansible
AWS
Data Science and Big Data
Microsoft Azure
Implementing AI in Automated Enterprise
Introduction to Jira
Next Level Power BI
ITIL 4 Certification
.NET Programming
Privacy and Security in AI
XML Course
Kubernetes
XML Learning
Developing AWS Services and Tools
Attacking and Securing C#
Chief Information Security Officer
Tableau Desktop
Administering A SQL Database
ITIL 4 Foundation Certification Training
CompTIA Linux
Certified Cloud Security Professional
Responsive Design
AI Tools in Graphic Design
C++ 20 Programming
Penetration Testing Professional
AI Automation Strategies
UX Design
JavaScript
MVC Web Application Development by .NET
SQL Data Warehouse
Advanced Angular
Advanced React
Voice Of Innovation
Introduction to Ansible
Cloud Operations on AWS
Mastering React
Implementing AI in Business
Certified in Cybersecurity Training
Hadoop
Certified Secure Software Lifecycle Professional
React Course
Generative AI
Microsoft Office 365 Online
Cloud Computing
CISSP Exam Preparation Course
Modern JavaScript
Microsoft Azure Data Fundamentals
Machine Learning Fundamentals
CompTIA
Strategic AI Dialogues
CompTIA Cybersecurity Analyst
JavaScript Essentials'
Core Java Programming
SQL Server Performance Tuning
AI Types
Network Defender
Basic Java Programming
SQL Server Performance Optimization
AI Principles
CSS3
Git
react native
How AI Process Images
Java Programming
AI Applications
ASP .NET Core
SQL Data Models
Customer Support with AI
UI/UX Design
SQL Server Integration
Django
CompTIA Data+
CompTIA Cloud Essentials+
Microsoft Azure for SAP Workloads
Microsoft Power BI Data Analyst
PL-600 Power Platform Solution Architect
CompTIA Project
Azure SQL Solutions
SharePoint End User
CompTIA Network
CompTIA A+ Core 2
Microsoft Azure Administrator
Professional Development
Prompt Engineering for Business Users
Cybersecurity Analyst
Microsoft Project 2016 Level 1
Microsoft Project 2016: Level 2
Microsoft Azure Fundamentals Training Certification
Introduction to AI
CompTIA IT Fundamentals
HTML5
Introduction to GitHub
Azure AI Fundamentals
Microsoft Azure Certification
CompTIA Cloud
CompTIA A+ Core 1
Azure Infrastructure Solutions
SQL Database Infrastructure
Full Stack Web Development
Citrix Endpoint Management
Introduction to C++
Azure AI Solution
HTM
CompTIA Server
Python
Citrix
CompTIA PenTest
Citrix Cloud with Amazon Web Services
Advance C++ 20 Programming
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 …