By Chris Saxon
Every application needs to store its data somewhere. This is highly likely to be in a relational database. And how do you access this data?
Structured Query Language (SQL) is one of the most enduring technologies around. It's so successful that many non-relational, "NoSQL" databases are scrambling to add SQL interfaces.
For students who are interested in becoming a developer, data analyst or database administrator, it's almost certain they'll need to use SQL at some point in their careers. Knowing how to use it will be an invaluable skill throughout their programming life.
But where do learners begin?
Oracle Dev Gym introduces Databases for Developers: Foundations. This 12-part tutorial teaches students the basics of SQL, including how to create database tables, query, and store data in them.
Each module starts with a video introducing a database concept. These entertaining videos give an overview of the feature. An interactive LiveSQL tutorial follows. These flesh out the syntax details and enable learners to practice writing real SQL statements.
Finally, to check that learners have understood the content, each module finishes with a series of quizzes.
The best part? This tutorial is 100% FREE and run completely online.
So what are you waiting for? Head over to the Oracle Dev Gym and register now.
Still not sure?
Here are selected quotes from the thousands of people who joined the first version of this tutorial. The feedback was overwhelmingly positive:
"Considered as being aimed at beginner developers, the class covered many aspects, including some that are almost beyond a beginner level. But it did it in a very intuitive way, and I am sure that all the newcomers have enjoyed it." Iudith
"Keep the great job. The material is explained in a very clear way! I would like to see more of your classes." Manuel
"Videos were very fun, I enjoyed them too much. Quiz answers were highly detailed and well explained." Tolga
"That it introduced me to databases in the friendliest way I've seen so far." topofkeks
"The videos were great and I loved that Chris provided examples and made real life comparisons to help us understand the concepts." Alisha
"Great for beginners." Kashif
"I loved the images Chris chose to use in the videos; they added a funny visual component that made the concepts easy to recall later on. Also, the pace - keeping the segments to 5-10 minutes made it easy to process one concept before moving on to the next."
"Very concentrated content. Did not take very long to get the concepts across. I appreciated the casual and comical approach to the explanations. Offering this content for a beginner at no cost is an extremely generous and helpful resource, and is a testament to the commitment of all who were involved."
What will students learn?
This course will teach the basics of SQL and working with Oracle Database. It covers the following topics:
How much does this cost?
Nothing. Nada. Nil. Zilch. That's right, it's 100% FREE!
My students missed the start. Can they still join?
Yes! They can join Databases for Developers at any time, as it’s all online.
When does the course end?
The modules have no fixed end date. Once someone registers, he or she can take open classes whenever they want.
How much time will it take?
We estimate that this will take up to 30 minutes per module.
What if learners fall behind?
This is a self-paced course. Once registered, students have lifetime access to these materials to review at any time and complete it at their leisure.
What is the format of this course?
The course is a combination of:
Do students need access to an Oracle Database?
No! This is a fully online course. The materials are designed so learners can complete the course without a database. And to practice what they’ve learned, they can head to LiveSQL, a free, browser-based tool they can use to write SQL.
Does each student receive a certificate for completing this course?
Yes! If one completes all the exercises, he or she receives a certificate of achievement.
If students already have a good working knowledge of SQL and Oracle Database, is this course right for them?
This course is aimed at beginners. It assumes no prior knowledge of SQL or Oracle Database. For advanced users, there may be little new. But it never hurts to brush up on the basics, right? ;)
For students confident with the basics who want to go beyond, we recommend Databases for Developers: Next Level.
For unanswered questions, who do I contact?
You can reach out to Chris Saxon on Twitter
Ready? Head over to the Oracle Dev Gym and join!