1. All topics
  2. Business
  3. Business Software and Tools
  4. Data Analysis
Intermediate SQL: Data Reporting and Analysis Preview

Intermediate SQL: Data Reporting and Analysis

With Emma Saunders Liked by 1,382 users
Duration: 2h 11m Skill level: Intermediate Released: 11/14/2022

Start my 1-month free trial Buy for my team

Course details

If you’re already familiar with the fundamentals of SQL covered in our introductory course on SQL: Data Reporting and Analysis, you may be interested in taking your skills to the next level and learning a few more new tricks of the trade. Join data consultant Emma Saunders in this hands-on, practical follow-up, designed specifically to help you grow beyond the basics so you can start writing more complex queries to change data in the database instead of just reporting it.

Expand your SQL toolbox, including how to query data in real time for reporting, editing, inserting, and deleting. Learn new date, number, and string functions to manipulate data as you retrieve it. Along the way, test out your technical know-how with the coding challenges and quizzes at the end of each section.

Skills you’ll gain

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

Meet the instructor

Learner reviews

4.6 out of 5

373 ratings
  • 5 star
    Current value: 278 75%
  • 4 star
    Current value: 64 17%
  • 3 star
    Current value: 25 7%
  • 2 star
    Current value: 4 1%
  • 1 star
    Current value: 2 <1%
  • Alexander Serov Alexander Serov

    Alexander Serov

    Senior Data Scientist | AI, Modeling & Simulations | Statistical Modeling, Machine Learning & Optimization | Ph.D. Biophysics, École Polytechnique

    4/5 January 3, 2025
    It's a good course with great delivery, correct selection of topics (all basic database operations) and practical examples. The only things I could suggest to improve are: - the last challenge could have been designed better: it's over complex for the objective it is trying to achieve, - sakila database can be downloaded to run locally, which would remove all the references to impact from or on other users, which would make the delivery more fluid.
    Helpful · Report
  • Ritesh kumar Ritesh kumar

    Ritesh kumar

    B-tech Computer Science Student| Frontend Developer Proficient in HTML, CSS, Javascript, React | Data Science

    4/5 November 24, 2024
    Intermediate SQL is a vital skill for effective data reporting and analysis. It allows users to work with data from multiple tables using different types of joins, such as INNER, LEFT, RIGHT, and FULL OUTER joins, to combine and extract meaningful insights. Aggregation functions like COUNT, SUM, AVG, MIN, and MAX help summarize data efficiently, while GROUP BY enables grouping and filtering with the HAVING clause to refine results. Subqueries provide a way to nest queries, enabling dynamic filtering and advanced data manipulation. Window functions, including ROW_NUMBER(), RANK(), and OVER(), allow for advanced analytics like ranking and cumulative calculations. Common Table Expressions (CTEs) simplify complex queries and improve readability by structuring logic with WITH clauses. Additional formatting features, such as the use of CASE, string functions, and date-time operations, enhance the clarity of reports. Lastly, performance optimization techniques, like indexing and efficient que
    Helpful · Report
  • ZVIDZAI CHINOMONA ZVIDZAI CHINOMONA

    ZVIDZAI CHINOMONA

    BANK TELLER at CBZ Bank Ltd

    5/5 October 29, 2024
    Yes very useful
    Helpful · Report

Contents

What’s included

  • Test your knowledge 3 quizzes
  • Learn on the go Access on tablet and phone

Similar courses

Download courses

Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.

Download on the App Store Get it on Google Play