Latest Courses
data build tool in Cloud(dbt Cloud)Check course
Dagger Hilt Dependency Injection MasterclassCheck course
Introduction to JavaCheck course
Feature importance and model interpretation in PythonCheck course
GIT for beginnersCheck course
The Ultimate Authentication Course with NodeJS and AngularCheck course
Master Data Science | A Step-by-Step Guide for 2022Check course
Master Google Cloud | A Step-by-Step Guide for 2022Check course
Data Science Machine Learning & AI with 7 Hands on ProjectsCheck course
Laravel Scout and Cashier with projects in Laravel 8Check course
data build tool in Cloud(dbt Cloud)Check course
Dagger Hilt Dependency Injection MasterclassCheck course
Introduction to JavaCheck course
Feature importance and model interpretation in PythonCheck course
GIT for beginnersCheck course
- 82% MySQL for Data Analysis - SQL Database for Beginners

SQL for Data Analysis: Beginner MySQL Business Intelligence

$24.99Track price

Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare
9.1/10 (Our Score)
Product is rated as #6 in category SQL

SQL and MySQL are incredibly powerful tools for managing and analyzing relational databases, and a skill that every Analyst and Business Intelligence professional should have in the arsenal.

In this course, you’ll play the role of a business owner who just acquired Maven Movies, a brick and mortar DVD rental shop. Using only a MySQL database and MySQL Workbench, your mission is to learn everything that you can about your new business; including your inventory, staff, and customer behavior.

But don’t worry, you’re not alone! We’ll be right here to guide you from start to finish, sharing crystal clear explanations, MySQL pro tips and best practices, and course quizzes, projects and homework assignments to test your SQL and database analysis skills along the way.

COURSE OUTLINE:

SQL Intro & MySQL Setup

We’ll start with a quick intro to the SQL landscape and it’s common flavors (MySQL, SQLite, PostgreSQL, etc), then download and install the tools that we’ll need to access and explore our MySQL database (MySQL Community Server + MySQL Workbench)

SQL Database Fundamentals (Part 1)

Once we have our tools installed, we’ll quickly review some database fundamentals and begin to explore the 16 tables contained within our MySQL database, containing information about Maven Movies customers, inventory, and transactions.

Instructor Details

Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 190 countries develop the most sought-after analytics skills, through on-demand courses, personalized skills assessments, curated learning paths, and enterprise training. Learning new skills shouldn t be complicated. Think of Maven as your personal team of instructors, experts, mentors and guides, helping you navigate the learning process and develop the skills you need, on-demand.

Specification: SQL for Data Analysis: Beginner MySQL Business Intelligence

Duration

4.5 hours

Year

2022

Level

All

Certificate

Yes

Quizzes

Yes

55 reviews for SQL for Data Analysis: Beginner MySQL Business Intelligence

