Username: 
Password: 
Mashups (Web 2.0 Web Apps) Tutorials

Online Contents For This Title

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!
   Title 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)

This title is just part of the entire VTC collection of over 625 courses, 66,000 video tutorials (12,500+ free), available to you for just $30 a month.


Tutorial Information

Title: 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 lessons
Work Files: Yes
Captions: No
Compatibility: Vista/XP/2000, OS X, Linux
QuickTime 7, Flash 8

Subscription / Purchase Information

This title is just part of the entire VTC collection of over 625 courses, 65,000 video tutorials (12,500+ free), available to you for just $30 a month.


Also Available in CD format

Single User: US$ 99.95      Purchase/Add to Cart

Select Bandwidth