Start Date | Batch Name | Timings | Days | Duration | Mode | Amount | Slots Available | Cart |
---|---|---|---|---|---|---|---|---|
Nov 19,2018 | Nov 2018 | 07:00 PM - 08:00 PM (PST) | Monday - Friday | 6 Weeks | Online (Instructor Led) | 25 |
In this Course, you'll be introduced to features and technologies for implementing a database beyond the basics. You will learn about the Microsoft SQL server, which is a relational database management system developed to store and retrieve data requested by other software applications.
You will learn about database development basics, programmatic database objects, in-memory databases, and transactions.
Control Flow Tasks
Precedence Constraints
Control Flow Containers
Control Flow Tasks
Precedence Constraints
Control Flow Containers
Data Flow Sources & Destinations
Data Flow Transformations
Data Flow Pipeline
Data Flow Sources & Destinations
Data Flow Transformations
Data Flow Pipeline
Overview of Integration Services Logging
Implementing Logging
Overview of Integration Services Logging
Implementing Logging
Debugging a Package
Implementing Error Handling
Deploying Packages
Managing Packages
Securing Packages
Scheduling a Package
OLTP, DWH
OLAP TYPES
Dimension Tables
Fact tables
Dimensions
Measure Groups
Creating simple calculations
Aggregations and Hierarchies
Dimension Relationships
Translations
Perspectives
Implementing KPI
Implementing Actions
Applying Security Roles
Levels of Security
Partitioning
Deployment and Scheduling