Computer & IT Tips By Akash Padhiyar

Course name: MySQL Essential Training
Author: Bill WeinmanLearn MySQL Essential Training -
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,BCA MCA Tutor ,Running Web development compnay "AkashInfoTech".

More Posts - Website - Facebook

Categories: My Sql, Other Stuffs

One Response so far.

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

Leave a Reply

Google Search

Popular Posts

Bigrock Hosting Prom

Bigrock Hosting PromoCode October 2016 HOSTING FEST! Flat 40% Off! Festivities ...

DotCom Domain Name a

DotCom Domain Name at Rs.99 Bigrock .Com Promocode end date for ...

Web Designer vs Web

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