Web Database Developer

Image for Web Database Developer

Database Driven Web Design Training from Gatlin International is Your Key to Limitless Career Possibilities

See how a Course Works: Intro to Online Learning





Description

In the Web Database Developer Online Training Program, you’ll learn to develop Web applications using several different tools and technologies. This program is composed of multiple modules to give you a baseline in developing and maintaining Web site databases.

You’ll begin by learning basic Web design and graphics skills, followed by training in Web publishing and design with HTML 4.01 and XHTML. You’ll also discover the client-side languages, including JavaScript, and extend into server-side languages, such as ColdFusion and PHP. Additionally, the modules cover: AJAX, Dynamic HTML (DHTML), SQL for Windows, CGI and Perl, MySQL, and XML. You’ll also learn how to install, configure, and maintain SQL Server 2005 and Oracle 10g.

Upon successful completion of this program, you’ll:

  • Know how to use HTML, Cascading Style Sheets, and JavaScript to design Web pages
  • Use Dynamic HTML to make your Web pages more interactive
  • Create database-driven Web applications using ColdFusion, Perl, or PHP
  • Use SQL to pull data from a database and to insert and modify data in a database
  • Employ XML to store and validate data and to make data more accessible to other applications

Outline

  1. Web Design and Graphics
    1. Introduction to Design
    2. Making Your Site Fast and Viewable
    3. Building Your Site With Images
    4. Building Your Site With Formatting
    5. Using Other Tools
  2. Web Publishing and Design With HTML 4.01 and XHTML
    1. Getting Organized
    2. Basics of HTML and XHTML
    3. HTML, XHTML, and Cascading Style Sheets (CSS)
    4. Advanced CSS, Forms, and DHTML
    5. Adding Interactivity and Multimedia with HTML and XHTML
  3. JavaScript
    1. Start Using JavaScript
    2. Using JavaScript for Interactivity
    3. Using Advanced JavaScript
  4. AJAX
    1. History and Revival of AJAX
    2. Introducing JavaScript
    3. The XMLHttpRequest Object
    4. N-Tier and AJAX
    5. Rich Internet Applications
    6. CSS and the DOM
    7. AJAX Frameworks
    8. Understanding an AJAX Library
    9. AJAX and Web Services
    10. Tagging With AJAX
    11. Cloning Google Suggest
    12. User Controls and AJAX.NET
    13. AJAX and Mapping
    14. AJAX and Web Parts
    15. AJAX and ASP.NET Security
    16. Performancev
    17. Debugging Your Application
    18. AJAX and Site Testing
    19. AJAX Usability
    20. Atlas
  5. Dynamic HTML
    1. DHTML and Style Sheets
    2. Using Javascript
    3. Objects and Events
    4. Styles and Content
    5. Data From Other Sources
  6. SQL for the Windows Environment
    1. Introduction to Databases and SQL
    2. Filtering Data
    3. Calculations and Functions
    4. Summarizing Data
    5. Groups and Queries
    6. Joins
    7. Data and Tables
    8. Views and Stored Procedures
    9. Transaction Processing and Cursors
    10. Advanced SQL Functions
  7. CGI/Perl
    1. Getting Familiar With Forms
    2. Building Programs
    3. Web Applications
    4. Interacting With Databases
  8. ColdFusion MX
    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
  9. PHP and MySQL
    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. Developing Web Applications
    10. Cookies and Sessions
    11. Web Application Security
    12. Extended Topics
    13. Content Management Example
    14. User Registration Example
    15. E-Commerce Example
  10. XML
    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
  11. SQL Server 2005
    1. Installing and Configuring SQL Server 2005
    2. Creating Databases
    3. Working With Tables and Programmability Objects
    4. Implementing Database Objects
    5. Supporting the XML Framework
    6. Enhancing Data Consumption and Throughput
    7. Maintaining and Backing Up Databases
    8. Monitoring Performance
    9. Troubleshooting and Optimizing
    10. Implementing High Availability
    11. Practice Exams
  12. Oracle 10g Administration
    1. Oracle Architectural Components
    2. Oracle Server Introduction
    3. Database Architecture, Creation, and Interfaces
    4. Database Control and Storage Structures
    5. Managing Users and Schemas
    6. Data Management
    7. PL/SQL
    8. Database Security Management
    9. Oracle Net Services
    10. Oracle Shared Server
    11. Database Performance Monitoring
    12. Database Maintenance
    13. Database Undo Management
    14. Database Locking Conflicts
    15. Database Backup and Recovery Concepts
    16. Database Backups
    17. Database Recovery

