Oracle SQL Developer for Absolute Beginners

Name: Oracle SQL Developer for Absolute Beginners
Rating: 4.1 (46 reviews)

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
Learn how to download and install Oracle SQL Developer for Windows with JDK included, from Oracle.com, including licensing, extracting the zip, and launching the application.
Connect database using SQL Developer10:45
Learn to connect to any database using Oracle SQL Developer by creating a named connection with username, password, hostname, port, and SID, then test and save the setup.
Navigating tables inside SQL Developer13:05
Navigate the Oracle SQL Developer interface to explore HR schema objects, view and sort table data, inspect columns and constraints, and run and filter queries in the worksheet.
Create new table inside database10:57
Create a new table in a schema using the Oracle SQL Developer interface, define columns with types and constraints, review the generated DDL, insert records, and manage constraints and commits.
Changing table definition5:24
Discover how to change table definitions in Oracle SQL Developer by adding and renaming columns, and managing constraints, indexes, and privileges with a graphical interface.
Adding table constraints3:02
Add primary key and not null constraints to a table using the constraints editor, select columns, and choose check, unique, and foreign key options to enforce data integrity.
Export data from SQL developer to excel4:06
Export table data from Oracle SQL Developer to csv by using the export option, including headers, and understand comma separated values and line terminators for easy application import.
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
Learn how to access data inside tables by dragging a table from the connections tab to the worksheet, generating a select statement, and displaying the full table data.
Creating reports in SQL Developer4:04
Save and reuse queries by creating reports in Oracle SQL Developer, store them under user defined reports, select a schema, and quickly view results for salary conditions.
Creating and executing PL/SQL3:06
Create and run a simple pl/sql block that prints hello world using dbms_output.put_line, enable server output, and execute blocks against the hr schema.

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