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

Web Designer vs Web Developer

Web Designer vs Web

This Infographic explain you what is role of Web Designer and ...

Download Bluestack Offline

Download BlueStack O

Download BlueStack Offline  BlueStack is software in which you can run ...

FireCMD user interface

Command Prompt (cmd.

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

Sponsors