A beginner's guide to MySQL

Learn the basics of MySQL

3.70 (216 reviews)

Udemy

platform

English

language

Databases

What you will learn

MySQL Basics

MySQL Database CRUD Operations

MySQL Advance Query Features Like GroupBy etc.

MySQL Optimization

Why take this course?

MySQL is written in C and C++. Its SQL parser is written in yacc, but it uses a home-brewed lexical analyzer.

MySQL works on many system platforms, including AIX, BSDi, FreeBSD, HP-UX, ArcaOS, eComStation, IBM i, IRIX, Linux, macOS, Microsoft Windows, NetBSD, Novell NetWare, OpenBSD, OpenSolaris, OS/2 Warp, QNX, Oracle Solaris, Symbian, SunOS, SCO OpenServer, SCO UnixWare, Sanos and Tru64. A port of MySQL to OpenVMS also exists.

The MySQL server software itself and the client libraries use dual-licensing distribution. They are offered under GPL version 2, or a proprietary license.

MySQL is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter, and "SQL", the abbreviation for Structured Query Language. A relational database organizes data into one or more data tables in which data types may be related to each other; these relations help structure the data. SQL is a language programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.

MySQL is free and open-source software under the terms of the GNU General Public License, and is also available under a variety of proprietary licenses. MySQL was owned and sponsored by the Swedish company MySQL AB, which was bought by Sun Microsystems (now Oracle Corporation). In 2010, when Oracle acquired Sun.

MySQL has stand-alone clients that allow users to interact directly with a MySQL database using SQL, but more often, MySQL is used with other programs to implement applications that need relational database capability. MySQL is a component of the LAMP web application software stack (and others), which is an acronym for Linux, Apache, MySQL, Perl/PHP/Python. MySQL is used by many database-driven web applications, including Drupal, Joomla, phpBB, and WordPress. MySQL is also used by many popular websites, including Facebook, Twitter, and YouTube.

Screenshots

A beginner's guide to MySQL - Screenshot_01

A beginner's guide to MySQL - Screenshot_02

A beginner's guide to MySQL - Screenshot_03

A beginner's guide to MySQL - Screenshot_04

Reviews

Roberto

September 12, 2023

It's very difficult to understand what the tutor is saying, and the subtitles are almost random. It's too fast to follow for a complete novice, and what is being said is hard to comprehend.

Nadav

June 26, 2023

The teacher's accent was very hard to interpret, and there were no subtitles. There were no chances to practice the lessons learned.

James

October 8, 2022

Quality of these captions is laughable.. at least you can hear this instructor and not have to rely on them. That said, whoever paid that guy needs to get their money back.. seriously. I wouldn't hire that guy to teach children how to tie shoelaces.

Gargi

May 27, 2022

1.The Beginners course should provide a high level view of what the end would like and its usefulness in work before diving into the installation. 2.The SQL version isnot updated in the course and I am not able to progress from Section 1.3 onwards. 3.The speech delivery of the coach is flat and monotonous.

Noemi

January 30, 2022

I know that is free and short, so i was not expecting much but I guess I trusted I could learn something. The teacher uses tables that you dont have, or it doesn't tell you how to find them, so you cannot follow the examples or even practice. Also, the accent is a bit strong and you cannot follow the subtitles because they are not correct, so there are lessons at the end when gets more complicated, that you don't know what he is saying. Please, can someone fix the subtitles? that will make it so much better. Anyway, It is a super basic course in which you only will understand how this program he uses looks like and get a very basic concept of the whole thing.

Charts

Price

Rating

Enrollment distribution

A beginner's guide to MySQL - Distribution chart