CGS 3066 Web Programming and Design Fall 2019
CGS 3066: Web Programming and Design Fall 2019 Final Exam Review
Overview • Date: 12/11/2019 (Wednesday) • Time: 5: 30 PM – 7: 30 PM • Place: LOV 301 (Classroom) • Test Format: • Multiple Choice Questions, including some True/False Questions • Short Answer Questions • Write Code (CSS/Java. Script/PHP) • Write SQL Queries
Important Topics • Study all slides, examples, assignments, quizzes covered in the class. HTML/HTML 5: • • • Basic HTML tags. HTML page and tree structure. Text formatting tags. Links, images, lists, tables and iframes. Block and inline elements. HTML 5 layouts. • HTML forms, various input types. • More … read lecture slides
Important Topics CSS/CSS 3: • • • Separating styles from content. Different ways of adding CSS (inline/external/embedded). Selectors and different types of selectors. CSS Box model. Div vs Span vs P tags; block vs inline elements Backgrounds, borders, margins and padding. CSS for lists, tables, and text. Pseudo Classes Grouped selectors Hover, CSS dropdown menu Positioning (absolute/relative), z-index • More … read lecture slides
Important Topics Java. Script: • • • Capabilities and syntax of Java. Script. Adding Java. Script to an HTML document. Keywords, data types and variables. Operators, operator precedence and evaluating expressions. Control Structures: if statements, switch statements, loops. Functions - definition, invocation, parameter passing and return. Numbers, strings, arrays and objects. Form validation using Java. Script (with using basic regular expressions). Java. Script DOM. get. Element. By. Id, get. Elements. By. Class. Name etc. Setting element styles using Java. Script Writing small Java. Script code snippets (like read form input values and use for a conditional output). j. Query – Basic functionality (like reading/changing input values, creating/changing html element/content, add/remove/change attributes/classes/styles, event handlers – e. g. click/change event ). • More … read lecture slides/Examples/Assignments
Important Topics PHP: • • Basic PHP syntax Arrays in PHP superglobals, Cookie, Session Include/require files • Excluded – PHP file handling/reading/writing • Receiving form data (GET and POST) • Database interaction using PHP – writing query and printing data (the in-class examples) • More … read lecture slides/Examples/Assignments
Important Topics SQL: • • • Basic SQL query structure Create/Alter/Update/Delete/Truncate/Drop Joins – Inner and Left joins Using Aliases, Concatenations Sorting, Filtering, SUM, AVG, COUNT etc. • Very important – Study Assignment 5 • More … read lecture slides
Sample Questions • Study all questions from all quizzes • Write a Java. Script code snippet that reads a person’s name and favorite programming language from a form containing 2 text boxes. If the person’s favorite language is C, C++ or Java, print "Your interview is on Thursday". Otherwise, print "Your interview is on Friday". • Write a code in PHP to read an input field value named “date_of_birth” from a submitted form and store this value into a session variable named “sess_user_dob”. • Given a table "Restaurants" with field names "City", "Food" and "Deliciousness", write a SQL query to display all the Italian restaurants in Seattle.
BEST OF LUCK
- Slides: 9