1 / 7

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.

raisingthebar01
Download Presentation

Premium SQL Programming Courses By Raising The Bar

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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. Introduction to SQL Data Definition Language 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. Introduction to SQL Contact Us Raising The Bar Address: Level 2, 80 Mount St North Sydney NSW, 2060 Australia Contact No: 1300 937 782 Email: craig@rtb.com.au Website: www.rtb.com.au

More Related