Category: Web Programming

Introduction to Databases for the Web

My image
  • Author: Selena Sol
  • Format: online HTML
  • Price: free

This is a free four part course, suitable for webmasters and web developers with little or no database experience. The goal of this tutorial is to introduce database concepts and give you the tools you need to get to work using the databases available to you. The first part introduces the various types of database systems, especially relational databases and the SQL language. Examples are given of creating and manipulating a database and tables within it.

Chapters include:

  • What is a Database
  • Types of Databases
  • Analytic Databases
  • Operational Databases
  • Databases Models
  • Hierarchical Databases
  • Network Databases
  • Relational Databases
  • Client Server Databases
  • Good Database Design
  • Talking to a Database
  • The Basics of the SQL Database
  • Tables
  • The Data Dictionary
  • Basics of an SQL Query
  • Data Types
  • Logging on to the Database
  • A Sample Database
  • Creating Databases
  • Creating Tables
  • Deleting Databases and Dropping Tables
  • Altering a Table
  • Retrieving Data
  • Wildcards
  • Where
  • And, Or, and Not
  • Between
  • In
  • Like
  • Null
  • Order by
  • Performing math
  • Maximums and Minimums
  • Counting Records
  • Distinct
  • Averages
  • Joins
  • Subquerries
  • Adding Data
  • Modifying Data
  • Deleting Data
  • Server Side Database Communication With CGI
  • Chains of Communication
  • Using Perl 5 and the DBI Module to Communicate With Databases
  • The DBI Module
  • The DBI API
  • Getting the Pieces
  • Installing Perl
  • Installing a Web Server : Sambar
  • Running CGI Applications on a Single Station Local Area Network
  • Setting up a Sample Database
  • Putting it all together with a DBI-Aware CGI Script
  • Intro to JDBC
  • JDBC Application Environment Setup
  • Using JDBC to Connect to a Database
  • Using JDBC to Query a Database
  • Using JDBC to Modify a Database
  • More on JDBC
  • JDBC by Example

http://www.extropia.com/tutorials/sql/toc.html

Introduction to XML for Web Developers

My image
  • Author: Selena Sol
  • Format: online HTML
  • Price: free

In this tutorial, Selena Sol walks you through XML and the sister XSL style sheet language. Using simple, well-explained examples, Sol shows you how to get up to speed with the syntax of XML.

Chapters include:

  • What is a Markup Language
  • What is XML
  • Advantages of XML: Breaking the Tag Monopoly
  • Advantages of XML: Moving Beyond Format
  • Disadvantages of XML
  • History of XML
  • The Basics of XML
  • Well Formed XML
  • XML Document Structure
  • Data Versus Markup
  • The XML Declaration
  • Elements
  • Character Data
  • Tags
  • CDATA
  • Comments
  • Processing Instructions
  • Entities
  • General Entities
  • Parameter Entities
  • The DOCTYPE Declarations
  • Entity References
  • Introducing the Valid XML Document and the DTD
  • The Prolog and The Body
  • The Basic DTD
  • Element Type Declarations (ETDs)
  • Defining Elements and their Children
  • Ordering Child Elements
  • Repeated Elements
  • Grouping Elements
  • Either/Or
  • Optional Children
  • Mixed Content
  • Empty Elements
  • Defining Valid Element Attributes
  • Attribute Defaults
  • Attribute Types
  • CDATA TYPE
  • ENUMERATED TYPE
  • ID and IDREF
  • NMTOKEN and NMTOKENS
  • NOTATION TYPE
  • Entity Declarations
  • Gathering DTDs from Multiple Sources
  • Public DTDs

http://www.extropia.com/tutorials/xml/toc.html

The Web Book

My image
  • Author: Robert Schifreen
  • Format: PDF download (click the blue download button)
  • Price: Free for personal use

The Web Book is a complete 330-page book that tells you how to create a Web site from scratch. It covers everything from registering a domain name and renting some hosting space, to creating your first HTML page, to building full online database applications with PHP and MySQL. You can download The Web Book as a PDF file completely free of charge for personal use.

