SQL is a critical skill for application and database developers, and Oracle is THE MOST popular database engine today, especially at large companies, so you made a good choice by choosing Oracle.
In this course I will cover the most important and useful features of SQL, starting with the most basic form of the SELECT statement and then progressing step by step to more complex concepts like group operations, functions, subqueries, joins, transactions, etc.
This is not a course on advanced SQL, but it includes some topics that some people consider advanced, so, if you are completely new to SQL, that is great because the course starts from zero. No previous SQL knowledge is necessary! But if you do have some previous knowledge, that’s great too, because I will cover much more than just the basics, and you will learn a lot of new things, even in areas where you might already have some knowledge.
I’ve been a developer myself for many years, and I can tell you from experience that being the person who knows more than the rest feels REALLY GOOD.
And you know what? I’m going to help you be that person!
Methodology
Let me make this very clear: THIS IS NOT A THEORETICAL COURSE. You will have the opportunity to practice everything that is covered, because that is the only way to really learn the language.
And I’m not talking about telling you to do what I do or just follow along with me as I write code. That doesn’t work! That doesn’t really help you learn.
I’m talking about real problems that you will have to solve on your own.
You will be challenged, because I know you have the capacity!
Contents
These are the basic things you need to know about how the course is structured and the resources you will have available to support your learning:
There are 2 sections before you get to the point where you start actually learning SQL:
The first one is about setting the environment, which includes installing and configuring the necessary software, or learning how to use a website that allows you to run SQL code without installing anything.
And the second one is about some general database and Oracle concepts. I don’t like theory too much either, but these topics are essential, and you really need to know them before starting to learn SQL.
You will probably be tempted, but I recommend that you do not skip any of these sections, unless after reading the lesson’s titles and descriptions you are completely sure that you already know the topics covered in them.
After those two sections, you will start learning SQL, and from that point onwards, most of the lessons include at least one practice challenge.
These challenges are the opportunity for you to practice and play with the concepts and techniques covered in the lesson, and they are crucial for your learning, so, don’t skip any of them.
For each practice challenge, I will give you not only the problem description but also the expected result or output, so that you can use it as a guide to know whether your solution is correct or not.
By the end of the course, you will be able to do different types of joins to query more than one table simultaneously, and will be able to insert, update and delete information, and to create and use tables, indexes, sequences and views!
Can you believe it?
Need Motivation?
There are thousands of SQL Developers out there, but there is a lack of GOOD ones, so if you want to succeed in this competitive market, YOU HAVE TO STAND OUT.
I created this course because I want to share the love and the knowledge of SQL. I want to provide as much value to as many people as I can and I want to help YOU be the best SQL developer in your team or the best prospect for a potential employer.
The good news is that by enrolling in this course you already took the first and most important step. Here you will have the opportunity to learn more and to learn better, and that will allow you to differentiate yourself, and STAND OUT.
But it is not going to happen automatically!
You will have to put effort and do your best when working on the practice challenges.
Are you willing to do it?
Great! Now please continue to the next lecture for my recommendations on how to take full advantage of this course.
See you there.