Author
Released
3/31/2014- Exploring MySQL data types
- Creating a database
- Creating tables
- Reading and adding data
- Using date and number functions
- Sorting results
- Inserting and replacing records
- Joining tables
Skill Level Beginner
Duration
Views
- [Voiceover] Hi there, I'm Sheeri Cabral. Welcome to Up and Running with MySQL. MySQL is the world's most popular open source database and powers many different types of applications, from a tiny blog to web giants like Facebook, Twitter and Etsy. The goal of this course is to get you interacting with data in MySQL. We'll take a look at some general topics like why databases are better than spreadsheets for many purposes and then we'll explore the databases that come with the MySQL installation. We'll take a look at creating and modifying a database as well as how to read data back out.
I'll explain terms and acronyms that you're likely to come across and, in a series of challenges, I'll ask you to work with entering and retrieving information yourself. This course focuses on working with databases at the command line, not database server administration or installation. Now, let's get up and running with MySQL development.
-
Introduction
-
Welcome55s
-
-
1. Database Basics
-
Databases vs. spreadsheets4m 55s
-
Normalizing databases7m 5s
-
-
2. MySQL Basics
-
NULL values5m 44s
-
3. Creating and Changing Tables
-
Creating a database5m 20s
-
Additional INSERT methods5m 49s
-
Additional UPDATE methods4m 44s
-
-
4. More Advanced Querying
-
Basic functions4m 30s
-
String functions5m 33s
-
Sorting results3m 53s
-
-
5. Inserting and Replacing Records
-
6. Joining Tables
-
Conclusion
-
Next steps36s
-
- Mark as unwatched
- Mark all as unwatched
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.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Welcome