Author
Emma Saunders
Released
10/21/2016Join 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
Skill Level Intermediate
Duration
Views
- [Emma] Hi, I'm Emma Saunders and this is SQL for Data Reporting and Analysis. This course will teach you how to retrieve and manipulate data from a database. By the end you will be able to build your own queries to report data, adding filters, merging fields, running calculations and grouping your results. You will also know a bit about database design. To help you avoid common pitfalls in writing queries. This course is aimed at technically able business people, rather than IT staff.
If you report or analyze data, this course can help you to become more efficient, by working with your database directly. So, let's get started.
-
Introduction
-
Welcome43s
-
Who this course is for2m 3s
-
Different versions of SQL2m 54s
-
Database setup2m 47s
-
Code in SQL5m 28s
-
-
1. Use SQL to Report Data
-
Data types in SQL databases5m 47s
-
2. Group your SQL Results
-
3. Merge Data from Multiple Tables
-
Visualize your database9m 16s
-
Combine rows with SQL UNION3m 36s
-
4. Advanced Features and Taking Your Learning Forwards
-
Functions5m 56s
-
Procedures3m 26s
-
Conclusion23s
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Welcome