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

About This Presentation

Premium SQL Programming Courses By Raising The Bar


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


Transcript and Presenter's Notes

Title: Premium SQL Programming Courses By Raising The Bar


SQL Programming Courses
SQL Courses
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.

Types of SQL Commands
SQL Commands
DDL (Data Definition
DML (Data Manipulation Language)
DCL (Data Control
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

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

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
  • REVOKE - Withdraw access privileges given with
    the GRANT command

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 Website
Write a Comment
User Comments (0)