United States Mashups (Web 2.0 Web Apps) Tutorials
Online Contents For This Course
We have made some of the video tutorials for
Mashups (Web 2.0 Web Apps)
freely available to help you evaluate our training. Click on any of the linked lesson listings below to preview FREE!
Course Description
Mashups let you combine data and data presentations (such as maps) from a variety of sources. It may be your own data, or what you bring to the mashup may be a unique way of combining or presenting data. Mashups require a little technical knowledge about a lot of different Web technologies. VTC author Jesse Feiler walks you through every step of the development of two mashups guiding you through the use of some of the most common technologies: MySQL, PHP, REST, JavaScript, and XML. You'll see how to retrieve and parse data from an SQL database and from Amazon.com's product listings; you'll also see how to produce Google maps from your own data. The techniques here are common to many mashups and will help you get started with other sites including eBay and Flickrs. To begin learning simply click the links.
Choose your media type:
|
Introduction
|
|||
| Introducing Mashups | (03:36) | ||
| Mashups for Information, Connections, & Maps | (03:22) | ||
| The Campaign Contribution Mashup: Overview | (05:43) | ||
| About This Course | (03:09) | ||
|
Business Models & Legal Issues for Mashups
|
|||
| Overview | (04:28) | ||
| Using Mashups for Advertising & Promotion | (01:30) | ||
| Mashups for Advocacy | (02:27) | ||
| Mashups for Intermediaries | (01:23) | ||
| Mashups for Hollywood | (00:56) | ||
|
Mashup Architecture & Technology
|
|||
| Housekeeping | (03:14) | ||
| Mashups: The What | (03:53) | ||
| Mashups: The Why | (05:31) | ||
| Mashups: The How | (05:50) | ||
| Mashups: Technology Pt.1 | (05:51) | ||
| Mashups: Technology Pt.2 | (01:49) | ||
|
The Campaign Contribution Mashup Data
|
|||
| Introducing the Data & the Mashup | (06:12) | ||
| Campaign Data | (03:09) | ||
| Looking at the Candidate Data Files | (04:11) | ||
| Converting Candidate Data with Excel Pt.1 | (03:58) | ||
| Converting Candidate Data with Excel Pt.2 | (06:47) | ||
| Converting Candidate Data with Excel Pt.3 | (05:25) | ||
| The Campaign Contribution Data Model | (04:04) | ||
|
Writing the Mashup with JavaScript
|
|||
| Starting the Mashup | (04:35) | ||
| Getting Access to Google Mapping | (06:03) | ||
| The Most Basic Mapping Mashup | (04:40) | ||
| Testing the Basic Mapping Code | (01:55) | ||
| Structuring at the JavaScript Code | (03:31) | ||
| Modifying the Basic Mapping Code | (02:59) | ||
| Making the Map a Global Variable | (06:10) | ||
| Adding a Marker with a Function | (04:53) | ||
| Adding Information to a Marker | (06:19) | ||
| Customizing Markers | (03:18) | ||
| Adding Map Controls | (02:43) | ||
| Introducing Geocoding | (03:02) | ||
| Restructuring the Code | (04:32) | ||
| The showAddress Function | (03:55) | ||
| Running the Geocoder | (02:05) | ||
| Generalizing showAddress | (07:00) | ||
|
Adding PHP
|
|||
| Introducing PHP | (03:08) | ||
| Mixing HTML & JavaScript with PHP | (02:36) | ||
| Generating HTML from PHP | (05:10) | ||
| PHP Basics: Comments | (03:04) | ||
| PHP Basics: Strings & Concatenation | (04:34) | ||
| PHP Basics: Variables & Defines | (02:43) | ||
| Using PHP with Forms | (02:20) | ||
|
Adding MySQL
|
|||
| Running MySQL on Windows | (02:57) | ||
| Running MySQL on Mac OS X | (04:38) | ||
| Configuring MySQL on Windows | (01:43) | ||
| Roadmap for the Rest of the Chapter | (05:39) | ||
| Overview of SELECT | (02:08) | ||
| Describing the Table & Selecting Data | (04:54) | ||
| Using WHERE | (03:07) | ||
| Using Help | (01:44) | ||
| More on WHERE: Joining Tables | (02:55) | ||
| Selecting from the Joined Tables | (06:50) | ||
| Grouping Data | (04:15) | ||
| HAVING, ORDER BY, & FORMAT | (03:54) | ||
| Creating & Altering Tables | (05:19) | ||
| Altering Table Columns | (03:22) | ||
| More on Altering Tables | (04:36) | ||
| Using Indexes | (06:12) | ||
| Unique & Partial Indexes | (04:55) | ||
| Forcing non-Null Values | (02:09) | ||
| Using Primary Keys | (01:32) | ||
| Loading Data: Introduction | (04:36) | ||
| Loading CSV Data (Candidates) | (06:19) | ||
| Loading Tab-delimited Data (Committees) | (04:10) | ||
| Loading Fixed-Width Data (Individuals) | (06:11) | ||
| Checking the Data Load | (03:45) | ||
| Correcting the Fixed-Width Data Load | (03:26) | ||
| Showing the Warnings | (01:03) | ||
| Altering Tables with New Fields & Types | (04:07) | ||
| Updating the Table Data | (06:54) | ||
| Adding Security | (04:50) | ||
|
Adding MySQL to PHP
|
|||
| Overview | (03:05) | ||
| Structuring the PHP File: Include Files | (06:36) | ||
| How PHP Catches MySQL Errors | (01:50) | ||
| The MySQL/PHP Syntax | (04:08) | ||
| Constructing a MySQL Query in PHP | (05:10) | ||
| Executing the Query/Beginning HTML Table | (04:00) | ||
| Filling the HTML Table with MySQL Results | (06:01) | ||
| Using the Mapping API with MySQL Data | (01:56) | ||
| Revising the Includes | (05:37) | ||
| Getting ZIP Code Data from MySQL | (04:55) | ||
| Implementing the WHILE Loop | (03:29) | ||
| Cleaning Up a Bad ZIP Code | (03:53) | ||
| Changing the Info Window Text Pt.1 | (03:23) | ||
| Changing the Info Window Text Pt.2 | (05:06) | ||
| Using Alternate Markers | (06:12) | ||
|
Building Mashups from External Data
|
|||
| Overview | (05:03) | ||
| Registering for Amazon Web Services | (05:28) | ||
| Registering for eBay | (02:50) | ||
| Retrieving Data from Amazon | (05:19) | ||
| Adding the Keywords | (03:16) | ||
| Testing the URL & Looking at XML | (05:03) | ||
| Sending the URL & Retrieving the XML | (05:49) | ||
| Parsing the XML | (06:12) | ||
| Generalizing the Parsing in a PHP Function | (03:49) | ||
| Creating an Amazon Link Pt.1 | (04:54) | ||
| Creating an Amazon Link Pt.2 | (03:53) | ||
| Finish the Formatting of Multiple Authors | (04:45) | ||
|
Course Summary
|
|||
| Course Summary | (03:45) | ||
|
About the Author
|
|||
| About the Author | (03:46) | ||
Email this Page
Send us FeedbackCourse Information
| Course: | Mashups (Web 2.0 Web Apps) |
| Author: | Jesse Feiler |
| SKU: | 33730 |
| ISBN: | 1-933736-58-5 |
| Release Date: | 2006-12-22 |
| Duration: | 7 hrs / 103 tutorials |
| Work Files: |
Yes |
| Captions: | No |
Subscription / Purchase Information
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Sign up for a Free Trial
Full Access Members have full access to VTC.com’s entire library of video tutorials.
If you are already a member, please login here.