Oracle SQL & PL SQL LIVE Classroom 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 Oracle PL SQL Course

 

Oracle SQL & PL-SQL Training Plans

  PLAN A PLAN B PLAN C
Description Oracle SQL
PL-SQL
PL-SQL &
Python
PL-SQL,
Python & Tableau
Total Duration 4 Weeks 8 Weeks 12 Weeks
Completely Real-time, Practical
Mock Interviews, Case Studies
SQL : Basic SQL, SQL Server Concepts
PL-SQL : Queries, Joins, Group By
PL-SQL : Queries, SProcs, Lock Hints
PL-SQL: Queries, Normal Forms, Excel
Python: Modules
Python: Detailed Design of Interactive
Python: Python Dictionary
Python: Introduction to Web
Python: GUI Programming-Tkinter
Working with Tableau Online
Tableau Desktop & Reports
Groups, Sets, Hierarchies
Filters, LOD Expressions
Actions, Bookmarks, Calc
Tableau Prep and ETL
Tableau Server, Online
Table Admin & Security
Dashboards & Worksheets - Security
Tableau : Real-time Project
Total Course Fee * INR 6,000
USD 81
INR 11,000
USD 149
INR 16,000
USD 217

Tableau Training Schedules :

S No Timings (IST) Start Date Register
Schedules for Oracle SQL & PL-SQL
1 6:30 AM - 7:30 AM July 21st Register
2 10:30 AM - 11:30 AM Aug 5th Register
3 5:30 PM - 6:30 PM July 28th Register
4 8:30 PM - 9:30 PM July 7th Register
Schedules for Python Training
1 7:30 AM - 8:30 AM July 28th Register
2 6:30 PM - 7:30 PM July 8th Register
3 8:30 AM - 10:30 AM (w) July 17th Register
Schedules for Tableau Training
1 9:30 AM - 10:30 AM July 29th Register
2 7:30 PM - 8:30 PM July 6th Register
3 6:30 AM - 8:30 AM (w) July 17th Register

Oracle SQL & PL-SQL Training Highlights :

Real-Time Training Practical Training
DDL, DML, DCL, TCL Commands Queries, Joins
Query Tuning CTEs, TVPs
Excel Imports PIn-Memory Tables
Cloud (Service) with Reports Dashboards & Apps
Tableau Server Configuration Data Refresh Options
Project for your Resume Excel, Database Sources

If above schedule does not work, opt for Tableau Training Videos

Oracle SQL & PL SQL Training Course Contents:

Part 1: Tableau Report Design - 1

Part 2: Tableau Report Design - 2

Part 3: Tableau Prep, Server, Online

Ch 1 : TABLEAU INTRO, INSTALLATION

  • Introduction to Tableau, Reporting Tools
  • Report Types in Real-time: Interactive
  • Paginated, Analytical and Mobile Reports
  • Data Sources for Report Design Process
  • Tableau as a Self Service BI Tool
  • Tableau Features, Technical Advantages
  • Data Sources Types in Tableau
  • Tableau Training : Course Plan, Lab
  • Tableau Public Desktop : Installation
  • Tableau Prep Tools - Data Modelling
  • Power BI Licensing Plans - Types
  • Worksheets, Marks, Shelves, Axis
  • Basic Report Design Terminology
  • Data Sources, Connectors, Clients
  • Study Material, Certifications, FAQs

Ch 7 : TABLEAU VIZ - LEVEL 3

  • Tableau Treemaps & Nested Rectangles
  • Marks Type, Color, Size and Label
  • Comparing Treemaps with Bars & Tables
  • Circle View Vizualization and Usage
  • Side By Side Circle View, Usage
  • Scatter Plot - Labels, Axis Items
  • Packed Bubbles and Circles - Lables
  • Tableau Symbol Maps - Examples
  • Tableau Filled Maps - Examples
  • Using Quick Table Calculations
  • Histogram Charts and Properties
  • Measures and Value Comparisions
  • Tableau Motion Charts and Axis
  • Bullet Graphs and Limitations
  • Dimension - Measure Considerations

