Python Classroom Training

Python uses dynamic typing, and a combination of reference counting and a cycle-detecting garbage collector for memory management. It also features dynamic name resolution (late binding), which binds method and variable names during program execution. Register Today

Python Training Plans

Description PLAN A PLAN B
Python Python with Power BI
Duration 4 Weeks 8 Weeks
Real-Time Project Check-Symbol-for-Yes Check-Symbol-for-Yes
Resume Support Check-Symbol-for-Yes Check-Symbol-for-Yes
Mock Interviews Check-Symbol-for-Yes Check-Symbol-for-Yes
Placement Assistance Croos-symbol-for-Yes Croos-symbol-for-Yes
Python Croos-symbol-for-No Check-Symbol-for-Yes
Power BI Croos-symbol-for-No Check-Symbol-for-Yes
Total Course Fee INR 4,000/- INR 10,000/-

Trainer - Mr. Sekhar (15+ Years of Exp)

Timings Demo Date Start Date  
Schedules for Python Training
9:15 AM to 10:15 AM Aug 13th Aug 14th Register
6 PM - 7 PM Aug 8th Aug 9th Register
11 AM to 1:30 PM (Wknd) July 28th July 29th Register
Schedules for Power BI Training
9 AM - 10 AM Aug 6th Aug 7th Register
11:30 - 12:30 AM July 17th July 18th Register
6:15 PM - 7:30 PM July 30th July 31st Register
7 AM - 9:30 AM (Weekend) July 21st July 21st Register
9:30 AM - 11 AM (Weekend) July 28th July 29th Register
 

Python Training Course Contents:

Module I - Core Phython

Module II - Advanced Phython

CHAPTER 1 : Introduction to Script

  • What is Script
  • What is a program?
  • Types of Scripts
  • Difference between Script & Programming Languages
  • Features of Scripting
  • Limitation of Scripting
  • Types of programming Language Paradigms

CHAPTER 2 : Introduction to Python

  • What is Python?
  • Why Python?
  • Who Uses Python?
  • Characteristics of Python
  • History of Python
  • What is PSF?
  • Python Versions
  • How to Download Python
  • How to Install Python
  • Install Python with Diff IDEs
  • Features of Python
  • Limitations of Python
  • Python Applications
  • Creating Your First Python Program
  • Printing to the Screen
  • Reading Keyboard Input
  • Using Command Prompt and GUI or IDE
  • Python Distributions

CHAPTER 3 : Different Modes in PYTHON

  • Execute the Script
  • Interactive Mode
  • Script Mode
  • Python File Extensions
  • SETTING PATH IN Windows
  • Clear screen inside python
  • Learn Python Main Function
  • Python Comments
  • Quit the Python Shell
  • Shell as a Simple Calculator
  • Order of operations
  • Multiline Statements
  • Quotations in Python
  • Python Path Testing
  • Joining two lines
  • Python Implementation Alternatives
  • Python Sub Packages
  • Uses of Python in Data Science
  • USES OF PYTHON IN IOT
  • Working with Python in Unix/Linux/Windows/Mac/Android..!!

CHAPTER 4 : PYTHON NEW IDEs

  • PyCharm IDE
  • How to Work on PyCharm
  • PyCharm Components
  • Debugging process in PyCharm
  • PYTHON Install Anaconda
  • What is Anaconda?
  • Coding Environments
  • Spyder Components
  • General Spyder Features
  • Spyder Shortcut Keys
  • Jupyter Notebook
  • What is Conda?
  • Conda List?
  • Jupyter and Kernels
  • What is PIP?

CHAPTER 5 : Variables in Python

  • What is Variable?
  • Variables in Python
  • Constants in Python
  • Variable and Value
  • Variable names
  • Mnemonic Variable Names
  • Values and Types
  • What Does “Type” Mean?
  • Multiple Assignment
  • Python different numerical types
  • Standard Data Types
  • Operators and Operands
  • Order of Operations
  • Swap variables
  • Python Mathematics
  • Type Conversion
  • Mutable Versus Immutable Objects

