Maven Analytics
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
Courses : 2
Specification: SQL for Data Analysis: Beginner MySQL Business Intelligence
|
55 reviews for SQL for Data Analysis: Beginner MySQL Business Intelligence
Add a review
| Price | $24.99 |
|---|---|
| Provider | |
| Duration | 4.5 hours |
| Year | 2022 |
| Level | All |
| Language | English |
| Certificate | Yes |
| Quizzes | Yes |
$24.99
Liong Mei Lai –
It has been easy to understand and follow for a complete beginner like myself. Loving it!
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
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!
Nirjhar Sinha –
Excellent, want more examples
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.
Jeb Percival –
So far it’s been informative and easy to follow.
Jilles de Vries –
Very clear
Dave Pua –
Very intuitive. I also liked how every topic discussed, there is a small exercise to help really understand each and every topic.
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.
Jorge Porras –
Es un excelente curso para aprender SQL
Staci A. Berry –
I use it as reference for my job everyday.
Lasisi Salmah –
Yes,am really learning a lot
Olumide Olaoye –
Awesome so far. I’m having a great time.
Pingping Gou –
The teacher explained in very details and very clear instructions!
Esther Ifyede –
I am loving it already.
Nir Erez –
VERY UNDERSTANDABLE AND COMPREHENSIVE
Mojeed Akande –
Highly recommended!!!
Achmad Praditya Wardhana –
Definitely! Practical SQL is all I need. Thanks!
Puja bhalla –
Thank you so much for detailing out the process of downloading the tool. It really helped a lot !
Arun V Josh –
It is one of the best courses. I will recommend it to beginners.
Jeremy –
Awesome! Looking forward to more of your courses
Genmu Miller –
Great course
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!
Anishkumar Sadasivam –
I found this course very useful. Looking to build on my SQL from here
Donald Turrell –
Great instructor, Wish I had taken the course when I first started with MySQL
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.
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!
Carmen Martinez –
Genial
Prakhar Mishra –
Very good experience learnt a lot with this course
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.
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.
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
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
Stephanus Advena Setia –
It was excellent!
Anjali Jha –
good
Lakshmimedha –
Great
Steve –
Excellent course for learning SQL from scratch. Will look into taking more courses from this instructor.
Olutosin Akinsomisoye –
Very explicit and easy to follow. I am going to take the advanced course!
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.
Benjamin Popoola –
Pace is good. The explanation detailed and well ordered
Yatish Devadiga –
Best course for beginner to learn SQL
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.
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.
Santosh Kumar Waddi –
Excellent course for beginners. Quiz and assignments are additional assets for this course
Bohdan Punyk –
It is VERY basic, but very thorough. Would have been nice if it had a bit more functions in it
Smita Mathad –
informative
D K –
The most outstanding beginner course and most outstanding instructor. Advanced course is a must after this. I love John Pauler’s courses!
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
Atul S Rathi –
Very Good & Useful
Christian Ampon –
I love the experience. very cool
Ricardo Mitchell –
Nice so far
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.
Krishna Tibrewal –
Can include more questions and did not cover primary key,foreign key and other constraints
Basher Farhang –
Great class, enjoy it.
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.