A beginner's guide to MySQL

Learn the basics of MySQL
Free tutorial
Rating: 3.7 out of 5 (115 ratings)
3,880 students
34min of on-demand video
English
English [Auto]

MySQL Basics
MySQL Database CRUD Operations
MySQL Advance Query Features Like GroupBy etc.
MySQL Optimization

Requirements

  • Basic computer knowledge

Description

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.

Who this course is for:

  • Aspiring Database Developers
  • Aspiring Web Developers
  • Web Developers
  • Database Developers

Instructor

Start Learning Today...
SkillBakery Studio
  • 3.8 Instructor Rating
  • 1,658 Reviews
  • 33,397 Students
  • 33 Courses

SkillBakery is one of the fastest growing online education company.

Our vision is to provide high quality education which is affordable and accessible to everyone

We believe that every one has their own way of learning and grasping things and that's why we provide self-paced HD quality contents,so you can learn what you love at your convinience

We currently offer courses in web development and will soon be publishing new courses in other categories as well

We are committed to bring courses on new topics and we try to release one new course every month

So keep visiting us, you will surely find something for yourself here.

Top companies trust Udemy

Get your team access to Udemy's top 17,000+ courses