CHAPTER 6 : String Handling

  • What is string?
  • String operations
  • String indices
  • Basic String Operations
  • String Functions, Methods
  • Delete a string
  • String Multiplication and concatenation
  • Python Keywords
  • Python Identifiers
  • Python Literals
  • String Formatting Operator
  • Structuring with indentation in Python
  • Built-in String Methods
  • Define Data Structure?
  • Data Structures in PYTHON

CHAPTER 7: Python Operators and Operands

  • Arithmetic Operators
  • Relational Operators
  • Comparison Operators
  • Python Assignment Operators
  • Short hand Assignment Operators
  • Logical Operators or Bitwise Operators
  • Membership Operators
  • Identity Operators
  • Operator precedence
  • Evaluating Expressions

CHAPTER 8 : Python Conditional Statements

  • How to use “if condition” in conditional structures
  • if statement (One-Way Decisions)
  • if .. else statement (Two-way Decisions)
  • How to use “else condition”
  • if .. elif .. else statement (Multi-way)
  • When “else condition” does not work
  • How to use “elif” condition
  • How to execute conditional statement with minimal code
  • Nested IF Statement

CHAPTER 9 : Python LOOPS

  • How to use “While Loop”
  • How to use “For Loop”
  • How to use For Loop for set of other things besides numbers
  • Break statements in For Loop
  • Continue statement in For Loop
  • Enumerate function for For Loop
  • Practical Example
  • How to use for loop to repeat the same statement over and again
  • Break, continue statements

CHAPTER 10 : Learning Python Strings

  • Accessing Values in Strings
  • Various String Operators
  • Some more examples
  • Python String replace() Method
  • Changing upper and lower case strings
  • Using “join” function for the string
  • Reversing String
  • Split Strings

CHAPTER 11 : Sequence or Collections in PYTHON

  • Strings
  • Unicode Strings
  • Lists
  • Tuples
  • buffers
  • xrange

CHAPTER 12 : Python Lists

  • Lists are mutable
  • Getting to Lists
  • List indices
  • Traversing a list
  • List operations
  • List slices
  • List methods
  • Map, filter and reduce
  • Deleting elements
  • Lists and strings

CHAPTER 13 : Python TUPLE

  • Advantages of Tuple over List
  • Packing and Unpacking
  • Comparing tuples
  • Creating nested tuple
  • Using tuples as keys in dictionaries
  • Deleting Tuples
  • Slicing of Tuple
  • Tuple Membership Test
  • Built-in functions with Tuple
  • Dotted Charts

CHAPTER 14 : Python Sets

  • How to create a set?
  • Iteration Over Sets
  • Python Set Methods
  • Python Set Operations
  • Union of sets
  • Built-in Functions with Set
  • Python Frozenset

CHAPTER 15 : Python Dictionary

  • How to create a dictionary?
  • PYTHON HASHING?
  • Python Dictionary Methods
  • Copying dictionary
  • Updating Dictionary
  • Delete Keys from the dictionary
  • Dictionary items() Method
  • Sorting the Dictionary
  • Python Dictionary in-built Functions
  • Dictionary len() Method
  • Variable Types
  • Python List cmp() Method
  • Dictionary Str(dict)

CHAPTER 16 : Python Functions

  • What is a function?
  • How to define and call a function in Python
  • Types of Functions
  • Significance of Indentation (Space) in Python
  • How Function Return Value?
  • Types of Arguments in Functions
  • Default Arguments
  • Non-Default Arguments
  • Keyword Arguments
  • Non-keyword Arguments
  • Arbitrary Arguments
  • Rules to define a function in Python
  • Various Forms of Function Arguments
  • Scope and Lifetime of variables
  • Nested Functions
  • Call By Value, Call by Reference
  • Anonymous Functions/Lambda functions
  • Passing functions to function
  • map(), filter(), reduce() functions
  • What is a Docstring?