4.6 out of 5
40
11
3
1
0
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. Liong Mei Lai

    It has been easy to understand and follow for a complete beginner like myself. Loving it!

    Helpful(0) Unhelpful(0)You have already voted this
  2. Gerry Papenburg

    Great course by John, very knowledgeable and easy to understand and follow. Will be taking up other courses by this instructor. Thanks John

    Helpful(0) Unhelpful(0)You have already voted this
  3. Thomas Sardelic

    Really amazing course. So many mini assignments and then the big final assignments mid course and at the end really allow you to elevate those skills and feel confident about moving onto the next technique. Thank you so much!

    Helpful(0) Unhelpful(0)You have already voted this
  4. Nirjhar Sinha

    Excellent, want more examples

    Helpful(0) Unhelpful(0)You have already voted this
  5. Sandra Plewes

    The instructions to download and configure the application were not exactly as being demoed. I needed to stop and rewind while i was following along to ensure that I had all of the pieces setup correctly.

    Helpful(0) Unhelpful(0)You have already voted this
  6. Jeb Percival

    So far it’s been informative and easy to follow.

    Helpful(0) Unhelpful(0)You have already voted this
  7. Jilles de Vries

    Very clear

    Helpful(0) Unhelpful(0)You have already voted this
  8. Dave Pua

    Very intuitive. I also liked how every topic discussed, there is a small exercise to help really understand each and every topic.

    Helpful(0) Unhelpful(0)You have already voted this
  9. Melanie Alveranga

    This was a great course as an intro to MySQL. I initially took the course just to get some understanding of SQL but have learned enough SQL to apply some pretty good fundamental queries at work on some of our databases. I would definitely recommend this course to anyone looking for a good intro and I plan to check out the advanced course once I’ve put in a little more practice at work.

    Helpful(0) Unhelpful(0)You have already voted this
  10. Jorge Porras

    Es un excelente curso para aprender SQL

    Helpful(0) Unhelpful(0)You have already voted this
  11. Staci A. Berry

    I use it as reference for my job everyday.

    Helpful(0) Unhelpful(0)You have already voted this
  12. Lasisi Salmah

    Yes,am really learning a lot

    Helpful(0) Unhelpful(0)You have already voted this
  13. Olumide Olaoye

    Awesome so far. I’m having a great time.

    Helpful(0) Unhelpful(0)You have already voted this
  14. Pingping Gou

    The teacher explained in very details and very clear instructions!

    Helpful(0) Unhelpful(0)You have already voted this
  15. Esther Ifyede

    I am loving it already.

    Helpful(0) Unhelpful(0)You have already voted this
  16. Nir Erez

    VERY UNDERSTANDABLE AND COMPREHENSIVE

    Helpful(0) Unhelpful(0)You have already voted this
  17. Mojeed Akande

    Highly recommended!!!

    Helpful(0) Unhelpful(0)You have already voted this
  18. Achmad Praditya Wardhana

    Definitely! Practical SQL is all I need. Thanks!

    Helpful(0) Unhelpful(0)You have already voted this
  19. Puja bhalla

    Thank you so much for detailing out the process of downloading the tool. It really helped a lot !

    Helpful(0) Unhelpful(0)You have already voted this
  20. Arun V Josh

    It is one of the best courses. I will recommend it to beginners.

    Helpful(0) Unhelpful(0)You have already voted this
  21. Jeremy

    Awesome! Looking forward to more of your courses

    Helpful(0) Unhelpful(0)You have already voted this
  22. Genmu Miller

    Great course

    Helpful(0) Unhelpful(0)You have already voted this
  23. Wayne Soltis

    Yet another great Maven course! This is an amazing way to invest in yourself anytime but especially during COVID19 (and for such a reasonable price tag)! Maven instructors are complete masters of their subject matter. I am a hands on learner and these courses are tailor made for me. I highly recommend ANY Maven course!

    Helpful(0) Unhelpful(0)You have already voted this
  24. Anishkumar Sadasivam

    I found this course very useful. Looking to build on my SQL from here

    Helpful(0) Unhelpful(0)You have already voted this
  25. Donald Turrell

    Great instructor, Wish I had taken the course when I first started with MySQL

    Helpful(0) Unhelpful(0)You have already voted this
  26. Emilio Pantaleon

    Excellent course, I would recommend it. I like this course because uses a project based approach and the theme of that project is carried throughout the course. John teaches the course simple, practical and easy to follow.

    Helpful(0) Unhelpful(0)You have already voted this
  27. Alex Long Pham

    Very practical and easy to understand. John makes it very clear to understand the concepts and he is will answer your questions in a very timely manner!

    Helpful(0) Unhelpful(0)You have already voted this
  28. Carmen Martinez

    Genial

    Helpful(0) Unhelpful(0)You have already voted this
  29. Prakhar Mishra

    Very good experience learnt a lot with this course

    Helpful(0) Unhelpful(0)You have already voted this
  30. Shreyash Dahale

    An exceptional beginner level course. I would’ve given a 5 star rating if it weren’t for how the instructor would frequently write incorrect code for the sake of explanation. This is great from a learning perspective, but some intentional error inclusions were unnecessary.

    Helpful(0) Unhelpful(0)You have already voted this
  31. Julian Hinds

    Great course for whatever level of your SQL skills are. I’ve used SQL for a few years in a very limited capacity so this course was a great to expand my knowledge. The instructor/presentation have made it very clear and easy to follow, highly recommend! I’ve purchased the advanced course, can’t wait to jump in.

    Helpful(0) Unhelpful(0)You have already voted this
  32. Som Munda

    I have’t start yet , once i will start and learn what i am expecting as of my knowledge and skills . Thank you

    Helpful(0) Unhelpful(0)You have already voted this
  33. Jithesh K B

    This course helped me to remember most of the things studied during during my Bachelors.To continue with the flow I will be enrolling for the advanced Sql course to improve my analysis skills

    Helpful(0) Unhelpful(0)You have already voted this
  34. Stephanus Advena Setia

    It was excellent!

    Helpful(0) Unhelpful(0)You have already voted this
  35. Anjali Jha

    good

    Helpful(0) Unhelpful(0)You have already voted this
  36. Lakshmimedha

    Great

    Helpful(0) Unhelpful(0)You have already voted this
  37. Steve

    Excellent course for learning SQL from scratch. Will look into taking more courses from this instructor.

    Helpful(0) Unhelpful(0)You have already voted this
  38. Olutosin Akinsomisoye

    Very explicit and easy to follow. I am going to take the advanced course!

    Helpful(0) Unhelpful(0)You have already voted this
  39. Stephen Minter

    Just got to the end and thought it was great. Maven do a really good job with practice examples that really help you to understand really world use cases.

    Helpful(0) Unhelpful(0)You have already voted this
  40. Benjamin Popoola

    Pace is good. The explanation detailed and well ordered

    Helpful(0) Unhelpful(0)You have already voted this
  41. Yatish Devadiga

    Best course for beginner to learn SQL

    Helpful(0) Unhelpful(0)You have already voted this
  42. Doug Ouverson

    I like that all the material and instruction are presented and taught in context. The instructor is a good communicator. I can recommend this course without reservation.

    Helpful(0) Unhelpful(0)You have already voted this
  43. Rajnil Guha

    SQL is one of the most powerful tools to understand what is there in your data. This course is great for people who are starting with SQL and also for people who have worked with SQL before but been out of touch for sometime and are now looking to brush up the concepts.

    Helpful(0) Unhelpful(0)You have already voted this
  44. Santosh Kumar Waddi

    Excellent course for beginners. Quiz and assignments are additional assets for this course

    Helpful(0) Unhelpful(0)You have already voted this
  45. Bohdan Punyk

    It is VERY basic, but very thorough. Would have been nice if it had a bit more functions in it

    Helpful(0) Unhelpful(0)You have already voted this
  46. Smita Mathad

    informative

    Helpful(0) Unhelpful(0)You have already voted this
  47. D K

    The most outstanding beginner course and most outstanding instructor. Advanced course is a must after this. I love John Pauler’s courses!

    Helpful(0) Unhelpful(0)You have already voted this
  48. Angeline Silva Netto

    This instructors detailed step by step instructions on what this course will cover and how to install SQL app and workbench was awesome! I am now ready to get started in working in SQL. Thanks

    Helpful(0) Unhelpful(0)You have already voted this
  49. Atul S Rathi

    Very Good & Useful

    Helpful(0) Unhelpful(0)You have already voted this
  50. Christian Ampon

    I love the experience. very cool

    Helpful(0) Unhelpful(0)You have already voted this
  51. Ricardo Mitchell

    Nice so far

    Helpful(0) Unhelpful(0)You have already voted this
  52. Akshay Dehadray

    I thoroughly enjoyed learning SQL through this course. Loved the maven movies database and practical assignments that were included as part of the coursework. Thank you John for the amazing learning experience. Looking forward to the next one.

    Helpful(0) Unhelpful(0)You have already voted this
  53. Krishna Tibrewal

    Can include more questions and did not cover primary key,foreign key and other constraints

    Helpful(0) Unhelpful(0)You have already voted this
  54. Basher Farhang

    Great class, enjoy it.

    Helpful(0) Unhelpful(0)You have already voted this
  55. Chandrashekhar Sharma

    Overall was good ! As I have saw that you have been using mostly a same tables frequently like films, actor, categories. Try to use some other tables as well. And will be great all tables have less number of columns within.

    Helpful(0) Unhelpful(0)You have already voted this

    Add a review

    Your email address will not be published.

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    SQL for Data Analysis: Beginner MySQL Business Intelligence
    SQL for Data Analysis: Beginner MySQL Business Intelligence

    $24.99

    Price tracking

    Java Code Geeks
    Logo
    Register New Account
    Reset Password
    Compare items
    • Total (0)
    Compare