Query Faster with SQL on the Command Line

4.3 Average Customer Rating

Learn to manage your database with just the command line

  • 6 Videos
  • 0 hours 50 minutes
  • 955 Happy Students

About the course

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.

  • 6 Videos
  • 0 hours 50 minutes
  • 955 Happy Students

Courses Outline

Lesson 1: Database on the Command Line
MySQL on the Command Line
Creating MySQL Databases and Tables From the CLI
Working with a Database on the Command Line
Working with Databases by Finding, Adding and Removing Records
Improving Your Ability to Search for and Update MySQL Records
Understanding NoSQL Databases
  • 6 Videos
  • 0 hours 50 minutes
  • 955 Happy Students