Describes target audience for the course, plus what the course covers and doesn't cover
- [Narrator] SQL is the most common language used to talk to databases. When you use a business intelligence, or BI, reporting system to drag and drop columns into a report, the software is almost certainly building an SQL query behind the scenes which runs on the database and returns your selected data. Knowing how to use the SQL itself can make you an expert user of BI systems or help you to abandon your reporting interface altogether and talk to your database directly.
By the end of this course, you will be able to retrieve data from your database using queries that you have designed and built. You will also be able to run calculations, filter results, merge fields and aggregate data within your query. This course is intended for people who need to get answers from their data. Perhaps, you're a business analyst, manager or data scientist. It's aimed at technically-abled business people rather than IT staff. The course assumes that you have access to a database at your work.
This might be through a reporting system or direct access. If you don't have access to a database or a server, you can still follow the course by downloading software and sample data. There are instructions on this in section six of this chapter. The course touches upon database design too, ideas such as data types and table structures. How your database is set up affects how you write your code so knowing a bit about databases will help you to avoid common pitfalls in using Sequel. SQL is a straight-forward language to learn, even for people who've never coded anything before.
There are several versions of SQL and this course will point out variations for the major ones. SQL can let you edit, insert and delete data in a database. It can create the fields, tables and databases that house the data but this course does not cover these functions. Rather, it is focused on how to retrieve data efficiently and manipulate that data like a pro.
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