MENU
SQL
This chapter provides a quick tour of SQL using MySQL Workbench, a unified visual tool for database management. Its graphical interface gives database architects and administrators an easier way to model data, build and run SQL queries, and maintain a database.Although several different SQL database engines exist (see SQL Engines), most share the same core language as MySQL, one of the most popular SQL distributions.
The following topics walk through installing MySQL Server, performing basic CRUD (Create, Read, Update, Delete) operations, and mastering a handful of essential SQL concepts:
- Setting Up MySQL Server - installing and configuring MySQL on Windows, Linux (Ubuntu), Mac, and XAMPP.
- Basic CRUD - creating a sample database and performing Create, Read, Update, and Delete operations.
- Essential Concepts - sorting, limiting, aggregate functions, joins, indexes and constraints, subqueries, and common table expressions (CTEs).