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.
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.
Entities are represented within a schema through ________ whereas attributes are realized by _______ and instances by ____________.
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.
I received my Ph.D. from the University of Wisconsin in Visual Psychophysics with a minor in Computer Science. I worked my entire professional career within the computer industry specializing in relational database design and large-scale international databases.
Out of school, I went to work for VeriFone the credit card processing company because they were headquartered in Hawaii and I yearned to get out of the cold of Wisconsin. I started as employee #36. By the time I left, they were publically traded, had thousands of employees and billions in revenue. At the time of my departure, I was VeriFone's Database Design Manager and oversaw a technical staff of 125+.
I subsequently served as MIS Manager for Family Health International, Database Manager for A4 Health Systems, and CTO and President of Castle Worldwide. I retired from Castle in 2014 at the age of 55.
After retirement I was searching for a great means to keep my hands in technology. Teaching with Udemy has provided that venue. I enjoy creating the courses and interacting with the students. It is my new passion. Middle aged and young people are my favorite students - seeing them better utilize their new toys and skills gives me great pleasure, such energy.
I am a huge advocate of life-long learning and love this opportunity to share that passion with others. Remember, "keep on learning."