Training Description
This training course covers the training for Python Language. This includes fundamentals, OOPS, File handling, Exception handling and multithreading using Python. After finishing this training you will be ready for develop advanced applications like Web based or Data Science or Machine learning.
Course Content
- DML & DDL statements in SQL
- SQL Data Types
- Common function & Analytics functions in SQL
- Selecting single column
- Selecting multiple columns
- Select Distinct
- Select Top
- Learning count
- Arithmetic Operators
- Aliasing
- Arithmetic operations on data – Concatenation
- Data manipulations using built in functions
- Date Functions
- Operators used for filtering
- Filtering of numerical
- Filtering of text values
- Filtering of date values
- Data cleanup by handling NULLs
- Aggregate Functions
- Combining aggregate functions with where clause
- Elimination of duplicate records
- Sorting the data- Order By
- Groups records into summary rows – Group By
- Filter data after aggregates – HAVING
- Types of Joins
- Sorting and grouping multiple tables
- Aggregating data from multiple tables
- Writing sub-queries in SQL
- RANK
- DENSE_RANK
- NTILE
- ROW_NUMBER
- What is T-SQL?
- Comparison between SQL and T-SQL?
- T-SQL Keywords
- Programming constructs
- Variables and Data-types
- Control statement- (if else)
- Looping Statement-(While)
- Introduction to Cursors
- Cursors storing data from multiple columns
- Cursors storing data from views
- Introduction to Functions
- Types of functions?
- User defined Scalar function
- Table valued functions
- Introduction to Stored Procedures
- Calling functions from procedures
- Passing table parameter to stored procedures
- For operation triggers (For-Insert, For Update, For Delete)
- Instead of operation triggers (Instead of Insert, Instead of Update, Instead of Delete)
- Using Exists function
- Using RowCount variable
- Using Merge function
- What are Errors?
- Error Types
- Error Handling using Try-Catch
- Introduction to MSBI
- What is SSRS?
- Why do we need SSRS?
- How SSRS works?
- Introduction to SQL Server Data Tools
- Creating new project
- Solution Explorer
- What is Data source and Data set?
- Creating new report
- Report Data Window
- Creating Data Source
- Creating Data Set
- List of Report Items
- Create New Table Report
- Add Text Box to Report
- Rectangle in a Report
- Create a List Report
- Display Image in Report
- Changing Font and Background Color of a Text Box
- Format Numbers in a Text Box
- Format Date and Time in a Report
- Global references in SSRS
- Repeat Column Headers on Each Page
- Column Headers Visible While Scrolling
- Add, or Remove Headers and Footers on Reports
- Page number
- Filtering at Tablix Level
- Filtering at Dataset Level
- Sorting Data at Tablix Level
- Interactive Sorting
- Simple Expressions
- Complex Expressions
- Add Row Numbers to Report
- Add Alternative Row Color to Report
- Conditional Formatting
- CStr function
- Add totals
- Add calculated fields
- Add Parent Groups
- Add Child Groups
- Add total and Subtotal in grouping
- Create new Matrix Report
- Add Row Groups and Column Groups
- Add Total and Subtotal in Matrix Report
- Simple drill down report
- Drill down matrix report
- Multiple drill down matrix report
- Type in text Parameter
- Drop Down List Parameter
- Drop down List Parameter with user friendly labels
- Drop down List Parameter with default value parameter
- Multiple Parameters
- Multi-value Parameters
- Cascaded Parameters
- Linked Report
- Sub Report
- Drill through Report
- Go to URL Action
- Dashboards
- Two table two queries
- Two table one query
- Dynamic Conditional Formatting
- Visibility Control
- Report using Stored Procedure
- Report using Parameterized Stored Procedure
- Charts Introduction
- Column Chart
- Pie Chart
- Data Bars
- Indicators
- Linear Gauges
- Radial Gauges
- Sparkline
- SQL Server Reporting Services Configuration Manager
- Report Deployment