Introduction to MySQL
Offered By: Great Learning via YouTube
Course Description
Overview
Today, we have data present everywhere around us in the form of text, bills, photos, videos etc. Hence, It's management has become really important. Today, we'll be discussing the basics of MySQL and we will be guiding you through the basic concepts of MySQL which will help you manage this immense data.
SQL is known as Structured Query Language. SQL is the standard language for storing, manipulating and retrieving the data in databases. We will be covering the basics of SQL through various examples. A database usually contains one or more tables and we apply different functionalities on the records of this database. We apply SQL commands or Queries on this database.
In this tutorial, we will be teaching about data manipulation, it's extraction and fetching. Through this example, we will teach you how to update, read, create, delete data in a database. We will use different techniques such as Joins and we will learn to use various other SQL functions as well. So, stay tuned and watch the video till the end.
Syllabus
Introduction.
What is SQL?.
Getting Started with MySQL.
Installing MySQL.
Data Types in MySQL.
String Data Types in MySQL.
Types of Command in MySQL: DDL.
Demo - DDL Commands on SQL.
Types of Command in MySQL: DML .
Demo - DML Commands on SQL.
Types of Command in MySQL: DQL.
Types of Command in MySQL: DCL.
Types of Command in MySQL: TCL .
Filter Records in MySQL.
Taught by
Great Learning
Related Courses
Introduction to DatabasesMeta via Coursera Web Development
Udacity Introduction to Data Science
University of Washington via Coursera Datenmanagement mit SQL
openHPI Sabermetrics 101: Introduction to Baseball Analytics
Boston University via edX