MCSA: SQL Server 2012/2014 (Online Courses)
Elevate your career trajectory with our premier online course, designed to sharpen your competitive edge. Explore our curated selection of top-tier digital programs to hone your skills and propel your professional journey forward. Experience transformative learning tailored to empower your career advancement in today's dynamic landscape.
Price on Request
Start Learning
This Course Includes
-
20 hours 5 minutesof self-paced video lessons -
19 Programscrafting your path to success -
Completion Certificateawarded on course completion
Auditing, Logging, & Event Handling
Price on Request
45 minutes
SQL Server Integration Services (SSIS) and SQL Server Data Tools (SSDT) both offer tools and techniques to monitor and optimize SSIS solutions. Discover how to implement auditing, logging, and event handling in SSIS.
Perks of Course
Certificate: Yes
CPD Points: 46
Compliance Standards: AICC
Connection Managers & Data Sources
Price on Request
1 hour 10 minutes
Connection managers in a data warehouse are used to define the data source connections. Discover how to use connection managers to specify source and destinations, as well as how to create custom data sources.
Perks of Course
Certificate: Yes
CPD Points: 69
Compliance Standards: AICC
Data Flow Implementation & ETL
Price on Request
1 hour
Extract, transform, load (ETL), is the main process in data warehousing solutions and helps transfer data from one source to another. During this course you will examine the ETL process and how it can be implemented. You will start by examining data flows and how to debug them. Next, you will learn how to use SQL Server Integration Services (SSIS), and perform a broad range of data migration tasks. These include how to create SSIS packages, transform data, and perform lookup tasks. Next you will employ ETL, the SSIS data warehousing tool, to facilitate the transfer of data from a source to a destination. Discover how to implement the ETL process, to extract, transform, and load data. Specify a data source and a destination. Finally, you will performance tune SSIS data flow and optimize data Integration Services.
Perks of Course
Certificate: Yes
CPD Points: 62
Compliance Standards: AICC
Data Loading
Price on Request
55 minutes
SQL Server Integration Services (SSIS) is an extensible platform for creating data integration and workflow solutions. Explore various options available for loading data, including incremental, full, and bulk load.
Perks of Course
Certificate: Yes
CPD Points: 56
Compliance Standards: AICC
Data Quality Projects
Price on Request
45 minutes
When creating a data warehouse, data quality should be one of your top priorities. In order to trust the results of data analysis, high-quality data is essential. Explore various strategies for creating data quality projects.
Perks of Course
Certificate: Yes
CPD Points: 46
Compliance Standards: AICC
Data Quality Services (DQS) & Master Data Services (MDS)
Price on Request
1 hour 10 minutes
DQS can help identify duplicate or invalid data entries while automatically correcting them. MDS enables data validation and rules to ensure consistency in your data. Discover how to install and use both of these technologies.
Perks of Course
Certificate: Yes
CPD Points: 70
Compliance Standards: AICC
Data Transformation & Flow
Price on Request
1 hour
When working with data in a data warehouse, some level of transformation is usually required between the source and destination. Learn how to work with transformations and design data flow.
Perks of Course
Certificate: Yes
CPD Points: 59
Compliance Standards: AICC
Designing & Implementing Dimensions
Price on Request
1 hour 5 minutes
A data warehouse combines data from multiple sources that can be used to create analytical reports. Explore schemas and tables that are created within it, and how to create dimension and fact tables.
Perks of Course
Certificate: Yes
CPD Points: 63
Compliance Standards: AICC
Designing a Fact Table
Price on Request
1 hour 30 minutes
Each data warehouse consists of at least one fact table, which contains fundamental measurements of the business. Explore the implementation of fact tables using partitions, data compression, and columnstore indexes.
Perks of Course
Certificate: Yes
CPD Points: 62
Compliance Standards: AICC
Designing Control Flow
Price on Request
1 hour
Control flow consists of three elements: containers, tasks, and precedence constraints, which can be used to provide structure, functionality, and order of operations. Examine how to design control flow elements in SSIS.
Perks of Course
Certificate: Yes
CPD Points: 59
Compliance Standards: AICC
Implementing Control Flow
Price on Request
1 hour 10 minutes
By using the control flow data flow task, data flow can be implemented into the SSIS package specifying the data source, data transformation, and data destination. Discover how to implement control flow elements.
Perks of Course
Certificate: Yes
CPD Points: 68
Compliance Standards: AICC
Script Components
Price on Request
40 minutes
SQL Server Integration Services (SSIS) provides the ability to create custom components if the integrated components do not suit your specific needs. Learn how to develop and install custom components and implement script tasks.
Perks of Course
Certificate: Yes
CPD Points: 41
Compliance Standards: AICC
SSIS Components
Price on Request
1 hour 35 minutes
SQL Server Integration Services (SSIS) can be installed during the SQL Server installation or as a separate component. Examine the various components of SSIS, as well as installation considerations, such as upgrade options and architecture.
Perks of Course
Certificate: Yes
CPD Points: 93
Compliance Standards: AICC
SSIS Package Execution & Script Tasks
Price on Request
1 hour 30 minutes
Microsoft SQL Server Integration Services (SSIS) is a platform that can be used to build packages for data warehousing. Discover how to create simple SSIS packages and use script tasks.
Perks of Course
Certificate: Yes
CPD Points: 74
Compliance Standards: AICC
SSIS Packages
Price on Request
1 hour 35 minutes
SSIS in SQL Server 2014 allows for dynamic packages, enabling values within the package to be manually set, depending on your requirements at execution time. Discover what's involved in designing SSIS packages.
Perks of Course
Certificate: Yes
CPD Points: 96
Compliance Standards: AICC
SSIS Security
Price on Request
1 hour
SSIS consists of several layers, including digital signatures and database roles, to provide a rich and flexible security environment. Examine techniques and recommendations on how to secure an SSIS deployment.
Perks of Course
Certificate: Yes
CPD Points: 58
Compliance Standards: AICC
SSIS Solutions
Price on Request
45 minutes
SSIS consists of several layers, including package properties and centralized management, to provide a rich and flexible environment. Explore SSIS catalog creation, package deployment, and package validation.
Perks of Course
Certificate: Yes
CPD Points: 45
Compliance Standards: AICC
SSIS Variables
Price on Request
35 minutes
SQL Server 2014 allows for the use of parameters, variables, and expressions to create dynamic packages. Examine SSIS variable concepts, such as system variables, scope, parameterization of properties, and data types.
Perks of Course
Certificate: Yes
CPD Points: 36
Compliance Standards: AICC
Troubleshooting Data Integration
Price on Request
55 minutes
SSIS includes tools and features that can be used to troubleshoot data integration. Learn how to debug and troubleshoot packages at the design and production level using techniques such as data viewers and break points.
Perks of Course
Certificate: Yes
CPD Points: 54
Compliance Standards: AICC