COURSE OUTLINE
DATABASE CONCEPTS
- Data processing basics
- Dbms – database management system
- Erm – entity-relationship model
- Rdm - relational data model
- Normalization
- Manipulating tables
SQL
- SQL basic/’data dictionary’
- SQL statement coding rules…
- Data control language – Commit, Rollback, Savepoint …
- Data definition language (DDL)
- Tables/create, drop, alter,…, constraints…
- Views - creation and using
- Sequences - creation and using
- Data manipulation language (DML) /IUD – insert, update and delete
- Retrieving data/ select statement, where, order by, group by, having clause, operators/
- Expressions, functions – single row and group functions
- Subqueries, correlated subqueries, using by subqueries
- Joins (self join, outer join, equijoin, non-equijoin)
- Optimization /indexes and clusters
- Advanced SQL (SET operators, EXISTS operator)
SQL*PLUS
- Reports with SQL*PLUS
- Substitution variables
- Scripts in SQL*Plus
PL/SQL
- Overview
- Fundamentals /Blocks, Variables, Constants, Attributes, Datatype
- Control Structures / If…, For… Loop, …
- Cursors
- Transaction Control /Commit, Rollback, Savepoint
- Subprograms /Procedures, Functions (stored and client)
- Procedures
- Packages
- Triggers
- Error Handling
- SQL Developer