Premium SQL Programming Courses By Raising The Bar - PowerPoint PPT Presentation

About This Presentation
Title:

Premium SQL Programming Courses By Raising The Bar

Description:

Raising The Bar offers excellent SQL training courses. Structured Query Language (SQL) is a language used for viewing or changing data stored in the databases. The sentences utilised in this programming language are called SQL Queries. The various SQL commands like data definition language, data manipulation language and data control language have been discussed briefly. – PowerPoint PPT presentation

Number of Views:47

less

Transcript and Presenter's Notes

Title: 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
Write a Comment
User Comments (0)
About PowerShow.com