Oracle SQL Developer Tool 19c- Mastering Tips & Tricks

Oracle SQL Developer Tool 19c- Mastering Tips & Tricks, available at $29.99, has an average rating of 4.15, with 44 lectures, based on 43 reviews, and has 215 subscribers.

You will learn about 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 This course is ideal for individuals who are Database Developers or ETL Developers or Data Analyst or Data Quality Professional – Testing Team or Data Scientist It is particularly useful for Database Developers or ETL Developers or Data Analyst or Data Quality Professional – Testing Team or Data Scientist.

Enroll now: Oracle SQL Developer Tool 19c- Mastering Tips & Tricks

Summary

Title: Oracle SQL Developer Tool 19c- Mastering Tips & Tricks

Price: $29.99

Average Rating: 4.15

Number of Lectures: 44

Number of Published Lectures: 44

Number of Curriculum Items: 44

Number of Published Curriculum Objects: 44

Original Price: ₹4,499

Quality Status: approved

Status: Live

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

Who Should Attend

Database Developers
ETL Developers
Data Analyst
Data Quality Professional – Testing Team
Data Scientist

Target Audiences

Database Developers
ETL Developers
Data Analyst
Data Quality Professional – Testing Team
Data Scientist

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)

Course Curriculum

Chapter 1: Oracle SQL Developer – Bird's-eye view

Lecture 1: Oracle SQL Developer – Bird's-eye view

Chapter 2: Let's Start

Lecture 1: SQL Developer Installation

Lecture 2: Creating our first database connection

Lecture 3: Understanding the different components of the tool

Chapter 3: Essential GUI Settings

Lecture 1: Change font size of GUI

Lecture 2: Change font size of Worksheet and Results' Grid

Lecture 3: Grid Layout or Zebra Pattern for Results' Grid

Chapter 4: SQL Developer Basics

Lecture 1: How to Navigate to Worksheet?

Lecture 2: Create Database Objects (Table, View, Procedure)

Lecture 3: Reset to Factory Settings

Lecture 4: Color formatting of the connections

Lecture 5: Code Formatting

Lecture 6: Use code Snippet and make your own Code template

Lecture 7: Short-cuts

Lecture 8: Grouping connections

Lecture 9: Generate CSV & Insert script File

Lecture 10: Generate HTML file

Lecture 11: Line Gutter

Lecture 12: SQL History features

Lecture 13: Finding Dependencies of database objects

Lecture 14: Debug your PL/SQL code

Lecture 15: Debug – Watches

Chapter 5: SQL Developer Advanced

Lecture 1: Connecting to MySQL, MS SQL Server, Sybase database

Lecture 2: Data Migration From MySQL to Oracle

Lecture 3: Find the Database difference

Lecture 4: Creating & Scheduling Oracle Jobs

Lecture 5: Checking Explain Plan

Lecture 6: Generate Auto Trace Report.

Chapter 6: Data Modeling

Lecture 1: Creating ERD by Reverse Engineering

Lecture 2: Creating ERD & Generating Scripts

Chapter 7: Graphs & Reports

Lecture 1: Master Detail & Drill Down Reports

Lecture 2: Charts (PI & Bar)

Lecture 3: Guage Reports

Lecture 4: Export & Import Reports in XML format

Lecture 5: Generate & Share HTML Report

Chapter 8: Additional Tips & Tricks

Lecture 1: How to Change Language of tool?

Lecture 2: Navigation Filter

Lecture 3: Export & Import database connections

Lecture 4: Add & Remove Features

Chapter 9: Bonus 01: An ETL Project

Lecture 1: BRD (Business Requirement Document) Discussion

Lecture 2: Project Execution steps, Code Snippet, Procedure, Tables, Scripts etc.

Chapter 10: Bonus 02: Oracle Multitenant Architecture

Lecture 1: Oracle 21C – XE Installation

Lecture 2: Multitenant Architecture overview

Lecture 3: Create PDB & Schema user in 21c

Instructors

Global Trainers
Technical Architect

Rating Distribution

1 stars: 3 votes
2 stars: 0 votes
3 stars: 2 votes
4 stars: 8 votes
5 stars: 30 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu