SQL: Data Reporting and Analysis Sign in before you view the course to earn a certificate of completion and access exercise files

SQL: Data Reporting and Analysis

With Emma Saunders Liked by 12,494 users
Duration: 2h 17m Skill level: Intermediate Released: 12/2/2019

Course details

Do you rely on IT to get the data you need? Are you often stuck waiting in line for data, and wish you could just retrieve it yourself? In this course, learn 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, grouping it, and relabeling it to get just the report you want. Join Emma Saunders as she shows how to write simple SQL queries for data reporting and analysis using a publicly accessible online database. Learn how to filter, group, and sort data, using built-in SQL functions to format or calculate results. Discover how to perform more complex queries, such as joining data together from different database tables. Last but not least, she introduces views, procedures, functions, and variables.

Earn a sharable certificate

Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.

Sample certificate

Certificate of Completion

  • Showcase on your LinkedIn profile under “Licenses and Certificate” section

  • Download or print out as PDF to share with others

  • Share as image online to demonstrate your skill

Instructor

  • Click here to view Emma Saunders’ instructor page

    Emma Saunders

    Product design & data visualisation at Swiss Re

    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 http://vizdata.co.uk.

Skills covered in this course

Related courses

Contents