Another Oracle Dev Gym class for you...

Databases for Developers: Foundations


A FREE 12 week boot camp to help you get started with Oracle Database and SQL. The course is a series of weekly videos to teach you database concepts with quizzes to reinforce the ideas.

Information

  • Instructor

    Chris Saxon*

  • Starts On

    On Demand

  • Difficulty

    Beginner

Oracle Account Text

You need an Oracle Account to take a class. Click here to sign up.
Already a member of the Oracle Dev Gym? Click here to get back to work.

Course Modules

Module 1: Tables
An introduction to the types of table available in Oracle Database and their uses.
Module 2: Columns and Data Types
When defining columns in a table, you need to choose a data type for them. This class gives a rundown of the common data types and their uses.
Module 3: Data Modeling
Deciding where to store what is one of the fundamental decisions you make when building a database. This class gives an overview of the things you need to consider when designing your tables.
Module 4: Tables, Columns and Modeling Review
A chance to catch up on the material from weeks 1-3. When the class is scheduled, rather than on demand, Chris Saxon holds a Q&A webcast to answer your questions.
Module 5: Select and Where
A select statement returns you rows from your database. This class covers how to filter this data using a where clause.
Module 6: Joins
When fetching data, often you'll want related rows from two (or more) tables. To do that, you need a join. This class covers everything you need to know about this.
Module 7: Aggregates and Group By
This class covers how you can summarize your data using aggregate functions and group by.
Module 8: Select, Joins and Group By Review
A chance to recap and catch up on weeks 5-7 covering select, joins and group by. Put your questions to Chris on these topics in the live Q&A webcast Weds, May 24 @ 2pm BST
Module 9: Insert and Commit
Insert loads data into your tables. This class the various ways of doing this along with how to save and undo your changes.
Module 10: Update and Transactions
You use an update statement to change the values of rows in your database. This class discusses how to do this and the concept of a transaction: a single, logical unit of work.
Module 11: Delete and Truncate
To remove data from your database, use delete or truncate. This class covers the differences between these operations and when you should use one or the other.
Module 12: Insert, Update and Delete Review
A chance to catch up and review the material from week 9 - 11 on data modifications. Put your questions to Chris about these or any other topics covered in the course in the final Q&A webcast Weds, Jun 21 @ 2pm BST

Frequently Asked Questions

How much does this cost?
Nothing. Nada. Nil. Zilch. That's right, it's 100% FREE!
I missed the start. Can I still join?
Yes! You can join Databases for Developers at any time
When does the course end?
The modules have no fixed end date. Once you're registered you can take open classes whenever you want
What will I learn on this course?
This course will teach you the basics of SQL and working with Oracle Database
How much time will it take?
We estimate that this will take up to 30 minutes per week.
What if I fall behind?
This is a self-paced course. Once registered, you have lifetime access to these materials to review at any time. So you can complete it at your leisure. But to get the best value from this course we recommend that you complete each class in the week it's released.
What is the format of this course?
The course is a combination of videos designed to teach you about database concepts and quizzes to test your knowledge
Do I need access to an Oracle Database?
No! This is a fully online course. The materials are designed so you can complete the course without a database.
I don't have access to an Oracle Database. Where can I practice what I've learned?
Head to LiveSQL. This is a free, browser based tool you can use to write SQL.
Will I get a certificate for completing this course?
Yes! If you complete all the exercises then we'll send you a certificate of your achivement.
I already have a good working knowledge of SQL and Oracle Database. Is this course right for me?
This course is aimed at beginners. It assumes no prior knowledge of SQL or Oracle Database. If you're an advanced user there may be little new for you. But it never hurts to brush up on the basics, right? ;)
I'm confident with the basics, have you got anything more advanced?
Yes! If you want to go beyond the basics, take Databases for Developers: Next Level
I still have unanswered questions. Where can I ask them?
You can reach out to Chris Saxon on Twitter
Instructor

*About Chris Saxon

Chris Saxon is the quizmaster for the Database Design competitions and an Oracle Developer Advocate for SQL. His job is to help you get the best out of the Oracle Database and have fun with SQL! He's also part of the answer team on Ask TOM and creates YouTube videos at The Magic of SQL channel.

More from Chris Saxon