Ch 4: Manipulating Data in Databases

About This Chapter

If you're looking for a way to review manipulating data in databases quickly and easily, look no further than this informative and easy-to-follow chapter. Our bite-sized and mobile-friendly lessons provide you with a convenient way to finish your homework or catch up in class.

Manipulating Data in Databases - Chapter Summary

In this chapter, we've provided a collection of lessons on manipulating data in databases. Work through subjects including data manipulation language (DML) and its commands and examples at your own pace. Along with each lesson, you'll find a self-assessment quiz that gives you a good sense for how well you understand the topics or how you might do on an upcoming exam. These resources are accessible to you 24 hours a day on any tablet, smartphone or computer so you can study at your convenience. Once you finish this chapter, you should be able to:

  • Give a definition and example of DML
  • Outline the commands for DML
  • Identify the UPDATE and DELETE statement in SQL
  • Explain TCL and how to control transactions in SQL
  • Provide an explanation for a SQL TRUNCATE string and table
  • Understand how to manipulate data in database programming

7 Lessons in Chapter 4: Manipulating Data in Databases
Test your knowledge with a 30-question chapter practice test
Data Manipulation Language (DML): Definition & Example

1. Data Manipulation Language (DML): Definition & Example

Data Manipulation Language is actually a way to talk to databases that was first used by computers before being adapted by humans via SQL. Sound backwards? Read this lesson to find out more.

Data Manipulation Language (DML) Commands

2. Data Manipulation Language (DML) Commands

This lesson will cover data manipulation language (DML) commands in database management systems. These are commands that query, modify, and delete data in a database; they cannot modify the structure.

SQL: UPDATE Statement

3. SQL: UPDATE Statement

The SQL update statement allows us to manipulate data in a relational database. It is a powerful statement that lets us make multiple changes simultaneously. In this lesson, we'll learn the syntax for this command, and also look at an example of it in use.

SQL: DELETE Statement

4. SQL: DELETE Statement

Explore how and what the SQL Delete statement does. The SQl Delete is only used in large, interconnected, relational databases where permanent removal is warranted. There is no trash can from which to recover records or files if it is implemented.

SQL TRUNCATE String: Tutorial & Overview

5. SQL TRUNCATE String: Tutorial & Overview

SQL offers some nifty commands to manipulate and work with strings. In this lesson, we'll discuss three commands, each with their own uses, that can reduce strings to an appropriate size.

SQL TRUNCATE Table: Tutorial & Explanation

6. SQL TRUNCATE Table: Tutorial & Explanation

This lesson will cover the SQL TRUNCATE statement, providing a brief tutorial of the command and some code examples from various database management systems.

Practical Lesson for Database Programming: Manipulating Data

7. Practical Lesson for Database Programming: Manipulating Data

The lesson is all about updating and changing data. All databases are dynamic and changes to data are frequent and inevitable - new records need to be added, stale records need to be deleted and existing records need to be updated. In this lesson, you will get hands on details about manipulating data using SQL.

Chapter Practice Exam
Test your knowledge of this chapter with a 30 question practice chapter exam.
Not Taken
Practice Final Exam
Test your knowledge of the entire course with a 50 question practice final exam.
Not Taken

Earning College Credit

Did you know… We have over 160 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Support