Description

Quick Info:Latest update: 10/23/2017More than 220 LecturesVery Comprehensive with extralectures onDatabase AdministrationMay help in obtainingOracle Database12cSQLCertification.With FULLSubtitles for all the video lessonsAbout This Course:Welcome to the course, TheComplete Oracle SQL Course.This course introduces SQL, which is an acronym for ‘Structured Query Language’, to its students. This is based on Oracle’s SQLimplementation for Oracle Databases. The lessons are based on Oracle 12c Database and SQLDeveloper Tools running in Windows 10.This course mayhelp you in taking a step towards..in becoming an ‘Oracle SQL Developer’in achieving ‘Oracle SQL Certification’About the Name of this Course:When I started out to create this course, I wanted to create a Beginner Level Oracle SQLcourse. So I named it as ‘SQL Development for Beginners’.However as I progressed, I decided to make it much more comprehensive andcover most of the topics in thecurriculum of Oracle SQLexam 1Z0-071. And so I renamed it to, TheComplete Oracle SQL Course.So, this course starts with Beginner Level lessons and progresses into next levels.About SQL:SQLis used to interact with Database Systems. As per ANSI (American National Standards Institute), SQLis the standard language for Relational Database Management Systems.SQL has been the prominent language to interact with various Database Systems for many decades. While many languages that existedtwo decades ago are extinct now, SQL has always maintained its supremacy in the RDBMS world. Over the time, it has only advanced with new features and standards. And it seems to stay that way for years to come.About Oracle Database:Oracle Database is one of the prominent Database Systemsin the RDBMS (Relational Database Management Systems) segment. Some of the other prominentDatabase Systems areMicrosoft SQL ServerMySQLSybase ASE.They also use SQL to interact with their Database Systems. While there are subtle differences between each of their SQL implementations, a SQL as a whole, is generally very standard. Soa person with SQL knowledge in one platform such as Oracle,may find it easier to learn and code for otherDatabase Systems such as Microsoft SQL or MySQL.The point is, once you learn SQL, then your reach into the job market is very wide.About the Curriculum:The curriculum has been carefully designed to introduce the Oracle RDBMS environment first.Then it moves on to various types of SQL Statements such as DDL, DML and TCL.And next, it goes to the depths of various SQL Statements, Conditions, Sorting, Functions, Grouping etc..It also gives Database Administration tips, as needed.It is alsocovers most of the topicsfrom theOracle SQL Certification Exam 1Z0-071 Oracle Certification:Oracle awards certain certifications that are recognized globallyOne such certification is Oracle Database 12c SQL Certified AssociateThe exam for that certification is (currently as of May 2016), 1Z0-071.The topicsin this course covers most of the topics for that exam.Oracle Certification – DeclarationsWhile this course covers most of the topics for that exam, this course is not a sole material for that exam. Additional materials such as Oracle’s recommended Books may be needed.This course isNOT an official course fromOracle Corporation.This course has been developed individually by its author.About the Instructor:The instructor of this course, Mr.Sam Dhanasekaran, has more than 20 years of IT experience. It predominantly includes Database Support, IT Support and Recruiting.About Previews:Morelessons have been opened for public previews than the required amount. Please take your time to go through all of them. This will give you an idea about the instructor’s presentation style, technical knowledge etc.Subtitles/Closed Captions:All the video basedlectures contain subtitles or closed-captions. You would be able to enable them if needed.