Database development

Core Database Concepts, Creating Database Objects, Manipulating Data, Data Modeling and Normalization.

Business Intelligence(BI)

Automating complex data integration tasks and building error handling methods for data integration. You will learn to develop workflows to extract, transform and load data from heterogeneous data sources such as text files, Excel, Share point list, and OLE DB — and effectively and securely managing data integration across various platforms.

Database Administration (DBA)

Database administration tasks such as installation of SQL server instances, the configuration of SQL server databases and setting, monitoring database performance, controlling user access to databases, and database maintenance.

Power BI

Power BI Desktop, Multi-page reports, visualization, data modeling, custom tooltips, advanced navigation, and DAX   ex[resson. you will also learn power BI Server including Creating workspace, publishing reports to workspace, and managing workspace.

Transactional Database Modeling

Designing and implementing data model for transactional database system.

Dimensional Modeling and DW

Designing and implementing dimensional DW for data analytics and reporting

Data Visualization, Reporting and analysis

Developing and Publishing reports, Dashboards, and Data cubes.

Reviewing resume and mock interviews

Reviewing resumes, providing resume templates, and conducting mock interviews

Building Protfolio

Professional Portfolio based on real-world porjects.

Industry Served