From the course: Advanced MySQL Data Analysis

Setting expectations - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

Setting expectations

“

- [Instructor] All right, now we'll talk a little bit about what you should and should not expect from this course. So technically, you're going to be learning MySQL and you'll be practicing that using MySQL Workbench. But the most important thing I can say about this is that the various flavors of SQL, like T-SQL or Postgres, are all very, very similar. They all just have minor syntax differences, but are built on the same fundamental language. So when you learn MySQL in this course, you're really learning SQL, and you can apply those skills to any of the other flavors of SQL. This part's really important. We're going to skip over the basics in this course. It's not meant for beginners. I've tried to be really clear about this in the promo video, asking students to watch the prerequisite video. Instead of doing the intro stuff, talking about how to connect tables, how to query from a single table, we're going to skip over that and focused on applying your skills in a deeper way, so that you can pull out analytical insights using more complex queries. And actually help steer a business just like you would in the real world. So hopefully everyone got that message and hopefully your past the beginner steps. If this is your first time writing SQL Queries, this is not going to be the right course for you. In this course, we're going to focus entirely on extracting and analyzing data to generate insights, we'll be using a custom built and very rich e-commerce database to simulate a real world project, in which you are going to help business leaders understand their business and steer into opportunities. We're not going to be covering the building and maintenance of database, or kind of these activities that you would more associate with a database administrator. This course is about advanced SQL for data analysis, and so we're going to be focusing on teaching you the skills to be a really badass database analyst. And we won't be focusing on trying to teach you to be a database administrator in this course. Hopefully, this all sounds really good to you, and you'll be ready to get started.

Contents