CHAPTER 17 : Python Modules

  • What is a Module?
  • Types of Modules
  • The import Statement
  • The from…import Statement
  • ..import * Statement
  • Underscores in Python
  • The dir( ) Function
  • Creating User defined Modules
  • Command line Arguments
  • Python Module Search Path

CHAPTER 18 : Packages in Python

  • What is a Package?
  • Introduction to Packages?
  • py file
  • Importing module from a package
  • Creating a Package
  • Creating Sub Package
  • Importing from Sub-Packages
  • Popular Python Packages

CHAPTER 19 : Python Date and Time

  • How to Use Date & DateTime Class
  • How to Format Time Output
  • How to use Timedelta Objects
  • Calendar in Python
  • datetime classes in Python
  • How to Format Time Output?
  • The Time Module
  • Python Calendar Module
  • Python Text Calendar
  • Python HTML Calendar Class
  • Unix Date and Time Commands

CHAPTER 20 : File Handling

  • What is a data, Information File?
  • File Objects
  • File Different Modes
  • file Object Attributes
  • How to create a Text File
  • How to Append Data to a File
  • How to Read a File
  • Closing a file
  • Read, read line ,read lines, write, write lines…!!
  • Renaming and Deleting Files
  • Directories in Python
  • Working with CSV files
  • Working with CSV Module
  • Handling IO Exceptions

CHAPTER 21 : Python OS Module

  • Shell Script Commands
  • Various OS operations in Python
  • Python File System Shell Methods

CHAPTER 22 : Python Exception Handling

  • Python Errors
  • Common RunTime Errors in PYTHON
  • Abnormal termination
  • Chain of importance Of Exception
  • Exception Handling
  • Try … Except
  • Try .. Except .. else
  • Try … finally
  • Argument of an Exception
  • Python Custom Exceptions
  • Ignore Errors
  • Assertions
  • UsingAssertionsEffectively

CHAPTER 23 : More Advanced PYTHON

  • Python Iterators
  • Python Generators
  • Python Closures
  • Python Decorators
  • Python @property

CHAPTER 24 : Python Class and Objects

  • Introduction to OOPs Programming
  • Object Oriented Programming System
  • OOPS Principles
  • Define Classes
  • Creating Objects
  • Class variables and Instance Variables Constructors
  • Basic concept of Object and Classes
  • Access Modifiers
  • How to define Python classes
  • Python Namespace
  • Self-variable in python
  • Garbage Collection
  • What is Inheritance? Types of Inheritance?
  • How Inheritance works?
  • Python Multiple Inheritance
  • Overloading and Over Riding
  • Polymorphism
  • Abstraction
  • Encapsulation
  • Built-In Class Attributes

CHAPTER 25 : Python Regular Expressions

  • What is Regular Expression?
  • Regular Expression Syntax
  • Understanding Regular Expressions
  • Regular Expression Patterns
  • Literal characters
  • Repetition Cases
  • Example of w+ and ^ Expression
  • Example of \s expression in re.split function
  • Using regular expression methods
  • Using re.match()
  • Finding Pattern in Text (re.search())
  • Using re.findall for text
  • Python Flags
  • Methods of Regular Expressions

CHAPTER 26 : Python XML Parser

  • What is XML?
  • Difference between XML and HTML
  • Difference between XML and JSON and Gson
  • How to Parse XML
  • How to Create XML Node
  • Python vs JAVA
  • XML and HTML

CHAPTER 27 : Python-Data Base Communication

  • What is Database? Types of Databases?
  • What is DBMS?
  • What is RDBMS?
  • What is Big Data? Types of data?
  • Oracle
  • MySQL
  • SQL server
  • DB2
  • Postgre SQL
  • Executing the Queries
  • Bind Variables
  • Installing of Oracle Python Modules
  • Executing DML Operations..!!

