Query Faster with SQL on the Command Line

 12 Reviews Add a review

Published July 2017

Learn to manage your database with just the command line

Although several GUI tools exist for managing your SQL databases, there are times when using the command line is either necessary or even desired. In this course, you’ll be able to learn why command line manipulation of your databases can make working with your data quick and easy.

You’ll learn to create and edit tables as well as create, edit, and remove records. Searching for and updating records will also be on the agenda, and by the time you’re through the course, you’ll have all of the basic understanding of MySQL command line operations that you need to manage your databases without a GUI aid, that way you’ll have the knowledge if you need it — or if you just prefer command lines!

Learn more developer essentials with Git. You can pick up handy lessons in our Git Tips mini course or learn Git from scratch with our Introduction to Git course.

Oh yeah, and the whole SitePoint library! Learn More.

What you'll learn

  • SQL basics with the command line
  • Closed captions available
Meet your instructor
Dr. Richard Stibbard

Web developer and online educator.

Lesson 1: Database on the Command Line
MySQL on the Command Line 5:31
Creating MySQL Databases and Tables From the CLI 7:57
Working with a Database on the Command Line 9:05
Working with Databases by Finding, Adding and Removing Records 7:39
Improving Your Ability to Search for and Update MySQL Records 9:51
Understanding NoSQL Databases 9:58

Leave a Review