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.
About the Instructor
Dr. Rick Phillips
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. 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."
Frequently Asked Questions
It is an online tutorial that covers a specific part of a topic in several sections. An Expert teaches the students with theoretical knowledge as well as with practical examples which makes it easy for students to understand.
A Course helps the user understand a specific part of a concept. While a path and E-Degrees are broader aspects and help the user understand more than just a small area of the concept.
A Course will help you understand any particular topic. For instance, if you are a beginner and want to learn about the basics of any topic in a fluent manner within a short period of time, a Course would be best for you to choose.
We have an inbuilt question-answer system to help you with your queries. Our support staff will be answering all your questions regarding the content of the Course.
People interested in this course also viewed
How it works
The offer includes all live courses, Deals and E-Degrees.
Bogo Offer will be applied automatically upon adding 2nd Course, Deal or E-degree in the Cart. Offer Price will be reflected in Checkout Total
You can buy multiple courses or deals using your cart but they have to be in combo of 2 to get benefit of the offer.
We are free to withdraw any product from this offer based at our own discretion.
Please complete your profile for better search results