Akum diperlukan Freelance Trainer utk ajar Mysql--Apache/Tomcat utk 10 org 5 day Topik2 cover spt:ni rougly boleh ubahsuai ikut kemudian Apache and Secure Web Server Administration Course Outline
• Introduction and Basic Apache Configuration - httpd overview: Client/server topology, Transactional overview - History of web servers: NCSA, Apache evolution, The Apache Organization - Apache today: usage, extensibility, cess model, Red Hat's Apache packages - Basic configuration: configuration files and options, basic daemon control • Apache Virtual Hosts: - Understanding Virtual hosts: IP-based, name-based - Configuration directives and Syntax checking - Using Apache to serve Virtually hosted web servers - Web server log files: formats, configuration, use and analysis - Servre MIME types • CGI and Server Side Includes: - Definition, Mechanics, limitations, common CGI languages - Basic CGI requirements - Useful CGI tasks - SSI: similarities to CGI, shtml implementation, Xbithack directive - CGI security: suEXEC • Database backends - Available Databases - Postgres: installation, administration - Query and insert with SQL - Implementations of query and insert in CGI - Perl CGI.pm; DBD/DBI.pm • Apache customization through modules - Concepts; mod_perl; mod_php; mod_status; mod_usertrack; mod_rewrite; other modules • Security and authentication - Basic access control by host/domain/network - Apache security strategies - Authentication scenarios • Advanced Security with SSL - Basic Cryptography and SSL concepts - SSL Certificates - Obtaining a website certificate - Implementing SSL with Apache MySQL on Linux Course Outline • Database Terminology - DBMS and RDBMS - Tables and Databases - Primary Key and Foreign Key - Unique Keys - Structured Query Language - SQL as DDL, DML and DCL • MySQL Database Server - Features of MySQL - MySQL Data Directory - Logging and Log Files - Installation of MySQL Server • MySQL Database Design - Data Definition Language - Columns and Datatypes - Primary and Foreign Keys - Unique Keys and NOT NULL - Auto Increment Values - Table, View & Database Creation • MySQL Queries - Data Manipulation Language - INSERT Records to Table - UPDATE Records of Table - DELETE Records from Table - Relationships Between Tables - Inner Joins and Natural Joins - Left Joins and Right Joins - Locking the Tables • Optimizing Tables and Queries - Indexes in MySQL - Setting Indexes to Existing Tables - Non Unique Indexes - MySQL Functions - MySQL Cursors • MySQL User Management - MySQL Users and Privileges - Local and Remote users - user() Function - Access Rights with MySQL - SQL GRANT Statement - Granting Multiple Privileges - Setting Password for Users - Revoking Privileges Display Privileges for Tables & Users • MySQL Storage Engines - MyISAM, InnoDB , HEAP Tables - Features of InnoDB and MyISAM - Repairing Tables by isamchk - myisamchk • MySQL Server Backup & Replication - Backup Principles - mysqldump and mysqlhotcopy - Transfers to Database or Server - Backup by Direct Copying - Recovering Databases and Tables - Setting Multiple MySQL Servers - MySQL Server Replication - MySQL Triggers • API based MySQL Server - Basics of Standard APIs - Overview of Using PHP API - PHPMyAdmin -- Join Open Source Developers Club Malaysia http://www.osdc.my/ Facebook Fan page http://www.facebook.com/group.php?gid=98685301577 http://www.facebook.com/OSDC.my You received this message because you are subscribed to the Google Groups "OSDC.my Mailing List" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/osdcmy-list?hl=en
