SQL Basics
  • Introduction
  • Basic Syntax
  • Basic Select Statements
  • Table Variables & Set Operators
  • Subqueries in the Where Clause
    • Using Operators in a Subquery
  • Subqueries in the From & Select Clause
  • The 'Join' Family Operators
    • Inner Join
    • Natural Join
    • Outer Join
  • Aggregation
    • Aggregation Functions
    • Aggregation Clauses
  • Data Modification Statements
    • Insert Commands
    • Delete Commands
    • Update Commands
Powered by GitBook
On this page
  • What is Structured Query Language?
  • Two Parts of SQL

Was this helpful?

Basic Syntax

What is Structured Query Language?

Structured Query Language, or SQL, is a special-purpose programming language used to manage data within a relational database management system (RDBMS).

You will find that there are multiple ways to write the same query in SQL, and some ways are better than others.

Two Parts of SQL

Data Definition Language (DDL): DDL includes commands to create a table, to drop a table, or create and drop other aspects of a database.

Data Manipulation Language (DML): DML includes commands that are used to query and modify a database. It includes the select statement for querying the database, and the insert, update, and delete statements, all for modifying the database.

PreviousIntroductionNextBasic Select Statements

Last updated 1 year ago

Was this helpful?