New Training: Structured Query Language (SQL) Introduction
| new skills - Team Nuggets

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.

Download

Download

Ultimate Systems Administration Cert Guide

A 158-page guide to every Microsoft, VMware, Citrix, AWS, Google, and Linux certification, and how they fit into your career.

By submitting this form you agree that you have read, understood, and are able to consent to our privacy policy.

LEARNING ON MOBILE

Learn anytime anywhere with our mobile apps.

I have read and understood the privacy policy and am able to consent to it.

© 2021 CBT Nuggets. All rights reserved. Terms | Privacy Policy | Accessibility | Sitemap | 1550 Valley River Drive, Eugene, OR 97401 | 541-284-5522
CBT Nuggets