SQL: Data Manipulation Language (DML)
Using Structured Query Language to retrieve, filter, and modify data stored in databases.
About This Topic
Using Structured Query Language to retrieve, filter, and modify data stored in databases.
Key Questions
- How can a poorly written SQL query impact the performance of a web application?
- What are the security risks associated with SQL injection and how are they mitigated?
- How does data mining differ from simple data retrieval?
Active Learning Ideas
See all activities→Activities & Teaching Strategies
See all activities
More in Data Representation and Databases
Binary and Hexadecimal Systems
Representing numbers, text, and media using binary systems and understanding overflow errors.
8 methodologies
Representing Text and Images
Understanding character encoding (ASCII, Unicode) and bitmap image representation.
8 methodologies
Introduction to Databases
Understanding the purpose of databases, common database models, and key terminology.
8 methodologies
Designing Simple Database Tables
Students will learn to identify key pieces of information (fields) and organize them into logical tables for a simple database, understanding the concept of primary keys.
8 methodologies
Basic Database Operations (SQL SELECT)
Students will learn to use basic SQL SELECT statements to retrieve specific data from a single database table.
8 methodologies