Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Oracle SQL Developer Tool 19c- Mastering Tips & Tricks
Rating: 4.4 out of 5(46 ratings)
244 students
Created byLokanath Giri
Last updated 9/2023
English

What you'll learn

  • Learn the latest version SQL Developer tool - 19c
  • Once mastered the features the team will look you as an Expert
  • Speed-up your coding by using code templates inside the tool
  • Data modeling & generating ERD (Entity Relationship Diagram)
  • Debugging skill - Most sought skill when there is a production issue/bug to fix.
  • Code formatter will help formatting code in seconds saving huge time.
  • Migration of data from Other databases to Oracle
  • Connection to 3rd party databases like - MySQL, SQL Server & Sybase
  • 21c - Multitenant Architecture + Connection to PDB from the Tool
  • Exporting and Importing Reports
  • Use Explain Plan & Auto trace inside the Tool.
  • Creating Different types of Graphs and Reports
  • Advanced features SQL Developer tool

Course content

10 sections • 44 lectures • 5h 49m total length

  • Oracle SQL Developer - Bird's-eye view3:16

    Explore Oracle SQL Developer through a one-stop course covering GUI customization, code formatting, debugging, charts, and reports. Learn data modeling with reverse and forward engineering and cross-database connections.

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


Who this course is for:

  • Database Developers
  • ETL Developers
  • Data Analyst
  • Data Quality Professional - Testing Team
  • Data Scientist

Report abuse