Title Language  : 

Find a Course... Try for Free!

 

Mashups (Web 2.0 Web Apps) Tutorials

Course Content
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.
QT To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.
Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.

лл Hide This
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 Feedback
Tutorial Information / Pricing
Title: Mashups (Web 2.0 Web Apps)
Author: Jesse Feiler
SKU: 33730
ISBN: 1-933736-58-5
Duration: 7 hrs / 103 Lessons
Compatibility: Win XP, 2000, 98, NT, Mac OS X, OS 9

Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP LEARN MORE »

Get this title on CD
Single User: US$ 99.95 - Purchase CD / Add to Cart

Multi User (10): US$ 500.00 - Purchase CD / Add to Cart

Select Bandwidth
Click "High Bandwidth" if you want to view movies at the highest quality available. Click "Low Bandwidth" if on a slow dial-up connection (28 Kbps and such). The low bandwidth movies are slightly more compressed and smaller in file size, allowing for faster streaming.

Select:

Select Category

Special Groups

Publisher or Products