Genre: eLearning | Language: English | Duration: 1 hours | Size: 561 MB
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
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.