Oracle SQL - From Beginner to Pro
What you'll learn
- By the end of the course the student will be proficient in relational theory, all facets of SQL including data definition, data manipulation and queries, as well as introduced to PL/SQL, Oracle XML, user-defined objects and performance.
- Successful students should be familiar with at least one programming language.
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.
Who this course is for:
- The perfect student is relatively new to programming and is seeking to interface their programs to an Oracle, or other, relational database via SQL.
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."