CHAPTER 28 : Multi-Threading

  • What is Multi-Threading
  • Threading Module
  • Defining a Thread
  • Thread Synchronization

CHAPTER 29 : Web Scrapping

  • The components of a web page
  • BeautifulSoup
  • Urllib2
  • HTML,CSS,JS,jQuery
  • Dataframes
  • PIP
  • Installing External Modules Using PIP

CHAPTER 30 : Unit Testing with PyUnit

  • What is Testing?
  • Types of Testings and Methods?
  • What is Unit Testing?
  • What is PyUnit?
  • Test scenarios, Test Cases, Test suites

CHAPTER 31 : Introduction to Python Web Frameworks

  • Django – Design
  • Advantages of Django
  • MVC and MVT
  • Installing Django
  • Designing Web Pages
  • HTML5, CSS3, AngularJS
  • PYTHON Flask
  • PYTHON Bottle
  • PYTHON Pyramid
  • PYTHON Falcon

CHAPTER 32 : GUI Programming-Tkinter

  • Introduction
  • Components and Events
  • Adding Controls
  • Entry Widget, Text Widget, Radio Button, Check Button
  • List Boxes, Menus, ComboBox

CHAPTER 33 : Data Analytics

  • Introduction to data Big Data?
  • Introduction to NumPY and SciPY
  • Introduction to Pandas and MatPlotLib

CHAPTER 34 : Introduction to Machine Learning with PYTHON

  • What is Machine learning?
  • Machine Learning Methods
  • Predictive Models
  • Descriptive Models
  • What are the steps used in Machine Learning?
  • What is Deep Learning?

CHAPTER 35 : Data Science

  • What is Data Science?
  • Data Science Life Cycle?
  • What is Data Analysis
  • What is Data Mining
  • Analytics vs Data Science

CHAPTER 36 : Internet of Things

  • IMPACT OF THE INTERNET
  • What is IOT
  • History of IoT
  • What is Network?
  • What is Protocol?
  • What is smart?
  • How IoT Works?
  • The Future of IoT

Power BI Training Course Contents:

Module I: Power BI Basics, Visuals

Module II: ETL and Data Modelling

Module III: Power BI Service (Cloud)

Chapter 1 : Introduction to Power BI

  • Need for Big Data and BI Technologies
  • Purpose of BI & Power BI Suite of Tools
  • Power BI as a Self-Service BI, Scope
  • Comparing Power BI with Microsoft MSBI
  • Comparing Power BI @ Tableu, QlickView
  • Power BI as an End-to-End BI Tool
  • Microsoft Data Platform Technologies
  • Colloboration, Visualization and IOT
  • Power BI with Reporting Services (SSRS)
  • Power BI For Data Scientists, AI Scope
  • Power BI For Business Analysts
  • Power BI Job Roles and Responsibilities
  • Power BI Component :Overview, Lab Plan
  • MCSA Examination for Power BI: 70-778

Chapter 7 : Power Query & M Language - 1

  • Power Query [M Language] - Purpose
  • Power Query Usage & Operation Types
  • Power Query Architecture and Usage
  • QUERY Concept, Properties, Validations
  • Power Query for Data Mashup Operations
  • Basic Data Types, Literals and Values
  • Expressions and Primitives in M Language
  • LIST : Syntax, Examples and Usage
  • RECORD : Syntax, Examples and Usage
  • TABLE : Syntax, Examples and Usage
  • Power Query Connection Formats, Settings
  • let, source & in statements in M Lang
  • Power BI Canvas: Edits, Applied Steps
  • Queries and Applied Steps, Edit Queries

