Data Manipulation Language

Oracle 12c    |    Beginner
  • 14 videos | 1h 3m 26s
  • Earns a Badge
Rating 4.7 of 215 users Rating 4.7 of 215 users (215)
Oracle Database 12c objects contain data, and that data needs to be managed. Learn about manipulating tables by inserting, updating, deleting, and truncating rows.

WHAT YOU WILL LEARN

  • Define the data manipulation language in sql
    Add rows to a table in the database by using the insert sql statement
    Work with null values during the insert sql statement when adding rows to a table
    Work with special values during the insert sql statement when adding rows to a table
    Work with specific date and time values during the insert sql statement when adding rows to a table
    Save commands with substitution variables to a file and execute the commands in the file
    Use the insert sql statement to copy rows from one table to another
  • Change data in a table using the update sql statement
    Change data into two columns using a subquery to update the two columns using the update sql statement
    Change the rows in a table based on a different table using the update sql statement
    Remove rows from a table using the delete sql statement
    Remove rows from a table based on a different table using the delete sql statement
    Use the truncate sql statement to delete all rows from a table
    Insert and update rows in a table

IN THIS COURSE

  • Locked
    1.  Data Manipulation Language
    2m 26s
    In this video, you will learn about the Data Manipulation Language in SQL. FREE ACCESS
  • Locked
    2.  Adding New Rows to Tables using the INSERT Statement
    5m 9s
    In this video, you will add rows to a table in the database by using the INSERT SQL statement. FREE ACCESS
  • Locked
    3.  Inserting Rows with Null Values
    5m 18s
    Find out how to work with NULL values during the INSERT SQL statement when adding rows to a table. FREE ACCESS
  • Locked
    4.  Inserting Rows with Special Values
    2m 35s
    In this video, you will learn how to work with special values during the INSERT SQL statement when adding rows to a table. FREE ACCESS
  • Locked
    5.  Inserting Specific Date and Time Values
    2m 52s
    In this video, you will work with specific date and time values during the insert SQL statement when adding rows to a table. FREE ACCESS
  • Locked
    6.  Creating a Script
    4m 7s
    Learn how to save commands with substitution variables to a file and execute the commands from the file. FREE ACCESS
  • Locked
    7.  Copying Rows from Another Table
    5m 55s
    Learn how to use the INSERT SQL statement to copy rows from one table to another. FREE ACCESS
  • Locked
    8.  Updating Rows in a Table
    7m 1s
    In this video, you will learn how to change data in a table using the UPDATE SQL statement. FREE ACCESS
  • Locked
    9.  Updating Two Columns with a Subquery
    5m 28s
    Find out how to change data into two columns using a subquery. Update the two columns using the UPDATE SQL statement. FREE ACCESS
  • Locked
    10.  Updating Rows Based on Another Table
    4m 35s
    In this video, learn how to change the rows in one table based on data from another table using the UPDATE SQL statement. FREE ACCESS
  • Locked
    11.  Deleting Rows from a Table
    4m 55s
    In this video, find out how to remove rows from a table using the SQL DELETE statement. FREE ACCESS
  • Locked
    12.  Deleting Rows Based on Another Table
    3m 3s
    In this video, you will remove rows from a table based on a different table using the DELETE SQL statement. FREE ACCESS
  • Locked
    13.  TRUNCATE Statement
    3m 7s
    In this video, find out how to use the TRUNCATE SQL statement to delete all rows from a table. FREE ACCESS
  • Locked
    14.  Exercise: Manipulate Data in a Table
    6m 55s
    In this video, you will learn how to insert and update rows in a table. 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

Course Database Fundamentals: Working with SQL Commands
Rating 4.7 of 212 users Rating 4.7 of 212 users (212)
Course Database Fundamentals: Getting Started with SQL
Rating 4.5 of 268 users Rating 4.5 of 268 users (268)
Channel Database Core Concepts

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Database Transactions
Rating 4.6 of 230 users Rating 4.6 of 230 users (230)
Course Customizing Output
Rating 4.7 of 168 users Rating 4.7 of 168 users (168)
Course Working with Joins
Rating 4.6 of 182 users Rating 4.6 of 182 users (182)