Create a database from MySQL command line interface
Create a table from MySQL command line client
Add records into a table using MySQL Command line client
Alter table structure using MySQL Command line client
Update existing database records using MySQL Command line client
Delete records inside a database using MySQL Command line client
Query and retrieve data from database using MySQL Command line client
2 sections • 19 lectures • 1h 32m total length
7 lectures • 44minSetting Up Database Environment
What is MySQL Workbench
Basic Database Concepts
What is a Schema
12 lectures • 48minUsing MySQL Command Line Tool To Perform Essential SQL Operations
Basic MySQL Commands
Show existing databases
Show existing tables
Create a new database
Create a new table
Add some records into table
Query and retrieve records from database
Display table structure
Change table structure
Drop a column
Update existing records
Delete records from database
Access to a computer and internet required.
SQL ( Structured Query Language) is used to query and interact with various types of database systems. Most applications we interact with daily has a database component which SQL can query and manipulate.
In this course we will use MySQL which is a relational database management system that comes with some sample database when installed.
We will perform the essential operations that occur frequently on any database system using the MySQL Client Tool which is a command line interface utility.
The most essential operations on any database system is called CRUD
Create | Read | Update | Delete
You will learn how to create database and table ; also how to insert some data into the table ,update records and the delete records.