Web Database Developer (200 hours)

Course Overview/Description

In the Web Database Developer online program, students will learn to develop web applications using several different tools and technologies. This program begins with client-side languages, such as HTML and JavaScript and extends into server-side languages, such as ColdFusion and PHP. Students will also learn to use Dreamweaver to make web development easier and Flash to make rich Internet applications.

This interactive program consists of 10 modules. Each module is described below:

HTML Series
This online training series shows how to use HTML to develop Web pages. It covers common HTML commands and tags, formatting text using tags and CSS style sheets, and incorporating links and images on Web pages. The use of graphics on Web pages is discussed in detail, including graphics software, file size, and animation. Design concepts such as background and color, layout, image maps, and tables are examined, and Web page interactivity using multimedia, applets, and ActiveX is discussed in-depth. Advanced topics covered include using JavaScript for interactivity, and advanced JavaScript techniques such as frames, cookies, objects, text strings, and the history list.

Dynamic HTML Series
This online training series is intended for Web page developers who want to implement Dynamic HTML in their Web site design. It examines the basic concepts of DHTML and the use of Cascading Style Sheets, implementing JavaScript with DHTML, and the DHTML object model. Other topics covered include objects, events and event handling, style sheets and content formatting, and binding data from other sources to Web pages.

Dreamweaver MX 2004 Series
This series presents information on designing Web sites using Macromedia Dreamweaver MX 2004. Topics include an introduction to the interface and the basic concepts of Web design, in addition to procedures for setting up the site, managing the site, creating pages, and inserting basic text, links, and images. The latter part of the series covers advanced topics such as tables and frames, DHTML, behaviors, and forms. Finally the series explains how to upload projects and work with templates.

Flash MX 2004 Series
Flash MX 2004 teaches learners how to create animated web graphics and movies from scratch. Learners will be able to apply their knowledge to the creation of both dynamic and interactive Web graphics and applications.

ActionScript 2.0 Series
The Flash MX 2004 ActionScript 2.0 series is designed to help learners who are familiar with previous versions of ActionScript to learn more about the benefits of object-oriented programming and using ActionScript 2.0.

SQL Series
This series provides an overview of SQL, including basic concepts and terms related to database and table design. The basic tasks of creating a new table in a database, using the INSERT statement, and managing and deleting SQL tables and table data are covered, as well as a comprehensive discussion of database objects, which includes creating, changing, and deleting table views, table spaces, storage groups, indexes, index spaces, and databases. An introduction to basic query techniques is provided, along with an overview of joining tables.

ColdFusion MX Series
This series teaches users how to install and set up a ColdFusion development environment, including connecting to a database, and also teaches how to build ColdFusion applications that integrate e-mail, FTP, Flash, Java, and XML.

PHP / MySQL Series
This series teaches learners to create dynamic Web sites. Learners will be able to apply their knowledge to the creation of dynamic Web applications such as content management, user registration, and e-commerce.

CGI / Perl Series
This series is designed for users who want to create interactive Web pages using CGI and Perl. It covers creating and working with forms, building programs using HTTP headers and SSI, and developing Web applications and utilities. It also discusses how to pass data between Web pages and databases.

XML Series
This online training series provides an introduction to the Extensible Markup Language (XML) and its general format. It introduces the fundamentals of XML, including how to read a basic XML document, the XML document structure, and viewing XML source documents. It shows how to build an XML data document, including creating elements and element modes, naming XML objects, and creating declarations and well-formed documents. Building DTDs is explained in detail, along with creating and managing internal, external, and parameter entities. Additional topics covered in this series include a detailed discussion of the Document Object Model, Cascading Style Sheets (CSS), and XSL Style Language.

Course Objectives

The purpose of this program is to:

• Learn to use HTML, Cascading Style Sheets, and JavaScript to design web pages.
• Learn Dynamic HTML to make your web pages more interactive.
• Learn to use Dreamweaver to for more efficient web design and development.
• Learn Flash and ActionScript to create dynamic interactive user interfaces.
• Learn ColdFusion, Perl, and/or PHP to database-driven web applications.
• Learn SQL to pull data from a database and to insert and modify data in a database.
• Learn to use XML to store and validate data and to make data more accessible to other applications.

Course Outline

1. HTML Series
   1. Creating High Quality Web Graphics
   2. Layout and Design for Your Web Pages
   3. Making Your Web Pages Interactive
   4. Start Creating Your Own Web Pages
   5. Start Using JavaScript
   6. Using Advanced JavaScript
   7. Using JavaScript for Interactivity
2. Dynamic HTML Series
   1. Data from Other Sources
   2. DHTML and Style Sheets
   3. Objects and Events
   4. Styles and Content
   5. Using JavaScript
3. Dreamweaver MX 2004 Series
   1. Interface and Web Page Creation Basics
   2. Project Planning, Link Creation, and HTML Editing
   3. Images, Image Maps, and Assets
   4. Tables, Frames, and Framesets
   5. Dynamic HTML
   6. Advanced Behaviors and Forms
   7. Uploading Projects and Working with Templates
4. Flash MX 2004 Series
   1. Flash Overview
   2. Drawing, Painting, and Using the Library
   3. Creating Animations
   4. Using Shape Tween and Timeline Effects
   5. Using Sound and Layers
   6. Adding Symbols and Buttons
   7. ActionScript, Behaviors, and Publishing
5. ActionScript 2.0 Series
   1. Object-Oriented Programming
   2. Properties and Methods
   3. Implementing Inheritance and Interfaces
   4. Inter-Object Communications
   5. Building User Interface Components
