1 / 15

Oracle & SQL Introduction

Oracle & SQL Introduction. LAB 7. Oracle. Oracle is a powerful relational database management system (RDBMS) that offers a large feature set . Oracle is widely regarded as one of the popular full-featured database systems on the market today .

quinlan-shepherd
Download Presentation

Oracle & SQL Introduction

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. Information Systems Department Oracle & SQL Introduction LAB 7

  2. Oracle • Oracle is a powerful relational database management system (RDBMS) that offers a large feature set. • Oracle is widely regarded as one of the popular full-featured database systems on the market today. • In almost all relational databases, data is accessed through Structured Query Language (SQL), and Oracle is one of them.

  3. SQL • Structured Query Language • The standard for relational database management systems (RDBMS). • SQL is relatively easy to learn. • Basic command set has vocabulary of less than 100 words. • Case insensitive. • SQL is nonprocedural language that represents a combination of DDL and DML.

  4. What can ORACLE SQL Plus do? DDL, DML, DCL, and the database development process

  5. Database Design Revision Steps in building a database for an application: • Analysis: • Understand real-world domain being captured. • Design: • Specify it using a database conceptual model (ER). • Translate specification to model of DBMS (Relational). • Implementation (using DBMS): • Create schema using DBMS commands (DDL). • Load data (DML).

  6. Relational Database • A relational database is a DB that stores the data in the form of tables/relations with rows and columns. Every table shares at least one column with another table (Relationships). • A table/Relation is the category of data, like Staff. The columns are information about the category (Attributes), like name or address and the rows are the actual data or records.

  7. Data Definition Language (DDL) • DDL is a descriptive language for defining the database schema. • Some of the main SQL-DDL commands are: • CREATE TABLE • ALTER TABLE • DROP TABLE

  8. Data Definition Language (DDL)

  9. Data Definition Language: CREATE TABLE {table} ( {column datatype [DEFAULT expr] [column_constraint] ... | table_constraint} [, { column datatype [DEFAULT expr] [column_constraint] ... ) ALTER TABLE {table} [ADD|MODIFY {column datatype [DEFAULT expr] [column_constraint]} [DROP drop_clause] DROP TABLE {table} [cascade constraints] DESC {table}

  10. Data Manipulation Language (DML) • The SQL data-manipulation language (DML)provides the ability to query information, and insert, delete and update tuples. • A typical SQL query has the form:select A1, A2, ..., Anfromr1, r2, ..., rmwhere P • Ai represents an attribute • Rirepresents a relation • P is a predicate. • The result of an SQL query is a relation/table.

  11. Data Manipulation Language (DML)

  12. Data Manipulation Language (DML)

  13. Starting (Logging into) SQL*plus • To Start Oracle Database (you must  do this first!!): • Go to Start and click each of the following:…All Programs……Oracle 10g XE…………….SQL Plus • Connecting : Now the SQL command window requests your user-name, PW.

  14. Try your account .

More Related