2014
Lynda
Sheeri Cabral
2:57
English

Get a simple introduction to MySQL—without the overhead. Sheeri K. Cabral introduces the vocabulary and tools for MySQL, the world's most popular open-source database that powers everything from your neighbor's blog to Internet giants like Facebook. The goal of this course is to get you interacting with data and understanding just why databases are better. Most of the work is done at the command line, as Sheeri teaches you how to create a new database, build tables, read and edit database records, and use functions to query data. She also issues a series of challenges along the way that allow you to test your skills and compare your results with hers.

Introduction
Welcome
What you should know before watching this course
Easy ways to play with MySQL
Using the exercise files
1. Database Basics
Databases vs. spreadsheets
Relational databases vs. flat files
Normalizing databases
Common database acronyms
2. MySQL Basics
Understanding MySQL terminology: Database, table, row, column, and field
Finding information about your database with SHOW
Exploring MySQL data types
NULL values
Understanding declarative language
Challenge: Explore the built-in databases
Solution: Explore the built-in databases
3. Creating and Changing Tables
Creating a database
Exploring table creation with SHOW CREATE TABLE
Creating and altering a table with CREATE and ALTER
Reading from a table with SELECT
Adding data to a table with INSERT
Additional INSERT methods
Modifying data in a table with UPDATE
Additional UPDATE methods
Removing rows from a table with DELETE and TRUNCATE
Challenge: Build the address book database
Solution: Build the address book database
4. More Advanced Querying
Basic functions
Date and number functions
String functions
Comparing strings and numbers with operators
Arranging items with GROUP BY clauses
Sorting results
Challenge: Using date and string functions
Solution: Using date and string functions
5. Inserting and Replacing Records
Updating values if they already exist with INSERT...ON DUPLICATE KEY UPDATE
Replacing information with the REPLACE statement
Ignoring values if they already exist with INSERT IGNORE
Challenge: Adding new information, even if it already exists
Solution: Adding new information, even if it already exists
6. Joining Tables
Joining tables with matching fields using INNER JOIN
Joining tables regardless of matching data using OUTER JOIN
Challenge: Creating reports with JOIN
Solution: Creating reports with JOIN
Conclusion
Next steps

Download File Size:314.61 MB

---