SQL Server Development

• SQL Server database Overview
• What is DDL, DML
• Data Types
• What are Constraints (Identity, Unique, Check, NULL, Default)
• Operators
• Aggregates
• Where
• Group by
• Having
• Distinct, Top
• Date functions
• Temp tables
• Table Variables
• Usage of While loop & if conditions
• Case Statement
• Ranking Functions
• Scalar Functions
• Exception handling
• Transactions
• Joins
• Sub Queries
• Views
• CTE
• Cursor
• Stored Procedures
• User Defined Functions (String, Table value: inline Functions and multi value)
• Triggers

SSIS (SQL Server Integration Services)

• SSIS Introductions
• Control Flow
• Data Flow
• Precedence constraint & Expressions
• Sequence Container
• Annotation
• Data Flow Components
• Data viewer
• Copy
• OLEDB Source
• OLDB Destination
• Audit
• Character Map
• Conditional Split
• Row sampling
• Percentage sampling
• Multicast
• Data conversion / Type Cast
• Sort
• Merge
• Union all
• Aggregate
• Derived
• RowCount
• BreakPoints
• Merge join
• Flat File Destination
• Excel Destination
• OLEDB Command
• Cache transformation (target is cashed)
• Lookup
• SCD (type 1, type 2)
• Excel Source
• Flat File Source
• Control Flow Components
• Sequence Containers
• For loop
• For each loop
• Variables with default values
• Variables with dynamic values through Expressions
• Dynamic loading of Excel files into SQL target
• FTP Task
• Execute SQL Task – Basic
• Execute SQL task with parameter and with result
• Breakpoints
• Script task
• Bulk Insert Task ( sending FF – SQL)
• Execute package
• Execute process
• ERROR Output in DF
• File system Task
• Send Mail Task
• Logging
• Checkpoints (restart ability)
• Jobs (Scheduling)
• Deployment
• Configurations

Real-time Project related to Image and Capture Work stream with Banking Domain which implement  real time Working Framework with ERROR Handling

SSRS (SQL Server Reporting Services)

• Introduction to SSRS
• Architecture of SSRS
• What is Report Server
• What is Report Manager
• Creating reports using BIDS
• What are Data sources
• What are Shared Data sources
• Types of Reports (Table and Matrix)
• FOTTER
• HEADERS AND EXPRESSIONS.
• Parameterized report
• Multi-valued Parameterized Reports
• Page break concept
• Drill Down report
• Report Wizard / Adhock Report /Ad-Hock Report / Wizards
• Cascading report — Parameter Dependency
• Drill through Report / hyperlink report / jump report / navigation report / go to report/ Action report
• Chart report and its properties & expressions
• Sub report
• List Report with Image
• Rectangle Report
• Indicators
• Gauge
• Deployment
• Report Subscription (Email and Windows File Share) and Scheduling
• Report Manager Operations
• Edit Report
• Move / Delete Report
• Linked Report
• Cashed / Execution Report
• Snap short and History comes under this report

SSAS (SQL Server Analysis Server)

• Introduction to SSAS
• Schemas
• Star Schema
• Snowflake Schema
• Data source
• Data source views
• Options in DSV
• Dimension
• Measures
• Cube Creation
• Build
• Deploy
• Process
• How to Brows the CUBE
• Types Of Relationships inside CUBE
• No relationship
• Regular Relationship
• Fact Relation
• Referenced Relationship
• Many to Many
• None
• Hierarchies
• What are KPI’s and How to Create KPI’s in SSAS
• What are Perspective and how to create
• What are Partitions
• What are Translations
• What are Actions
• What are Calculations
• Aggregations
• Storage design – ROLAP, MOLAP , HOLAP
• How to use Cube in Excel
• MDX in Report