Entegra Consultancy

Home / Training / Database Management / J223a

J223a

J223a: MySQL Programming & Administration - 5 Days

Who Should Attend:

Web designers and programmers, software engineers, systems analysts, applications programmers, computer science students, and anyone who is interested in finding a complete solution to Intranet/Internet based computing as well as Database management and OS management using scripting languages.

Prerequisites:

Knowledge on Web and browsers as well as basic programming experience with scripting languages like Perl is recommended.

Objectives:

MySQL and PHP programming enables an individual to set up an e-commerce platform for commercial purposes. These software packages are popular freeware, which are easily available to small-and medium size enterprises. The actual platform can be hosted either on Windows or on Linux operating systems for added flexibility and economy to the company.

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.

MySQL Administration Introduction: How to administer your database services, How to start, stop and error check a running database instance

Installing MySQL: Best installation practices, common pitfalls of installation, how to take advantage of RAID. Partitioning your database files

MySQL Administration: Administration basics, User account creation, Role assignment, Database and table creation, learning about how to maintain and administer MySQL system database files

Data Directory Concept: How to create and maintain data directory, common pitfalls of administration of data systems

Security Settings: Role assignment and security procedures, common hacks, how to configure system ports, how to maintain a system security check, how to backtrack an activity from system security log

Database Maintenance and Repair: how to backup and restore your database, how to manage you backup schedules, how to handle hot and cold backup.

Database Creation: Creating Tables, Creating Indexes; Dropping/Altering Tables and Indexes; User Security and Priviledges; 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.

--------