Manipulating Data

MySQL 8.0    |    Beginner
  • 12 Videos | 57m 55s
  • Includes Assessment
  • Earns a Badge
Likes 24 Likes 24
Data Manipulation Language (DML) statements are used to manipulate the actual data in MySQL databases. Explore the syntax and use of the most common DML statements, including INSERT, UPDATE, and DELETE.

WHAT YOU WILL LEARN

  • describe the use of the INSERT, UPDATE, and DELETE DML statements, and recognize their basic syntax
    work with the INSERT statement to add new data to your MySQL tables
    work with the UPDATE statement to modify existing data in your MySQL tables
    work with the DELETE statement to remove existing data from your MySQL tables
    use additional INSERT options to add new data to your MySQL tables
    use additional UPDATE options to modify existing data in your MySQL tables
  • use MySQL Workbench to insert and delete data in your tables
    use MySQL Workbench to view and modify existing data in your tables
    use MySQL Workbench to retrieve data from your tables using filters
    use MySQL Workbench to export existing data in your tables to an external file
    use MySQL Workbench to import existing data into your tables
    manipulate data using the DML statements and MySQL Workbench

IN THIS COURSE

  • Playable
    1. 
    Data Manipulation Language (DML) Statements
    4m 40s
    UP NEXT
  • Playable
    2. 
    Basic INSERT Statements
    5m 3s
  • Locked
    3. 
    Basic UPDATE Statements
    3m 6s
  • Locked
    4. 
    DELETE Statements
    3m 56s
  • Locked
    5. 
    Advanced INSERT Statements
    5m 6s
  • Locked
    6. 
    Advanced UPDATE Statements
    4m 48s
  • Locked
    7. 
    Inserting and Deleting Data
    4m 57s
  • Locked
    8. 
    Viewing and Editing Data
    1m 58s
  • Locked
    9. 
    Filtering Data
    3m 18s
  • Locked
    10. 
    Exporting Data
    4m 53s
  • Locked
    11. 
    Importing Data
    5m 1s
  • Locked
    12. 
    Exercise: Using DML Statements and MySQL Workbench
    5m 41s

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

Likes 18 Likes 18  
Likes 66 Likes 66  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 66 Likes 66  
Likes 38 Likes 38  
COURSE SOLID & GRASP
Likes 3218 Likes 3218