What you should know - SQL Tutorial

- So here's a quick rundown of what we're going to cover, and a good way to start is saying what we're not going to do. Many SQL courses spend lots of time explaining the history and computer science theory behind databases and query language. We're not going to do that. Instead, we'll focus on learning just enough of the essentials to understand how relational databases function. Then you can apply the skills you learn in this course to complete the final project. As you apply your skills in real world scenarios, use this course as a reference guide when needed. You see, as great as a course might be, the truth is learning SQL requires a commitment to regular study and practice. There's just no way around it, but this course will help you adopt a resilient, can-do mindset as you continue your learning path. You know, it's a pleasure to spend my working hours venturing into oceans of data but it is my privilege that you've allowed me to help you navigate the skill of SQL without any fear of getting lost. Now, let's talk about what you should know. If you don't have any database knowledge, that's okay. We'll be stepping through the basics all the way to advanced SQL topics. If you do have prior database or SQL experience, it's helpful, but you don't need it to be successful in this course. We'll be using an SQLite database for this course in addition to the DB Browser for SQLite database software. SQLite can be easily installed on Windows and Mac machines. Lite is not to be confused with lightweight as this software is robust and handles large volumes of data. Later, I'll walk you through downloading the course exercise file, a sample database. We'll also install the database software, DB Browser for SQLite. Okay, as they say in Jamaica, enough talk. Let's get to work.