Scribd
Upload
29 views47 pages

SQL Course: Mastering SELECT Queries

The document provides an overview of SQL components, specifically focusing on the SELECT query used to retrieve customer data from a database. It outlines various SQL command types including DQL, DDL, and DML, and lists specific commands such as SELECT, CREATE, and INSERT. Additionally, it includes examples of SQL statements and their components, emphasizing the structure and functionality of SQL queries.

Uploaded by

bencarbon17
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
29 views47 pages

SQL Course: Mastering SELECT Queries

The document provides an overview of SQL components, specifically focusing on the SELECT query used to retrieve customer data from a database. It outlines various SQL command types including DQL, DDL, and DML, and lists specific commands such as SELECT, CREATE, and INSERT. Additionally, it includes examples of SQL statements and their components, emphasizing the structure and functionality of SQL queries.

Uploaded by

bencarbon17
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 47

SQL COMPONENTS

Baraa Khatib Salkini


YouTube | DATA WITH BARAA
SQL Course | SELECT Query
-- Retrieve Customers Data
SELECT
name,
LOWER(country)

FROM customers
WHERE country = 'Italy'

SQL Course | SELECT Query |SQL Components


SQL STATEMENT

-- Retrieve Customers Data


SELECT
name,
LOWER(country)

FROM customers
WHERE country = 'Italy'

SQL Course | SELECT Query |SQL Components


Comment -- Retrieve Customers Data
SELECT
name,
LOWER(country)

FROM customers
WHERE country = 'Italy'

SQL Course | SELECT Query |SQL Components


-- Retrieve Customers Data
SELECT
name,
Clauses LOWER(country)

FROM customers
WHERE country = 'Italy'

SQL Course | SELECT Query |SQL Components


-- Retrieve Customers Data
SELECT
name,
Keywords LOWER(country)

FROM customers
WHERE country = 'Italy'

SQL Course | SELECT Query |SQL Components


-- Retrieve Customers Data
SELECT
name,
Function
LOWER(country)

FROM customers
WHERE country = 'Italy'

SQL Course | SELECT Query |SQL Components


-- Retrieve Customers Data
SELECT
name,
LOWER(country) identifiers

FROM customers
WHERE country = 'Italy'

SQL Course | SELECT Query |SQL Components


-- Retrieve Customers Data
SELECT
name,
LOWER(country) Operator

FROM customers
WHERE country = 'Italy'

SQL Course | SELECT Query |SQL Components


-- Retrieve Customers Data
SELECT
name,
LOWER(country) Value

FROM customers
WHERE country = 'Italy'

SQL Course | SELECT Query |SQL Components


QUERY DATA
SELECT STATEMENT

Baraa Khatib Salkini


YouTube | DATA WITH BARAA
SQL Course | SELECT Query
Types
SQL Commands

DQL DDL DML


Data Query Data Definition Data Manipulation
Language Language Language

SELECT CREATE INSERT

DROP UPDATE

ALTER DELETE

SQL Course | SELECT Query


Types
SQL Commands

DQL DDL DML


Data Query Data Definition Data Manipulation
Language Language Language

SELECT CREATE INSERT

DROP UPDATE

ALTER DELETE

SQL Course | SELECT Query


SQL Course | SELECT Query
SQL Course | SELECT Query
SQL Course | SELECT Query | SELECT ALL
SQL Course | SELECT Query | SELECT ALL
SQL Course | SELECT Query | SELECT Few Columns
SQL Course | SELECT Query | SELECT Few Columns
SQL Course | SELECT Query | WHERE
SQL Course | SELECT Query | WHERE
SQL Course | SELECT Query | ORDER BY
SQL Course | SELECT Query | ORDER BY
SQL Course | SELECT Query | ORDER BY
SQL Course | SELECT Query | GROUP BY
SQL Course | SELECT Query | GROUP BY
SQL Course | SELECT Query | HAVING
SQL Course | SELECT Query | HAVING
SQL Course | SELECT Query | HAVING
SQL Course | SELECT Query | DISTINCT
SQL Course | SELECT Query | DISTINCT
SQL Course | SELECT Query | TOP
SQL Course | SELECT Query | TOP
SQL Course | SELECT Query
BONUS
Sketches

Baraa Khatib Salkini


YouTube | DATA WITH BARAA
SQL Course | SELECT Query
SQL Course | SELECT Query
SQL Course | SELECT Query
SQL Course | SELECT Query
SQL Course | SELECT Query
SQL Course | SELECT Query
SQL Course | SELECT Query
SQL Course | SELECT Query
SQL Course | SELECT Query
SQL Course | SELECT Query
SQL Course | SELECT Query
SQL Course | SELECT Query

You might also like