Introduction to MySQL Database
4.9 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
148 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Introduction to MySQL Database to your Wishlist.

Add to Wishlist

Introduction to MySQL Database

Learn the basics of MySQL Database management system
4.9 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
148 students enrolled
Created by Skill Tree
Last updated 7/2016
English
Current price: $10 Original price: $65 Discount: 85% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Setup MySQL Database
  • Install and use MySQL Workbench
  • Write simple MySQL Queries
  • Filter records from MySQL Database
  • Sort records returned from MySQL Database
  • Eliminate duplicate records with MySQL DISTINCT
  • Specify multiple values using MySQL IN Operator
  • Search data patterns using LIKE Operator
  • Combine results of multiple MySQL queries
View Curriculum
Requirements
  • Basic knowledge of using a computer
  • Basic knowledge of how to navigate the internet
Description

MySQL is a very popular reliable salable and free open source relational database management system owned by Oracle.There is a commercial licensed version of MySQL that can be purchased which comes with premium support. This is the version most widely used by notable companies.

The following are some notable users of MySQL:

  • US Navy
  • Nasa
  • WhiteHouse
  • Youtube
  • Square
  • Netflix
  • Sony
  • Uber
  • Zappos
  • Facebook
  • LinkedIn
  • Pinterest

This is a  basic beginners introductory course suitable for  anyone who wants to learn about MySQL. The course is a video based and taught at a place that anyone can understand and follow along.
At the end of this course you will be familiar with MySQL database and be able to write simple queries to retrieve data from a MySQL databases. You will also be able to filter and sort records obtained from a MySQL database.
This course is a practical hands on and should be  easy to follow along with me as I write some basic MySQL queries  statements. At the end of this basic 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 MySQL
  • How to write your own basic MySQL SELECT Statement
  • What are Database Concepts
  • How to use MySQL Workbench
  • How to Filter records from a query with WHERE clause
  • How to sort records from a query with ORDER BY clause
  • How to specify multiple values 
  • How to search data pattern using LIKE operator
  • How to avoid duplicate records with MySQL DISTINCT

Welcome to the course :-)

Who is the target audience?
  • SQL Aspiring developers
  • Anyone who wants to learn something new
  • Aspiring Database Administrators
  • Anyone who wants to learn about databases
Students Who Viewed This Course Also Viewed
Curriculum For This Course
14 Lectures
01:45:30
+
Introduction and Database Setup
5 Lectures 30:26



MySQL Workbench Tool
06:14

Database Concepts
04:57
+
Querying MySQL Database
9 Lectures 01:15:04
Getting data from MySQL Database with SELECT query
09:52

Filtering Data with MySQL WHERE clause
08:32

Sorting Data with MySQL ORDER BY clause
09:14

Avoiding duplicates with MySQL DISTINCT
06:48

Specify multiple values with MySQL IN operator
08:38

Retrieve values within a range with MySQL BETWEEN Operator
06:38

Search for data pattern with MySQL LIKE Operator
10:59

Combine results of multiple queries with MySQL UNION operators
08:05

Limit number of records returned with MySQL LIMIT
06:18
About the Instructor
Skill Tree
4.2 Average rating
290 Reviews
7,684 Students
19 Courses
Skill based learning

We are experienced company that provides quality video based training .
Our courses are easy to follow and understand and will take you from
an absolute beginner with no technical skills to being efficient and confident with various technical skill like SQL and databases.
We have worked with companies of various sizes and provided consultancy services at various levels.
Thank you for learning with us and we hope your experience will be pleasant.