Oracle SQL Developer Tool 19c- Mastering Tips & Tricks

Oracle SQL Developer Tool 19c- Mastering Tips & Tricks udemy course

UI settings | Query formatting | Data modeling | Debugging | Reports & Charts | Journey from Basic to Expert Developer!!

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 too l!

• 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, Font's 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 & PL/SQL 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)