Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Oracle SQL Developer Tool 19C

Query formatting | Reports & Charts | Data modeling | debugging | Be an Efficient and Professional Developer !!
3.9
3.9/5
(12 reviews)
57 students
Created by

8.8

CourseMarks Score®

8.6

Freshness

8.1

Feedback

9.1

Content

Platform: Udemy
Video: 4h 30m
Language: English
Next start: On Demand

Table of contents

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 (Sybase, SQL Server, MySQL etc.) 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 changing 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 engineering & Reverse Engineering)
•Creating Ad-hoc reports & Graphs (Simple, Master-detail, Drilldown Reports + Gauge & Charts)

You will learn

✓ Working with SQL Developer tool – 19C
✓ 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
✓ And many more !!

Requirements

• Should have knowledge on SQL and PL/SQL

This course is for

• Database Developers
• ETL Developers
• Data Analyst & Data scientist
Database Architect
I am an OCP – Oracle Certified Professional having 16+ Years of hands-on experience as an Architect in wide spectrum of Oracle-Related technologies in development, maintenance and migration projects in client server (OLTP), data warehousing (OLAP). His expertise is basically on SQL, PLSQL, Data Modeling and ETL etc.
Global Trainers is a training company trying to provide quality and affordable training  Worldwide.
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 4h 30m
Language: English
Next start: On Demand

Students are also interested in