INT322 - Internet II - Web Programming on UNIX

Outline info
Semester
School
Last revision date 2017-05-29 00:34:22.112
Last review date 2017-07-17 00:15:33.9


Subject Title
Internet II - Web Programming on UNIX

Subject Description
E-commerce remains one of the fastest-growing aspects of business in recent years, and there is a great demand for people who can plan and implement complete, database-driven web applications that run in a variety of different environments. Focusing on technologies popular on the Linux/Unix platform, this subject will provide the student with the skills and knowledge required to create and maintain commercial-quality web sites suitable for database-driven business transactions. The student will learn to build dynamic web applications using popular web programming languages, while leveraging the power of a SQL database. Coverage will include application and web site security.

Credit Status
1 credit (3 units)
Required for CPA - Computer Programming and Analysis (Ontario College Advanced Diploma)
Required for CPD - Computer Programmer (Ontario College Diploma)

Learning Outcomes
Upon successful completion of this subject the student will be able to:

1. Design databases and develop applications that process database contents using a DBMS and a scripting language

2. Design, code, test, and implement programs using a server side scripting language

3. Continue the life-long learning process of acquiring new skills and knowledge through formal and self-directed means using information and learning resources

4. Develop and deploy Internet-based applications using current technologies to meet client needs

5. Use written, oral and visual communication skills to communicate with technical and non-technical audiences, at levels appropriate for a variety of business settings

Essential Employability Skills
Execute mathematical operations accurately.

Apply a systematic approach to solve problems.

Use a variety of thinking skills to anticipate and solve problems.

Locate, select, organize, and document information using appropriate technology and information systems.

Analyze, evaluate, and apply relevant information from a variety of sources.

Manage the use of time and other resources to complete projects.

Take responsibility for one's own actions, decisions, and consequences.

Cheating and Plagiarism
Each student should be aware of the College's policy regarding Cheating and Plagiarism. Seneca's Academic Policy will be strictly enforced.

To support academic honesty at Seneca College, all work submitted by students may be reviewed for authenticity and originality, utilizing software tools and third party services. Please visit the Academic Honesty site on http://library.senecacollege.ca for further information regarding cheating and plagiarism policies and procedures.

Discrimination/Harassment
All students and employees have the right to study and work in an environment that is free from discrimination and/or harassment. Language or activities that defeat this objective violate the College Policy on Discrimination/Harassment and shall not be tolerated. Information and assistance are available from the Student Conduct Office at student.conduct@senecacollege.ca.

Accommodation for Students with Disabilities
The College will provide reasonable accommodation to students with disabilities in order to promote academic success. If you require accommodation, contact the Counselling and Disabilities Services Office at ext. 22900 to initiate the process for documenting, assessing and implementing your individual accommodation needs.

Prerequisite(s)
INT222 and  ULI101 

Topic Outline
Unix / Linux review

  • Review Unix / Linux basic commands
 
Introduction to Perl
  • Language origins
           
Perl - the basics 
  • Perl Syntax and Grammar 
  • Variables and Data Types 
  • Expressions, Operators and Flow Control 
  • Scalars
  • Perl Subroutines 
  • References
  • Arrays and Hashes 
  • Perl built-int functions 
  • Regular Expressions 
  • Special Variables 
  • Perl modules

Perl CGI? 
  • Introduction to CGI 
  • CGI.pm Library 
  • How Does CGI Work? 
  • Calling Your CGI Program 
  • HTTP Headers 
  • CGI and Environment Variables 

Introduction to PHP
  • What does PHP do

PHP Language basics
  • Exical structure
  • Data Types and Variables
  • Expressions and Operators
  • Flow Control
  • PHP Functions
  • String and string Functions
  • Array and Array Functions    
 
Web servers - Apache 
  • A Brief Overview 
  • Installation of Apache web server 
  • Configuring the web server
  • Using Server Side Includes (SSI)

Form Processing 
  • A Brief Overview of HTML forms 
  • A Brief Overview of CSS / JavaScript  
  • Handling Form Information 

MySQL Overview 
  • MySQL strengths and limitations
  • Basic syntax 
  • MySQL Perl DBI / DBD 
  • Creating tables 
  • Accessing tables 
  • Updating tables
          
General Security issues 
  • Why Are File Permissions Important in Unix / Linux 

Mode of Instruction
Classroom lectures and discussions are supplemented by lab sessions with the instructor, reinforced by assigned readings and assignments between classes. 

It is the student's responsibility to save documents, articles and notes that the instructor has provided on BlackBoard or in class. Students will not be able to access BlackBoard as of the last day of the students' class.

Prescribed Texts
Learning Perl, O'Reily - Randal L. Schwartz - (6th edition) ISBN-13: 978-1449303587  ISBN-10: 1449303587

Reference Material
Programming Perl (3rd Edition)  by Larry Wall, Tom Christiansen, Jon Orwant, Published by O'Reilly & Assoc., ISBN#0596000278, , 978-059-6000271 

Promotion Policy

Grading Policy
A+ 90%  to  100%
A 80%  to  89%
B+ 75%  to  79%
B 70%  to  74%
C+ 65%  to  69%
C 60%  to  64%
D+ 55%  to  59%
D 50%  to  54%
F 0%    to  49% (Not a Pass)
OR
EXC Excellent
SAT Satisfactory
UNSAT Unsatisfactory

For further information, see a copy of the Academic Policy, available online (http://www.senecacollege.ca/academic-policy) or at Seneca's Registrar's Offices.


Modes of Evaluation
Since this is a professional credit subject, marking standards reinforce professional practice by demanding legible, tidy work. Written materials should be well organized and grammatically correct, with proper spelling and punctuation.

Assignments

  • Students must retain a duplicate of all assignments.
  • Computer assignments should be documented to the instructor's standards.
  • Assignments must be handed in on the scheduled due date. Late assignments are penalized.
  • For particulars, please obtain standards, dates, etc. from your instructor.

Absenteeism and Tests
  • Students should be aware that absenteeism will impact on their ability to achieve satisfactory grades.
  • If you miss a test, you must provide the reason in writing to the instructor prior to the next scheduled class. If your reason is accepted, you will be permitted to write a make-up test. Otherwise, you will be given a zero for the test. You must submit an original doctor’s certificate identifying the date, length of time of expected absence and the specific reason for your absence, or other appropriate documentation.

Term Work and Final Exam
  • Students must attain a combined grade of at least 50% on term work and the final exam. Students must pass the final exam in order to pass the subject. 
  • For further information on evaluation and academic standing, see a copy of the Academic Policy available at Seneca registration offices.

Grading is based on the following marking scheme:


Assignment 1, 2 and 3 (15% each) 45%
Lab Exercises 5%
Midterm 15%
Final Exam 35%

Approved by: Denis Gravelle