Oracle SQL Developer Tool 19c- Mastering Tips & Tricks

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

Created by: Global Trainers
Technical Architect

What Will I 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

Requirements

• Should have knowledge on SQL and PL/SQL

Target audience

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