About This Chapter
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
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.
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.
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.
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.
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.
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.
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.
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.
Other chapters within the Computer Science 204: Database Programming course
- Intro to Relational Database Management Systems
- Creating & Managing Database Tables
- Populating & Retrieving Data in Databases
- Data Queries in Multiple Tables Using Joins
- Data Queries in Multiple Tables Using Subqueries
- Views & Indexes in Databases
- Modifying Tables in Databases
- Manipulating Large Data Sets in Databases
- Developing & Using Regular Expressions in Databases
- Database Security