Shareittips.com

Computer & IT Tips By Akash Padhiyar

Course name: MySQL Essential Training
Author: Bill WeinmanLearn MySQL Essential Training - Lynda.com
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

  • Welcome
  • What is MySQL?
  • Important terminology
  • Using the exercise files

2. Installing the Test Environment

  • Installation overview
  • Installing XAMPP on Windows
  • Installing XAMPP on a Mac

3. Configuring MySQL

  • Using the MySQL Command Line Interface on Win
  • Using the MySQL Command Line Interface on a Mac
  • Setting up the root user
  • Setting up a regular user
  • Importing databases on Windows
  • Importing databases on a Mac

4. Using the SQL Interactive Demonstrator (SID)

  • Using SID
  • Installing SID on Windows
  • Installing SID on a Mac

5. Creating a Database

  • Creating a database
  • Creating a table

6. MySQL Data Types

  • What are data types?
  • Numeric types
  • String types
  • Large storage types
  • Date and time types
  • Bit type
  • .Boolean values
  • Enumeration types

7. MySQL Functions

  • MySQL functions
  • String functions
  • Numeric functions
  • Date and time functions
  • Time zones in MySQL
  • Installing time zone support in MySQL in Windows
  • Installing time zone support in MySQL on a Mac
  • Aggregate functions
  • Full-text search

8. PHP’s MySQLi Interface

  • PHP programming interfaces
  • Introducing CRUD
  • Connecting to the database
  • Prepared statements
  • Fetching results
  • Auto-increment IDs

9. PHP’s PDO Interface with MySQL

  • PDO is multi-platform
  • Connecting to the database
  • Prepared statements
  • Fetching results
  • Auto-increment IDs

10. Conclusion

Download Hot File

Akash Padhiyar

I am Akash Padhiyar Founder of Shareittips.com,BCA MCA Tutor ,Running Web development compnay "AkashInfoTech".

More Posts - Website - Facebook

Share
Categories: My Sql, Other Stuffs

One Response so far.

  1. [...] artykuł na: Learn MySQL Essential Training – Lynda.com | MySQL Essential … a-regular-user, command, command-line, databases-on-windows, importing, interface-on-win, root–, [...]

Leave a Reply


Google Search

Popular Posts

Download Bluestack Offline

Download BlueStack O

Download Offline Version  Download Online Version  Note: To Install BlueStack Software you ...

FireCMD user interface

Command Prompt (cmd.

Serious geeks spend a lot of time at the command ...

Psy – Gangnam Style Facebook Smileys

Facebook Hidden Smil

Psy – Gangnam Style Facebook Smileys [[195616067242230]] [[195616073908896]] [[195616063908897]] [[195616077242229]] [[195616070575563]] ...

Sponsors