SitePoint
  • Premium
  • Library
  • Community
  • Jobs
  • Blog
LoginStart Free Trial

The home for developers

Track your course progress, manage projects, and find your dream job - all in one place.

Start Your Free Trial

7 Day Free Trial. Cancel Anytime.

SitePoint Premium

  • Access to 700+ courses
  • Publish articles on SitePoint
  • Daily curated jobs
  • Learning Paths
  • Discounts to dev tools
  • Library/
  • Video courses/
  • Query Faster with SQL on the Command Line
Query Faster with SQL on the Command Line

Query Faster with SQL on the Command Line

Learn to manage your database with just the command line


Course details

4.3∙15 Ratings7 reviews

Published
July 2017
Videos
6
Duration
50m
Happy students
956

Take this course

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.

Course Instructor

Dr. Richard Stibbard

Dr. Richard Stibbard

Web developer and online educator.

Course Outline

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

Reviews
4.3

14 total

5
8
1
0
0

Course details

4.3∙15 Ratings7 reviews

Published
July 2017
Videos
6
Duration
50m
Happy students
956

Take this course
SitePoint

Stuff we do

  • Premium
  • Newsletters
  • Learning paths
  • Library
  • Forums

Contact

  • Contact us
  • FAQ
  • Publish your book
  • Write an article
  • Advertise

About

  • Our Story
  • Corporate Memberships
  • Start free trial
  • Login

Connect

  • RSS
  • Facebook
  • Twitter (X)
  • Instagram

Subscribe to our newsletter

Get the freshest news and resources for developers, designers and digital creators in your inbox each week

© 2000 – 2025 SitePoint Pty. Ltd.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Terms of usePrivacy policy