JavaScript Editor Javascript source editor     Web programming 



Team LiB
Previous Section Next Section

Part IV: PHP and MySQL Integration

 

Chapter 15 Understanding the Database Design Process

 

Chapter 16 Learning Basic SQL Commands

 

Chapter 17 Interacting with MySQL Using PHP

    Team LiB
    Previous Section Next Section


              Chapter 15.  Understanding the Database Design Process
          The Importance of Good Database Design
          Types of Table Relationships
          Understanding Normalization
          Following the Design Process
          Summary
          Q&A
          Workshop
              Chapter 16.  Learning Basic SQL Commands
          Learning the MySQL Data Types
          Learning the Table Creation Syntax
          Using the INSERT Command
          Using the SELECT Command
          Using WHERE in Your Queries
          Selecting from Multiple Tables
          Using the UPDATE Command to Modify Records
          Using the REPLACE Command
          Using the DELETE Command
          Frequently Used String Functions in MySQL
          Using Date and Time Functions in MySQL
          Summary
          Q&A
          Workshop
              Chapter 17.  Interacting with MySQL Using PHP
          Connecting to MySQL with PHP
          Working with MySQL Data
          Summary
          Workshop


    JavaScript Editor Javascript source editor     Web programming