SQL Developer

Oracle 12c    |    Beginner
  • 16 videos | 1h 1m 13s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 583 users Rating 4.5 of 583 users (583)
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

  • Locked
    1.  Introduction to SQL Developer
    3m 51s
    Upon completion of this video, you will be able to list the key features of Oracle SQL Developer FREE ACCESS
  • Locked
    2.  Creating a Database Connection
    4m 4s
    In this video, learn how to create a database connection in SQL Developer. FREE ACCESS
  • Locked
    3.  Browsing Database Objects and Structures
    3m 37s
    In this video, you will browse through the database objects and structures within SQL Developer. FREE ACCESS
  • Locked
    4.  Creating a New Schema Object
    5m 20s
    During this video, you will learn how to create a new schema object using SQL Developer. FREE ACCESS
  • Locked
    5.  Using the SQL Worksheet
    4m 1s
    During this video, you will learn how to use the SQL Worksheet to execute SQL and PL/SQL statements and format SQL code. FREE ACCESS
  • Locked
    6.  Working with SQL Statements and Scripts
    3m 16s
    In this video, you will work with SQL statements and scripts using SQL Developer. FREE ACCESS
  • Locked
    7.  Executing Saved Script Files
    3m 5s
    Learn how to execute saved script files using various methods in SQL Developer. FREE ACCESS
  • Locked
    8.  Using Snippets
    3m 30s
    In this video, learn how to use code snippets in SQL Developer. FREE ACCESS
  • Locked
    9.  Using the Recycle Bin
    3m 49s
    Learn how to use the Recycle Bin in SQL Developer to recover or delete dropped objects. FREE ACCESS
  • Locked
    10.  Debugging Procedures and Functions
    3m 19s
    In this video, learn how to debug procedures and functions. FREE ACCESS
  • Locked
    11.  Database Reporting
    3m 16s
    In this video, you will learn how to display built-in database reports in SQL Developer. FREE ACCESS
  • Locked
    12.  Creating a User-defined Report
    3m 56s
    In this video, find out how to create a user-defined report in SQL Developer and organize them in folders. FREE ACCESS
  • Locked
    13.  Linking to External Tools and Search Engines
    3m 13s
    Learn how to configure links to external tools and search engines within SQL Developer. FREE ACCESS
  • Locked
    14.  Setting Preferences within SQL Developer
    4m 49s
    During this video, you will learn how to customize the SQL Developer interface and environment to better suit your needs. FREE ACCESS
  • Locked
    15.  Data Modeler in SQL Developer
    2m 39s
    Learn how to use the Data Modeler in SQL Developer. FREE ACCESS
  • Locked
    16.  Exercise: Browse the HR Schema Using SQL Developer
    5m 29s
    Find 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.

YOU MIGHT ALSO LIKE

Rating 4.6 of 63 users Rating 4.6 of 63 users (63)
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 203 users Rating 4.6 of 203 users (203)
Rating 4.6 of 182 users Rating 4.6 of 182 users (182)