Oracle SQL Developer Tool 19C

Query formatting | Reports & Charts | Data modeling | debugging | Be an Efficient and Professional Developer !!

Why Oracle SQL Developer is so popular?

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.
  • And many more !!.

Course Content

  • Oracle SQL Developer – Bird’s-eye view –> 1 lecture • 3min.
  • Let’s Start –> 3 lectures • 17min.
  • Essential GUI Settings –> 3 lectures • 7min.
  • SQL Developer Basics –> 15 lectures • 1hr 37min.
  • SQL Developer Advanced –> 6 lectures • 33min.
  • Data Modeling –> 2 lectures • 23min.
  • Graphs & Reports –> 5 lectures • 30min.
  • Additional Tips & Tricks –> 4 lectures • 19min.
  • Bonus Section – An ETL Project –> 2 lectures • 27min.

Oracle SQL Developer Tool 19C

Requirements

  • Should have knowledge on SQL and PL/SQL.

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 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) 
Get Tutorial