SQL for MySQL: A Beginner's Tutorial
- 1h 23m
- Djoni Darmawikarta
- Brainy Software Corp.
- 2014
Written by a database expert with 20 years commercial experience, this manual is an approachable and user-friendly introduction to the SQL variant for MySQL. SQL, which stands for Structured Query Language is the standard language you use to interact with a relational database management system (RDBMS). This book uses the free edition of the MySQL database to show how SQL works. It teaches beginners how to select data from the database, insert and update data, and how to create database objects with chapters that detail each topic with jargon-free language.
About the Author
Djoni Darmawikarta is an expert in data warehousing and business intelligence. He worked for IBM for 17 years as a systems engineer, a consultant, and a customer support manager before joining a Toronto-based insurance company as a senior data analyst. He is the author of Dimensional Data Warehousing with MySQL: A Tutorial.
In this Book
-
Introduction
-
Storing and Maintaining Data
-
Basic Queries
-
Full-Text Search
-
Query Output
-
Grouping
-
Joins
-
Subqueries
-
Compound Queries
-
Views
-
Built-in Functions
-
Transactions
-
Stored Routines
-
The Data Dictionary
