Up and Running with MySQL Development

with Sheeri Cabral
please wait ...
Up and Running with MySQL Development
Video duration: 0s 2h 57m Beginner

Viewers:

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.

Topics include:
  • 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
Subject:
Developer
Software:
MySQL
Author:

Welcome

- [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.

please wait ...