Facebook

`Live Courses by Practice Area Courses

Most popular
Trending

All `Live Courses by Practice Area Courses

Test  description

We found 285 courses available for you
See

55321: SQL Server Integration Services

87 Lessons
40 hours
Intermediate

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

27 Lessons
24 hours
Beginner

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

40 Lessons
24 hours
Intermediate

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

104 Lessons
40 hours
Intermediate

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

73 Lessons
40 hours
Intermediate

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)

DP-080T00: Querying Data with Microsoft Transact-SQL

29 Lessons
16 hours
Intermediate

Course Description This course will teach you how to use …

What you'll learn
Introduction to Transact-SQL
Sort and filter results in T-SQL
Combine multiple tables with JOINs in T-SQL
Write Subqueries in T-SQL
Use built-in functions and GROUP BY in Transact-SQL
Modify data with T-SQL

55316: Administering A SQL Database

107 Lessons
40 hours
Intermediate

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
Free

Diversity, Equity, Inclusion, & Belonging (DEI&B) An Overview

10 Lessons
Intermediate

Course Description This training provides participants with the foundational knowledge …