Importing & Exporting Data

Oracle 12c
  • 11 Videos | 52m 48s
  • Includes Assessment
  • Earns a Badge
Likes 5 Likes 5
An Oracle database administrator is responsible for ensuring data is secure and available. Explore working with Oracle data, including data migration, the Oracle Data Pump, SQL*Loader files, and external tables.

WHAT YOU WILL LEARN

  • describe the functional components used for moving data and the use of Oracle Data Pump in Oracle Database 12c
    work with Oracle Data Pump directory objects, clients, and modes in Oracle Database 12c
    export data using Data Pump in Oracle Database 12c
    import data using Data Pump in Oracle Database 12c
    create a SQL*Loader control file in Oracle Database 12c
    use SQL*Loader to load external data into tables in Oracle Database 12c
  • describe the uses of external tables in Oracle Database 12c
    use ORACLE_LOADER to access external tables in Oracle Database 12c
    create and populate an external table using ORACLE_DATAPUMP in Oracle Database 12c
    use data dictionary views to access information about external tables in Oracle Database 12c
    verify database configuration and export the HR schema in the Oracle Database 12c

IN THIS COURSE

  • Locked
    1. 
    Data Migration and Oracle Data Pump
    6m 39s
  • Locked
    2. 
    Oracle Data Pump Directory Objects and Clients
    5m 27s
  • Locked
    3. 
    Exporting Data with Data Pump
    2m 34s
  • Locked
    4. 
    Importing Data with Data Pump
    3m 48s
  • Locked
    5. 
    Creating a SQL*Loader Control File
    6m 19s
  • Locked
    6. 
    Using SQL*Loader to Load Data
    5m 16s
  • Locked
    7. 
    Using External Tables
    3m 21s
  • Locked
    8. 
    Accessing External Tables
    2m 27s
  • Locked
    9. 
    Populating External Tables
    3m 12s
  • Locked
    10. 
    Using Data Dictionary Views for External Tables
    3m 18s
  • Locked
    11. 
    Exercise: Back up Database and Export HR Schema
    5m 58s

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.

YOU MIGHT ALSO LIKE

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 27 Likes 27  
Likes 9 Likes 9  
Likes 223 Likes 223