Summary SQL complete notes

SQL & ADVANCED SQL
Marcin Blaszczyk (CERN IT-DB)


, AGENDA
 Goal of this tutorial:
 Present the overview of basic SQL capabilities
 Explain several selected advanced SQL features


 Outline
 Introduction
 SQL basics
 Joins & Complex queries
 Analytical functions & Set operators
 Other DB objects (Sequences, Synonyms, DBlinks, Views & Mviews)
 Indexes & IOTs
 Partitioning
 Undo & Flashback technologies

Oracle Tutorials 5th of May 2012

, SQL LANGUAGE
 Objective: be able to perform the basic operation of the
RDBMS data model
 create, modify the layout of a table
 remove a table from the user schema
 insert data into the table
 retrieve and manipulate data from one or more tables
 update/ delete data in a table
 +
 Some more advanced modifications




Oracle Tutorials 5th of May 2012

, SQL LANGUAGE (2)
 Structured Query Language
 Programing language
 Designed to mange data in relational databases


 DDL Data Definition Language
 Creating, replacing, altering, and dropping objects
 Example: DROP TABLE [TABLE];
 DML Data Modification Language
 Inserting, updating, and deleting rows in a table
 Example: DELETE FROM [TABLE];
 DCL Data Control Language
 Controlling access to the database and its objects
 Example: GRANT SELECT ON [TABLE] TO [USER];

Oracle Tutorials 5th of May 2012