LOGO For Immediate Assistance Call 855-211-9361

Enterprise

Dynamic, Data Driven Websites

Price: $1,750.00

Call for availability 855-211-9361

Learn how to create dynamic, data driven Web sites using today's most popular technologies. This course will teach you the basics of Structured Query Language (SQL) and how to use SQL to interact with databases from within your Web pages. Students have the opportunity to work with examples and exercises built with .NET, JSP, PHP, ColdFusion, and even classic ASP. Students will learn to build queries, retrieve data, and display results on their pages. The course will also teach students to use user-submitted form data to update databases, process logins, and more! Students will even have a chance to experiment with advanced techniques such as state management with session and cookies so they can build persistent site recognition and shopping carts.

Course Overview

By the end of the class students will be able to:

  • Understand the basics of Structured Query Language (SQL)
  • Learn to perform CRUD (create, retrieve, update, and delete) operations
  • Learn the principles of server-side programming.
  • Learn to retrieve data and output to the client browser using multiple environments
  • Learn to work with user form input to query and modify data
  • Learn to apply common development techniques such as validation and data drilldowns
  • Understand server objects such as sessions, cookies, and applications

Prerequisites

Students should have a strong knowledge of HTML, particularly HTML forms, and be comfortable with client-server applications such as the ones covered in PB Tech's Advanced HTML class. Experience using database-driven applications is helpful but not required.

Course Outline

  • Server Side Technologies

    • PHP/ASP/ASP.NET/JSP/Coldfusion
  • Programming Overview

    • Classes, Objects, Methods, Properties, and Events
    • Creating Server Side Code and Basic Output (Hello World, Date, Time Formats)
    • Comments and Concatenation
    • Conditionals (if/case/switch)
  • Page Redirect/relocation

  • Forms, all-in-one and separate action page

  • Scalar, URL and Form Variables

  • Collections, Arrays, Lists and Structures

  • Looping Techniques

  • Database Connections

  • Selecting and Displaying Data

  • Advanced Form Concepts

    • Dynamic Form Population
    • Form Validation
    • Regular Expressions
  • Inserting New Records

  • Updating Records

  • Deleting Records

  • Stored Procedures

  • Data Drill Down

  • Project Time

  • Advanced: Server Side Topics

  • State Management

    • Cookies
    • Session
  • Email

  • User Defined Functions

  • Technology Appendices