Excel Data-Mining Fundamentals Training

You don't need to be a statistician to explore your own data. Learn how to use the software you already have, Excel, to perform basic data mining and analysis. Ron introduces core data-mining concepts like CRISP-DM (Cross Industry Standard Process for Data Mining), and then dives into the algorithms Microsoft offers for data mining right out of the box. Then learn about the data-mining structures and models in Excel SQL Server Analysis Services, and the new add-ins that make data mining in Excel both exceedingly powerful and incredibly easy. Topics include: -Solving business problems with data mining -Exploring Excel's data-mining algorithms -Data mining with Excel SQL Server Analysis Services -Using the Data Preparation tab -Detecting categories -Using the Prediction Calculator

Lynda.com -PHP With MySQL Essential Training

Lynda.com -PHP With MySQL Essential Training
Author: Kevin Skoglund

PHP is a popular, reliable programming language at the foundation of many smart, data-driven websites. This comprehensive course from Kevin Skoglund helps developers learn the basics of PHP (including variables, logical expressions, loops, and functions), understand how to connect PHP to a MySQL database, and gain experience developing a complete web application with site navigation, form validation, and a password-protected admin area. Kevin also covers the basic CRUD routines for updating a database, debugging techniques, and usable user interfaces. Along the way, he provides practical advice, offers examples of best practices, and demonstrates refactoring techniques to improve existing code.
Topics include:

What is PHP?
Installing and configuring PHP and MySQL
Exploring data types
Controlling code with logical expressions and loops
Using PHP's built-in functions
Writing custom functions
Building dynamic webpages
Working with forms and form data
Using cookies and sessions to store data
Connecting to MySQL with PHP
Creating and editing database records
Building a content management system
Adding user authentication

With Exercise files!

Android App Development with Java Essential Training

Overview: Lynda.com - Android App Development with Java Essential Training
Author: Lee Brimelow

Android App Development with Java Essential Training is a comprehensive look at the Android architecture that teaches how to build and deploy applications for Android phones and tablets using the Java programming language. Starting with the installation of the required developer tools, including Eclipse and the Android SDK, the course covers how to build the user interface, work with local data, integrate data from the accelerometer and other sensors, and deploy finished applications to the Android Market. Exercise files are included with the course.

Topics:
* Understanding project creation and structure
* Using explicit and implicit intents
* Setting up security and permissions
* Building text, button, and list controls
* Applying styles and themes to the interface
* Providing alternate layouts for different screen sizes
* Creating menus and dialogs
* Working with audio and video
* Adding animation
* Displaying notifications
* Using input from sensors
* Creating a home screen widget
And Finally
+ Publishing Your App
Preparing for publishing
Signing and building
Preparing the graphics
Publishing to the Android Market