Oracle PL-SQL Online Training

This impeccable PL SQL Training Course is exclusively designed for starters as well as for experienced professionals addressing Oracle Installation, Database Design, Queries, Joins, Stored Procedures, Triggers, Remote Queries, Transactions and Tuning options with BLOB Data and JSON. Practice Material, Certification, Resume & Interview Guidance are included in this PLSQL Course

PL-SQL Training Plans

Description PLAN A PLAN B PLAN C
PL-SQL PL-SQL with Power BI PL-SQL with Python
Duration 4 Weeks 7 Weeks 9 Weeks
Real-Time Project Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Resume Support Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Mock Interviews Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Placement Assistance Croos-symbol-for-Yes Croos-symbol-for-Yes Check-Symbol-for-Yes
Oracle SQL & PL-SQL Croos-symbol-for-No Check-Symbol-for-Yes Check-Symbol-for-Yes
Total Course Fee INR 6,000/-
USD 100
INR 15,000/-
USD 250
INR 15,000/-
USD 250
 

For Weekend / FastTrack Trainings Click Here

Schedules for Oracle PL-SQL Online Training

Timings Demo Date Start Date  
7:45 AM - 8:45 AM May 17th May 18th Register
9 AM - 10 AM June 4th June 5th Register
11:30 AM - 12:30 PM May 23rd May 24th Register
3 PM - 4 PM Recently Started Register
6 PM - 7 PM May 28th May 29th Register

Who can take this Course?

This PL SQL Course is helpful for aspiring Data Scientists, Data Analysts, PL SQL Developers, Report Developers and more..!

If the above schedules does not work for you, please opt for PL-SQL Video Training (on demand, 24x7 Access)

PL-SQL Highlights : Daily Tasks Weekly Interviews Real-time Project Resume Guidance Certification Guidance Placement Services
 

Oracle PL/SQL Training Course Contents:

 

Module : 1
Database Concepts, Basic SQL

Module : 2
Oracle Concepts, PL/SQL

Chapter 1 : INTRODUCTION TO DBMS

  • What is Data and Information?
  • Purpose of Data Management
  • File and File System For Data Storage
  • Disadvantages of File Data Management
  • Database : Purpose, Basic Terminology
  • Advantages of Database for Data Storage
  • Possible Operations on the Database
  • Database Models – Hierarchal Model
  • Network Model and Relational Model

CHAPTER 2 : Introduction to RDBMS

  • Features of RDBMS
  • Advantages of RDBMS over FMS & DBMS
  • E.F Codd Rules for RDBMS
  • Normalization Process
  • Client server Technology
  • Oracle Corporation Products
  • Oracle Versions about SQL & SQL*PLUS
  • Difference between OLTP & OLAP

CHAPTER 3 : Sub Language Commands

  • Data Definition Language(DDL)
  • Data Retrieval Language (DRL)
  • Data Manipulation Language (DML)
  • Transaction Control Language (TCL)
  • Database Security and Privileges (DCL)

CHAPTER 4 : Introduction to SQL

  • Schema & Schema Objects
  • Oracle Data Types
  • DDL Commands
  • DML Command DRL Commands Operators
  • Arithmetic and Logical Operators
  • Set Operators (UNION, UNION ALL, INTERSECT, MINUS)
  • Special Operators – IN (NOT IN), BETWEEN (NOT BETWEEN),
  • LIKE (NOT LIKE), IS NULL (IS NOT NULL)

CHAPTER 5 : Built-in Functions

  • Arithmetic Functions
  • Character Functions
  • Date functions
  • Conversion Functions
  • Aggregate Functions
  • OLAP Functions & General Functions

CHAPTER 6 : Grouping the result of a query

  • Using Group by and Having Clause of DRL Statement
  • Using Order by clause
  • Working with, Sequences, Working with Synonyms,
  • Working with Index and Clusters, Creating Cluster Tables,
  • implementing Locks, Working with roles

