SQL Server

SQL Server Reporting Services (SSRS

What is the Terminology involved in SSRS, SSRS Architecture and how to configure
SSRS?
What is Shared Data source and How to Create an Ad-hoc Report from Wizard.
Creating Expressions and Conditional Formatting.
· How to Calculate Total and Percentage and how to create Drill-Down reports.
· Creating Report Parameter and Debugging Parameter issues.
· How to create a Basic Matrix Report, Tablix Report and Charts.
· How to Create a Standard and Data-driven Subscription and managing subscriptions.
· Managing Reports, Security and how to use Web-based Report Manager

Introduction to Data Warehousing, OLTP, OLAP, Star Schema and Snow Flake
schema. etc.

How to do Slice and Dice in the Cube.
How to retrieve the data in Cube i.e. Through MDX.
Full Coverage of MDX and its functions from Basics to Advanced.
What is Role and How to give Cube access to a Login.
Different Options for Deploying a Cube.
How to take Cube backup and how to synchronize the cube from one server to
another server and how to do that with XMLA query
How to take the report from Cube in Excel and Power Pivot.

Introduction to SSIS Packages and Legacy DTS Packages
Introduction of (BIDS) and Explanation of All tool boxes, Solution Explorer, Package
variables
Import and Export Wizard, Control Flow and Dataflow tasks
· Control Flow tasks like Execute SQL Task, BULK insert tasks, File System tasks , The
FTP Task and Send mail task
Dataflow tasks and transformations introduction
Data sources, Data transformations, Copy column Transformation, Derived Column
transformation, Conditional Split and Aggregate Transformation, Sort
Transformation and Data Viewers.
Slowly Changing Dimension (SCD) Concepts and its Transformations.
Debugging, Error Handling and Logging
How to implement Check points.
SSIS Package Deployment and Package Management like how to schedule package,
DTUtil and DTExec command.

1. Learn Database models
2. Overview of SQL Server Management Studio and Transact-SQL language
3. Master writing simple and complex queries that retrieve data from the database
4. Calculate information across result sets using aggregate queries (sum, min, max, avg, etc.)
5. Insert, update, and delete data
6. Retrieve data from tables
7. Joins
8. Sub -queries
9. Working with Data Types
10. Procedure and Functions4

11. Understand the different Views
12. Working with Triggers
13. Design a database
14. Maintain databases, tables, and sequences with SQL statements
15. Create and manage views
16. Ensure the integrity of multiple, related database updates by using transactions
17. Retrieve data using cursors