Upon completion of this course, the student will be able to: Describe the concepts of DBMS and RDBMS. Describe how Oracle8i implements ORDBMS. Describe the concepts of SQL and SQL*Plus. Construct SELECT statements to query a database. Identify different SQL commands such asDDL, DML, DCL, and TCL. Use arithmetic expressions in SQL statements. Sort the data obtained from a table both by multi-column sort and by rows retrieved from a query. Limit rows retrieved from query. Search for data using combinations of search conditions.
Unit 1: RDBMS and SQL
- Database Design
- Entity Relationship Models
- Integrity Constraint Types
- SQL *Plus Commands
Unit 2: Basics of SQL
- SQL Commands: Categories
- SELECT Statement
- Arithmetic Expressions
Unit 3: Controlling Selected Rows
- Sorting a Database Table
- Restricting Rows
Unit 4: Operators
- Logical Comparison Operators
- SQL Comparison Operators
- NULL Operators
- Logical Operators
- SQL Operators: Sequencing