Last updated 6/2021
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 357.76 MB | Duration: 1h 46m
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
Homepage
https://www.udemy.com/course/mysql-for-beginners-k/