Introduction

This course will provide you with the basics that you need to know to get started using SQL. No prior SQL experience is required. Some of the major topics that we will cover include querying data using the select statement,shaping your results using the where clause,creating and modifying data in your tables,as well as creating and modifying those tables themselves. By the end of this course,you'll know the basics of how to create and use a relational database.

In this course, I'm going to give you an introduction to SQL. So Structured Query Language, or SQL,as it's better known as or SQL is a special‑purpose programming language. That differentiates it from other languages,like C, C++, JavaScript, or Java,which are all general‑purpose programming languages. This means that SQL has a very particular purpose,and that purpose is to manipulate sets of data.

Now typically,we manipulate those sets of data from what we call a relational database. And generally speaking, once you've learned SQL,it's pretty easy to pick up other query languages. Now SQL has a number of standards. It's both an ANSI and an ISO standard, and this is only really important. Because that means that each relational database vendor has to implement at least the standard so that you can know that if you learn the SQL standard, you can apply that to many different databases.

Now I will pick a particular database product. It's a free one called MySQL,which I'll talk about how to set up and use in a later module,but I'm going to stick to just the standards. One of those terms is a database. So what's a database?A database is really just a name that we give a container that helps us to organize data in some logical way. Now, by organizing that data in a logical way,we basically have a much more efficient way of storing the data and retrieving the data.

So oftentimes in an enterprise, data will be stored in a spreadsheet,and there is some commonality between spreadsheets and databases. Spreadsheets contain rows and columns. Database table, as we'll get into also store data in rows and columns,but you wouldn't create a database just for the data in one spreadsheet.