SQL: Data Reporting and Analysis

( 0 Reviews )

Created by: Emma Saunders

Produced in 2016

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 0 / 100

Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a sql course? Or looking for more detail on Emma Saunders's SQL: Data Reporting and Analysis? Feel free to chat below.

Join CourseDuck's Online Learning Discord Community

Course Description

Do you rely on IT to get you the data you need? Do you wish you could retrieve it yourself? SQL for Data Reporting and Analysis teaches you how to get the data you want by writing a bit of SQL code. You won't just be able to pull data out of the database; you'll be able to manipulate it: merging it, multiplying it, grouping it, and relabeling it to get just the report you want.

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.

Intermediate Level

Time: 2h 16m

Instructor Details

Emma Saunders

0.0 Rating
0 Reviews

Emma Saunders is a freelance data consultant specializing in data visualization on the web.

She uses HTML, CSS, D3, DC, Crossfilter, JavaScript, PHP, SQL, and VBA in her work, but she is a designer as much as a coder. Emma enjoys finding the story in data, and working out the best way to communicate that story.

A graduate of Oxford University, Emma has 15 years of business experience, starting on the Shell graduate scheme, and moving to Credit Suisse, the UK financial regulator, and even working a brief spell as a journalist at the Financial Times in London. She has never worked in an IT department, but taught herself coding skills as they have become useful from job to job. She also ran her own online business for a few years from 2006, and coded an ecommerce site for that venture. She is available professionally via https://vizdata.co.uk.