SQL Developer
Oracle 12c
| Beginner
- 16 videos | 1h 1m 13s
- 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 Developercreate a database connection within SQL Developerbrowse through the database objects and structures within SQL Developercreate a new schema object using SQL Developeruse SQL Worksheet to execute SQL and PL/SQL statements and format SQL codework with SQL statements and scripts using SQL Developerexecute saved script files using various methods in SQL Developeruse snippets in SQL Developer
-
use the Recycle Bin in SQL Developer to recover or purge dropped objectsdebug procedures and functionsdisplay built-in database reports in SQL Developercreate a user-defined report in SQL Developer and organize them in foldersconfigure links to external tools and search engines within SQL Developercustomize the SQL Developer interface and environmentuse the Data Modeler in SQL Developerconnect 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 on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.