InfoTekGuide

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.