CHAPTER 7 : Pseudo Columns in Oracle

  • Understanding Pseudo Columns in Oracle
  • Type of Pseudo Columns in Oracle
  • CURRVAL AND NEXTVAL, LEVEL, ROWID, ROWNUM

CHAPTER 8 : Working with Integrity Constraints

  • Importance of Data integrity
  • Working with different types of integrity constraints
  • NOT NULL constraint, UNIQUE constraint,
  • PRIMARY KEY constraint, REF constraint
  • Understanding ON DELETE clause in referential integrity constraint
  • Working with multiple constraints upon a column
  • Adding constraints to a table
  • Dropping of constraints, Enabling /
  • disable constraints
  • Querying for constraints information

CHAPTER 9 : Working with Sub Queries

  • Understanding the practical approach
  • to Sub Queries/Nested Select/Sub Select/Inner Select/Outer Select
  • Usage of Sub Queries.
  • The Impact of Having Clause in Sub Queries,
  • IN, ANY SOME, ALL Operators in Sub Queries
  • PAIR WISE and NON PAIR WISE Comparison in Sub Queries, Be…
  • Aware of NULL’S, Correlated Sub Queries,
  • Handling Date Retrieval with EXISTS and NOT EXISTS Operators

CHAPTER 10 : Locks

  • Row level Locks
  • Table level Locks
  • Shared Lock
  • Dead Lock
  • Implicit Locking

CHAPTER 11 : Querying Multiple Tables (Joins)

  • Equi Join/Inner Join/Simple Join,
  • Cartesian Join, Non-Equi Join, Self Join

CHAPTER 12 : Data Partitions & Parallel Process

  • Range Partitions, Hash Partition
  • List Partition, Composite Partition, Parallel
  • Query Process

CHAPTER 13 : Working with DCL, TCL Commands

  • Grant, Revoke,
  • Commit, Rollback, Savepoint
  • Read Consistency

CHAPTER 14 : PL/SQL (Procedure Language – SQL)

  • introduction to Programming Languages
  • Introduction PL/SQL, The Advantages of
  • PL/SQL
  • PL/SQL Architecture, PL/SQL Data types
  • Variable and Constants, Using Built-in
  • Functions
  • Conditional and Unconditional Statement
  • Simple if, if..else. Nested if..else, if.. else
  •  Ladder, Selection Case, Simple Case, GOTO Label and EXIT
  • Iterations in PL/SQL, Simple LOOP, WHILE LOOP,
  • FOR LOOP and NESTED LOOPS
  • SQL within PL/SQL, Composite Data types
  • (complete), Cursor Management in PL/SQL
  • Implicit Cursors, Explicit Cursors, Cursor
  • Attributes
  • Cursor with Parameters, Cursors with LOOPs Nested Cursors,
  • Cursors with Sub Queries, Ref. Cursors, Record and PL/SQL Table Types.

