SQL Guide Chapter

Lesson 0 – Course Introduction (in which you realize SQL is both useful and slightly terrifying)

And look, when someone says “course objectives” your brain usually leaves the room. But this introduction actually matters, because it tells you what kind of power you’re about to get – and how easily you could use it t...

oracle 19c mysql notes study chapter

And look, when someone says “course objectives” your brain usually leaves the room. But this introduction actually matters, because it tells you what kind of power you’re about to get – and how easily you could use it to, say, delete 100,000 rows instead of 10.

By the end of this course you should be able to:

So yes, this is the part where we set expectations – before later chapters demonstrate how those expectations can be exceeded, abused, and rolled back with flashback.

1. Course Roadmap (a guided tour of future chaos)

The course is structured into units and lessons that slowly escalate from “cute little SELECT” to “cross-database, time-zone-aware, multi-table upserts”.

You’ll work through:

Along the way you get:

2. Icons, Databases, and Why There Are Two of Them

Because one database apparently wasn’t enough, this course uses Oracle Database 19c and MySQL.

Same SQL family, different personalities:

You’ll see both so that, later, you can’t say “oh, I only learned the other SQL.”

3. Oracle Database 19c and MySQL: The Big Picture

3.1 Oracle Database 19c focus areas

Oracle 19c exists to be extremely serious about your data in a few key areas:

Which is a polite way of saying: “we expect your system never to go down, ever, and also to be very fast.”

3.2 MySQL: the busy one

MySQL is a modern relational database used by both:

Real‑world scale examples:

So yes, that time your query was slow was probably your fault, not MySQL’s.

Supported platforms include:

And it can be compiled on other platforms because apparently someone, somewhere, is still running that strange OS from 2003.

3.3 MySQL Enterprise Edition extras

MySQL Enterprise Edition adds the features you want when “little side project” becomes “production system with customers and lawyers”.

Highlights:

Why care? Because when things go wrong at 3 a.m., Stack Overflow is not contractually obligated to answer.

4. Relational Database Concepts (a.k.a. “why everything is in tables”)

The relational model was proposed by Dr. E. F. Codd in 1970 and has been quietly running most of civilization ever since.

Key ideas:

“Relational” doesn’t mean “it’s about relationships” in the human sense; it means data is stored in related tables that can be joined by keys.

4.1 From ideas to tables: entity and table models

The journey from business idea to database looks like this:

  1. A human has an idea: “We need to track employees and departments.”
  2. We build an entity model from that narrative.
  1. We map that to a table model: each entity becomes a table, each attribute becomes a column.

Conventions:

4.2 Primary keys, foreign keys, and “who’s the parent?”

Every row should be uniquely identifiable. That’s the job of the primary key.

To relate tables:

Foreign key rules:

So before you insert “Steven King in department 90”, department 90 has to exist in DEPARTMENTS. The database is basically insisting that your org chart make sense.

4.3 Rows, columns, fields, and NULLs

In relational terminology:

In many tools, number columns are right‑aligned and character columns are left‑aligned, which is your first tiny clue about the data type.

5. The HR Schema: Your Playground

For this course you’ll mostly work with the HR schema – a fictional but suspiciously realistic human resources schema.

Key tables include:

Some details:

About the data sets:

So if your query result suddenly has five times more rows, it’s not necessarily wrong – you might just be in the “big data” version of HR.

6. SQL and Development Environments

6.1 What SQL actually is

SQL = Structured Query Language.

Major categories of SQL statements:

6.2 Oracle development environments

You have a few options:

The course assumes SQL Developer as your day‑to‑day Oracle environment.

6.3 MySQL development environments

For MySQL you’ll see:

Again, think of Workbench as the place you’re meant to live, and the CLI as the place you go to when something is on fire.

7. Documentation, Resources, and Training Paths

7.1 Oracle 19c documentation highlights

Useful docs include:

Additional learning resources:

7.2 Oracle training and certification

For developers the typical path is:

Formats include ILT (instructor-led training), IVC (virtual classroom), and TOD (training on demand).

Certification examples:

Exams are delivered via Pearson VUE in 175+ countries, which means you can panic in a testing center almost anywhere on Earth.

7.3 MySQL resources, training, and certification

Websites:

Training paths:

Certification:

Yes, even your MySQL skills can come with official paperwork.

8. What You Should Take Away from This Introduction

By the end of this lesson, you should be able to:

The practice for this lesson typically covers:

In other words: before we let you write queries that rearrange reality, we make sure you at least know how to log in.

← previous view source markdown next →
// sql-guide generated from markdown notes