Ch 13 : DASHBOARDS & STORIES

  • Creating and Using Tableau Dashboards
  • Worksheet - Dashboard Differences, Use
  • Bulding Dashboards - Views and Sheets
  • Dashboard Size, Views and Objects
  • dashboards - Implementation Steps
  • Working with Local and Global Filters
  • Tiles, Floating Layouts in Tableau
  • Layout Containers and Images
  • Tableau URLs, Worksheets, Tiles
  • Dashboard Extensions & Management
  • Device Designer - Layout Options
  • Adding and Customizing Layouts
  • Story Points - Creation and Use
  • Adding Worksheets and Dashboards
  • Tableau Publish Options (PROD)

Ch 2: BASIC REPORTS, ARCHITECTURE

  • Tableau Workbook Creation, Data Sources
  • Data View, Preview Settings, Row Count
  • Tableau Worksheets : Creation, Options
  • Row Shelf & Column Shelf, Details View
  • Dimensions, Measures Identification
  • Basic Tableau Report Design
  • Marks : Text, Detail, Tooltip, Colors
  • VizQL : Vizualization Query Language
  • Tableau Architecture - Components
  • Data Connectors and LIVE Connections
  • Tableau In-Memory Database Usage
  • Tableau Server Components and Use
  • Application Server and Data Engine
  • Backgrounder, Data Server, Search
  • Fast Data Engine, Gateway Components
  • Tableau File Types and Workbooks
  • Level of Detail, Sets, Marks, Workbooks

Ch 8 : TABLEAU CALCULATIONS - 1

  • Tableau Operators and Types
  • Tableau Functions and Real-time Use
  • Tableau Calculations and Formats
  • Numerical Calculatins & Examples
  • Aggregated Calculations in Tableau
  • Creating Calculations From Shelfs
  • Using Calculations in Reports
  • Calculation Edits, Identifications
  • String and Logic Functions
  • ASCII, CHAR, LEN, ENDSWITH
  • FIND, FINDNTH, LEFT, CONTAINS
  • LOWER, UPPER, LTRIM, RTRIM
  • MID, MIN, REPLACE, RIGHT
  • SPACE, SPLIT, UPPER, MAX
  • ELSE, ELSEIF, END, IF, IIF
  • IFNULL, ISDATE, ISNULL, MAX
  • MIN, NOT, OR, THEN, WHEN, ZN

Ch 14 : TABLEAU ONLINE (CLOUD)

  • Tableau SDLC - Dev to Prod
  • Tableau Online - SaaS Platform
  • Tableau Cloud - Projects Arch
  • Create/Register Tableau Account
  • Tableau Workbooks Publish Options
  • Tableau Data Sources - Publish
  • Tableau Workbook Uploads, Shares
  • Verify / Access Workbooks, URLs
  • Creating Reports in Tableau Online
  • Published Data Sources - Online
  • Project Share and Workbook Share
  • SheetShare, Dashboard Share Options
  • Story Share and User Acces Control
  • Favorite and Tableau Online Objects
  • Subscriptions and Email Share Options
  • Ask Data ( Q & A) Options, Report Design
  • Security Advantages @ Tableau Online

Ch 3 : GROUPS, BINS, UNION

  • Grouping : Data Categorization
  • Creating Groups on Static Data
  • Dynamic Data Grouping, Binnig
  • Static & Dynamic Ranges - Bins
  • Hierarchies: Creation, Real-time Use
  • Drilldown Reports in Tableau
  • Drill-Down and Drill-Up Reports
  • Working with "Show Me" Button
  • Union - Combining Multiple Inputs
  • Data Filters & File / Table Union
  • Considerations For Union in Tableau
  • Using Union Tables in Tableau Viz
  • Filters & Expressions in Data Source
  • Data View Operations in Tableau
  • Table Operations - Report Design
  • DataView Operations - Report Design