Chapter 13 : Power BI Service (Cloud) - 1

  • Power BI Cloud & Power BI Workspace
  • App Workspace Creation in Real-time
  • Publish Reports from Power BI Desktop
  • Reports and Datasets in Power BI Cloud
  • Pin Visuals and Pin LIVE Report Pages
  • Dashboard Creation and Tiles, Media
  • Images, Web Content, Videos, Q & A
  • Mobile View, Web View, QR Codes, Shares
  • Enabling Interactive Visuals. Embed Codes
  • Report Shares and Dashboard Shares
  • App Publish Options and App Updates
  • Power BI Report Edits in Cloud, Visuals
  • Download PBIX Reports from Cloud
  • Sharepoint Integration, PPTX and Excel

Chapter 2: Power BI Architecture

  • Power BI Architecture - in Detail, Tools
  • Power BI - Integrations in Real-time
  • Need for Power BI Service and Cloud
  • Need for Power BI Report Server, SSDT
  • Power BI Report Server & Report Builder
  • Power BI Mobile Report Publisher Tool
  • Types of Reports in Power BI - Interactive
  • Analytical, Paginated & Mobile Reports
  • Office Online Server & SharePoint Server
  • Content Packs, Cortana - Q&A Features
  • API Integration: LIVE Streaming DataSets
  • Configure Power BI Cloud, Basic Usage
  • Installing Power BI Desktop, Gateways
  • Installing Excel Publisher & Analyzer

Chapter 8 : Power Query & M Language - 2

  • Data Sources with Excel, File Formats
  • Data Sources with Database Connections
  • BLANK Data Sources Creation & Scope
  • Creating LIST, RECORD, TABLE Queries
  • Functions in Power Query and Usage
  • Defining Functions and Invoke Options
  • Mashup Operations in Power Query Editor
  • Row Filters, Column Filters, Renames
  • Promoting Headers and Query Settings
  • MERGE Queries For Combining Queries
  • Inner Join and Left/Right Outer Joins
  • Left Anti Join, Right Anti Join, Full Join
  • UNION All, Group By and Aggregations
  • Close and Apply Options. Data Imports

Chapter 14 : Power BI Service (Cloud) - 2

  • Dashboard Properties and Security
  • Report properties and Security
  • Dataset properties and Security
  • Report Insights, Related Items & Metrics
  • Quick Insights. Publishing App Workspace
  • Power BI LIVE Report Edits, Downloads
  • Content Packs : Creation and Use
  • Organizational and Service Level
  • Content Packs from Azure MarketPlace
  • Gateway Clusters - Installation
  • Personal and Enterprise Gateways
  • NT SERVICE\PBIEgwSERVICE Account
  • Dataset Refresh Options and Schedules
  • Azure Databus Integration, ODG Logs

Chapter 3 : Using Power BI Desktop

  • Install and Configure Power BI Desktop
  • Understanding Power BI Desktop Tool
  • In-Memory, SMDL and Vertipaq Options
  • Visuals, Fields, Pages and Filters
  • Report, Data and Relationship Options
  • Concept & Use of PBIX and PBIT Files
  • Designing Simple / Basics Reports in PBI
  • Get Data from DAT Files, Basic Reports
  • Enter Data from Excel Files, Basic Reports
  • Creating PBIX Files and Re-Use
  • Creating PBIT Files & Data Import Options
  • Database Connections with Power BI
  • Import and DirectQuery - Data Loads
  • Table Reports, Matrix and Chart Reports
  • Interactive Visuals and Focus Mode

Chapter 9 : Power Query & M Language - 3

  • Creating Parameters in Power Query
  • Intrinsic & Query Parameters, Usage
  • Parameter Data Types, Default Value Lists
  • Static Lists, Dynamic Lists For Parameters
  • Reports with Range Values - Bookmarks
  • Parameters with PBIT Reports, Prompts
  • New Queries from Dataset Fields, Usage
  • Removing Duplicate Rows and Columns
  • Column Delimters and Field Formatting
  • Change Type and Transform Operations
  • Replace Values & Errors, Transpose
  • Group By Aggregations, Fill, Reverse Rows
  • Format Options in M Language. Bookmarks
  • Pivot and Unpivot Options in Power Query
  • Data Type Conversions & Format Options

