Original subtitles

‫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.