SQL AND DATA RETRIEVAL OVERVIEW

SQL AND DATA RETRIEVAL OVERVIEW - CREATE and DROP DML -...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
SQL AND DATA RETRIEVAL OVERVIEW Up until now, we have been focused on analyzing the user's requirements and  designing the database. Now we are ready to start building our database and retrieving  data from it.  SQL (Structured Query Language)  is the "language" that we use to communicate with  the database. Just as you speak in a particular language, the database receives  requests in SQL. At the basic level, SQL written for Access is very similar to SQL written  for Oracle or SQL Server. More complex features of the language will vary more  drastically from one provider to another. Three types of SQL DDL  - (Data Definition Language) is concerned with defining the structure  of the  database. This part of the language is used to create the database, tables and  other objects in the database. It includes commands like 
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: CREATE and DROP DML - (Data Manipulation Language) is concerned with retrieving data, and inserting, updating and deleting data in the database. It includes commands like INSERT, UPDATE, DELETE, SELECT. This category includes DQL (Data Query Language) statements. DCL - (Data Control Language) is concerned with control issues such as who are the users and what operations can a particular user perform on the database. It includes commands like GRANT and REVOKE. Options for Executing SQL Commands: 1. Interactive (dynamic) o command line (character based), advantage-can run batches or scripts o Graphical User Interface (GUI) --advantage- easier to use, does not require detailed syntax knowledge like command line interface 2. Embedded...
View Full Document

Ask a homework question - tutors are online