E-Books » Video Training → Lynda.com MySQL Essential Training




Published by: KingOfDCP on 5 September 2010  |   0       | Report post

Lynda.com MySQL Essential Training
Related Files: 1294, Download Speed: 9723 kb/s

Your Future Downloads - Downarchive.com

Lynda.com MySQL Essential Training | 188.65MB

MySQL is by far the most popular database management system for small- to medium-sized web projects. In MySQL Essential Training, instructor Bill Weinman provides clear, concise instruction in the tools needed to create and maintain a database. Bill explores the different data types MySQL supports, and the functions it provides, enabling the user to get the most out of them. He even shows the MySQL PHP interfaces that can be used to create web applications. Exercise files accompany the course.

Course name: MySQL Essential Training
Author: Bill Weinman
Duration (hr:min): 02:46
Released on: 8/4/2009
Exercise files: Yes

Topics include:
• Installing and configuring MySQL
• Creating and using databases
• Using numeric, string, and full-text search functions
• Using the command line interface to access MySQL’s powerful security model
• Inserting and retrieving data
• Choosing a storage engine

Table of Contents:

1. Introducing MySQL
1. Welcome
2. What is MySQL?
3. Important terminology
4. Using the exercise files

2. Installing the Test Environment
1. Installation overview
2. Installing XAMPP on Windows
3. Installing XAMPP on a Mac

3. Configuring MySQL
1. Using the MySQL Command Line Interface on Win
2. Using the MySQL Command Line Interface on a Mac
3. Setting up the root user
4. Setting up a regular user
5. Importing databases on Windows
6. Importing databases on a Mac

4. Using the SQL Interactive Demonstrator (SID)
1. Using SID
2. Installing SID on Windows
3. Installing SID on a Mac

5. Creating a Database
1. Creating a database
2. Creating a table

6. MySQL Data Types
1. What are data types?
2. Numeric types
3. String types
4. Large storage types
5. Date and time types
6. Bit type
7. Boolean values
8. Enumeration types

7. MySQL Functions
1. MySQL functions
2. String functions
3. Numeric functions
4. Date and time functions
5. Time zones in MySQL
6. Installing time zone support in MySQL in Windows
7. Installing time zone support in MySQL on a Mac
8. Aggregate functions
9. Full-text search

8. PHP's MySQLi Interface
1. PHP programming interfaces
2. Introducing CRUD
3. Connecting to the database
4. Prepared statements
5. Fetching results
6. Auto-increment IDs

9. PHP's PDO Interface with MySQL
1. PDO is multi-platform
2. Connecting to the database
3. Prepared statements
4. Fetching results
5. Auto-increment IDs

10. Conclusion
1. Goodbye


Screenshot



Link for more information: http://www.lynda.com/home/DisplayCourse.aspx?lpk2=770

Download Links

Hotfile
Download

Fileserve
Download

Filesonic
Download



NO MIRROR PLS.



Direct Download Links Speed Max Upto 100Mbps


Fast Download : Lynda.com MySQL Essential Training
Lynda.com MySQL Essential Training is available on a new fast direct download service with over 2,210,000 Files to choose from.Download anything with more then 1000+ Kb/s downloading speed. Signup process takes just 10 sec to go. Signup today and enjoy the speed !

Lynda.com MySQL Essential Training Download Torrent. Lynda.com MySQL Essential Training Download From Megaupload, Rapidshare & Hotfile. Lynda.com MySQL Essential Training with keygen, crack, serial, dvdrip

Related News

• Lynda.com - PHP with MySQL Essential Training
• Lynda.com - PHP with MySQL Essential Training DVD-ViH
• Lynda.com - PHP with MySQL Essential Training (repost)
• Lynda.com Dreamweaver CS5 Training with PHP and MySQL Video Tutorial
• Lynda - MySQL Tutorials Installing Apache MySQL and PHP

Dear visitor, you went to the site as unregistered user. Only registered and authorized users can leave comments. Please log in or Register, if not registered.

Comments (0)

Information

Members of Guest cannot leave comments.