MySQL is a relational database management system based on SQL – Structured Query Language. The application is used for a wide range of purposes, including data warehousing, e-commerce, and logging applications.
The MySQL is the world's most popular open source database.
The MySQL relational database is used to store data that can be manipulated using queries. It is used a lot in web development and other areas. In this course we are only covering the basics which should enable you write your own queries to get data from a database.
MySQL is currently owned and supported by the database giant Oracle. There is a commercial licensed version of MySQL that can be purchased that comes with premium support MySQL is a popular ,reliable and scalable relational database management system that is used by lots of companies and establishments all over the world. For example the social networking site Pinterest and The Space company Nasa just to mention a couple. In this basic beginners course, we'll introduce the concepts of relational database management systems in general, and how they relate to MySQL in particular.
Here is what you will learn:
MySQL Installation
MySQL Data Types.
Basic CRUD Operations
MySQL Access Privileges
MySQL Table Joins
Aggregate Functions
MySQL Clauses
MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modelling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.
MySQL Workbench enables a DBA, developer, or data architect to visually design, model, generate, and manage databases. It includes everything a data modeler needs for creating complex ER models, forward and reverse engineering, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort.
