Popular Topics
Data Analyst
CompTIA Security+
CISSP
Risk and Compliance
Developing Generative AI on AWS
Microsoft Azure
ITIL 4 Certification
Certified in Governance
Security Engineering on AWS
AWS
Developing AWS Services and Tools
ISO 22301 Certification
ITIL 4 Foundation Certification Training
CompTIA Linux
PECB ISO 31000 Certification
Generative AI Applications on AWS
SQL Server Integration
ISO / IEC 42001 Lead Auditor
Penetration Testing Professional
SQL Data Warehouse
Security on AWS
Cloud Operations on AWS
CISSP Exam Preparation Course
Chief Information Security Officer
Microsoft Azure Data Fundamentals
Cloud Computing
Certified in Cybersecurity Training
CompTIA
Administering A SQL Database
Penetration Testing Certification
SQL Server Performance Tuning
Advanced Developing on AWS
SQL Server Performance Optimization
ISO 31000 Risk Manager
AWS Cloud Essentials
SQL Data Models
CompTIA PenTest
Citrix
Microsoft Power BI Data Analyst
CMMC Certified Professional
ISO/IEC 42001 Lead Implementer
Citrix Cloud with Amazon Web Services
Microsoft PoerShell
CompTIA Data+
CompTIA Cloud Essentials+
Azure SQL Solutions
Lead Cloud Security Manager
Microsoft Azure for SAP Workloads
Microsoft Azure Administrator
PL-600 Power Platform Solution Architect
ISO 22301 Lead Auditor
CompTIA Project
CompTIA A+ Core 2
Cloud Security Manager
SharePoint End User
CompTIA Network
Cloud Security Certification
ISO 22301 Lead Implementer
Certified Secure Software Lifecycle Professional
Lead Pen Test Professional
Microsoft Office 365 Online
Microsoft Azure Fundamentals Training Certification
ISO 31000 Lead Risk Manager
Cybersecurity Analyst
Microsoft Project 2016 Level 1
Microsoft Azure Certification
CompTIA IT Fundamentals
ISO 31000 Certification
CompTIA Cybersecurity Analyst
Cybersecurity Foundation
Microsoft Project 2016: Level 2
CompTIA Cloud
Network Defender
Certified Cloud Security Professional
Cybersecurity Certification
Azure AI Fundamentals
SQL Database Infrastructure
CompTIA A+ Core 1
CMMC Foundations
Azure Infrastructure Solutions
CompTIA Server
ISO / IEC 42001 Certification
Citrix Endpoint Management
CMMC Certification
Azure AI Solution
All `Live Courses by Vendor Courses
Filter by Topic
Filter by Vendor
DP-300T00: Administering Microsoft Azure SQL Solutions
Course Description: This course provides students with the knowledge and …
What you'll learn
Plan, deploy and configure Azure SQL offerings
Monitor database performance and tune a database and queries for optimum performance
Plan and configure a High Availability Solution
Implementing A SQL Data Warehouse
This course provides students with the knowledge and skills to …
What you'll learn
Describe the key elements of a data warehouse solution
Considerations for building a data warehouse
Implementing a logical design for a data warehouse
Implement a physical design for a data warehouse
Create Columnstore indexes
Implementing an Azure SQL Data Warehouse
Describe the key features of SSIS
Implement a data flow by using SSIS
Implement control flow by using tasks and precedence constraints
Create dynamic packages that include variables and parameters
Debug SSIS packages
Describe the considerations of implement an ETL Solution
Implement Data Quality Services
Implement a Master Data Service model
Describe how you can use custom components to extend SSIS
Deploy SSI projects
Describe BI and common BI scenarios
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)