Chapter 15 : Excel with Power BI

  • Using Excel with Power BI Reports
  • Using Excel Analyser in Power BI
  • Using Excel Publisher in Cloud
  • Creating Datasets with Excel, Office 365
  • Excel Uploads & Cloud Imports, Office 365
  • Cell Selection and PINS in Power BI
  • Excel Online Service - Edits and Pins
  • Excel ODC Connections and Real-time Use
  • Excel Power Pivot and Power BI Cloud
  • Excel Drilldowns and Drillthru Reports
  • Create Key Performance : KPI Reports
  • Excel for Big Data Analysis, Reporting
  • Worksheets and Dashboards with Excel
  • Power Pivot Reports in with Excel
  • Power View Report Options in Excel

Chapter 4 : Hierarchies and Filters

  • Creating Hierarchies with Report Fields
  • Data / Drill Options - Auto & Manual
  • Data Explore Options : Spotlight, Focus
  • Expand, Goto Next Level and Drill-up
  • See Data, Export Data, See Records
  • Include and Exclude Options, Multi-Field
  • Filters and Real-time Usage with Power BI
  • Using Report Filters and Page Filters
  • Using Drill-down Filters and Visual Filters
  • Apply and Clear Options with Value Filters
  • Adding Text Box, Images, Buttons Shapes
  • Big Data Access with Power BI

Chapter 10 : Power Query & M Language - 4

  • Data Modeling Options with Power Query
  • Modeling Operations - Custom Columns
  • Query Transforms, Sort Direction, Statistics
  • Enabling / Disabling Loads. ToList Options
  • Creating Parameters & Variables. Functions
  • Date and Time Columns. String Functions
  • Advanced Edit Options, Custom Queries
  • Custom Functions in Power Query M Lang
  • Grouping and Sub Groups with Queries
  • Binning with Groups and Query Formats
  • SubString Functions, Splits (Row, Column)
  • Parsing XML and JSON Files. Formatting

Chapter 16: Power BI Report Server

  • Settings and Power BI Admin Console
  • Configuring Power BI Report Server
  • Report Server Database TempDB Database
  • Webservice URL, Webportal URL - Usage
  • Report Builder Installation & Usage
  • Designing Paginated Reports (RDL), Tests
  • Deploy to Power BI Report Server, Settings
  • Data Source Connections, Report Options
  • Register Power BI Report Server to Cloud
  • Tenant IDs Generation and Real-time Usage
  • Publish RDL Reports to Power BI Cloud
  • Paginated Reports Vs Interactive Reports

Chapter 5 : Power BI Visual Properties - 1

  • Fields, Formats and Analytics Options
  • Table Visuals & Properties, Filters
  • Data Bar and Data Scaling Options
  • Divergent Property, Data Labels
  • Matrix : Sub Totals, Grand Totals
  • Drilldown Options : Row and Column
  • Stacked Bar Chart, Clustered Colum Chart
  • Stacked and Clustered Colum Chart
  • 100% Stacked Bar and Column Charts
  • Area & Stacked Area Chart. Ribbon Chart
  • Waterfall Chart, Scatter Chart, Pie Chart
  • Line, Doughnut TreeMap, Funnel, Gauge
  • DETAILED Properties of Every Visual
  • General, Labels, Values, Legend Options
  • Axis, Title, Markers, Filter Options

Chapter 11 : DAX Functions & Usage - 1

  • DAX : Importance and Real-time Usage
  • DAX Data Types and DAX Calculations
  • Syntax, Functions, Context Options
  • ROW Context and Filter Context in DAX
  • DAX Functions. Aggregates and Usage
  • Creating and Using Measures with DAX
  • Creating and Using Columns with DAX
  • Vertipaq Engine & Special Characters
  • Operators in DAX - Real-time Usage
  • Quick Measures in DAX - Auto validations
  • PowerPivot xVelocity & Vertipaq Store
  • In-Memory Processing : DAX Performance
  • Date and Time & Text Functions
  • Time Intelligence Functions in DAX
  • Logical & Mathematical Functions

