Oracle SQL Developer for Absolute Beginners

Everything you need to know about Oracle SQL Developer tool

Created byArun Kumar

Last updated 9/2018

English

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 using GUI interface inside SQL Developer
Change table definition and modify table constraints
Export data from Oracle table to csv fil and much more

Course content

1 section • 13 lectures • 1h 13m total length

Before You Start0:17
Introduction to Oracle SQL Developer tool7:07
Discover Oracle SQL Developer, a free developer tool to write, run, and debug Oracle code, install on Windows, connect to cloud databases, navigate tables, and generate reports.
How to download SQL Developer for windows3:48
Connect database using SQL Developer10:45
Navigating tables inside SQL Developer13:05
Create new table inside database10:57
Changing table definition5:24
Adding table constraints3:02
Export data from SQL developer to excel4:06
How to save your sql worksheets5:00
Learn how to save and reopen your sql worksheets, use the save icon or Ctrl+click, name and store morning queries on your desktop, and reopen them against the correct schema.
Accessing table data2:20
Creating reports in SQL Developer4:04
Creating and executing PL/SQL3:06

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 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 this course is for:

Oracle PL/SQL developers
Oracle database administrators
Database architect