What you'll learn

Working with SQL Developer tool

Advanced features SQL Developer tool

Creating Different types of Graphs and Reports

Data modeling & generating ERD (Entity Relationship Diagram)

Exporting and Importing Reports

Debugging SQL and PL/SQL code

Migration of data from Other databases to Oracle

Many useful tips & tricks

!

Requirements

Should have knowledge on SQL and PL/SQL

Description

Why Oracle SQL Developer is so popular?

Oracle SQL Developer is mostly used tool used by 5million Oracle Developers. There are many features integrated & supported by Oracle SQL Developer, which makes it is a versatile tool !!

Integrated Oracle Data modeler

Integrated Migration workbench

Approximately 295+ built-in reports for help Developer & DBA folks

It has its own reporting features. (Master detail, Drilldown, Gauge & 50+ varieties of Charts ie- Pie & Bar )

Integrated SQL*Plus command interface.

Can connect to 3rd party databases using different drivers

Can connect to Oracle Cloud database

Integrated file history and change logging features

----------------------------------

This is one stop shop course !!

----------------------------------

What you learn in this course.

Installation & setup to start working with the tool

Learning different components of Oracle SQL Developer tool

Creating different types of objects (Table, View, Procedure etc.)

Learn GUI setting like chag language of the tool, Fonts size increase, Worksheet & Result-set font type/size change.

Code formatting techniques

Mostly used short-cuts

Exporting data into different formats (CSV, HTML, INSERT scripts etc.)

Technique how to debug SQL & PLSQL code

Connecting to third party databases like (Sybase, SQL Server, MySQL etc.)

Migration of data from MySQL to Oracle

How to create & schedule Oracle job

Explain plan & Auto trace reports

Finding the difference between two schemas

Data modeling using both technique (Forward eeering & Reverse Eeering)

Creating Ad-hoc reports & Graphs (Simple, Master-detail, Drilldown Reports + Gauge & Charts)

Who this course is for:

Database Developers

ETL Developers

Data Analyst & Data scientist



DOWNLOAD
uploadgig


rapidgator


nitroflare