Filter by Topic
Filter by Vendor
C)DRE – Certified Disaster Recovery Engineer
Course Description A Certified Disaster Recovery Engineer, C)DRE, is the …
C)DFE – Certified Digital Forensic Examiner
Course Description The Certified Digital Forensics Examiner, C)DFE certification is …
C)CSO – Certified Cloud Security Officer
Course Description Mile2’s Cloud Security Officer, C)CSO, course will provide …
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
Free
Implementing A SQL Data Warehouse
Course Description This course provides students with the knowledge and …
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
Featured
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
