I'm a software consultant that has a passion for databases, and teaching others. I have over seven years experience in the IT industry in many roles, including database support, database development, database design, reporting, business analysis, project management, and even Excel.
I obtained the Oracle SQL Expert certification and currently looking into the next certification on my list!
I'd like to teach others about databases and database topics, such as SQL, database design, and performance.
Take your courses with you and learn anytime, anywhere.
Learn and practice real-world skills and achieve your goals.
Learn how to use Oracle SQL AND get a Certification of Completion when you finish.
This course will teach you the basics of the SQL language on an Oracle database.
It uses video lectures, covering database topics such as:
The course materials run for approximately 4 hours and are split into multiple sessions.
It's structured into various sessions and lectures, grouped by functional areas to make it easier to lean.
Why should you take this course?
You can go from absolute beginner to capable of writing SQL statements in a matter of hours, without paying thousands of dollars for training. You can also study in your own time!
An introduction to this course, who I am, and what will be covered.
Explains key concepts used in Oracle and this course, as well as what tools are needed for this course.
Demonstration of how to download the Oracle Client.
Demonstration of how to install the Oracle Client.
Demonstration of how to download the Java Development Kit.
Demonstration of how to install the Java Development Kit.
Demonstration of how to download the Oracle SQL Developer software.
Demonstration of how to setup the Oracle SQL Developer software.
Demonstration of how to setup the connections inside the Oracle SQL Developer software.
Covers the basics of an SQL statement and how to run it on SQL Developer.
Demonstrates how to create a new user in SQL Developer.
Demonstrates how to create and populate the tables required for this course.
Includes how to run SELECT statements on the data in this database.
Explains the concepts of operators, as well as the DISTINCT and NULL keywords.
Covers some of the data types used in Oracle SQL.
Part one of how to restrict the data and sort it in a SELECT statement.
Part two of how to restrict the data and sort it in a SELECT statement.
Explains some of the string functions in Oracle SQL.
Explains some of the number functions in Oracle SQL.
Covers how to work with dates and times in Oracle.
Explains some of the date functions in Oracle SQL.
Explains some of the conversion functions in Oracle SQL.
Covers the aggregate functions used in Oracle.
Explains what table aliases are, as well as how to use joins.
Part two of using joins on tables in Oracle.
This session covers the concept of set operators and how to use them.
Covers three concepts inside Oracle - Translate, Decode and Case.
Explains the concept of a subquery, focusing on those that work with single rows.
Explains the concept of a subquery, focusing on those that work with multiple rows.
Introduces the INSERT statement for inserting data into a table.
Covers the UPDATE statement for updating data in a table.
Covers how to delete data from a table.
Explains several of the object types used in Oracle.
Looks at how to create a table, as well as how constraints are used.
Covers how to alter and drop a table in Oracle.
The course conclusion and next steps.
Overall this course is OK and has helped me from knowing nothing at all about SQL to understanding some of the basics. Where could it be better? There is virtually no triggers to trying examples out yourself, the examples given are not very 'real world' either, and often the lectures deviate from what is possible with loaded data that you are asked to load during the initial parts of the course. I'm afraid I also have to report that there is real 'death-by-powerpoint' in this course. The first setup video showed some finesse by the lecturer in the use of a desktop camera tool, but sadly that was never revisited. There was no encouragement to entering in the SQL into the delveoper application either, I found myself doing that without any prompt, but more often I found myself 'switching off' due to the over use of powerpoint static slides. This is a shame since the lecturer is not a bore to listen to and what is presented is presented well. Its just a very dry subject so to have very dry slides as well made for a sleepy experience! Overall then, good and worth the money. But could be much better, more vibrant and if encouraged the student to engage more with the material with examples (homework) to do, would really help with the learning activity.. (if the lecturer reads this, I highly recommend watching Bob Tabor's C# fundamentals course, which takes and even dryer subject (c# programming) and turns in an engaging and awesome online course - which is FREE on Microsoft Virtual Acadamey.
Course was well designed and laid out. Speaker was easy to hear/understand and topics were well designed.
I have literally just began this course (only on the second video) but I am very impressed. The commentator is very clear and precise and I feel that this is going to be of a great benefit to me during my studies.