Scribd
Upload
11 views14 pages

SQL Training Overview and Topics

The document outlines a training program for employees on SQL, covering its history, basic concepts, and advanced topics. It includes sections on database structure, SQL commands, performance optimization, and security measures. The training aims to equip participants with the skills to effectively interact with and manage databases using SQL.

Uploaded by

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

SQL Training Overview and Topics

The document outlines a training program for employees on SQL, covering its history, basic concepts, and advanced topics. It includes sections on database structure, SQL commands, performance optimization, and security measures. The training aims to equip participants with the skills to effectively interact with and manage databases using SQL.

Uploaded by

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

CHƯƠNG TRÌNH ĐÀO TẠO NHÂN VIÊN

MÔN HỌC: SQL

QL SQL Overview
S Trình bày: Vũ Quang Sơn

HANOI – NOV, 2015


SQL
History of SQL

• IBM by Donald D. Chamberlin and


Raymond F. Boyce early 1970s called
SEQUEL (Structured English QUEry
Language).

• RDBMS: Standard (ANSI - 1986, ISO -


1987) for Relational DataBase
Management Systems
L
SQ
What is SQL
• SQL: Structured Query Language

• SQL is a database interaction language


allows to add, retrieve, edit, and delete
information stored in databases
What can SQL do?
• Create, alter, drop

• Select, insert, update, delete

• Stored procedures, views SQL SQL

• Set permissions
Why SQL

SQL
• Easy to learn

• Proven technology > 30 years

• Scale well but rapidly (indexes)

• Concurrent, data integrity, multiple


applications
Topics to Study
I. Database Structure
II. SQL Basic
[Link] Intermediate

L
SQ
IV. SQL Advanced
V. MySQL & Security
VI. SQL Performance
S L
I. Database Structure
• The Data Definition Language (DDL)
• Creating a Database
• Table Definitions (create, drop, alter)
• Constraint Definitions (assertions,
domains)
• Aliases and Synonyms (create, drop alias)
• Database Structure
o Single-database Architecture
o Multi-database Architecture
o Multi-location Architecture
o Databases on Multiple Servers
II. SQL Basic
• Statements
• Data Types, Constants

L
Q
S
• Expressions, Built-in Functions
• Missing Data (Null Values)
• Simple Queries
o select, from, distinct, where, limit
o Search Conditions (=, <>, <, <=, >, >=,
between, in, like, is null, and, or, not)
o Sorting (Order By)
• Column Functions
o SUM, AVG, MIN, MAX, COUNT
III. SQL Intermediate
• Database Updates
– Single/multi insert, delete, update
• Subqueries
• Joins, Union, Wildcard
• Grouped Queries (Group By)
• Group Search Conditions (Having)

SQL
IV. SQL Advanced
• SQL Procedures SQL

• SQL View
• SQL Transactions
• SQL Scripts
– Using comments
– Variables
– Built-in Global Variables
– Flow Control
• Indexes (create, drop index)
V. MySQL & Security
• Definition, Usages and Compares with
PostgreSQL, Sqlite, MSSQL, etc.
• SQL Security Concepts
– User-Ids, Security Objects, Privileges
• Views and SQL Security
• Granting Privileges (GRANT)
– Column Privileges
– Passing Privileges (GRANT OPTION)
• Revoking Privileges (REVOKE)
– REVOKE and the GRANT OPTION
– REVOKE and the ANSI/ISO Standard
VI. SQL Performance
• Overview
• EXPLAIN SQL
• Optimize Schema and Data Types
• Indexing for High Performance
• Query Performance Optimization
• Best practices
L
SQ
THANK YOU!

You might also like