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
Learn more about lynda.com
Ready to join?
get started
Members who watched this also viewed
show more
Frequently asked questions
Find answers to the most frequently asked questions about MySQL Essential Training.
- 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.
Can’t find an answer?
If you still have a question about MySQL Essential Training, let us know.
