
This lecture will introduce the student to the course and layout a roadmap for moving forward. Rick Phillips, the instructor, will introduce himself and explain his background before providing an outline of the course. This lecture will culminate with a brief discussion of Rick's presentation style as well as the expectations placed on students.
In this lecture the student will learn how to download and install Oracle Express Edition, SQL*PLUS, SQL Developer and MySQL Workbench. These free software tools will be used throughout the remainder of the course.
This lecture will introduce the student to common relational database terminology.
In this lecture the student will be shown how to "interview the data." This process involves interviewing the data owners and also reviewing all historical system in an effort to establish a preliminary list of entities, attributes and relationships. This information is then validated against the data owner and documented in preparation for normalization.
In this lecture the student will learn how to take entity, attribute and relationship information and normalize it through Boyce-Codd 3NF. The normalization process is required to ensure proper SQL execution.
In this lecture the student will learn how to graphically document a schema design using standard ER Diagramming techniques; i.e. Entity-Relationship.
This course introduces the learner to all facets of Oracle SQL programming. The course begins with a section on relational database theory, moves onto cover the data definition components of SQL, the data manipulation components of SQL and then does a deep dive on queries. The course culminates with a overview of user-defined objects, collections, XML, large objects and performance.
The course is fast paced and targeted toward aggressive learners. Each of Dr. Phillips' examples, as well his lecture scripts, are provided as resource materials. Dr. Phillips shares many valuable experiences from both his academic and real-world careers.
This course is highly recommended for anyone seeking to advance their career by adding Oracle SQL programming to their technical toolbox as well as those seeking Oracle certification.