Linux Terminal / Command Line Skills
What you'll learn
- Create a key pair.
- Transfer files from and to your computer and a remote computer.
- Manage file permissions and access.
- Organize file structure.
- Create a MySQL Database
- Create a Table in a MySQL Database
- Create a User for a MySQL Database
- Manage Privileges for a User of a MySQL Database
- Manage Backing up and Restoring a MySQL Database
Requirements
- You must have some type of command line / terminal functionality set up on your computer. This course will NOT cover enabling command line functionality. If you are a GNU/*nix user or Mac user you've already got terminal access. If you are a Windows user, it is recommended that you install something like Cygwin, but you are free to use any tool of your choosing as long as it emulates a *nix environment.
- Your account should already be set up to access the remote server. This course will NOT cover how to set up the remote server to allow you to access it.
- You should be added to the sudoers file on the remote server. Alternatively, and far less preferably, you should have root access to the remote server.
- You must have an account with elevated privileges to a MySQL server
Description
You've gotten a new web development client and you are totally psyched!
Wait, what's that? You need to access the server through a terminal and ssh?
Have no fear! You can do it!
Don't fear the terminal! Whatever you can do through a graphical (S)FTP interface you can also do on the command line.
This course will quickly get you up to speed on all the typical commands you will use to:
- Create a key pair
- Connect to a remote computer
- Navigate the through the directory structure
- Perform file managements tasks like creating directories; copying and moving files; setting permissions on directories and files
- Create and manage databases and database users
Just follow sequentially through the lectures and all of the above and more will become clear.
Course Structure
Each command is presented in a separate lecture to make it easy to digest and easy to find again when you want to use the course like a reference guide.
Each command is fully demonstrated in a High Definition screen cast.
Satisfaction Guarantee
I personally guarantee that after you take this course you will be able to complete all the tasks you were formerly able to do only through a graphical interface. If you find that you are not able to do the things you could have otherwise done with a graphical interface, I will work one-on-one with you to help you through your challenge and will add that information to the course.
Please Note
The skills you will be learning in this course are for working in a *nix operating system environment.
Click the "Take This Course" button now and get ready to level up your command line skills!
Who this course is for:
- You are used to using a graphical interface, such as an FTP client (for example, WinSCP or Filezilla) to manage files on a remote server, but now you need to be able to use the command line to perform those same types of tasks.
- You will be accessing a server that is running some distribution of Linux. You are not working on a Windows server.
- You are looking for a basic introduction to the command line; you are not looking for a comprehensive curriculum on doing all things command line.
- You are a command line newbie; you are not already well-versed and comfortable using the command line.
- You are new to using the Command Line to perform basic management of MySQL Databases
- You had previously been doing this basic MySQL database management through a graphical user interface, such as phpMyAdmin
- This course is not for people looking to learn to: define views or stored procedures; write MySQL queries; build a MySQL server; acquire advanced MySQL skills
Course content
- Preview01:13
- Preview01:42
- Preview00:53
Instructor
![Marc Isaacson](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 3.5 Instructor Rating
- 5 Reviews
- 2,741 Students
- 1 Course
I was an AS/400 RPG application developer from 1989 - 2001. Then I pursued some other life interests, including teaching High School math, before returning to programming in 2010. I spent approximately 6 months, 7 days a week for 12 hours a day teaching myself to use the Drupal content management system prior to launching my web development business in July of 2010. Since that time I have become a highly sought after Drupal web developer. I specialize in using Drupal as a framework to build custom web applications for clients.
My "Drupal nick" is vegantriathlete.
I am both a vegan and a triathlete and successfully completed my first IronMan distance triathlon on August 2, 2015.
If there is anything you would like to know from or about me or anything you would like to tell me, please do get in touch!