Why MySQL Should Be Your Database

365 Careers
A free video tutorial from 365 Careers
Creating opportunities for Business & Finance students
4.5 instructor rating • 57 courses • 982,348 students

Lecture description

Why did we choose MySQL and not some other relational database management system?

Because it is:

  • reliable
  • mature
  • open-source

Learn more from the full course

SQL - MySQL for Data Analytics and Business Intelligence

SQL that will get you hired – SQL for Business Analysis, Marketing, and Data Management

09:20:17 of on-demand video • Updated June 2020

  • Become an expert in SQL
  • Learn how to code in SQL
  • Boost your resume by learning an in-demand skill
  • Create, design, and operate with SQL databases
  • Start using MySQL – the #1 Database Management System
  • Prepare for SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities
  • Adopt professionally tested SQL best practices
  • Gain theoretical insights about relational databases
  • Work with a sophisticated real-life database throughout the course
  • Get maximum preparation for real-life database management
  • Add data analytical tools to your skillset
  • Develop business intuition while solving tasks with big data
  • Study relational database management theory that you will need in your workplace every day
  • Learn how to create a database from scratch
  • The ability to take control of your dataset – insert, update, and delete records from your database
  • Be confident while working with constraints and relating data tables
  • Become a proficient MySQL Workbench user
  • Acquire top-notch coding techniques and best practices
  • Know how to answer specific business questions by using SQL’s aggregate functions
  • Handle complex SQL joins with ease
  • Approach more advanced topics in programming like SQL’s triggers, sequences, local and global variables, indexes, and more
  • Merge coding skills and business acumen to solve complex analytical problems
  • Become a proficient SQL user by writing flawless and efficient queries
  • Tons of exercises that will solidify your knowledge
  • The freedom to query anything you like from a database
English OK, so... at this point you might be telling yourself: Great Let me install a software containing SQL and start the course. Unfortunately, it is not so simple. Why? To implement SQL commands, you will need a database management system, often called a database or a platform. The problem is there are a few popular databases out there, which are all based on SQL. They support various forms of the original language and there are only slight differences between different versions. As a developer, you want to learn how to use the one that is the most suitable for your situation. We will base our course entirely on MySQL, but you should know there are other platforms like Oracle, SQLite, Microsoft SQL Server, postscripts sequel. Maria DB, Microsoft Access, and so on. The minor differences between the versions of the SQL language mean that transferring from one database to the other (which usually happens if your changing jobs) would not be an obstacle for you. If you are a user of another platform, you can still take this course and easily apply the tools we teach. So, why do we choose MySQL? Because it is reliable mature and open source. The latter means it is free. It is used by many institutions and companies, including Facebook YouTube, Dropbox, Twitter, Pinterest, Booking.com and LinkedIn. Considering the well-renowned DB-Engines Ranking, MySQL comes as the first open-source relational database management system. Yes, Oracle is on top with only a slight advantage, but don't forget it is a paid software! Therefore, aiming at providing you with the best experience possible, we chose MySQL. Now let's dig into some Database and SQL theory. This will provide the set of tools you'll need when we deal with various SQL tasks in the lessons to come. Thanks for watching!