Lecture Details :
This lecture was presented live at ITU on 1/31/11. It's the first live recorded powerpoint presentation. It's unedited and there are parts where I have to yell at the crowd to be quite. I will have a louder microphone for the next one! It's a nice overview of Database Objects and a basic Oracle and SQL Orientation.
Course Description :
Creating and Modifying Database Objects - overview of Database Objects and a basic Oracle and SQL Orientation - creating SQL queries and using SQL to it fullest capabilities - SQL - ERD concepts - Entity Relationship Diagramming and translating the diagrams into a set of table - Oracle PL/SQL language - Database Normalization - JDBC and the ODBC database interfaces - concept of JDBC - JDBC connectivity - how to design efficient "front ends" to databases using Java - Oracle Storage Management and Reporting Tools - Oracle Database