Explains what SQL stands for, and which databases can be accessed using this language
- SQL is often pronounced, sequel. And it stands for, structured query language. It's a programming language used to retrieve data from databases. Not all databases speak SQL. SQL will only talk to relational databases generally. Relational databases are the most popular kind of database, and were invented in 1970. Relational databases contain tables. The tables, in turn, contain fields. These can be thought of as columns. The fields hold the data, so you can't put data into a database without at least one table, and one field.
It stands to reason that there are also non-relational databases, and that SQL does not generally speak to them. In fact, the term noSQL is often used to group together the various languages used on these databases. Non-relational databases are increasingly used for storing big data, and they aren't covered in this course. From now on, if I use the word database, I mean relational databases.
Join Emma Saunders as she shows you how to design and write simple SQL queries for data reporting and analysis. Review the different types of SQL, and then learn how to filter, group, and sort data, using built-in SQL functions to format or calculate results. Learn a bit about data types and database design. Discover how to perform more complex queries, such as joining data together from different database tables. Last but not least, Emma shows how to save your queries as views, so you can run them again and again.
- Using different versions of SQL
- Retrieving data with SELECT statements
- Filtering and sorting your results
- Transforming results with built-in SQL functions
- Grouping SQL results
- Merging data from multiple tables
- Identifying data types, and how to make sense of your database design
- Saving SQL queries