Beginner Series: MySQL Tutorial
In terms of a relational database system MySQL has a few features to offer that help it stand out from similar platforms:
- MySQL Offers Client/Server Architecture: MySQL is both a client and server system. This means that there is a database server, which client programs can connect to.
- It’s Compatible with SQL: MySQL supports SQL (Structured Query Language).
- It Supports Views: MySQL has supported them since version 5.0.
- Stored Procedures: MySQL uses stored procedures to process data storage and retrieval.
- It Can Process SubSELECT Queries: This is a special form of query that references direct tables.
- Triggers: MySQL supports triggers like INSERT, UPDATE, and DELETE. These are executable server commands which get carried out automatically.
- Unicode: MySQL supports several sets of Unicode like Latin-1, Latin-2, and more.
- Full-Text Search: MySQL is capable of performing a full-text search for content across the database, even for information stored within it.
- Replication: MySQL database content can be replicated on multiple computers to improve database query speeds, and offer another form of protection (data backup).
- Transactions: MySQL will allow developers to create transactions or groups of commands that are always carried out together even in the event of a system failure.
- MySQL Supports Foreign Key Constraints: When working with InnoDB tables, MySQL will ensure that cross references do not link to tables that lead to nowhere.
- It Supports GIS Applications: MySQL can be used to store two-dimension geographical data, which means that it can support GIS (geographic information systems) applications.
- It Supports Multiple Languages: Through APIs (application programming interfaces) and libraries you can develop MySQL applications using a variety of languages such as C, C++, Perl, Java, PHP, Tcl, and Python.
- ODBC Interface Connector: MySQL includes support for the ODBC interface connector. Commonly used by Windows, the interface allows MySQL to be addressed by languages such as Delphi, Visual Basic, and others.
- It Supports Multiple Operating Systems: The MySQL server and client applications are supported across multiple OS versions, such as Mac OS X, Linux, Windows, Unix, and more.
- MySQL is Fast: Backed up by a number of benchmark tests, MySQL is considered a remarkably speedy database system.
Next, we’ll explore How MySQL is Different from PostgreSQL.
Recommended Training – Treehouse
Although this site recommends various training services, our top recommendation is Treehouse.
Treehouse is an online training service that teaches web design, web development and app development with videos, quizzes and interactive coding exercises.
Treehouse's mission is to bring technology education to those who can't get it, and is committed to helping its students find jobs. If you're looking to turn coding into your career, you should consider Treehouse.
Disclosure of Material Connection: Some of the links in the post above are “affiliate links.” This means if you click on the link and purchase the item, I will receive an affiliate commission. Regardless, I only recommend products or services I use personally and believe will add value to my readers.