Dec 01, 2021
CSCI 2006 - Internet Programming: Server-side Applications Credits: 4
Hours/Week: Lecture NoneLab None
Course Description: This course focuses on the server-side components involved in developing Internet programs. The course will examine some of the current languages, interfaces and technologies used to develop server-based applications that work in concert with client-side logic. Server-side scripting languages such as PHP will be used with a database (such as MySQL) to create database-driven websites. Concepts and techniques to implement secure websites will be presented.
Prerequisite(s): CSCI 2005 with a grade of C or higher or instructor consent. Introductory knowledge of database concepts and techniques
- Overview of web servers in common use (IIS, Apache, GWS¿)
- Unique capabilities of each
- Advantages and disadvantages of each
- PHP Language
- Basic syntax
- Data types, operators, decision making and looping
- Arrays and Hashes
- Regular expressions and strings
- Object-oriented PHP
- Error and exception handling
- File operations
- Review of Internet Theory
- The client/server model on the Internet
- The division of labor: client-side application responsibility vs server-side application responsibility
- The HTTP request/response protocol
- Database concepts and techniques
- Fundamental terminology and DB components
- Database design
- Database creation
- SQL Query fundamentals
- Accessing the database using PHP
- Web security concepts and techniques
- Type of ecommerce sites and threats
- Common security problems and solutions
- Techniques for authentication
- Techniques for secure transaction
- Advanced PHP Techniques
- Effective debugging techniques
- Techniques to access the server file system
- Session control
- Techniques to access date and time
- Creating a large, sophisticated PHP and database-driven project.
- Techniques for working on a large project
- Capstone project
At the end of this course students will be able to:
- design and create a relational database, and access it via PHP scripts and queries to retrieve and store data that is a component of a dynamic website.
- design, develop, test and debug server-side scripts written in PHP that can deliver dynamic content to a web page.
- describe the logical model used for client-server interaction on the Internet.
- differentiate the processing responsibilities typically assigned to client logic and server logic.
- describe common website security threats and incorporate appropriate security measures to implement secure transactions.
- use course concepts and techniques to build a sophisticated, secure, dynamic client/server application.
Courses and Registration
Add to Portfolio (opens a new window)