J223c

J223c: MySQL Programming - 3 Days

Who Should Attend:

Web based programmers, software engineers, systems analysts, applications programmers, computer science students, and anyone who is interested in using RDBMS to implement e-commerce or any kind of database related transaction system.

Prerequisites:

A basic understanding of operating systems and web based transactions. Programming will be mostly SQL and Server side scripting based. A robust understanding of server side technologies (ASP, JSP or PHP) is recommended.

Objectives:

MySQL is a free database environment, which is most suitable for small, medium-sized and larger enterprises. Its management is easy, clear, lightweight, and is an effective alternative to Microsoft SQL Server 2000, IBM DB/2, and Oracle.

This module covers basic management routines adopted by MySQL, essential skills for administering foundation services, SQL, and user management and optimization issues.

Contents:

Introduction to RDMS: Relational Database-Management Systems; the entity-relationship model; relational database theory; file structure; indexing and hashing; query processing; crash recovery; concurrency control/transaction processing; security and integrity.

Database Creation: Creating Tables, Creating Indexes; Dropping/Altering Tables and Indexes; User Security and Privileges; Working in Developer Groups.

SQL: Using SQL; Data Types; Editing SQL Statements; Data Manipulation; Rollback/Commit; Selecting Data; Writing Reports & Programs.

Event Programming: Writing PL/SQL Trigger Code; Referencing Objets in Triggers; Writing PL/SQL Procedures, Functions & Packages.

Multiple-Module Applications: Posting vs. committing; Savepoint / Rollback.

SQL Syntax in MySQL: MySQL API's.Introduction to APIs, Available functions. Common calling conventions, Available languages.

Introduction to Programming MySQL using MySQL API's: C/C++ extensions. Other Languages. Common Pitfalls. 3rd part libraries. Security

Programming Introduction for MySQL With PHP: Characteristics of PHP; User Affirmations; Downloading PHP/Apache; Installation and Configuration. What is SQL? PHP's database support. PHP's Predefined MySQL Functions; ODBC.

Performance Fine Tuning: How to make MySQL run faster, common problems in installation. Unix/Linux/Windows performance tuning. SQL performance tuning.

--------

Contact Us Today for enquiries on courses.