Chapter 17 : REST APIs & Power BI Admin

  • REST APIs with Power BI Cloud Service
  • Streaming Datasets Creation in Power BI
  • API : Usage. SubKeys and Channels
  • Push and Pubnub Datasets in Power BI
  • Azure Stream for Real-time Data Reports
  • Real-time Data Tracking Visuals (Interactive)
  • Power BI Mobile Publisher and Mobile Reports
  • Power BI Vs Tableau, SSRS, Sharepoint
  • Licensing & Pricing Plans in Power BI
  • MSBI SSAS and SSRS with Power BI
  • Custom Visuals in Power BI
  • Configuring Alerts in Power BI
  • Managing and Receiving Alerts
  • Power BI with OneDrive, Google Analytics
  • SaaS Components, OneDrive with PowerBI

Chapter 6 : Power BI Visual Properties - 2

  • Map Reports and Filled Map Reports
  • ArcGIS Maps and Real-time Usage. Options
  • Longitudes and Latitudes. Bing Maps
  • Color Analytical Maps, Styles, Options
  • KPI Reports - Target, Value and Trend
  • Plot Area & Responsiveness Properties
  • Sentiment Colors, Color Saturations
  • Breakdowns, Title, Axis Properties
  • Category & Data Lables, Constant Lines
  • Working with SLICER Visual : Value Filters
  • Horizontal and Vertical Slicer Filters
  • Single Select and MultiSelect Options
  • Frown (Errors), Details. Lock Aspects
  • Custom Visuals & PBIVIZ Files. Visual Sync
  • PBI : Options and Settings, VM Settings

Chapter 12 : DAX Functions & Usage - 2

  • Data Modeling with DAX. Creating Roles
  • Currency Conversions, Field Formatting
  • SUM and SUMX Functions: Differences
  • CALCULATE(), CALCULATEX() Functions
  • CALCULATETABLE Functions. VAR, VARP
  • DATESMTD, DATESQTD, DATESYTD
  • ENDOF(), FirstDay(), LastDay()
  • SAMEPERIODLASTYEAR, STARTOF()
  • Other DAX Functions and Examples
  • DAX Expressions with Quick Measure
  • DAX Usage for Row Level Security
  • Creating Roles with Power BI Desktop
  • DAX Filters and Multi Value Conditions
  • Manage Roles and Membership Options
  • VIEW AS ROLE. Information Functions

Real-time Project 1 :

For Power BI Registrations: Real-time Project Implementation @ Climate Control Datasets and REST API

Real-time Project 2 :

For Power BI with SQL Server T-SQL Registrations: Real-time Project Implementation @ ERP Database

24x7 LIVE Online Server (Lab) with Real-time Databases. Course includes ONE Real-time Project. Register Today
All Classes are Instructor-Led & LIVE. Completely Practical and Real-time with Study Material, Session Notes, Tasks and 24x7 LIVE Server.
 

Python Training - Highlights :

  • Completely Practical and Real-time
  • Suitable for Starters + Working Professionals
  • Session wise Handouts and Tasks + Solutions
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews, Certifications
  • Certification & Interview Guidance
 
 
  • Detailed SQL Server Architecture, DB Design
  • Query Tuning, Stored Procedures, Linked Servers
  • In-Memory, DAC and Contained Databases
  • Routine DBA Activities, Emergency DBA Activities
  • SQL Profiler, SQLDIAG, DTA and Litespeed Tools
  • High Availability, Disaster Recovery, Always-On
Register Today  Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses

Job-Oriented Real-time Training @ SQL School Training Institute - Trainer: Mr. Sai Phanindra T