What you'll learn

Install MySQL Database Management System
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

Requirements

Access to a computer and internet required.

Description

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.

Who this course is for:

Beginners to SQL
Beginners to MySQL

Homepage: https://www.udemy.com/sql-essentials-for-beginners-using-command-line-interface/