Demo

View Our Demo

Additional Info

Languages
English
Course Length
200.00 hours
Duration of Access

All of our programs are self-paced and open-enrollment. You can start and finish the program at your own pace. You’re given six months to complete this 200-hour program. If you need more time, a six-month extension is available free of charge. After one year, fees will apply.

Instructor

Instant Mentoring enables 24x7 access to certified instructors and Subject Matter Experts (SMEs). In addition to providing content expertise, our Mentors facilitate interaction and enhance the overall learning experience.

Prerequisites/Audience
There are no specific prerequisites for this program, but you should be fairly knowledgeable about computers and Internet usage, and you’ll need an Internet connection and e-mail capabilities.

This program is for you if you wish to become proficient in using HTML/DHTML and server-side programming to build Web pages.
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, all of which can be obtained for free:

• A web browser
• Any text or HTML editor
• The ability to install or access a web server (e.g, IIS or Apache)
• ColdFusion Application Server
• Perl
• PHP
• MySQL
• SQL Server 2005 (Express Edition is fine)
• Oracle (Express Edition is fine)

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.

This course includes a full online reference library featuring the following titles:

  • Agile Software Development Quality Assurance by Stamelos, Ioannis G; Sfetsos, Panagiotis
  • Beginning Ajax With PHP : From Novice to Professional {Expert's Voice in Open Source} by Babin, Lee
  • Professional Search Engine Optimization With PHP : A Developer's Guide to SEO {Wrox Professional Guides} by Sirovich, Jaimie; Darie, Cristian
  • Beginning Ruby On Rails {Wrox Beginning Guides} by Holzner, Steven
  • Web Analytics : An Hour a Day {Sybex Serious Skills} by Kaushik, Avinash
  • Practical Internet Security by Vacca, John R
  • Professional LAMP: Linux, Apache, MySQL, and PHP Web Development by Gerner, Jason
  • Beginning PHP and MySQL 5 : From Novice to Professional {2Nd Ed.} by Gilmore, W J
  • Web and Information Security by Ferrari, Elena; Thuraisingham, Bhavani M
  • Beginning Web Development With Perl : From Novice to Professional by Suehring, Steve
  • Professional Web APIs With PHP : EBay, Google, PayPal, Amazon, FedEx Plus Web Feeds {Wrox Professional Guides} by Reinheimer, Paul Michael
  • PHP 5 Unleashed by Coggeshall, John M
  • PHP and MySQL Everyday Apps for Dummies {--For Dummies} by Valade, Janet
  • Zend PHP Certification Study Guide by Herbert, Stuart
  • How to Do Everything With PHP & MySQL by Vaswani, Vikram
  • Pro Perl {Expert's Voice in Open Source} by Wainwright, Peter
  • Beginning Regular Expressions by Watt, Andrew
  • PHP 5 Recipes : A Problem-solution Approach {Expert's Voice in Open Source} by Babin, Lee
  • VBScript Programmer's Reference {2Nd Ed.} by Kingsley-Hughes, Adrian; Kingsley-Hughes, Kathie; Read, Daniel
  • Beginning PHP, Apache, MySQL Web Development by Glass, Mike
  • Apache, MySQL, and PHP Weekend Crash Course by Schafer, Steven M
  • Agile Database Techniques : Effective Strategies for the Agile Software Developer by Ambler, Scott W
  • Creating Interactive Websites With PHP and Web Services by Rosebrock, Eric
  • Learn VBScript in a Weekend {In a Weekend} by Ford, Jerry Lee
  • Using Active Server Pages by Johnson, Scot; Ballinger, Keith; Chapman, Davis Howard
  • Teach Yourself VBScript in 21 Days by Brophy, Keith; Koets, Timothy