MySQL Database Development: Manipulating Data

MySQL    |    Beginner
  • 12 videos | 52m 25s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 80 users Rating 4.4 of 80 users (80)
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

  • 4m 40s
    After completing this video, you will be able to describe the use of the INSERT, UPDATE, and DELETE DML statements, and recognize their basic syntax. FREE ACCESS
  • 5m 3s
    Find out how to work with the INSERT statement to add new data to your MySQL tables. FREE ACCESS
  • Locked
    3.  Basic UPDATE Statements
    3m 6s
    During this video, you will learn how to work with the UPDATE statement to modify existing data in your MySQL tables. FREE ACCESS
  • Locked
    4.  DELETE Statements
    3m 56s
    In this video, you will learn how to use the DELETE statement to remove existing data from your MySQL tables. FREE ACCESS
  • Locked
    5.  Advanced INSERT Statements
    5m 6s
    In this video, you will learn how to use additional INSERT options to add new data to your MySQL tables. FREE ACCESS
  • Locked
    6.  Advanced UPDATE Statements
    4m 48s
    During this video, you will learn how to use additional UPDATE options to modify existing data in your MySQL tables. FREE ACCESS
  • Locked
    7.  Inserting and Deleting Data
    4m 57s
    In this video, you will learn how to use MySQL Workbench to insert and delete data in your tables. FREE ACCESS
  • Locked
    8.  Viewing and Editing Data
    1m 58s
    In this video, find out how to use MySQL Workbench to view and modify data in your tables. FREE ACCESS
  • Locked
    9.  Filtering Data
    3m 18s
    In this video, you will learn how to use MySQL Workbench to retrieve data from your tables using filters. FREE ACCESS
  • Locked
    10.  Exporting Data
    4m 53s
    During this video, you will learn how to use MySQL Workbench to export data from your tables to an external file. FREE ACCESS
  • Locked
    11.  Importing Data
    5m 1s
    Find out how to use MySQL Workbench to import data into your tables. FREE ACCESS
  • Locked
    12.  Exercise: Using DML Statements and MySQL Workbench
    5m 41s
    In this video, you will learn how to manipulate data using the DML statements and MySQL Workbench. 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 Querying SQL Databases: Learning SQL Using Prompt Engineering
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Journey How to Transform Tables with SQL
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Book Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course MySQL Database Development: Introduction
Rating 4.6 of 109 users Rating 4.6 of 109 users (109)
Course MySQL Database Development: Query & Performance Optimization
Rating 4.6 of 33 users Rating 4.6 of 33 users (33)
Course MySQL Database Development: SELECT Statement & Operators
Rating 4.8 of 43 users Rating 4.8 of 43 users (43)