Pearson: MySQL - Developer's Library

Pearson: MySQL - Developer's Library
ISBN : 978-1-61691-464-6


uCertify uses content from well known publishers, instructors, and subject matter experts. They have a minimum of 15 years of experience in their fields. uCertify brings these textbooks to life. It is full of interactive activities that keeps the learner engaged. uCertify brings all available learning resources for a topic in one place so that the learner can efficiently learn without going to multiple places. Challenge questions are also embedded in the chapters so learners can attempt those while they are learning about that particular topic. This helps them grasp the concepts better because they can go over it again right away which improves learning. Learners can do Flashcards, Exercises, Quizzes and Labs related to each chapter. At the end of every lesson, uCertify courses guide the learners on the path they should follow.

uCertify platform supports 50+ different types of interactive activities, connect the idea, or try it yourself lab activities embedded throughout its course. These interactive activities keeps learners engaged and makes learning fun.

Here's What You Get

Each lesson comes with There is no limit to the number of times learners can attempt these.


Table of Content

Here's What you will Learn

Lesson 1: Getting Started with MySQL

  • How SQL Can Help You
  • A Sample Database
  • Basic Database Terminology
  • A MySQL Tutorial
  • Tips for Interacting with mysql
  • Where to Now?

Lesson 2: Using SQL to Manage Data

  • The Server SQL Mode
  • MySQL Identifier Syntax and Naming Rules
  • Case Sensitivity in SQL Statements
  • Character Set Support
  • Selecting, Creating, Dropping, and Altering Databases
  • Creating, Dropping, Indexing, and Altering Tables
  • Obtaining Database Metadata
  • Performing Multiple-Table Retrievals with Joins
  • Performing Multiple-Table Retrievals with Subqueries
  • Performing Multiple-Table Retrievals with UNION
  • Multiple-Table Deletes and Updates
  • Performing Transactions
  • Foreign Keys and Referential Integrity
  • Using FULLTEXT Searches

Lesson 3: Data Types

  • Data Value Categories
  • MySQL Data Types
  • How MySQL Handles Invalid Data Values
  • Working with Sequences
  • Expression Evaluation and Type Conversion
  • . Choosing Data Types

Lesson 4: Views and Stored Programs

  • Using Views
  • Using Stored Programs
  • Security for Views and Stored Programs

Lesson 5: Query Optimization

  • Using Indexing
  • The MySQL Query Optimizer
  • Choosing Data Types for Efficient Queries
  • Choosing Table Storage Formats for Efficient Queries
  • Loading Data Efficiently
  • Scheduling, Locking, and Concurrency

Lesson 6: Introduction to MySQL Programming

  • Why Write Your Own MySQL Programs?
  • APIs Available for MySQL
  • Choosing an API

Lesson 7: Writing MySQL Programs Using C

  • Compiling and Linking Client Programs
  • Connecting to the Server
  • Handling Errors and Processing Command Options
  • Processing SQL Statements
  • An Interactive Statement-Execution Program
  • Writing Clients That Include SSL Support
  • Using Multiple-Statement Execution
  • Using Server-Side Prepared Statements
  • Using Prepared CALL Support

Lesson 8: Writing MySQL Programs Using Perl DBI

  • Perl Script Characteristics
  • Perl DBI Overview
  • Putting DBI to Work
  • Using DBI in Web Applications

Lesson 9: Writing MySQL Programs Using PHP

  • PHP Overview
  • Putting PHP to Work

Lesson 10: Introduction to MySQL Administration

  • MySQL Components
  • General MySQL Administration
  • Access Control and Security
  • Database Maintenance, Backups, and Replication

Lesson 11: The MySQL Data Directory

  • The Data Directory Location
  • Structure of the Data Directory
  • Relocating Data Directory Contents

Lesson 12: General MySQL Administration

  • Securing a New MySQL Installation
  • Arranging for MySQL Server Startup and Shutdown
  • Using System and Status Variables
  • The Plugin Interface
  • Storage Engine Configuration
  • Globalization Issues
  • Server Tuning
  • Server Logs
  • Running Multiple Servers
  • Updating MySQL

Lesson 13: Security and Access Control

  • Securing Filesystem Access to MySQL
  • Managing MySQL User Accounts
  • Grant Table Structure and Contents
  • How the Server Controls Client Access
  • Setting Up Secure Connections Using SSL

Lesson 14: Database Maintenance, Backups, and Replication

  • Principles of Preventive Maintenance
  • Performing Database Maintenance with the Server Running
  • General Preventive Maintenance
  • Making Database Backups
  • Copying Databases to Another Server
  • Checking and Repairing Database Tables
  • Using Backups for Data Recovery
  • Setting Up Replication Servers

Lesson 15: Appendix A: Software Required to Use This Book

  • A.1. Obtaining the sampdb Sample Database Distribution
  • A.2. Obtaining MySQL and Related Software
  • A.3. MySQL Installation Notes
  • A.4. Perl DBI Installation Notes
  • A.5. PHP and PDO Installation Notes

Lesson 16: Appendix B: Data Type Reference

  • B.1. Numeric Types
  • B.2. String Types
  • B.3. Temporal (Date and Time) Types

Lesson 17: Appendix C: Operator and Function Reference

  • C.1. Operators
  • C.2. Functions
  • C.2.3. Numeric Functions

Lesson 18: Appendix D: System, Status, and User Variable Reference

  • D.1. System Variables
  • D.2. Status Variables
  • D.3. User-Defined Variables

Lesson 19: Appendix E: SQL Syntax Reference

  • E.1. SQL Statement Syntax (Noncompound Statements)
  • E.2. SQL Statement Syntax (Compound Statements)
  • E.3. Comment Syntax

Lesson 20: Appendix F: MySQL Program Reference

  • F.1. Displaying a Program's Help Message
  • F.2. Specifying Program Options
  • F.3. myisamchk
  • F.4. mysql
  • F.5. mysql.server
  • F.6. mysql_config
  • F.7. mysql_install_db
  • F.8. mysql_upgrade
  • F.9. mysqladmin
  • F.10. mysqlbinlog
  • F.11. mysqlcheck
  • F.12. mysqld
  • F.13. mysqld_multi
  • F.14. mysqld_safe
  • F.15. mysqldump
  • F.16. mysqlimport
  • F.17. mysqlshow
  • F.18. perror

Lesson 21: Appendix G: C API Reference

  • G.1. Compiling and Linking
  • G.2. C API Data Structures
  • G.3. C API Functions

Lesson 22: Appendix H: Perl DBI API Reference

  • H.1. Writing Scripts
  • H.2. DBI Methods
  • H.3. DBI Utility Functions
  • H.4. DBI Attributes
  • H.5. DBI Environment Variables

Lesson 23: Appendix I: PHP API Reference

  • I.1. Writing PHP Scripts
  • I.2. PDO Classes
  • I.3. PDO Methods

Copyright © 2002-2017 uCertify / All Rights Reserved.