6. SQL Series
   1. Database Maintenance
   2. Database Objects
   3. Query Techniques
   4. Joining Tables
7. ColdFusion MX Series
   1. Introduction and Installation
   2. Talking With the Database
   3. Displaying Data
   4. Programming and Application Framework
   5. Custom Tags and Building Blocks
   6. Using E-mail, Complex Data Types, and FTP
   7. Securing, Debugging, and Improving Application Performance
   8. Using Flash, Java, and XML
   9. Integration and Understanding Fusebox and FLiP
   10. Functions, Tags, and Resources
8. PHP / MySQL Series
   1. Installing Required Software
   2. PHP Basics
   3. Programming with PHP
   4. Creating Dynamic Web Sites
   5. SQL and MySQL
   6. Advanced SQL and MySQL
   7. Error Handling and Debugging
   8. Using PHP with MySQL
9. CGI / Perl Series
   1. Getting Familiar with Forms
   2. Building Programs
   3. Web Applications
   4. Interacting with Databases
10. XML Series
    1. Viewing and Understanding XML
    2. Creating a Basic Document
    3. Building DTDs and Checking Documents
    4. Entities
    5. The Document Object Model
    6. CSS and XSL Style Sheets

Prerequisites/Audience

Prerequisites
There are no specific prerequisites for this program. Students are assumed to be fairly knowledgeable on computers/Internet, and will need Internet connection with emailing capabilities.

Target Audience
This program is for students who wish to become proficient in using HTML/DHTML and server-side programming to build web pages.

PC Requirements/Materials Included

This course is compatible with the Windows Vista operating system.

The following are the minimum user system requirements necessary to enjoy maximum access to the HTML-based courses:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800x600 is recommended). Windows 95, 98, NT, 2000, or XP Internet Explorer 5.0 or higher required. An Authorware plug-in is used for course simulations but is not required to run the courses. It can be installed the first time you take a course by following the instructions shown on the Web page. The Macromedia Flash Player is used for course introductions and activities, but is not required to run the courses. It can be installed the first time you take a course by following the instructions shown at login. Netscape and AOL browsers are not supported.

We do not formally support our courseware on the Macintosh platform. If you choose to try to use the courses on a Macintosh, you need to be aware that they will not have full functionality, specifically within the Authorware simulations and the supplied files. However, if you are a Macintosh user and make use of a Windows emulator, Authorware simulations and supplied files may function. Since we do not test with Macintosh or Windows emulators, we cannot guarantee our courses on the Macintosh platform.

All necessary materials are provided online.

Instructor Bio

Instant Mentoring enables 24x7 access to certified instructors and Subject Matter Experts (SMEs). Instructors are Microsoft Certified Trainers (MCTs), all possessing instructional backgrounds. In addition to providing content expertise, our Mentors facilitate interaction and enhance the overall learning experience.

Frequently Asked Questions (FAQs)

1. How do I register?
Click on the register button at the top of the page and follow the directions. It is important that you type all your information in the boxes, then print it out to sign.  Payment and sending instructions are in the bottom right corner of the form.

2. How much do the courses cost?
The fee is in the pink box at the top of the page.

3. Can I register for courses if I live outside the United States?
Yes you can!

4. Do I ever have go to the school I register with?
All of our courses are delivered entirely online, so you never have to go to a class or travel to the school.

5. How long does it take to complete a course?
All of our courses are self-paced and open enrollment. You can start and finish the course at your own pace. Students are given 6 months to complete this 200 hour course. If you need more time, a 6 month extension is available free of charge. After one year, fees will apply.

6. Do I have to buy additional materials?
All necessary materials are provided online.

7. Can I get financial aid?
GES courses are non-credit courses, so they do not qualify for federal aid. In some states, vocational rehab or workforce development boards will pay for qualified students to take our courses.

• GES provides a loan opportunity for students. Simply go to www.collegeloanapplication.com to apply for an easier qualifying loan at a slightly higher rate. Click here for more information on this loan program.

8. What happens when I complete the course?
Upon successful completion of the course, you will be awarded a certificate of completion from the school you registered with. You must obtain a final passing grade of 70% or greater to be awarded a certificate.

9. Am I guaranteed a job?
GES courses will provide you with the skills you need to obtain an entry-level position in most cases. We do not provide direct job placement services, but our instructors will help you build your resume and are available to give advice on finding your first job. Instructors will also be available to use as a professional reference upon completion of the course. Potential students should always do research on the job market in their area before registering.

10. Who will be my instructor?
Instant Mentoring enables 24x7 access to certified instructors and Subject Matter Experts (SMEs). Instructors are Microsoft Certified Trainers (MCTs), all possessing instructional backgrounds. In addition to providing content expertise, our Mentors facilitate interaction and enhance the overall learning experience.

11. Can I use a Macintosh computer for this course?
We do not formally support our courseware on the Macintosh platform. If you choose to try to use the courses on a Macintosh, you need to be aware that they will not have full functionality, specifically within the Authorware simulations and the supplied files. However, if you are a Macintosh user and make use of a Windows emulator, Authorware simulations and supplied files may function. Since we do not test with Macintosh or Windows emulators, we cannot guarantee our courses on the Macintosh platform.

12. How can I get more information on the course?
All of the information we have is available online under our course catalog (www.gatlineducation.com). If you have questions that are not answered online, please feel free to email us at courseinfo@gatlineducation.com or call 817-870-2870. We will answer your questions promptly.

13. When can I start the course?
Our courses are all open enrollment. You can register and start the course as soon as you are ready.