All language subtitles for 1 - Course Outline English

Whoo!

We're about to start the course, however, it's always a good idea to have a look at the roadmap of

what we're about to learn and the steps we're going to take so that we know where we're ending up.

So you have a clear path to success.

So let's see what this course will look like for you.

Now, before I lay out the course outline, I do want to show you the thing that most students say is

the best part of the course right here are online private community of over 300000 professionals.

We have students chatting here every day, helping each other out, solving problems together, doing

challenges and just talking about the latest and greatest in the tech world.

This is an optional resource for you to use so you can have back and forth conversation with other students

and myself, IMO.

So you feel like you're part of a classroom.

I'm on there chatting every day.

And this way you feel like you are doing the course on your own and you have others pushing you to finish.

OK.

OK, I got sidetracked back to the course outline.

Now the course starts off with a big data breach, our CACO court, and they hired you to look at their

databases and figure out what happened and who stole this important data.

And that's going to set the stage for the rest of the course.

Now, the first part is the history of data.

We're going to learn about what a database is, what are the types of databases that we can have and

how a company like Amazon might want to have databases instead of pen and paper or Excel sheets to keep

track of their customers, their products.

Then we go straight into school fundamentals.

What is school?

How to do a query?

What are tables learning about primary key foreign keys, learning about all TPE versus Bolac databases?

These are the basics that we need to know to truly understand you.

Well, then we get into the important part, the environment setup.

We want to make sure that we use professional tools that you're going to encounter in your professional

career.

We're going to be using tools like Valentina studio, installing databases like PostgreSQL, which is

one of the most popular databases out there, so that you know how to set up your machine, how to create

a database, how to use tools to make queries using ask you.

Well, and don't worry, we provide videos for Mac, Linux and Windows users so that we accommodate

everybody to make sure that everybody is able to work and follow this course.

Next, as the Escorial Deepthi, this is where we go beyond the basics and learn about things like functions,

aggregate functions, filtering data, using comparison operators, working with dates and different

data types, and learning about joints, doing different types of joints to combine different tables.

An important topic that you always encounter when it comes to ask you.

Well, as if that wasn't hard enough and don't worry, I say hard, but we will guide you every step

of the way.

We get into even more advanced.

Ask you all because we don't want to just cover the basics.

We want to get you job ready here.

This advanced desk, you all part is going to talk about things like indexes to improve performance

of your queries about using sub queries, looking at things like partition by order, by group, by

lots of advanced topics that most other courses don't cover.

Then we go to the next part.

Even more exciting.

One of my favorite parts, and this is all about database management.

What happens when you're in charge of a database?

How do you set up a database in an organization?

How do you assign roles to different employees that are going to be using the database, setting up

privileges, granting privileges, learning about the data types and how you're going to set up the

columns and tables, learning about backups, how to restore a database?

Again, things that are going to take you from just a junior to somebody that truly understands databases

and is comfortable working with them.

This is a really fun part.

And I know I say this about every section, but right after that we have another fun section, which

is the database design.

And this is all about how to design data, because in order to work with databases, you need to not

just throw a bunch of data to it, but you need to actually design it so that it is optimized, it works

properly.

We're going to learn about system design, top down design, bottom up design and how to really take

charge of the relational model to make sure that you design the databases using the best practices in

mind.

This is one of those topics that you might learn when you're doing your computer science degree, but

you won't find anywhere else on the Internet.

All right.

And after all of that, if that wasn't enough, you now have the tools to actually solve the mystery,

the data breach or Kako court.

Once you've learned all these topics, we're going to go back to.

A mystery, and now you're going to get access to Keiko corpse databases and using all that you've learned

in the previous sections, we're going to give you clues and you're going to try to solve the mystery

yourself so that you become the hero of the day.

But don't worry, along the way, in all the previous sections, we have tons of exercises that you're

going to do to make sure that you're not just watching us, but you actually get to interact with data,

actually work with things, because without practice, we won't really learn anything.

So lots of exercises, but this is the final big piece that I think you're really, really going to

love.

Next up, once we've solved that mystery, we feel good about ourselves.

We want to take a high level overview of the whole database landscape.

We're going to talk about things like scalability, about charting, about replication backups, what

is distributed versus centralized databases mean.

How do we secure a database?

How do things like fuel injection work, how to store passwords safely?

And then also talk about important topics in the industry like relational databases versus NQ El Postcrisis

versus Mongo DB.

We're going to talk about things like new escudo, about other databases like ElasticSearch, like S3

object storage and how they differ and how they might be able to work alongside relational databases.

We then have some bonus sections for those that really want to expand their horizons and get into the

world of data engineering, where we talk about things like machine learning, how data engineering

and tools like Hadoop Spark Kafka might be used in a different way to analyze data, to create machine

learning models.

These are different types of databases that are being used for different industries.

But at the end of the day, they are still databases that work with data.

We then learn about a database that I think is extremely useful and you're going to encounter in your

career.

And that is where it's a key value storage, a memory storage that is used very often for things like

caching.

It's an important topic.

And we added here as a bonus for those that are extra curious and want to learn about different types

of databases.

Finally, there's some extra bits in there that we throw things like how does a database actually connect

to a Web app that uses Noguez?

As you can see, there's lots to cover.

And we tried to cover a big landscape because the database landscape is big.

And we want to make sure that you can connect the dots and you understand the whole picture.

I promise you, we're going to make it fun along the way.

By the end of it all, this is all going to make sense and you're going to truly understand the power

of school and how to work with databases.

We're going to take you from zero to mastery.

OK, enough talk.

Let's get started and let's start learning.