Facebook

Courses

We found 522 courses available for you
See

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

Course Description This instructor-led course provides students who administer and …

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

Course Description In this course, you will learn practical tuning …

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

Course Description This instructor-led course provides students who manage SQL …

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

Certified Threat Intelligence Analyst | CTIA eLearning

6 Lessons
24 hours
Intermediate

Course Description Certified Threat Intelligence Analyst (CTIA) is designed and …

Free

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

10 Lessons
Intermediate

Course Description This training provides participants with the foundational knowledge …

Free

Difficult Conversations & Conflict Management

8 hours
Intermediate

Course Description Difficult conversations are inevitable at work and in …

🚀 Get Up to 33% OFF on Top Courses + FREE e-learning subscription (worth $1595)
This is default text for notification bar