What you'll learn

Download and install Oracle SQL Developer 18.2 version
Connect remote database on cloud and navigate tables inside schema
CREATE TABLE IF NOT EXISTS using GUI interface inside SQL Developer
Change table definition and modify table constraints
Export data from Oracle table to csv fil and much more

Requirements

Basic SQL knowledge and understanding of database
Familiar with database concepts and database administration

Description

Oracle SQL Developer is a free graphical tool that enhances productivity and simplifies database development tasks. Using SQL Developer, you can browse database objects, run SQL statements, edit and debug PL/SQL statements and run reports, whether provided or created.

Your first step in becoming an Oracle SQL Developer

Developed in Java, SQL Developer runs on Windows, Linux and the Mac OS X. This is a great advantage to the increasing number of developers using alternative platforms. Multiple platform support also means that users can install SQL Developer on the Database Server and connect remotely from their desktops, thus avoiding client server network traffic.

This course provides you with concepts and usages of SQL Developer

Download and install SQL developer 18.2 version on windows

Connect remote database on cloud and navigate tables inside schema

CREATE TABLE IF NOT EXISTS using GUI interface inside SQL Developer

Change table definition and modify table constraints

Export data from Oracle table to csv fil and much more

You can connect to any target Oracle database schema using standard Oracle database authentication. Once connected, you can perform operations on objects in the database.

Who is the target audience?

Oracle PL/SQL developers
Oracle database administrators
Database architect