Whatever a database is being used for—web sites, bookkeeping, sales and inventory, or even the lowly to-do list—it’s all about the data. SQL Essential Training is designed to help users understand the most common language for database wrangling—SQL. Beginning with a brief introduction, instructor Bill Weinman teaches the major features of SQL; he offers a solid working knowledge of the language, and how to retrieve and manage data efficiently. He also works through a real-world example of building a CRUD (Create, Read, Update, and Delete) application using SQL. Exercise files accompany the course
A. Joomla! for Beginners
01. Introduction
02. Downloading Joomla!
03. Creating your Database
04. Uploading Joomla! to your site
05. Installing and Configuring Joomla!
06. A Walk around the Front End
07. It’s all about Content
08. The Back End - Administrator
09. Creating Sections
10. Creating Categories
11. Creating Content Items
12. Linking to Menus
13. Installing Templates
14. Worked Example - An online shop
15. Worked Example - A membership site
16. Worked Example - A magazine
17. Support and Conclusion
B. Building a CSS Template for JOOMLA
1. Lesson One – Slicing a Photoshop Image
• Planning the Layout
• Slicing Images
• Naming Slices
• Saving for the Web
2. Lesson Two – Creating the Foundation
• Files and Folders
• Linking the CSS into the PHP Document
• Getting Setup in Style Master
• Creating the DIV tags
3. Lesson Three – CSS Layout I
• Styling the Body
• Styling the Container
• Styling the Header
4. Lesson Four – CSS Layout II
• Styling the content DIV
• Working through browser bugs
5. Lesson Five – Finishing up and JOOMLA Integration
• Install JOOMLA Plug-in from
• Placing the Header Code
• Placing the Content Code
• Prepare the XML file
• Zip and Upload
C. Increasing User Experience with Javascript
1. Introduction
• Overview of the series
• Showcasing the javascript effects
2. Lesson Two - De-Cluttering the Membership Page
• Attaching scripts
• Considering MooTools as a solution to a cluttered layout
• Using the Fx.Styles of Mootools to change element properties
3. Lesson Three - Using MooTabs to Condense Related Products
• Understanding how MooTabs works
• Implementing MooTabs to condense the related products of a shopping cart
4. Lesson Four - Using a MooTools ‘Light Box’ to Create a Friendly Gallery
• Understanding the problem with the existing gallery
• Fixing the gallery with the MooTools Light Box
5. Lesson Five - Using Fx.Styles to Control Font Size
• Selecting an area to change
• Implementing Fx.Styles to change fonts
6. Lesson Six - Creating a Sliding Sub Menu with MooTools
• Analyzing the main menu and sub-menu for implementation
• Implement some simple MooTools effects to reveal sub-links
7. Lesson Seven - Implementing Reflection Javascript for Images
• Downloading and using reflection.js for images
8. Lesson Eight - Creating a Sliding Image Menu
• Understanding how the Sliding Image Menu works
• Implementing the Sliding Image Menu
9. Lesson Nine - Using AJAX with the Sliding Image Menu
• Creating an updated area for changing content
• Implementing AJAX links with the Sliding Image Menu
E. Template Migration for Joomla Tutorial Series
1. Lesson One - Introduction and Re-Ordering the File Structure
• Introduction to the Template
• Moving the template files to the correct location for Joomla
2. Lesson Two - Optimizing the Template
• The Dreamweaver extension from Joomlasolutions.com
• Inserting the php tags, header code, and various other code
3. Lesson Three - The Template Details XML File
• How the template_details.xml works
• Assigning files, images, css, etc.
4. Lesson Four - Re-naming and Styling the Main Menu
• Understanding how the Main Menu is styled
• Re-assigning existing menu styles with the Joomla selectors
5. Lesson Five - Migrating Styles for Use with Modules
• Latest news module changes
• Main menu module stylings in other positions
6. Lesson Six - Custom Module Styling Using Class Suffixes
• Styling the Newsflash module similar to the static template
Using class suffixes in Joomla
7. Lesson Seven - Styling Various Joomla Elements
• Style matching the titles, paragraphs, etc. in the template
• News component styling
Matthew Keefe, “Flash and PHP Bible”
Wiley | ISBN-10: 0470258241 | May 5, 2008 | 508 pages | PDF | 6.2MB
The demand for rich Internet applications (RIAs) such as complete storefronts and interactive surveys is skyrocketing, as is the pressure to create these dynamic apps overnight and at low cost. This in-depth Bible provides the step-by-step instructions you need to quickly create RIAs in Flash using cost-effective, open-source PHP programming tools. You’ll learn how PHP works, when you should use it in Flash, and above all, vital security techniques for keeping your interactive sites secure.
* Install, configure, and explore the basics of PHP
* Connect Flash to PHP and PHP to MySQL
* Create contact forms and search capabilities
* Clean, store, and check your interactive data
* Apply advanced security techniques
* Develop an RSS reader or banner tracking with PHP
* Extend Flash and PHP with third-party libraries
* Learn best practices for backing up and updating your server
