Database/Tableau/Power BI

Course Description:

 

The Oracle PL/SQL language is a flexible procedural extension to SQL and increases productivity, performance, scalability, portability and security. In this course, you will gain the practical knowledge to write PL/SQL programs. You will learn to build stored procedures, design and execute modular applications and increase the efficiency of data movement. 

Tableau certification training helps you learn how to build visualizations, organize data, and design dashboards to empower more meaningful business decisions. You’ll be exposed to the concepts of statistics, data mapping, and establishing data connections and be prepared for the Tableau exam.

Getting Started with Power BI, you will gain a fundamental understanding of the capabilities of Power BI. You'll start out with seeing how you can quickly and easily gather data from a variety of sources, and then cleanse and transform that data with just a few clicks. Next, you'll also learn how you can enhance the results by integrating disparate data sources and adding simple calculations. Then, you'll learn how to explore your data with visualizations and simple dashboards. Finally, you'll learn what steps are necessary to keep your data up-to-date. By the end of this course, you'll have a firm understanding of the basic skills required for using Power BI to acquire and transform data, enhance the data for analysis, and produce reports and dashboards.

Course Topics:

Module 1: Database (Oracle)

Time - 32 Hours

PL/SQL fundamentals

  • Declaring and anchoring variables to database definitions

  • Flow control constructs

  • DML commands: Select, Insert, Update, Delete

  • DDL commands: Create, Alter Tables/Views/Sequence

  • TCL commands: Grant, Revoke

  • Joins

  • Trigger

  • Stored procedure

Oracle 11g/12c PL/SQL features

  • PL/SQL in Oracle 11g

  • Returning implicit cursor results from stored procedures in Oracle 12c

  • Declaring local functions within SELECT statements in Oracle 12c

Data manipulation techniques

  • Maintaining data with DML statements

  • Employing the RETURNING INTO clause

  • Solving the fetch-across-commit problem

Managing data retrieval with cursors

  • Implications of explicit and implicit cursors

  • Simplifying cursor processing with cursor FOR LOOPs

  • Embedding cursor expressions in SELECT statements

Cursor variables

  • Strong vs. weak cursor variables  

  • Passing cursor variables to other programs

  • Defining REF CURSORS in packages

  • Developing Well-Structured and Error-Free Code

Error handling

  • Propagation and scope 

  • "Retrying" problem transactions with EXCEPTION processing

Debugging PL/SQL blocks

  • Simplifying testing and debugging with conditional compilation 

  • Interpreting compiler messages

  • Applying structured testing techniques

  • Building and applying a testbed

  • Leveraging the debugging facilities in SQL Developer

  • Achieving Maximum Reusability

Writing stored procedures and functions

  • Calling and invoking server-side logic 

  • Passing input and output parameters

  • Implementing an autonomous transaction

Calling user-written functions

  • Calling PL/SQL functions from SQL

  • Building table-valued functions

Developing safe triggers

  • Employing :OLD and :NEW variables

  • Avoiding unreliable trigger constructs

  • Exploiting schema and database triggers

 

 

 

 

Module 2: Tableau

Time - 16 Hours

  • Getting Started with Tableau

  • Load Data from Excel

  • User Interface of Tableau Public

  • Core Topics in Tableau

  • Dimension vs Measures

  • Discrete vs Continuous

  • Aggregation of Tableau

  • Creating Charts in Tableau (Bar Chart, Stacked Bar Chart, Line Chart, Scatter Plot, Dual-Axis Charts, Combined-Axis Chart, Funnel Chart, Cross Chart, Maps)

  • Working with Metadata (Data Types, Default Properties of Fields)

  • Filter in Tableau (Dimension Filter, Data Filter, Measure Filter, Visual Filter, Interactive Filter, Data Source Filter, Context Filter)

  • Applying Analytics to the Worksheet (Sets, Parameters, Group, Calculated Fields, Date Functions, Text Functions, Bins and Histogram, Sort, Reference and Trend Lines, Table Calculations, Pareto Chart, Waterfall Chart)

  • Dashboards

  • Story

  • Case Study

  • Modification to Data Connections (Edit Data Source, Union, Joins, Data Blending)

  • Level of Detail (Fixed LOD, Include LOD, Exclude LOD)

  • Publish to Tableau Public

 

Module 3: Power BI

Time - 16 Hours

  • Overview of Power BI Desktop

  • Data Sources in Power BI Desktop

  • Connecting to a data Source

  • Query Editor in Power BI

  • Clean and Transform your data with Query Editor

  • Combining Data - Merging and Appending

  • Cleaning irregularly formatted data

  • Views in Power BI Desktop

  • Modeling Data

  • Manage Data Relationship

  • Cross Filter Direction

  • Create calculated tables and measures

  • Optimizing Data Models

  • Data Analysis Expressions (DAX)

  • Data Visualization

  • Introduction to Power BI Service

  • Dashboard vs. Reports

  • Quick Insights in Power BI

  • Creating and Configuring Dashboards

  • Power BI embedded

  • Direct Connectivity

  • Power BI Report Servers

  • Advanced Analytics in Power BI using R & Python

 

 

Who should take this course?

 

  • Project Manager

  • Database programmer

  • Web Developer

  • Architect

Note: Students can combine modules to get a combo discount.

 

 

1/11

Exploiting complex data types

  • PL/SQL tables, nested tables, VARRAYs

  • Collection types

  • Stepping through dense and nonconsecutive collections

Bulk binding for high performance

  • Moving data into and out of PL/SQL blocks

  • BULK COLLECT INTO and FORALL

  • BULK cursor attributes

  • BULK EXCEPTION handling

  • Invoking Native Dynamic SQL

Finessing the compiler
  • The EXECUTE IMMEDIATE statement

  • The RETURNING INTO clause

Types of dynamic SQL

  • Building SQL statements during runtime

  • Auto generating standard code

Package tips and techniques

  • Package structure: SPEC and BODY

  • Eliminating dependency problems

  • Overloading for polymorphic effects

  • Evaluating application frameworks

  • Declaring and using persistent global variables

Database Design/Architect
  • Database Design  (ERD)

  • Normalization vs De-Normalization

  • Conceptual vs Logical vs Physical Design

  • Capacity  Planning and Forecasting 

  • OLTP vs OLAP design concepts

Database Administration

  • Install, Configure and Administer 

  • Implement Security

  • Backup and Restore procedure

  • Disaster Recovery Planning

  • Replication, Mirroring concepts

  • Performance Tuning 

Staffing Support
  • Resume Preparation

  • Mock Interview Preparation

  • Phone Interview Preparation

  • Face to Face Interview Preparation

  • Project/Technology Preparation

  • Internship with internal project work

  • Externship with client project work

Our Salient Features:
  • Hands-on Labs and Homework

  • Group discussion and Case Study

  • Course Project work

  • Regular Quiz / Exam

  • Regular support beyond the classroom

  • Students can re-take the class at no cost

  • Dedicated conf. rooms for group project work

  • Live streaming for the remote students

  • Video recording capability to catch up the missed class