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
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 |
S No | Timings (IST) | Start Date | Register |
---|---|---|---|
Schedules for Oracle SQL & PL-SQL | |||
1 | 6:30 AM - 7:30 AM | Jan 18th | Register |
2 | 10:30 AM - 11:30 AM | Jan 27th | Register |
3 | 5:30 PM - 6:30 PM | Jan 18th | Register |
4 | 8:30 PM - 9:30 PM | Feb 8th | Register |
Schedules for Python Training | |||
1 | 7:30 AM - 8:30 AM | Feb 17th | Register |
2 | 6:30 PM - 7:30 PM | Jan 18th | Register |
3 | 8:30 AM - 10:30 AM (w) | Jan 23rd | Register |
Schedules for Tableau Training | |||
1 | 9:30 AM - 10:30 AM | Feb 17th | Register |
2 | 7:30 PM - 8:30 PM | Jan 18th | Register |
3 | 6:30 AM - 8:30 AM (w) | Jan 16th | Register |
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
Module 1: Basic SQL |
Module 2: SQL & PL SQL |
Module 3: Adv PLSQL |
CHAPTER 1 : INTRODUCTION TO DBMS
|
CHAPTER 7 : CONSTRAINTS & KEYS
|
CHAPTER 13 : PL/SQL – (CONTROL STRUCTURE) - Level I
|
CHAPTER 2: ORACLE INSTALLATION
|
CHAPTER 8 : QUERIES & JOINS
|
CHAPTER 14: ADVANCED PL/SQL - 1
|
CHAPTER 3: INTRODUCTION TO RDBMS
|
CHAPTER 9 : VIEWS, SYNONYMS,SEQUENCES
|
CHAPTER 15 : ADVANCED PL/SQL - 2
|
CHAPTER 4 : SQL LANGUAGE COMMANDS
|
CHAPTER 10 : SUB QUERIES, NESTED QUERIES
|
CHAPTER 16 : ADVANCED PL/SQL - 3
|
CHAPTER 5.SQL SPECIAL OPERATORS
|
CHAPTER 11: LOCKS in ORACLE TABLES
|
CHAPTER 17: OBJECT TECHNOLOGY – Level I
|
CHAPTER 6: GROUPING QUERY RESULTS
|
CHAPTER 12 : PERFORMANCE (QUERY) TUNING
|
CHAPTER 18: OBJECT TECHNOLOGY – Level II
|
Part 1: Tableau Report Design - 1 |
Part 2: Tableau Report Design - 2 |
Part 3: Tableau Prep, Server, Online |
Ch 1 : TABLEAU INTRO, INSTALLATION
|
Ch 7 : TABLEAU VIZ - LEVEL 3
|
Ch 13 : DASHBOARDS & STORIES
|
Ch 2: BASIC REPORTS, ARCHITECTURE
|
Ch 8 : TABLEAU CALCULATIONS - 1
|
Ch 14 : TABLEAU ONLINE (CLOUD)
|
Ch 3 : GROUPS, BINS, UNION
|
Ch 9 : TABLEAU CALCULATIONS - 2
|
Ch 15 : TABLEAU SERVER
|
Ch 4 : JOINS, BIG DATA ACCESS
|
Ch 10 : TABLEAU CALCULATIONS - 3
|
Ch 16: TABLEAU PREP - 1
|
Ch 5 : TABLEAU VIZ - LEVEL 1
|
Ch 11 : TABLEAU FILTERS
|
Ch 17 : TABLEAU PREP - 2
|
Ch 6 : TABLEAU VIZ - LEVEL 2
|
Ch 12 : PARAMETERS, ACTIONS
|
Ch 18 : REAL-TIME PROJECT
|
Python Basics - Level I |
Python Basics - Level II |
Module II: Advanced Python |
DAY 1 : INTRODUCTION TO SCRIPT
|
DAY 9 : Python TUPLE
Python Sets
|
DAY 17 : Python Regular Expressions
|
DAY 2 : INTRODUCTION TO PYTHON
|
DAY 10 : Python Dictionary
|
DAY 18 : Python-Data Base Communication
|
DAY 3 : DIFFERENT MODE IN PYTHON
|
DAY 11 : Python Functions
|
DAY 19 : Multi-Threading
|
DAY 4 : PYTHON NEW IDEs
Variables in Python
|
DAY 12 : Python Modules
|
DAY 20 : Introduction to Python Web
|
DAY : 5 Python Operators and Operands
|
DAY 13 : Packages in Python
|
DAY 21 : GUI Programming-Tkinter
|
DAY 6 : String Handling
|
DAY 14 : Python Date and Time
|
DAY 22: Data Analytics
Data Science
|
DAY 7 : Python Conditional
|
DAY 15 : Python OS Module
|
DAY 23 : Internet of Things
|
DAY : 8 Python LOOPS
Sequence or Collections and Lists
|
DAY 16 : Python Class and Objects
|
DAY 24 : Introduction to Machine Learning
|