Ch 9 : TABLEAU CALCULATIONS - 2

  • Date and Time Calculations
  • DATEADD, DATEDIFF, DATENAME
  • DATEPART, DATETRUNC, DAY
  • ISDATE, MAKEDATE, MONTH
  • NOW, QUARTER, TODAY, YEAR
  • Calculations - Year, Quarter, Month
  • Custom Calculations, Data Appending
  • Custom Date and Time Formatting
  • Date and Time Conversions To INT
  • Calculations Reuse and Edits
  • Two Digit Conversions with Date
  • Table Functions with Tableau
  • Running Total and Row Number
  • Case Statements, FIRST, LOOKUP
  • Dynamic Row Numbers & Functions
  • Custom Date / Month Formatting

Ch 15 : TABLEAU SERVER

  • Tableau Server - Architecture
  • Tableau Server - Installation Process
  • Publish Tableau Workbook, Verify
  • Sharing Options and Layouts
  • Adding Device Layouts in Tableu Server
  • Adding Custom Layouts in Tableau Server
  • Adding Content to Custom Layouts
  • Java Script API in Table Server
  • Tableau Online Versus Table Server
  • Security Advantages @ Tableau Server
  • Tableau Online - Architecture
  • Publish Tableau Workbook, Verify
  • Sharing Options and Layouts
  • Adding Device Layouts in Tableu Online
  • Adding Custom Layouts in Tableau Online
  • Adding Content to Custom Layouts

Ch 4 : JOINS, BIG DATA ACCESS

  • Using Joins with Tableau Sources
  • Inner Joins with Tables, Reports
  • Outer Joins with Tables, Reports
  • Using Joins to Report Matching Data
  • Using Joins to Report Missing Data
  • Tableau Reports with SQL Queries
  • Joining More than 2 Tables, SQL
  • Joining Multiple Data Sheets
  • Working with Big Data Access
  • Azure SQL Databases in Tableau
  • Remote Data Sources and Joins
  • Using SQL Queries in Tableau
  • Data Blending Options in Tableau
  • Working with Multiple Data Sources
  • Data Combinations & Aggregations
  • Show Data & Data Grouping Options

Ch 10 : TABLEAU CALCULATIONS - 3

  • Table Calculations in Tableau
  • Using Table Calc, Scope Options
  • Partitioning, Addressing Benefits
  • Addressing Options with Table Calc
  • YTD Calculation Examples, Reports
  • QTD Calculation Examples, Reports
  • MTD Calculation Examples, Reports
  • Running Totals, Quick Calculations
  • LOD : Types of Level Of Detail
  • Level of Details (LOD), Usage
  • Table Calc Vs LOD Expressions
  • FIXED LOD Expression Examples
  • INCLUDE LOD Expression Examples
  • EXCLUDE LOD Expression Examples
  • Using LOD Expressions in Tableau
  • Using Quick Calculations with LOD

Ch 16: TABLEAU PREP - 1

  • Tableau Prep - ETL & Data Cleansing
  • Tableau Prep - WorkFlow, DEV & PROD
  • Comparing Tableau Prep and Desktop
  • Hyper / TDE Files with Tableau Prep
  • Creating, Using TDE with Prep Tool
  • Flow Pane, Input and Output Panes
  • Run Flow and TDE File Generation
  • Saving Flows, Reusability Options
  • Data Source and Data Sampling
  • Multiple Sources: Union Operation
  • Performing Data Extraction Options
  • Adding Steps and Flows to Prep
  • Adding Output to Flow in Prep
  • Run Flow Options and Destinations
  • Using Prep Output for Reports
  • Prep Output to Desktop & Server

Ch 5 : TABLEAU VIZ - LEVEL 1

  • Tableau Visualizations - Types
  • Visualization Categories, Usage
  • Tableau Bar Charts and Types
  • Simple Bar Charts and Usage
  • Horizontal & Colored Bar Charts
  • Stacked Bar Charts, Measures
  • Side By Side Bar Charts and Use
  • Interactive Bar Charts & Filters
  • Line Charts and Data Points
  • Continous Line Charts and Usage
  • Discrete Line Charts and Usage
  • Dual Line Chart and Types
  • Area Charts : Discrete, Continous
  • Stacked Area Charts, Reports
  • Combine Area Charts & Line Charts

