Course: CIS166AE First Term: 2004 Spring
Final Term: Current
Final Term: 2018 Summer
|
Lec + Lab 3 Credit(s) 4 Period(s) 3.7 Load
Credit(s) Period(s)
Load
Subject Type: OccupationalLoad Formula: S |
MCCCD Official Course Competencies | |||
---|---|---|---|
1. Explain the concept of client/server configurations and its benefits. (I)
2. Explain the role of server-side and client-side programming languages in the design of interactive, dynamic web pages. (I) 3. Design and develop scripts that manage program state. (I, VI) 4. Explain the concept of static versus dynamic content. (II) 5. Describe the benefits and disadvantages of open source solutions. (III) 6. Develop scripts using various PHP language components that include state management and security features. (IV, V, VI, VII) 7. Use SQL to access a relational database for dynamic content presentation. (VIII) 8. Describe the role of PHP in developing web services. (IX) | |||
MCCCD Official Course Competencies must be coordinated with the content outline so that each major point in the outline serves one or more competencies. MCCCD faculty retains authority in determining the pedagogical approach, methodology, content sequencing, and assessment metrics for student work. Please see individual course syllabi for additional information, including specific course requirements. | |||
MCCCD Official Course Outline | |||
I. Internet Scripts and Internet Applications
A. Concepts of the client/server paradigm 1. Client/server overview 2. The client role in internet applications and scripts 3. The server role in internet applications and scripts B. Program and script design 1. Documentation and specification 2. Scripting states 3. State diagram 4. Modular design fundamentals II. Static Content versus Dynamic Content A. Static content B. Dynamic content III. Open Source Solutions A. Concepts of open source B. Advantages and disadvantages of open source C. Open source options for PHP VI. The PHP Language A. Classes B. Data types C. Operators D. Expressions E. Functions F. Objects V. HTTP Requests A. GET method B. POST method C. Server variable ($_SERVER) D. File uploading ($_FILES) VI. Program State A. State machines B. Program state in global web applications versus local applications C. Cookies using PHP D. PHP sessions VII. Security A. HTTP authentication B. PHP security 1. Session construction (LOGIN) (session registration) 2. Session variables with regards to user authentication and state 3. Session destruction (LOGOUT) (session un-registration) VIII. Relational Databases A. Fundamental concepts B. Structure Query Language (SQL) 1. Creating and deleting tables 2. Inserting, updating, and deleting rows 3. Building queries C. PHP database functions and variables D. Databases supported by PHP (MySQL, Oracle, DB2, etc.) IX. Web Services A. Simple object access protocol (SOAP) B. Web services description language (WSDL) C. Universal, description, discovery, and integration (UDDI) D. Universal resource identifier (URI) | |||
MCCCD Governing Board Approval Date:
3/23/2004 |