CHAPTER 15 : Advanced PL/SQL

  • Procedures in PL/SQL: STORES PROCEDURE,
  • PROCEDURE with Parameters (IN, OUT and IN OUT
  • POSITIONAL Notation and NAMED Notation,
  • Procedure with Cursors, Dropping a Procedure
  • Functions in PL/SQL: Differences between
  • Procedures and Functions,
  • User Defined Functions, Nested Functions,
  • using stored function in SQL statements
  • Pragma_Autonomous_Transaction(),
  • Returning into clause, Bulk Collect,
  • For All, Definer/Invoker Rights
  • About flash Back Queries, Dynamic SQL,
  • Flash back command, Purge Command, Recycle bin, Regular expressions,
  • DML Error Logging, Virtual Columns, Read only tables,
  • Cross tab Views using, Pivot/Unpivot Operators Follows Clause,
  • Compound Triggers, New data types
  • Working with LARGE Objects

CHAPTER 16 : Maintaining Database Objects

  • VIEWS IN ORACLE
  • Understanding the Standards of VIEWS
  • in Oracle
  • Types of VIEWS: Relational Views,
  • Practical approach of SIMPLE VIEWS and COMPLEX VIEWS,
  • Column definitions in VIEWS, Using VIEWS for DML Operations,
  • forced Views, Putting CHECK Constraint upon
  • VIEWS, Creation of READ ONLY VIEWS
  • TOP-N Analysis, About Materialized
  • Understanding the IN LINE VIEWS
  • Views, View Triggers
  • Outer Joins – Types, Advantages and Usage
  • Cross Joins – Advantages and Limitations
  • Self Joins, Merge Joins and Sub Queries
  • Purity Levels, User _Source Dictionary table Packages in PL/SQL:
  • Creating PACKAGE Specification
  • PACKAGE Body, Private and Public Objects in PACKAGE
  • XCEPTIONS in PL/SQL: Types of Exceptions: User Defined Exceptions
  • SQL Error Code Values

CHAPTER 17 : Database Triggers in PL/SQL

  • Types of Triggers, Row Level Triggers,
  • Statement Level Triggers, DML Triggers, DDL Triggers, Schema Triggers
  • Using OLD and NEW References, Trigger Auditing,
  • Enabling / Disabling Triggers, Dropping Triggers

CHAPTER 18 : Implementing Object Technology

  • What is Object Technology?
  • OOPS-Object instances, Creation of objects
  • Creating user Defined Date Types
  • Creating Object Tables
  • Inserting rows in a table using object
  • Retrieving date from Object based
  • Tables
  • Calling a Method, Indexing Abstract
  • Data type Attributes

CHAPTER 19 : Using Collections

  • Advantages of collection
  • Ref Cursor (Dynamic Cursor), Weak Ref Cursor,
  • Strong Ref Cursor, Nested Tables
  • Associative Arrays, VARRAYS or
  • VARYING arrays
  • Creating tables using nested tables
  • Inserting, Updating & Deleting
  • Nested, Table Records

CHAPTER 20 : Advanced Features

  • New Date function, Rename column,
  • Inner Join/Natural Join,
  • Left Outer Join/Right Outer Join, Full Outer Join
  • Multiple inserts, Insert All Command,
  • Merge statement, NVL2(), NULLIF(), COALESCE(),
  • CASE expression of Select Command, Temporary Tables/Global Tables
  • New Function EXTRACT (), Autonomous Transaction

CHAPTER 21 : Oracle Built-in Packages

  • DBMS_OUTPUT Package
  • DBMS_DDL Package
  • DBMS_JOB Package
  • DBMD_SCHEDULER Package
  • UTL_FILE Package
  • UTL_MAIL Package
  • Architecture
  • Physical Structures Logical structures
  • DB Memory Structures

CHAPTER 22 : Oracle Utilities

  • Oracle Data Pump
  • SQL * Loader
  • External Tables
Power BI Training (Applicable for PLAN A & B)

CHAPTER 1 : INTRODUCTION TO POWER BI

  • Introduction to Power BI - Need and Importance in Real-world
  • Power BI - Advantages and Scalability Options. Self-Service BI
  • History - Excel with Power View, Power Query, Power Pivot
  • Power BI Data Source Library and Power BI Cloud Services
  • Business Analyst Tools, MS Cloud Tools and Azure Market Place
  • Power BI Architecture and Tools (Power BI Desktop, Gateways)
  • Power BI Architectue : On-Premise Data & Cloud Integration
  • Real-time Workflow and Implementation Models with Power BI
  • Power BI Licenses and Pricing Plans. Enterprise Services
  • Installation 1: Power BI Tool (Desktop) Cloud Configuration
  • Installation 2: Power View and Power Query Add-Ons in Excel
  • Installation 3: Power BI Gateways (Personal & Enterprise Level)
  • Installation 4: Power BI Publisher For Excel and Power BI Mobile
  • Sample Reports and Visualization Controls. On-premise & Cloud
  • Power BI Cloud Account Configuration Portal and Vocabulary
  • Report Rendering and End User Access with PINS, Dashboards
  • Comparing Power BI with MSBI, Tableau and QlikView
  • Course Plan - Power BI (LIVE) Online Training

CHAPTER 8 : DAX EXPRESSIONS - Level 1

  • Purpose & Scope of Data Analysis Expresssions (DAX)
  • DAX: Syntax, Functions & Context. Real-time DAX Usage
  • Using DAX to create new models from existing data
  • DAX to solve Big Data Analytics and Modelling Problems
  • DAX Context : Row Context and Filter Context Usage
  • DAX Entities : Calculated Columns and Measures in Fields
  • DAX Data Types : Numeric, Boolean, Variant, Currency
  • Datetime Data Tye with DAX. Comparison with MS Excel
  • DAX Operators & Symbols. Usage. Operator Priority
  • Parenthesis, Comparison, Arthmetic, Text, Logic Operators
  • DAX Functions and Types: Table Valued Functions
  • Filter, Aggregation and Time Intelligence Functions in DAX
  • Information, Logical, Parent-Child Functions in DAX
  • Statistical and Text Functions. Formulas, Queries in DAX
  • Syntax Requirements with DAX. Differences with MS Excel
  • Naming Conventions and DAX Format Expressions
  • Columns and Measures with DAX - Real-time Examples
  • Measure / Column Scope with DAX - Real-time Examples

CHAPTER 2 : CREATING POWER BI REPORTS, AUTO FILTERS

  • Report Design with Legacy & .DAT Files
  • Report Design with Databse Tables
  • Understanding Power BI Report Designer
  • Report Canvas, Report Pages: Creation, Renames
  • Report Visuals, Fields and UI Options
  • Experimenting Visual Interactions, Advantages
  • Reports with Multiple Pages and Advantages
  • Pages with Multiple Visualizations. Data Access
  • PUBLISH Options and Report Verification in Cloud
  • "GET DATA" Options and Report Fields, Filters
  • Report View Options: Full, Fit Page, Width Scale
  • Report Design using Databases & Queries
  • Query Settings and Data Preloads
  • Navigation Options and Report Refresh
  • Stacked bar chart, Stacked column chart
  • Clustered bar chart, Clustered column chart
  • Adding Report Titles. Report Format Options
  • Focus Mode, Explore and Export Settings

CHAPTER 9 : DAX EXPRESSIONS - Level 2

  • YTD, QTD, MTD Calculations with DAX
  • DAX Calculations and Measures
  • Using TOPN, RANKX, RANK.EQ
  • Computations using STDEV & VAR
  • SAMPLE Function, COUNTALL, ISERROR
  • ISTEXT, DATEFORMAT, TIMEFORMAT
  • Time Intelligence Functions with DAX
  • Data Analysis Expressions and Functions
  • DATESYTD, DATESQTD, DATESMTD
  • ENDOFYEAR, ENDOFQUARTER,ENDOFMONTH
  • FIRSTDATE, LASTDATE, DATESBETWEEN
  • CLOSINGBALANCEYEAR,CLOSINGBALANCEQTR
  • SAMEPERIOD and PREVIOUSMONTH,QUARTER
  • KPIs with DAX. Vertipaq Queries in DAX
  • IF..ELSEIF.. Conditions with DAX
  • Slicing and Dicing Options with Columns, Measures
  • DAX for Query Extraction, Data Mashup Operations
  • Calcualted COlumns and Calculated Measures with DAX

CHAPTER 3 : REPORT VISUALIZATIONS and PROPERTIES

  • Power BI Design: Canvas, Visualizations and Fileds
  • Import Data Options with Power BI Model, Advantages
  • Direct Query Options and Real-time (LIVE) Data Access
  • Data Fields and Filters with Visualizations
  • Visualization Filters, Page Filters, Report Filters
  • Conditional Filters and Clearing. Testing Sets
  • Creating Customised Tables with Power BI Editor
  • General Properties, Sizing, Dimensions, and Positions
  • Alternate Text and Tiles. Header (Column, Row) Properties
  • Grid Properties (Vertical, Horizontal) and Styles
  • Table Styles & Alternate Row Colors - Static, Dynamic
  • Sparse, Flashy Rows, Condensed Table Reports. Focus Mode
  • Totals Computations, Background. Boders Properties
  • Column Headers, Column Formatting, Value Properties
  • Conditional Formatting Options - Color Scale
  • Page Level Filters and Report Level Filters
  • Visual-Level Filters and Format Options
  • Report Fields, Formats and Analytics
  • Page-Level Filters and Column Formatting, Filters
  • Background Properties, Borders and Lock Aspect

CHAPTER 10 : POWERBI DEPLOYMENT & CLOUD

  • PowerBI Report Validation and Publish
  • Understanding PowerBI Cloud Architecture
  • PowerBI Cloud Account and Workspace
  • Reports and DataSet Items Validation
  • Dashboards and Pins - Real-time Usage
  • Dynamic Data Sources and Encryptions
  • Personal and Organizational Content Packs
  • Gateways, Subscriptions, Mobile Reports
  • Data Refresh with Power BI Architecture
  • PBIX and PBIT Files with Power BI - Usage
  • Visual Data Imprts and Visual Schemas
  • Cloud and On-Premise Data Sources
  • How PowerBI Supports Data Model?
  • Relation between Dashbaords to Reports
  • Relation between Datasets to Reports
  • Relation between Datasets to Dashbaords
  • Page to Report - Mapping Options
  • Publish Options and Data Import Options
  • Need for PINS @ Visuals and PINS @ Reports
  • Need for Data Streams and Cloud Intergration

CHAPTER 4 : CHART AND MAP REPORT PROPERTIES

  • CHART Report Types and Properties
  • STACKED BAR CHART, STACKED COLUMN CHART
  • CLUSTERED BAR CHART, CLUSTERED COLUMN CHART
  • 100% STACKED BAR CHART, 100% STACKED COLUMN CHART
  • LINE CHARTS, AREA CHARTS, STACKED AREA CHARTS
  • LINE AND STACKED ROW CHARTS
  • LINE AND STACKED COLUMN CHARTS
  • WATERFALL CHART, SCATTER CHART, PIE CHART
  • Field Properties: Axis, Legend, Value, Tooltip
  • Field Properties: Color Saturation, Filters Types
  • Formats: Legend, Axis, Data Labels, Plot Area
  • Data Labels: Visibility, Color and Display Units
  • Data Labels: Precision, Position, Text Options
  • Analytics: Constant Line, Position, Labels
  • Working with Waterfall Charts and Default Values
  • Modifying Legends and Visual Filters - Options
  • Map Reports: Working with Map Reports
  • Hierarchies: Grouping Multiple Report Fields
  • Hierarchy Levels and Usages in Visualizations
  • Preordered Attribute Collection - Advantages
  • Using Field Hierarchies with Chart Reports
  • Advanced Query Mode @ Connection Settings - Options
  • Direct Import and In-memory Loads, Advantages

CHAPTER 11 : POWER BI CLOUD OPERATIONS

  • Report Publish Options and Verifications
  • Working with Power BI Cloud Interface & Options
  • Navigation Paths with "My Workspace" Screens
  • FILE, VIEW, EDIT REPORTS, ACCESS, DRILLDOWN
  • Saving Reports into pdf, pptx, etc. Report Embed
  • Report Rendering and EDIT, SAVE, Print Options
  • Report PIN and individual Visual PIN Options
  • Create and Use Dashboards. Menu Options
  • Goto Dashboard and Goto LIVE Page Options
  • Operations on Pinned Reports and Visuals
  • TITLE, MEDIA, USAGE METRICS & FAVOURITES
  • SUBSCRIPTION Options and Reports with Mobile View
  • Options with Report Page : Print and Subscribe
  • Report Actions: USAGE METRICS, ANALYSE IN EXCEL
  • Report Actions: RELATED ITEMS, RENAME, DELETE
  • Dashboard Actions: METRICS, RELATED ITEMS
  • Dashboard Actions: SETTINGS FOR Q & A, DELETE
  • PIN Actions: METRICS, SHARE, RELATED ITEMS
  • PIN Actions: SETTINGS FOR Q & A, DELETE
  • EDIT DASHBOARD (CLOUD), On-The-Fly Reports
  • Dataset Actions: CREATE REPORT, REFRESH
  • SCHEDULED REFRESH & RELATED ITEMS
  • Dashboard Integration with Apps in Power BI

CHAPTER 5 : HIERARCHIES and DRILLDOWN REPORTS

  • Hierarchies and Drilldown Options
  • Hierarchy Levels and Drill Modes - Usage
  • Drill-thru Options with Tree Map and Pie Chart
  • Higher Levels and Next Level Navigation Options
  • Aggregates with Bottom/Up Navigations. Rules
  • Multi Field Aggregations and Hierarchies in Power BI
  • DRILLDOWN, SHOWNEXTLEVEL, EXPANDTONEXTLEVEL
  • SEE DATA and SEE RECORDS Options. Differences
  • Toggle Options with Tabular Data. Filters
  • Drilldown Buttons and Mouse Hover Options @ Visuals
  • Dependant Aggregations, Independant Aggregations
  • Automated Records Selection with Tabular Data
  • Report Parameters : Creation and Data Type
  • Available Values and Default values. Member Values
  • Parameters for Column Data and Table / Query Filters
  • Parameters Creation - Query Mode, UI Option
  • Linking Parameters to Query Columns - Options
  • Edit Query Options and Parameter Manage Entries
  • Connection Parameters and Dynamic Data Sources
  • Synonyms - Creation and Usage Options

CHAPTER 12 : IMPROVING POWER BI REPORTS

  • Publish PowerBI Report Templates
  • Import and Export Options with Power BI
  • Dataset Navigations and Report Navigations
  • Quick Navigation Options with "My Workspace"
  • Dashboards, Workbooks, Reports, Datasets
  • Working with MY WORK SPACE group
  • Installing the Power BI Personal Gateway
  • Automatic Refresh - Possible Issues
  • Adding images to the dashboards
  • Reading & Editing Power BI Views
  • Power BI Templates (pbit)- Creation, Usage
  • Managing report in Power BI Services
  • PowerBI Gateway - Download and Installation
  • Personal and Enterprise Gateway Features
  • PowerBI Settings : Dataset - Gateway Integration
  • Configuring Dataset for Manual Refresh of Data
  • Configuring Automatic Refresh and Schdules
  • Workbooks and Alerts with Power BI
  • Dataset Actions and Refresh Settings with Gateway
  • Using natural Language Q&A to data - Cortana

CHAPTER 6 : POWER QUERY & M LANGUAGE - Part 1

  • Understanding Power Query Editor - Options
  • Power BI Interface and Query / Dataset Edits
  • Working with Empty Tables and Load / Edits
  • Empty Table Names and Header Row Promotions
  • Undo Headers Options. Blank Columns Detection
  • Data Imports and Query Marking in Query Editor
  • JSON Files & Binary Formats with Power Query
  • JavaScript Object Notation - Usage with M Lang.
  • Applied Steps and Usage Options. Revert Options
  • creating Query Groups and Query References. Usage
  • Query Rename, Load Enable and Data Refresh Options
  • Combine Queries - Merge Join and Anti-Join Options
  • Combine Queries - Union and Union All as New Dataset
  • M Language : NestedJoin and JoinKind Functions
  • REPLACE, REMOVE ROWS, REMOVE COL, BLANK - M Lang
  • Column Splits and FilledUp / FilledDown Options
  • Query Hide and Change Type Options. Code Generation

CHAPTER 13 : INSIGHTS AND SUBSCRIPTIONS

  • Data Navigation Paths and Data Splits
  • Getting data from existing systems
  • Data Refresh and LIVE Connections
  • pbit and pbix : differences. Usage Options
  • Quick Insights For Power BI Reports
  • Quick Insights For PowerBI Dashboads
  • Generating Insights with Cloud Datasets
  • Generarting Reports with Cloud Datasets
  • Using relational databases on-premises
  • Using relational databases in the cloud
  • Consuming a service content pack
  • Creating a custom data set from a service
  • Creating a content pack for your organization
  • Consuming an organizational content pack
  • Updating an organizational content pack
  • Adding Tiles : Images, Videos, DataStreams
  • Creating New Reports from Cortana, Advantages

CHAPTER 7 : POWER QUERY & M LANGUAGE - Part 2

  • Invoke Function and Freezing Columns
  • Creating Reference Tables and Queries
  • Detection and Removal of Query Datasets
  • Custom Columns with Power Query
  • Power Query Expressions and Usage
  • Blank Queries and Enumuration Value Generation
  • M Language Sematics and Syntax. Tranform Types
  • IF..ELSE Conditions, TransformColumn() Types
  • RemoveColumns(), SplitColumns(),ReplaceValue()
  • Table.Distinct Options and GROUP BY Options
  • Table.Group(), Table.Sort() with Type Conversions
  • PIVOT Operation and Table.Pivot(). List Functions
  • Using Parameters with M Language (Power Query Editor)
  • Advanced Query Editor and Parameter Scripts
  • List Generation and Table Conversion Options
  • Aggregations using PowerQuery & Usage in Reports
  • Report Generation using Web Pages & HTML Tables
  • Reports from Page collection with Power Query
  • Aggregate and Evaluate Options with M Language
  • Creating high-density reports, ArcGIS Maps, ESRI Files
  • Generating QR Codes for Reports, Mobile / Tables
  • Table Bars and Drillthru Filters in Power BI

CHAPTER 14 : Power BI Services, Embeddded, Report Server

  • Power BI Service and Office 365 Integration
  • Power BI Servicer Components with Content Packs
  • Cortana Integration with Power BI Mobile Reports
  • Social Integration with Power BI Embedded Service
  • Power BI Service Integration with Azure AD
  • Report Server Configuration and Usage in Azure
  • SSRS Integration with Power BI
  • SSRS Report Portal URL to Power BI Cloud
  • Power BI KPI Reports and Mobile Reports
  • Convering PBIX into Mobile Reports, Tab Reports
  • Generating QR Codes and Report Security
  • Reporting JSON Files, OLAP DataSources in Power BI
  • Using MDX Queries with PowerBI Queries
  • KPIs and MDX Expressions with Power BI
  • MDX Queries and Filters with Power BI
  • Linked Servers and T-SQL SPROCs with MDX
  • YTD, PARALLELPERIOD,SCOPE, ALLMEMBERS
  • Implementing Row Level Security (RLS) with DAX
  • Using R for Power BI, Streaming DataSets
  • R Script and Custom Visualizations in Power BI
  • PowerBI Reports using R & CSV / DAT Files
  • Using R Script Editor with Power BI Desktop
  • R Script Security and Microsoft OneDrive

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 : Multi-Threading

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

CHAPTER 30 : Web Scrapping

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

CHAPTER 31 : 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 32 : 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 33 : GUI Programming-Tkinter

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

CHAPTER 34 : Data Analytics

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

CHAPTER 35 : 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 36 : Data Science

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

CHAPTER 37 : 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

*Above course curriculum applicable for registrations from April 26th, 2017

24x7 Support with Real-time Databases. Course includes Real-time Case Studies Register Today
All Classes are Instructor-Led & LIVE. Completely Practical and Real-time with Study Material, Session Notes, Tasks and 24x7 Support.

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