Microsoft SQL training course is an class training for Microsoft SQL Server and is meant for developers to help them master the descriptive learning language on database concepts for working for relational databases. The important topics included in this course are SQL introduction, relational databases, queries, Sub-queries, joins and unions. You will gain considerable proficiency in the theory of optimization, indexing, transactions, database administration, installation of SQL server and clustering.
- There are no specific prerequisites for taking this Training Course. Basic knowledge of relational DBMS can help.
The Big Picture
- Microsoft Business Intelligence Suite
- The SSIS Architecture
- Import/Export Wizard
- Introducing SSDT-BI
Control Flow
- Introduction to the Control Flow
- Understanding Precedent Constraints
- Grouping and Annotating Tasks
- Working with Properties
- Common Tasks
- Favourite Tasks
Basics of SSIS
- Getting Started
- Performing Basic Tasks
- Basic Transformations
- Variables
- Data Types and Data Conversion
- Expressions
- Conditional split and derived column transform
- Debugging
- Lookup Transforms
- Sequence Containers and FOR Loops
- Looping Over Files
- Other Foreach Loops
- Script Tasks using C#
- Script Tasks using Visual Basic
- Script Components
- Expression and Other Constraints
- Event-handling and logging
- Error handling
- Parameters and deployment
Data Flow Sources and Destinations
- Working with Data Sources
- Working with Data Destinations
Data Flow Transformations
- Basic Transformations
- Blocking Transformations
- Advanced Transformations
- Managing Incremental Updates
Making packages dynamic
- Using Variables
- Understanding Package Parameters
- Understanding Project Parameters
- Working with Expressions
Containers and Advanced Control Flow Tasks
- Working with Containers
- Adding Custom Control Flow Tasks
- The “Other Tasks”
- Instructor Demonstration of “Other Tasks”
- Working with Change Data Capture (CDC)
Package Reliability
- Configuring Logging
- Creating Event Handlers
- Redirecting Rows
- Using Checkpoints
- Configuring Transactions
Advanced Scripting
- General SSIS Programming Overview
- Creating Custom Event Handlers
- Writing Custom Transformations
- Advanced Script Tasks
Deploying to SSIS Catalog
- Introduction to the SSIS Catalog
- Creating Environments
- Deploying Projects
- Backwards Compatibility
- Executing Packages in SQL Server Management Studio (SSMS)
- Executing Packages from the Command Line
Working with Data Quality Services
- Installing and Configuring DQS
- Building a DQS Knowledge Base and Domains
- Using the DQS Cleansing Transformation
- Reviewing DQS Output
SSAS: Designing Cubes for Analysis
- Creating a new project and configuring a Data source for SSAS Cube
- Creating and Understanding the Data Source View
- Creating a Cube by assigning Dimensions, Measures and changing column names
- Deploying and viewing the cube
- Browse the cube before Deployment
- Gathering required columns and renaming them
- Creating Named calculated columns
- Named Column-Getting underlying data of a key
- Grouping dimensions into logical categories
- Creating a Hierarchy
SSRS: Understanding report creation, management and deployment
- What is SSRS?
- Life Cycle of a Report
- Getting started and looking at the Reporting Services interface
- Connecting to a Data Source using Embedded Connection
- Understand and prepare each project story
- Resume Preparation
- Mock Interview Session
- Final Resume Review
- Canadian Job Market Guidance
- Develop Key Strategies to Get the First Break in Business Analyst Role
- BA Best Practice
- Certification Discussion
Projects
- GCMD Requirements Documentation
- ALL Outstanding FX Deals
- Daily Income Report Trading
- Foreign Exchange Subsystem
- Full Precision Revaluation
- Fx Cash Management
- Fx Back Office Deals Transactions
- Unrealised profit and loss