Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

In this online course, you’ll learn how to retrieve, store, modify, delete, insert, and update data with the SQL data manipulation language (DML).

DML commands give you control over the information inside your database and the ability to change that data, allowing you to greatly expand your basic SQL toolkit.

This online course is perfect for SQL beginners, aspiring database administrators (DBAs), and programmers working with databases. Read on to learn more about what functions are covered and who else will benefit from completing the course.

Requirements:

Learn How To:

  • Work with SQL UPDATE, INSERT, and DELETE commands.
  • Deal with auto-filling values and combine SQL data manipulation. commands with IDENTITY, SEQUENCE, and NEWID().
  • Combine SQL DML commands with NULLs.
  • Combine SQL DML commands with JOINs.
  • Modify data using default values of columns.
  • Perform CRUD operations—the most important part of DML operations.

Who Should Take This Course?

  • Users who completed the SQL Basics course.
  • Aspiring Database Administrators (DBAs).
  • Software testers.
  • Programmers working with databases.
  • Business professionals dealing with SQL.
  • SQL enthusiasts.
  • Anyone who’d like to improve and refine their SQL DML skills.

What's in It for Me?

  • 52 interactive exercises. Learn at your own pace, from anywhere and anytime. Interact with hands-on exercises for improved retention.
  • Lifetime access to the course. When you purchase the course, you’ll get instant personal access to all of its content.
  • Certificate of completion. After you successfully finish all of the exercises, you’ll get a downloadable PDF certificate to showcase your accomplishment.
  • 30-day money-back guarantee. If you’re not satisfied with the quality of the course, you can get a refund within 30 days of your purchase.
  • Hints for the exercises. You can ask questions and share insights with other members of our community through the Disqus tab.
    Start for free
    Gift this course

    Bundle deals

    86%
    off

    Reg. price
    $1442

    One to Rule 'Em All

    Includes 36 courses Python Basics. Part 1, Python Basics. Part 2, Python Basics. Part 3, Python Data Structures in Practice, Built-in Algorithms in Python, Working with Strings in Python, SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Basic SQL Reports, Window Functions, Revenue Trend Analysis in SQL, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, Statistics 101, SQL Basics in MS SQL Server, How to Insert, Update, or Delete Data in MS SQL Server, Common Functions in MS SQL Server, Revenue Trend Analysis in SQL Server, Creating Basic SQL Reports in SQL Server, Window Functions in MS SQL Server, Recursive Queries in MS SQL Server, GROUP BY Extensions in MS SQL Server, Introduction to Python for Data Science, How to Read and Write CSV Files in Python, How to Read and Write JSON Files in Python, SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS, How to Read and Write Excel Files in Python

    Bundle price $199

    40 hours left at this price!

    Buy bundle

    67%
    off

    Reg. price
    $369

    SQL Complete Track

    Includes 9 courses SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Window Functions, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, PostGIS

    Bundle price $119

    40 hours left at this price!

    Buy bundle

    Table of contents

    Progress: 0% completed 0 of 52 exercises done

    1. The basics of INSERT, UPDATE, and DELETE

    Learn the basic data manipulation operations in SQL: INSERT, UPDATE and DELETE

    More details Less
    Start now

    0% completed 0 of 18 exercises done

    2. Advanced features of INSERT, UPDATE, and DELETE

    Practice advanced version of data manipulation operations in SQL.

    More details Less
    Start now

    0% completed 0 of 15 exercises done

    Summary

    3. Working with DEFAULT values in INSERT and UPDATE

    Learn how you can use default values in a database.

    More details Less
    Start now

    0% completed 0 of 10 exercises done

    Summary

    4. Final Quiz

    Check your knowledge of data manipulation in this quiz.

    More details Less
    Start now

    0% completed 0 of 9 exercises done

    Reviews

    Average rating

    3.3/566.66666666666667 (3)

    Details

    5 Stars 34%
    4 Stars 33%
    3 Stars 0%
    2 Stars 0%
    1 Stars 33%
      Load more reviews