Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

MYSQL Console (Command Line) For Beginners

Peter Fisher, Web development teacher and consultant

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
18 Videos (1h 34m)
    • Introduction to the MYSQL console (Command Line)

      3:18
    • MYSQL Console Tutorial 1 Basics

      7:00
    • MYSQL Console Tutorial 2 Dropping tables

      2:43
    • MYSQL Console Tutorial 3 Dropping Databases

      2:03
    • MYSQL Console Tutorial 4 Create a database and table

      9:54
    • MYSQL Console Tutorial 5 How to change null fields in a table schema

      4:29
    • MYSQL Console Tutorial 6 Renaming and changing table columns

      5:41
    • How to change default fields in a table schema

      5:06
    • How to change the extra value in a table schema

      5:30
    • How to insert records into a MYSQL table

      10:09
    • How to select records from a MYSQL table

      5:45
    • How to update records in a MYSQL table

      6:45
    • How to use aliases in a MYSQL query

      5:19
    • How to use the CONCAT function in MYSQL

      5:17
    • How to use the UPPER function in MYSQL

      3:26
    • How to use the LOWER function in MYSQL

      3:48
    • How to use the CONCAT WS function in MYSQL

      4:24
    • How to use the ASCII function in MYSQL

      3:49

About This Class

This is a beginners course in the MYSQL console. The course covers the basics of constructing a MYSQL query so no prior knowledge of MYSQL is needed for this course.

We will be focusing on using the MYSQL console and it is recommended that you are familiar with the command line.

Even though this course is based on the command line you can use many kinds of operating systems to access the MYSQL console.  This includes Mac Os, Linux and Windows command line interfaces

Practical Hands On Approach

My approach with this course is very similar to my other courses and that is to offer practical real world examples of the subject. Each lesson will be based around a challenge which we will accomplish together in easy to follow steps.

Why Should I Learn The MYSQL Console?

The MYSQL database is extremely popular as a data store for many web applications. It is therefore important to understand how to manage MYSQL databases quickly and efficiently.

You could use GUI tools like PHPMyadmin or the MYSQL Workbench to administer a MYSQL database but you will never be as quick as directly accessing the database via the command line. Using the MYSQL console you can create, delete, query and analyse databases far more efficiently than some graphical tools. 

This course will help you develop as a database administrator and as a web developer.

1

Student

--

Projects

0

Reviews (0)

Peter Fisher

Web development teacher and consultant

Hello,

My name is Peter Fisher. I am a freelance web and mobile developer from the UK.

I am the host of the How To Code Well YouTube channel where I talk about web development and have lots of coding tutorials on programming and web development skills.

I have nearly 2 decades of web development experience working with at web hosting companies, digital agencies and scientific publication companies.

Come and learn web development or brush up on your programm...

See full profile