See why this is one of the TOP RATED SQL/MySQL Courses on Udemy:
See why this is one of the TOPRATEDSQL/MySQLCourses on Udemy: "Clear presentation of information and with enough repetition of important SQLconcepts to help make the information memorable. Loved the frequent practice examples and code debugging exercises!" - Maggi M. "I totally loved this course! Everything was very easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much about MySQLand had fun doing it. In fact, at the end of the day I didn't want to stop learning -- I wanted to keep charging on to the next lesson!" - Ann S. "John's deep understanding of SQL and database analysis and ability to explain those tools to a newcomer with 0 experience, is really unmatched. I've taken other SQL and MySQLcourses and tried reading books, but this course is by far the easiest way to understand SQL. Excited to see more courses from John!" - Steven M. ______________________________ 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 MySQLWorkbench, 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 SQLand database analysis skills along the way. ______________________________ COURSEOUTLINE: SQLIntro &MySQLSetup 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 MySQLdatabase (MySQLCommunity Server +MySQLWorkbench) SQLDatabase 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 MySQLdatabase, containing information about Maven Movies customers, inventory, and transactions. Analyzing Data from Single Tables with MySQL In this section we'll start exploring and extracting information from individual tables in our MySQLdatabase, and practice writing SQL queries to select, filter, sort and group our data. [MID-COURSEMYSQLPROJECT] SQL Database Fundamentals (Part 2) The second half of the course is all about anayzing data from multiple tables in MySQL, so we'll begin with a quick review of relational databases and database analysis:primary vs. foreign keys, relationship cardinality, normalization, etc. Analyzing Multiple Tables via MySQLJOINS In this section, we'll review the most common types of SQLjoins (INNER, LEFT, RIGHT, OUTER, etc), and explore some more complex MySQL queries to analyze data that bridges multiple tables in our database. [FINAL MYSQLPROJECT] IMPORTANTNOTE:This course does NOTcover building, altering, or maintaining SQL/MySQL databases. Our goal here is to focus on data exploration and database analysis using MySQL and MySQLWorkbench (we'll cover database administration tools in a separate course). ______________________________ Enroll today and get LIFETIMEaccess to: 5+hours of high-quality video Downloadable MySQLebook and cheat sheets Quizzes and homework assignments Mid-course and Final SQLprojects 30-day money-back guarantee If you’re looking for a hands-on, practical guide to mastering data analysis with SQL/MySQL, this is the course for you! Happy analyzing! -John (Lead SQLInstructor &MySQLExpert, Maven Analytics) ______________________________ P.S. Looking to master the full Microsoft Excel, Power BI +SQLstack? Search for "Maven Analytics"and complete the courses below to become a business intelligence ROCKSTAR: Excel Pro Tips for Power Users Advanced Excel Formulas &Functions Data Visualization with Excel Charts &Graphs Data Analysis with Excel PivotTables Excel Power Query, Power Pivot &DAX Up &Running with Power BIDesktop Publishing to Power BIService SQLDatabase Analysis for Beginners Advanced MySQLfor Analytics &Business IntelligenceDescription
Course content
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.