Free Video Programming Tutorials from lynda.com

lynda.com produces thousands of tutorials, invaluable training, inspiration and more to help you get the most out of your software. Don’t just gain skills—gain confidence. Check out these free video programming tutorials from lynda.com.

iOS 4: Building Data-Driven Applications
In iOS 4: Building Data-Driven Applications, Bill Weinman teaches how to create a universal app for iPhone, iPod Touch, and iPad with Internet connectivity, XML parsing, database storage (using SQLite), and data presentation. The course also demonstrates the process of distributing the application, including testing and preparing the app, preparing the assets, and submitting to the Apple App Store. The completed application built in this course, BW RSS, is available as a free download from the App Store. Exercise files are included with the course.

SQLite 3 with PHP Essential Training
In SQLite 3 with PHP Essential Training, Bill Weinman addresses all of SQLite's major features in the context of the PHP environment. This tutorial covers the fundamentals of SQLite, including a thorough overview of its unique data type system, expressions, functions, transactions, views, and event triggers. A functional CRUD application and web site testimonial engine are demonstrated, and a quick-start guide is included to get experienced developers up and running fast.

SQL Server 2008 Essential Training
In SQL Server 2008 Essential Training, Simon Allardice explores all the major features of SQL Server 2008 R2, beginning with core concepts: installing, planning, and building a first database. Explore how Transact-SQL is used to retrieve, update, and insert information, and gain insight into how to effectively administer databases. The course also covers features outside SQL Server's database engine, including technologies that have grown up around it: SQL Server Reporting Services and Integration Services.

HTML5 First Look
In HTML5 First Look, author James Williamson introduces the newest HTML specification, providing a high-level overview of HTML5 in its current state, how it differs from HTML4, the current level of support in various browsers and mobile devices, and how the specification might evolve in the future.

Ruby on Rails 3 Essential Training
In Ruby on Rails 3 Essential Training, instructor Kevin Skoglund shows how to create full-featured, object-oriented web applications with the latest version of the popular, open-source Ruby on Rails framework. This course explains the complete process—from the fundamental concepts and best practices behind the Rails framework, to how to build a complete application with dynamic, database-driven content. Using a content management system as an example project, this tutorial explains how to structure databases, build database-driven, object-oriented models, route incoming requests, render pages with dynamic content, and to process and validate form data. Previous experience with Ruby is recommended, but not required.

Installing Apache, MySQL and PHP
Installing Apache, MySQL, and PHP with David Gassner describes how to install and perform the initial configuration of Apache, MySQL, and PHP, known as the AMP stack, on a local development computer. Chapters are devoted to multiple installation approaches: installing the components separately on both Windows and Mac, installing the pre-packaged Apache and MySQL distributions in WampServer on Windows and MAMP on Mac, and installing the cross-platform XAMPP on both Mac and Windows.