Introduction to RDBMS and Microsoft SQL server

Creating table, database, importing and Exporting data

Constraints and data type

Select statement and working with shorting and filtering data

Working with multiple tables using join concept

Using DML and modify data

Using built in function

Using subqueries concept and table expressions

Using set operators and windows ranking, and aggregate functions

Programming with T-SQL and stored procedure

Working with user defined function

Applying error handling concept in T-SQL programming

Concept of cursor and index

Performance tuning

Introduction to Power BI

Data loading

Data transformation – Split columns, remove duplicate, replace value and change data type

Data transformation – pivot and unpivot, append and join merge queries, parameters.

Data modeling- Data modeling techniques &relationship.

Data modeling – Hierarchy creation, formatting & data category , grouping.

Data visualization – visualization type, custom visualization ,visualization report creation.

Data visualization – bookmarks , spotlight, additional features .

Service – publishing & deploying report , creating dashboard

Service – export options ,excel integration, power bi mobile service ,admin roles.

Dax—data type, aggregated functions, relate functions, table function, format function, logical function .

Dax date and time intelligence

Project

Introduction to python

Starting with variables, comments & data type.

Operator and i/o function

if condition and decision making

Loop concept

Functions( pre defined, user defined and Lambda function)

Deep dive in data types or data structure

Debugging and error handling

Make http request

Object oriented programming

OPPS exercise ( class method and class attributes , inheritance, polymorphism )

Iterators and generators Decorators(Decorators with different signature, building speed test decorators)

Python testing (Assertion, doctest , unit test)

File input and output (working with text file, csv file)

Web scraping with beautiful soup

Regular expression(writing Regix, Regix quantifiers)

Python + SQL ( installing My SQL, inserting with python, fetching data in python from My SQL)

Take away from the training (projects)