New Training: Structured Query Language (SQL) Introduction
In this 9-video skill, CBT Nuggets trainer Ben Finkel discusses DML and DDL and covers the primary commands that make up these two elements of SQL in this “bootcamp” approach to learning SQL. Watch this new Azure training.
Learn Azure with one of these courses:
This training includes:
- 9 videos
- 57 minutes of training
You’ll learn these topics in this skill:
- Structured Query Language (SQL) Introduction
- Retrieving Data with Select
- Adding Data with Insert
- Change and Remove Data with Update and Delete
- Filtering Data With the Where Clause
- Literals and Wildcards
- Combine Multiple Tables with Join
- Creating Tables with DDL
- SQL Introduction Summary
4 SQL Flavors You Should Know: DQL, DDL, DCL, DM
SQL stands for "Structured Query Language" and is a domain-specific language designed to manage data. This data can either be held in a relational database management system or stream processed in a relational data stream management system.
The language was created to more effectively interact with large datasets. Some of its key advantages include the ability to access multiple records with a single command and eliminating the requirement to specify how records should be reached (i.e., with or without an index). When using SQL, you'll encounter four primary sublanguages: DQL, DDL, DCL, and DML.
Data Query Language statements are used to execute data queries within schema objects. Using DQL statements allows you to obtain the schema relation based on the query you use.
Data Definition Language statements are used to create or modify database objects (e.g., users, indices, and tables), similar to how you would define database structures or schemas.
Data Control Language statements are used to control access to information within a database. The two most common DCL statements are GRANT and REVOKE.
Data Manipulation Language statements govern how a user interacts with information within a database. Executing tasks like retrieving, inserting, updating, or deleting data requires DML statements.