Module -I RELATIONAL DATABASE BASICS
- Introductions to Database, RDBMS,
- SQL, Tables, Constraints, Views,
- Stored Procedures, SQL Server Data types, NULL data
- Scripts and Management Studio.
Module-II AN INTRODUCTION OF THE T-SQL
- Selecting and Sorting, Database Manipulation language,
- Database Definition Language, Calculated Fields,
- Aggregate Functions and Grouping,
- Built-in Data Manipulation Functions..
Module-III T-SQL
- Sub queries, Joins, and Unions,,
- Database Control Language (DCL),
- How to Declare Variables, Working with Variables
- Variables as Object Names, System Variables..
Module-IV VIEWS, LOCKS AND PERFORMANCE TUNING WITH INDEXES
- Views in MS Transact-SQL, Types of Indexes, Utilizing Indexes,
- Creation of Indexes, Graphical Exec Plan / Profiler, Transactions,
- Type of Locks, Behavior of Locks, Deadlock.
Module-V STORED PROCEDURES, FUNCTIONS
- Creating A Stored Procedure, Using Input and Output Variables
- Extended Stored Procedures.
- Type of Locks, Behavior of Locks, Deadlock.
- User Defined Functions, Scalar UDF, Multi-Statement UDF.
Module-VI TRIGGERS AND CURSORS
- The Creation of a Trigger, The Mechanics of Triggers
- Nesting and Recursive Triggers and interview Question
- Answer discussion, Mock Interview.
Basics of Power BI
Module 1: Introduction to Power BI
- Get Started with Power BI,
- Overview: Power BI concepts,
- Sign up for Power BI
- Connect to a SaaS solution
- Upload a local CSV file
- Connect to Excel data that can be refreshed
- Connect to a sample
- Create a Report with Visualizations
- Explore the Power BI portal
Module 2: Viz and Tiles
- Overview: Visualizations
- Using visualizations
- Create a new report
- Create and arrange visualizations
- Format a visualization
- Create chart visualizations
- Use text, map, and gauge visualizations and save a report
- Use a slicer to filter visualizations
- Sort, copy, and paste visualizations
- Download and use a custom visual from the gallery
Module 3: Publishing Workbooks and Workspace
- Share Data with Colleagues and Others
- Publish a report to the web
- Manage published reports
- Share a dashboard
- Create an app workspace and add users
- Use an app workspace
- Publish an app
Register Here
Your Queries