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 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 51sUpon completion of this video, you will be able to list the key features of Oracle SQL Developer FREE ACCESS
-
2. Creating a Database Connection4m 4sIn this video, learn how to create a database connection in SQL Developer. FREE ACCESS
-
3. Browsing Database Objects and Structures3m 37sIn this video, you will browse through the database objects and structures within SQL Developer. FREE ACCESS
-
4. Creating a New Schema Object5m 20sDuring this video, you will learn how to create a new schema object using SQL Developer. FREE ACCESS
-
5. Using the SQL Worksheet4m 1sDuring this video, you will learn how to use the SQL Worksheet to execute SQL and PL/SQL statements and format SQL code. FREE ACCESS
-
6. Working with SQL Statements and Scripts3m 16sIn this video, you will work with SQL statements and scripts using SQL Developer. FREE ACCESS
-
7. Executing Saved Script Files3m 5sLearn how to execute saved script files using various methods in SQL Developer. FREE ACCESS
-
8. Using Snippets3m 30sIn this video, learn how to use code snippets in SQL Developer. FREE ACCESS
-
9. Using the Recycle Bin3m 49sLearn how to use the Recycle Bin in SQL Developer to recover or delete dropped objects. FREE ACCESS
-
10. Debugging Procedures and Functions3m 19sIn this video, learn how to debug procedures and functions. FREE ACCESS
-
11. Database Reporting3m 16sIn this video, you will learn how to display built-in database reports in SQL Developer. FREE ACCESS
-
12. Creating a User-defined Report3m 56sIn this video, find out how to create a user-defined report in SQL Developer and organize them in folders. FREE ACCESS
-
13. Linking to External Tools and Search Engines3m 13sLearn how to configure links to external tools and search engines within SQL Developer. FREE ACCESS
-
14. Setting Preferences within SQL Developer4m 49sDuring this video, you will learn how to customize the SQL Developer interface and environment to better suit your needs. FREE ACCESS
-
15. Data Modeler in SQL Developer2m 39sLearn how to use the Data Modeler in SQL Developer. FREE ACCESS
-
16. Exercise: Browse the HR Schema Using SQL Developer5m 29sFind out how to connect to the database and browse the tables in the HR schema using SQL Developer. FREE ACCESS
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.
