We've Moved - eBookFrenzy is now Payload Publishing.

Visit our new site at https://www.payloadbooks.com.

MySQL Essentials eBook


This eBook is intended to teach the basics of using the MySQL relational database management system (RDBMS) to create and manage databases and is ideal for those unfamiliar with both databases in general and MySQL in particular.

Topics covered include the basics of relational databases, MySQL installation on Linux and Windows systems, an overview of the MySQL administration tools, database security and detailed tutorials on using SQL to create, manage and retrieve data.

Purchase includes eBook in PDF and ePub formats.

Product Details

Page Count: 123
Page Size: 8.50 x 11.00
Language: English
Format: PDF and ePub
Price: $9.99

eBook Contents

  • Database Basics
  • MySQL Database Architecture
  • The mysql Command-Line Tool
  • Creating Databases and Tables Using SQL Commands
  • Updating and Deleting MySQL Tables
  • Inserting Data into a MySQL Database
  • Updating and Deleting MySQL Data
  • Retrieving Data From a MySQL Database
  • Sorting Data Retrieved from a MySQL Database
  • Using WHERE to Filter MySQL Data
  • Advanced MySQL Data Filtering - AND, OR, NOT and IN
  • MySQL Wildcard Filtering using LIKE
  • MySQL Regular Expression Searches
  • Joining Tables in MySQL
  • An Introduction to MySQL Views
  • MySQL Calculations and Concatenations
  • Manipulating Text in MySQL
  • MySQL Mathematical Functions
  • Working with Dates and Times in MySQL
  • MySQL Data Aggregation Functions
  • MySQL Users and Security
  • Administering and Monitoring MySQL using the MySQL Workbench
  • Using the MySQL Workbench SQL Editor
  • Using MySQL Workbench to Create a Database Model

Featured Titles

Tell me more... Tell me more... Tell me more... Tell me more...

Tell me more... Tell me more... Tell me more... Tell me more...