Start learning with our library of video tutorials taught by experts. Get started

MySQL Essential Training
Illustration by Richard Downs

MySQL Essential Training

with Bill Weinman

Video: Welcome

(Music playing.) Hi! I'm Bill Weinman and welcome to MySQL Essential Training. In this course, I aim to give you the knowledge to perform the basic functions that will allow you to use MySQL effectively, and to take advantage of its powerful and unique features. After I walk you through the installation of the program, we get right into creating and using your own databases. We'll look at the different data types MySQL supports and the functions that are provided to get the most out of them. We'll take a good look at the command-line interface, and how to use it to access MySQL's powerful security model.
Expand all | Collapse all
  1. 6m 24s
    1. Welcome
      1m 1s
    2. What is MySQL?
      54s
    3. Important terminology
      2m 53s
    4. Using the exercise files
      1m 36s
  2. 15m 18s
    1. Installation overview
      3m 50s
    2. Installing XAMPP on Windows
      5m 12s
    3. Installing XAMPP on a Mac
      6m 16s
  3. 28m 5s
    1. Using the MySQL Command Line Interface on Windows
      4m 20s
    2. Using the MySQL Command Line Interface on a Mac
      1m 3s
    3. Setting up the root user
      4m 1s
    4. Setting up a regular user
      6m 33s
    5. Importing databases on Windows
      5m 35s
    6. Importing databases on a Mac
      6m 33s
  4. 8m 53s
    1. Using SID
      1m 19s
    2. Installing SID on Windows
      4m 19s
    3. Installing SID on a Mac
      3m 15s
  5. 4m 49s
    1. Creating a database
      1m 21s
    2. Creating a table
      3m 28s
  6. 23m 23s
    1. What are data types?
      54s
    2. Numeric types
      5m 24s
    3. String types
      1m 28s
    4. Large storage types
      1m 8s
    5. Date and time types
      2m 25s
    6. Bit type
      3m 20s
    7. Boolean values
      1m 8s
    8. Enumeration types
      7m 36s
  7. 56m 39s
    1. MySQL functions
      1m 27s
    2. String functions
      10m 44s
    3. Numeric functions
      9m 13s
    4. Date and time functions
      3m 26s
    5. Time zones in MySQL
      5m 11s
    6. Installing time zone support in MySQL in Windows
      5m 32s
    7. Installing time zone support in MySQL on a Mac
      7m 49s
    8. Aggregate functions
      4m 46s
    9. Full-text search
      8m 31s
  8. 13m 58s
    1. PHP programming interfaces
      56s
    2. Introducing CRUD
      2m 59s
    3. Connecting to the database
      4m 22s
    4. Prepared statements
      2m 23s
    5. Fetching results
      2m 17s
    6. Auto-increment IDs
      1m 1s
  9. 7m 30s
    1. PDO is multi-platform
      38s
    2. Connecting to the database
      2m 36s
    3. Prepared statements
      1m 2s
    4. Fetching results
      2m 10s
    5. Auto-increment IDs
      1m 4s
  10. 1m 3s
    1. Goodbye
      1m 3s

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
Please wait...
MySQL Essential Training
2h 46m Beginner Aug 04, 2009

Viewers: in countries Watching now:

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.

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
Subjects:
Developer Databases
Software:
MySQL
Author:
Bill Weinman

Welcome

(Music playing.) Hi! I'm Bill Weinman and welcome to MySQL Essential Training. In this course, I aim to give you the knowledge to perform the basic functions that will allow you to use MySQL effectively, and to take advantage of its powerful and unique features. After I walk you through the installation of the program, we get right into creating and using your own databases. We'll look at the different data types MySQL supports and the functions that are provided to get the most out of them. We'll take a good look at the command-line interface, and how to use it to access MySQL's powerful security model.

I'll show you the MySQL PHP interfaces to help you create web applications. Whatever the application, calendar, email, Websites, bookkeeping, sales, inventory, even the lowly To Do list, it's all about the data, and that usually mean some sort of a database. This course will give you the tools to create and maintain the database you need. Now let's get started with MySQL Essential Training.

Find answers to the most frequently asked questions about MySQL Essential Training.


Expand all | Collapse all
Please wait...
Q: When attempting to follow the steps described in the "Installing XAMPP in Windows/Mac" videos, after typing in “localhost” in the browser, the XAMPP page does not appear as it does in the tutorial, or another page appears. Typing “mysql” in the command line may lead to an error: mysql is not recognized as an internal or external command. What is causing these errors, and how can it be resolved?
A: There are several common reasons for problems running the Apache or MySQL servers in XAMPP.  - Make sure there are no conflicting servers running. Before you install XAMPP be sure that you have disabled any existing web servers or other installations of MySQL. (Mac OS X comes with Apache, and Windows may come with Microsoft Internet Information Server.)  - Be sure to install the exact same version of XAMPP that is used in the video instructions. You may download these versions of XAMPP from http://bw.org/ldcsql/ - Computers are notoriously picky about punctuation. Be extra careful when typing commands while installing XAMPP.
Q: How do I get your program, SID, to allow me to choose a different database from the drop-down box, other than the 'test' file included in the exercise files?
A: At the top of the sid.php file, there is an array declaration that lists what databases to show in the drop-down box. You may modify this list to show whatever databases you like.
Q: After downloading XAMPP I was unable to start Apache from the control panel. MySQL started fine. When I click the Start button next to Apache it looks like it starts and then stops. Here is the output:

Busy
Apache Started (Port 80)

The MySQL button says "running" with a stop button; the Apache button still? says start no matter how many time I click it.
A: This usually means that another program is using Port 80 (the port that Apache needs). Port 80 is used for any web server, so you either have another web server running or you're running something else (usually Skype) that is using Port 80.

If you're running Skype (and this is really common), you need to configure it to use a different port. If it's not Skype, it may be that you're running another web server or IIS (Microsoft Internet Information Server, the web server that comes with Windows), which you'll need to quit.
Share a link to this course
Please wait... Please wait...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.
Upgrade now


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

join now

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed MySQL Essential Training.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Welcome to the redesigned course page.

We’ve moved some things around, and now you can



Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked