This free online course will teach you how to install the MySQL database and perform standard CRUD (Create, Read, Update, and Delete) operations to manipulate the data in the database. You'll learn how to execute a SQL query, which is a way of asking the database to give us the specific data we're looking for, and how to modify existing data using a SQL statement.

Most business applications store critical information in a database, and having database experience is an important skill to have on your resume in today's IT world.

Course Prep:

1. Read Chapter #14 (pages 591 - 605) in the Core Servlets and JavaServer Pages textbook.

   The reading in chapter 14 does a good job of covering general SQL CRUD statements, and the statements work the same regardless of which database is used (in fact, the book uses the Hypersonic database, but we'll stick with MySQL which is much more widely used in the real world).

2. Download and install MySQL Server 5.0 by following the instructions in MySQL5_Install_Configure.doc.
3. View the MySQL lecture (also available in pdf format here), which provides an overview of database concepts and an introduction to SQL CRUD operations.

Course Exercises:

1. Open a MySQL command window and enter the SQL commands from the lecture. You'll find the MySQL command window by running mysql.exe, located in the bin folder of your MySQL installation.
2. Save a pre-built SQL script to your system by right-clicking on this file and saving it to your hard-drive: etraining.txt.
3. Load the etraining.txt script into MySQL using the source command (refer to the lecture slides for usage instructions).
4. Use the MySQL commands described in the lecture to view the Etraining database tables, and select all records from the users and accounts tables.
5. Delete a record from each table, using a SQL Delete statement.
6. Add a new record to each table, using a SQL Insert statement.
7. Change the username of one of the records in the users table, using a SQL Update statement.
8. Change the account balance of one of the records in the accounts table, using a SQL Update statement.
9. Notice that the accounts table contains an AccountKey field and a UserKey field. Select both the UserName and the Account balance in the same SQL query using a join (shown below):
   

   SELECT users.UserName, accounts.Balance
   FROM users, accounts
   WHERE users.UserKey = 4

Congratulations - by reading the lecture slides and performing the tasks listed above, you should now be familiar with basic database operations.

SystemSuite 7 Professional Complete Protection for Your PC! Get the only solution that offers complete PC maintenance, diagnostics, and protection for up to 3 PCs! VCOM SystemSuite Professional is a comprehensive collection of essential PC utilities designed to maintain and protect your PC to keep it running just like the day you bought it. With VCOM SystemSuite Professional you can improve system performance, protect your system against viruses and from hackers, diagnose computer problems, recover lost data, protect against email spam, and much, much more. Special Offer: Save 50% with Coupon Code AFSS50