Ch 11 : TABLEAU FILTERS

  • Tableau Filters - Creation, Use
  • Extract Filters and TDE (hyper)
  • Data Source Filters & twb Files
  • String, Numeric & Date Fields
  • Context Filters & Real-time Use
  • Filter Dependancy with Context
  • Row Filters : All, Top & Bottom
  • Aggregated Extracts and History
  • Visual Filters, Worksheet Filters
  • Report Level Filters and Usage
  • Dimension Filters and Examples
  • Measure Filters and Examples
  • MeasureName Filters and Examples
  • Custom Filters and Real-time Use
  • Quick Filters, Types For Reports

Ch 17 : TABLEAU PREP - 2

  • Working with Multiple Data Sources
  • Data Cleansing, Clean Step Options
  • UNION Transformation, Aggregations
  • Missing Column Detections & Merge
  • Column Rename, Adding New Columns
  • Changes and Step Audits in Prep
  • Creating Calculated Fields, Replace
  • Grouping and Manual Selections
  • Aggregate Steps : Precautions, Types
  • Data Type Conversions, Filed Options
  • Custom Calculations, String Functions
  • Field Formatting, Data Flow Options
  • Adding Output Steps to the Flow
  • Generating and Using TDE (hyper)
  • Reusing the Flows with Flow Files

Ch 6 : TABLEAU VIZ - LEVEL 2

  • Tableau Pie Charts, Real-time Use
  • Simple Pie Charts - Examples
  • Stacked Pie Charts - Examples
  • Side By Side Pie Charts
  • Reverse Rows and Row Count
  • Donut Charts and Agle Properties
  • Inner / Outer Pie Charts, Stacking
  • Drill-down Pie Charts and Usage
  • CrossTab Charts and Text Properties
  • Rows, Columns and Marks : Text
  • Conditional Formatting, Divergence
  • Using Quick Claculations in Tableau
  • Highlight Tables and Color Palettes
  • Box & Wishker Plots - Text Tables
  • Heat Maps and Real-time Usage
  • Size Controls and Color Options

Ch 12 : PARAMETERS, ACTIONS

  • Tableau Parameters - Working
  • Creating Parameters, Conditions
  • Linking Parameters to Calculations
  • Using Calculations in Fields/View
  • Dynamic Filters using Parameters
  • Dynamic Dimension using Parameters
  • Dynamic Measures using Parameters
  • Sets and Set Parameters, Usage
  • Tableau Action Types, Limitations
  • Filter Actions: Static/Dynamic
  • Highlight Actions, Dynamic Types
  • URL and Parameter Action Types
  • Worksheet Actions, Usage Options
  • Set Actions, Runtime Actions
  • Tableau Actions & Dashboards
  • Use Field and Filter Actions

Ch 18 : REAL-TIME PROJECT
  • Project Requirement Analysis
  • Implementing SDLC Phases
  • Requirement Gathering, FSA
Phase 1:
  • TABLEAU Report Design
  • Visualizations, Properties
  • Analytics and Formating
Phase 2:
  • Data Modeling, Tableau Prep
  • Dynamic Connections, Azure DB
  • Parameters and VizQL Scripts
Phase 3:
  • Tableau Online Analysis
  • Cloud and Tableau Server
  • Project FAQs and Solutions
 
All Classes are Instructor-Led & LIVE. Completely Practical and Real-time with Study Material, Session Notes, Tasks and 24x7 LIVE Server.
 

Oracle SQL & PL SQL 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 Basics includes DDL, DML, DCL, TCL
  • Table Design, Normal Forms and RAID Levels
  • Queries, Sub Queries and Nested Queries
  • Loops, Variables, Functions and Cursors
  • Query Tuning, Stored Procedures, Triggers
  • PL SQL Programming Concepts and Advanced PLSQL
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