Mysql Made Simple For Beginners

Learn How to use MySQL which a popular open source database to write queries to perform basic database tasks

What you'll learn
Download and Install MySQL
Have a working knowledge of MySQL Workbench
Write Syntax for MySQL SELECT Statement
Write your own basic MySQL SELECT statement
Format your MySQL Queries
Get data from a database table
Choose columns from a database table to get data
Retrieve all data from a table
Requirements
Download and Install MySQL(We'll cover that in the course)
Description
The MySQL relational database is used to store data that can be manipulated using queries. It is used a lot in web development and other areas. In this course we are only covering the basics which should enable you write your own queries to get data from a database.
MySQL is currently owned and supported by the database giant Oracle. There is a commercial licensed version of MySQL that can be purchased that comes with premium support.MySQL is a popular ,reliable and scalable relational database management system that is used by lots of companies and establishments all over the world. For example the social networking site Pinterest and The Space company Nasa just to mention a couple. In this basic beginners course, we'll introduce the concepts of relational database management systems in general, and how they relate to MySQL in particular.This is a practical hands on course where I strongly encourage you to type along with me as I write some basic MySQL queries using the SELECT statement. At the end of this short course you will have the confidence and skill to write your own MySQL basic SELECT statements.
Here is what you will learn:
How to download and Install MySQLWhat is MySQLWhat are Database Concepts What is MySQL WorkbenchHow to write syntax for SELECT StatementHow to write your own basic MySQL SELECT Statement
I look forward to welcoming you to this MySQL for beginners course.

Overview

Section 1: Getting Started

Lecture 1 Introduction

Lecture 2 What is MySQL

Lecture 3 Database Concepts

Lecture 4 Downloading and Installing MySQL

Lecture 5 What is MySQL Workbench

Lecture 6 Introduction To MySQL SELECT Statement

Section 2: MYSQL DATA MANIPULATION

Lecture 7 MySQL ORDER BY

Lecture 8 MySQL WHERE

Lecture 9 MySQL LIMIT

Lecture 10 MySQL DISTINCT

Lecture 11 MySQL IN

Lecture 12 MySQL BETWEEN Operator

Lecture 13 MySQL LIKE Operator

Lecture 14 MySQL UNION Operator

Lecture 15 Thank You

Anyone new to Databases,People ineterested in learning new things,Anyone new to MySQL