Contents include:

  • About The Web Book
  • Our Choice of Web Host
  • Licensing The Web Book
  • A Custom Edition For Your Company
  • Who’s Written This Book?  And Why?
  • Why We’re Here
  • From Word Processor to Web Site
  • How long should all this take?
  • What Is a Web Site Anyway?
  • How the Web Works
  • Domain Names
  • The Simple Option
  • The Flexible Option
  • About Web Content
  • Do you need a development server?
  • Getting Everything Together
  • Our Domain Name and Hosting
  • It’s Not Rude to Point
  • Our HTML Editor and FTP Client
  • Amaya
  • Make A Web Work Folder
  • Filezilla
  • Creating Your First Web Page
  • Now step away from the computer!
  • Keep On Reading
  • WWW – What, Why, Who?
  • Importing Existing Content
  • Writing For The Web
  • Fonts and Colours
  • Hyperlinks
  • Linking to Other Sites
  • Mailto: Links
  • Understanding The Basics of HTML
  • Meta tags
  • HTML and Privacy
  • Validating your HTML
  • A Bit More about Accessibility
  • Cascading Style Sheets
  • About DOCTYPEs
  • Getting Started with CSS
  • A Word About Fonts
  • Classes
  • Making Styles Work For You
  • HTML Tags Names
  • A Better CSS Editor
  • ID-based Styles
  • Extreme CSS
  • Page Layouts and Div Tags
  • The CSS Box Model
  • Pictures On Pages
  • About Image Sizes
  • Pictures As Links
  • Finding Images to Use on Your Site
  • A Browser Icon for your Site
  • The Short Cut to Great Web Pages
  • Using an Open Source Design
  • Tweaking the Text
  • Changing the Pictures
  • Changing the CSS Styles
  • Which Style Is This?
  • Adding Pages and Navigation
  • Uploading the Finished Files
  • Rules, Tables and Image Maps
  • Rules
  • Tables
  • Image Maps
  • Password-Protecting your Web Pages
  • The .htaccess File
  • The .htpasswd File
  • Protecting Multiple Folders
  • CMSes and Other Software
  • CMSes and Templates
  • Automatic Installers
  • Try Before You Install
  • A Word about Patching
  • Setting Up A Database
  • General Installation Procedures
  • Uninstalling
  • Joomla
  • Uploading the Files
  • Configuring Joomla
  • Your New Joomla Site
  • WordPress
  • Downloading the Software
  • Make a Database
  • Configure WordPress
  • Upload The Software
  • Final Configuration
  • phpBB
  • File Permissions
  • Plogger
  • Getting Started
  • The Installation Process
  • Uploading Your Pictures
  • Avoiding Data Overload
  • Installing the PSPad Editor
  • Javascript
  • Choose Your Side
  • Javascript and Semicolons
  • Email Address Obfuscation
  • Why Upload?
  • Security and Cookies
  • Morning All!
  • Getting the Screen Size
  • Javascript Toolkits and Frameworks
  • Finding Out More
  • MySQL and Web Databases
  • Databases, Tables, Fields, Rows and Columns
  • Normalization
  • Referential Integrity
  • Creating A Database
  • Using phpMyAdmin
  • Creating The Customers Table
  • Inserting Some Data
  • Querying the Customers Table
  • Introducing PHP
  • Don’t Panic
  • Your First PHP Program
  • Some More PHP
  • Random Numbers
  • Sending Email with PHP
  • Passing Information to PHP
  • Don’t Forget to Sanitize
  • Loop the Loop
  • Arrays
  • User-Defined Functions
  • HTML Forms
  • Creating a Form with Amaya
  • Naming the Form Objects
  • Handling Form Data in PHP
  • Testing The Form
  • Other Types of Form Data
  • Checkbox Arrays
  • Feedback Forms
  • Hidden Fields
  • Accessing MySQL Databases with PHP
  • Counting Rows
  • Reading Data
  • Searching A Table
  • About SQL Injection Attacks
  • Adding Data to a Table
  • Editing a Data Record
  • Deleting Data
  • Putting it All Together
  • Debugging and Global Variables
  • Syntax Errors
  • Coding Errors
  • The $_SERVER Variables
  • The Structure of a PHP Application
  • Web Servers and the Real World
  • Putting the App Together
  • Saving State
  • How to Back Up your Web Site
  • Don’t Forget the Database
  • Restoring Lost Information
  • Finance and Marketing Issues
  • Promoting Your Site
  • Making Money
  • Accepting Online Payments
  • Managing your Marketing
  • Search Engine Optimisation
  • SEO Tips
  • Keeping the Crawlers Away
  • If at First you Don’t Succeed, Pay
  • The End.  So, What Now
  • Appendix A – Building a Test Server
  • Our Goal
  • First Install the OS
  • Some Useful Commands
  • Get Updated
  • Test Your Web Server
  • Install the Telnet Server
  • An ftp server
  • Webmin
  • Webalizer
  • PHP and MySQL

