Oracle Database 12c SQL Fundamentals

Hi, my name is Charles Smiles and welcome to this Oracle Database 12c SQL Fundamentals course. I will be your instructor. This course will serve as both introductory and intermediate courses for performing SQL query and database operations against the Oracle 12c database. 

This course extends the Oracle Database: SQL Workshop I course offered by Oracle University. So if you are on a low budget, but you have come to the right place with the most vendor training. Before we begin, let me provide a bit of background about myself. I am an Oracle certified database professional who has been working professionally with Oracle databases since 2004. My experience has been centered around consulting but I have been working as an on-staff Oracle DBA / Developer for a number of companies.

In this workshop I will provide you the foundational coverage of the Oracle SQL language. This course is comprehensive enough to serve as your primary certification exam prep for the OCA SQL IZ0-061 exam. Many of the important goals of that exam coincide with the goals I believe that all practitioners should be knowledgeable when working on Oracle SQL. These goals include understanding normalization, basic selections, join tables, modifying objects, subqueries, updating rows, and many other topics we will cover. Many of you may be new to Oracle’s version of SQL and some of you may have some prior experience. I’ve prepared the content to ensure easy assimilation for new folks and a challenging challenge for more sophisticated students. So if you are looking to start a career as an Oracle Database Administrator or Oracle PL / SQL Developer, this is a great starting point. Beyond the multitude of lectures, demos, and quizzes I have introduced lab exercises which require the installation of Oracle Database 12c. For that reason, the first lab features a guided installation of Oracle Database 12c and SQL Developer. Unlike some other instructors, I’ve included instructions for installing on Windows and Mac OS X. The demonstrations and labs will feature a demonstration schema you will need to install if you intend to follow along in the course. If you have already purchased this course, I would like to thank you for making that investment in yourself. If you are browsing feel free to take the sample lessons I provided and let me know if you have any questions. I look forward to serving you as your instructor. Good luck I have introduced lab exercises which requires the installation of Oracle Database 12c. For that reason, the first lab features a guided installation of Oracle Database 12c and SQL Developer. Unlike some other instructors, I’ve included instructions for installing on Windows and Mac OS X. The demonstrations and labs will feature a demonstration schema you will need to install if you intend to follow along in the course. If you have already purchased this course, I would like to thank you for making that investment in yourself. If you are browsing feel free to take the sample lessons I provided and let me know if you have any questions. I look forward to serving you as your instructor. Good luck I have introduced lab exercises which requires the installation of Oracle Database 12c. For that reason, the first lab features a guided installation of Oracle Database 12c and SQL Developer. Unlike some other instructors, I’ve included instructions for installing on Windows and Mac OS X. The demonstrations and labs will feature a demonstration schema you will need to install if you intend to follow along in the course. If you have already purchased this course, I would like to thank you for making that investment in yourself. If you are browsing feel free to take the sample lessons I provided and let me know if you have any questions. I look forward to serving you as your instructor. Good luck The first lab features a guided installation of Oracle Database 12c and SQL Developer. Unlike some other instructors, I’ve included instructions for installing on Windows and Mac OS X. The demonstrations and labs will feature a demonstration schema you will need to install if you intend to follow along in the course. If you have already purchased this course, I would like to thank you for making that investment in yourself. If you are browsing feel free to take the sample lessons I provided and let me know if you have any questions. I look forward to serving you as your instructor. Good luck The first lab features a guided installation of Oracle Database 12c and SQL Developer. Unlike some other instructors, I’ve included instructions for installing on Windows and Mac OS X. The demonstrations and labs will feature a demonstration schema you will need to install if you intend to follow along in the course. If you have already purchased this course, I would like to thank you for making that investment in yourself. If you are browsing feel free to take the sample lessons I provided and let me know if you have any questions. I look forward to serving you as your instructor. Good luck The demonstrations and labs will feature a demonstration schema you will need to install if you intend to follow along in the course. If you have already purchased this course, I would like to thank you for making that investment in yourself. If you are browsing feel free to take the sample lessons I provided and let me know if you have any questions. I look forward to serving you as your instructor. Good luck The demonstrations and labs will feature a demonstration schema you will need to install if you intend to follow along in the course. If you have already purchased this course, I would like to thank you for making that investment in yourself. If you are browsing feel free to take the sample lessons I provided and let me know if you have any questions. I look forward to serving you as your instructor. Good luck