Premium SQL Programming Courses By Raising The Bar

1

SQL Programming Courses
SQL Courses
2
Introduction to SQL
Introduction to SQL

• SQL Stands for Structured Query Language

• SQL is an ANSI (American National Standards
  Institute) standard, there are different versions
  of the SQL language.

• SQL lets you access and manipulate databases.

3
Types of SQL Commands
SQL Commands
DDL (Data Definition
Language)
DML (Data Manipulation Language)
DCL (Data Control
Language)
4
Data Definition Language
Introduction to SQL
Data Definition Language (DDL) statements are
used to define the database structure or schema.

• CREATE - To create objects in the database
• ALTER - Alters the structure of the database
• DROP - Delete objects from the database
• TRUNCATE - Remove all records from a table,
  including all spaces allocated for the
  records are removed

5
Introduction to SQL
Data Manipulation Language
Data Manipulation Language (DML) statements are
used for managing data within schema objects.

• SELECT - Retrieve data from the a database
• INSERT - Insert data into a table
• UPDATE - Updates existing data within a table
• DELETE - Deletes all records from a table, the
  space for the records remain

6
Introduction to SQL
Data Control Language
Data Control Language (DCL) is used to control
access to data stored in a database.

• GRANT - Gives user's access privileges to
  database
• REVOKE - Withdraw access privileges given with
  the GRANT command

7
Contact Us
Introduction to SQL
Raising The Bar
Address Level 2, 80 Mount St
North Sydney NSW,
2060 Australia Contact
No 1300 937 782 Email
craig_at_rtb.com.au Website www.rtb.com.au