Databases for Developers


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. It also features a monthly webcast for you to put your questions to Oracle Database experts.

Information

  • Teacher

    Chris Saxon

  • Start Date

    Monday, April 3 2017

  • Difficulty

    Beginner

Missed the Start?

It's OK, you can still join! Just click Register below

Oracle Account Text

HTML centering
You need an Oracle Account to take a class. Click here to sign up.

Course Outline

  • Week 1: Tables

    An introduction to the types of table available in Oracle Database and their uses.

  • Week 2: Columns and Data Types

    When creating columns you need to choose a data type for them. This class gives a rundown of the common data types and their uses.

  • Week 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.

  • Week 4: Tables, Columns and Modeling Review

    A chance to catch up on the material from weeks 1-3, including a live Q&A webcast!

  • Week 5: Select and Where

    A select statement returns you rows from your database. This class covers how to use this and filter the data with a where clause.

  • Week 6: Joins

    When fetching data, often you want to get related rows from two (or more) tables. To do that, you need a join. This class covers the join types in Oracle Database.

  • Week 7: Aggregates and Group By

    This class covers how you can summarize your data using aggregate functions and group by.

  • Week 8: Select, Joins and Group By Review

    A chance to recap and catch up on the past three weeks covering select, joins and group by.

  • Week 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.

  • Week 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.

  • Week 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.

  • Week 12: Insert, Update and Delete Review

    A chance to catch up and review the material from week 9 - 11 on data modifications.

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 followed by quizzes to deepen 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 still have unanswered questions. Where can I ask them?
You can reach out to Chris Saxon on Twitter or ask questions on the Databases for Developers Facebook page

Hidden

Get Started!