RKCP Information Technology
                                                                                                          MySQL
Home » Courses   » MySQL

MySQL

Overview

How to develop SQL statements, views, stored procedures, and triggers for their MySQL databases.

How to design and implement a database and how to work with foreign keys, transactions, and stored programs.


Objective

  • Work with any database
  • Use MySQL Workbench to work with a database and run SQL statements
  • Retrieve, add, update, and delete data from a database
  • Work with summary queries, subqueries, data types, and functions
  • Use MySQL Workbench to create an EER (enhanced entity-relationship) model for their database
  • Design and implement their own databases
  • Use MySQL to create stored procedures, functions, triggers, and events
  • Manage transactions and locking

  • Prerequisites

    Experience in basic computer literacy with previous experience with command-line programs and some knowledge of database concepts is required. Some knowledge of data retrieval and reporting would be beneficial.


    Syllabus

    Expand All
    • 1.Introduction to Relational Databases & SQL
      • An Introduction to Client/Server Systems
      • An Introduction to the Relational Database Model
      • An Introduction to SQL and SQL-Based Systems
      • The SQL Statements
      • How to Use SQL From An Application Program
    • 2.MySQL Workbench and other Development Tools
      • An Introduction to MySQL Workbench
      • Using Workbench to Run SQL Statements
      • Using the Reference Manual
      • Command Line Client
    • 3.How to Retrieve Data From a Single Table
      • An Introduction to the SELECT Statement
      • The SELECT Clause
      • The WHERE Clause
      • The ORDER BY Clause
      • The LIMIT Clause
    • 4.How to Retrieve Data From Two or More Tables
      • Inner Joins
      • Outer Joins
      • Other Skills For Working With Joins
      • How to Work With Unions
    • 5.How to Insert, Delete and Update Data
      • Creating Test Tables
      • Inserting New Rows
      • Updating Existing Rows
      • Deleting Existing Rows
    • 6.Coding Summery Queries
      • Aggregate Functions
      • How to Group and Summarize Data
    • 7.Coding subqueries
      • An Introduction to Subqueries
      • How to Code Subqueries In the WHERE Clause
      • How to Code Subqueries In Other Clauses
      • Working With Complex Queries
    • 8.The Datatypes
      • Converting Data
      • Working With Data Types
    • 9. How to use Functions
      • String Data
      • Numeric Data
      • Date/Time Data
      • Other Functions You Should Know About
    • 10.How to Design Database
      • Design A Data Structure
      • Normalize A Data Structure
      • Using MySQL Workbench For Database Design
    • 11. Creating Databases, Tables and Indexes
      • Databases
      • Tables
      • Indexes
      • A Script That Creates A Database
      • How to Use MySQL Workbench
      • Character Sets and Collations
      • Storage Engines
    • 12. How to Create Views
      • An Introduction to Views
      • How to Work With Views
    • 13. Language Skills for Writting Stored Programs
      • An Introduction to Stored Programs
      • How to Write Procedural Code
    • 14. Transactions and Locking
      • How to Work With Transactions
      • How to Work With Concurrency and Locking
    • 15. How to Create Stored Procedure and Functions
      • Coding Stored Procedures
      • Coding Stored Functions
      • How to Use Workbench With Procedures and Functions