Get the book: The Web Book

Active Server Pages

My image
  • Author: Wikibooks, the open-content textbooks collection
  • Format: HTML
  • Price: free

This book is organized into modules. Each module should take you about one hour to complete. Later modules build upon earlier modules, so you are encouraged to read them in sequence.

The book is a work in progress, and there may be incomplete or missing chapters.

Chapters include:

  • Prerequisites
  • Differences between ASP 3.0 and ASP.NET
  • Your first page
  • Basic ASP Syntax
  • Variable Types
  • Expressions
  • Conditionals and Looping
  • Functions and Subroutines
  • Database Access Using ADO
  • Server-Side Includes
  • Appendix A: Language Reference
  • Protecting against user-input (XSS attacks)

http://en.wikibooks.org/wiki/Active_Server_Pages

Perl Programming

My image
  • Author: Wikibooks, the open-content textbooks collection
  • Format: HTML
  • Price: free

Perl is a programming language designed by Larry Wall, known today for its strong community and module archive CPAN. It was originally developed to process text and produce reports. As a result, a backronym has been formed from its name: Practical Extraction and Report Language. It makes extensive use of significant punctuation, and highly chaotic-looking code has been written in it. This has resulted in a less complimentary backronym (which is still embraced by Perl users): Pathologically Eclectic Rubbish Lister (said to be a quote from the language designer himself).

Perl is Free Software, available under the Artistic License and the GPL. It was developed on Unix, and its Unix roots are pervasive. Perl is available for most operating systems but is particularly prevalent on Unix and Unix-like systems, and is growing in popularity on Microsoft Windows systems. However, it has been ported to a multitude of environments (some say as many as Java). It’s a popular systems administration tool in Windows. Most of the things done in Perl transfer well from one operating system to another (provided suggested conventions are followed).

The book is a work in progress, and there may be incomplete or missing chapters.

Chapters include:

  • Editors and IDEs
  • First Program
  • Basic Variables
  • Strings
  • Numbers
  • Making choices: if and else
  • Doing things over and over: while and for loops
  • Operators
  • Variables
  • Data Types
  • Scalar Variables
  • Array Variables
  • Hash Variables
  • User I/O
  • Advanced Output
  • Filehandles
  • Statement modifiers
  • Functions
  • Perl 5.10 Additions
  • Exercises
  • Programming Structure and style
  • References and Data Structures
  • Regular Expressions
  • Regular Expression Operators
  • Regular Expressions Reference
  • Code reuse (modules)
  • Perl Objects
  • GUI and desktop programming
  • CPAN
  • DBI – Perl Database Interface
  • CGI
  • FastCGI
  • mod_perl
  • HTML::Mason
  • Perl 6
  • Humour
  • First example code to get you started
  • Second example code to get you started
  • Function Reference
  • Concept Index
  • Useful Modules
  • Quick-reference cards
  • Websites

http://en.wikibooks.org/wiki/Perl_Programming