SQL Introduction PDF
Document Details
Uploaded by BuoyantLithium
An-Najah National University
Tags
Summary
This document provides an introduction to Structured Query Language (SQL). It covers the different types of SQL statements including Data Definition Language(DDL), Data Manipulation Language (DML), and Data Control Language (DCL). It also details how SQL operates within the different applications that use it, like Oracle.
Full Transcript
Command line tool that process user’s SQL statements Requires Oracle account DDL Data Definition SQL DML Data Manipulation DCL Data Control 1 Structured Q...
Command line tool that process user’s SQL statements Requires Oracle account DDL Data Definition SQL DML Data Manipulation DCL Data Control 1 Structured Query Language (SQL) The standard query language for creating and manipulating and controlling data in relational databases MS Access, Oracle, Sybase, Informix, etc. specified by a command-line tool or is embedded into a general purpose programming language, C, Pascal, Java, Perl... Data Definition Language (DDL) Used to create (define) data structures such as tables, indexes, clusters Data Manipulation Language (DML) is used to store, retrieve and update data from tables Data Control Language used to control the access to the database objects created using DDL and DML 2 3 4 5 6 Same as your pegasus password Password: MBAgrad2004 7 Changing SQL*Plus password passw command Getting help Help command 8 Using Oracle Developer Interface 9 10 11 12 13 14 15 16 17 18 19 Summary 20