SQL Developer
Oracle 12c
| Beginner
- 16 Videos | 1h 7m 43s
- Includes Assessment
- Earns a Badge
Oracle offers a free integration development environment, SQL Developer. Learn about SQL Developer, including creating connections, using SQL Worksheet, debugging, modeling data, and linking to external tools.
WHAT YOU WILL LEARN
-
list the key features of Oracle SQL Developer
create a database connection within SQL Developer
browse through the database objects and structures within SQL Developer
create a new schema object using SQL Developer
use SQL Worksheet to execute SQL and PL/SQL statements and format SQL code
work with SQL statements and scripts using SQL Developer
execute saved script files using various methods in SQL Developer
use snippets in SQL Developer -
use the Recycle Bin in SQL Developer to recover or purge dropped objects
debug procedures and functions
display built-in database reports in SQL Developer
create a user-defined report in SQL Developer and organize them in folders
configure links to external tools and search engines within SQL Developer
customize the SQL Developer interface and environment
use the Data Modeler in SQL Developer
connect to the database and browse the tables in the HR schema using SQL Developer
IN THIS COURSE
-
1.Introduction to SQL Developer3m 51s
-
2.Creating a Database Connection4m 4s
-
3.Browsing Database Objects and Structures3m 37s
-
4.Creating a New Schema Object5m 20s
-
5.Using the SQL Worksheet4m 1s
-
6.Working with SQL Statements and Scripts3m 16s
-
7.Executing Saved Script Files3m 5s
-
8.Using Snippets3m 30s
-
9.Using the Recycle Bin3m 49s
-
10.Debugging Procedures and Functions3m 19s
-
11.Database Reporting3m 16s
-
12.Creating a User-defined Report3m 56s
-
13.Linking to External Tools and Search Engines3m 13s
-
14.Setting Preferences within SQL Developer4m 49s
-
15.Data Modeler in SQL Developer2m 39s
-
16.Exercise: Browse the HR Schema Using SQL Developer5m 29s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.
