Introduction to MySQL Database

Introduction to MySQL Database, available at $34.99, has an average rating of 4.1, with 19 lectures, based on 17 reviews, and has 189 subscribers.

You will learn about 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 This course is ideal for individuals who are SQL Aspiring developers or Anyone who wants to learn something new or Aspiring Database Administrators or Anyone who wants to learn about databases It is particularly useful for SQL Aspiring developers or Anyone who wants to learn something new or Aspiring Database Administrators or Anyone who wants to learn about databases.

Enroll now: Introduction to MySQL Database

Summary

Title: Introduction to MySQL Database

Price: $34.99

Average Rating: 4.1

Number of Lectures: 19

Number of Published Lectures: 19

Number of Curriculum Items: 19

Number of Published Curriculum Objects: 19

Original Price: $54.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

SQL Aspiring developers

Anyone who wants to learn something new

Aspiring Database Administrators

Anyone who wants to learn about databases

Target Audiences

SQL Aspiring developers

Anyone who wants to learn something new

Aspiring Database Administrators

Anyone who wants to learn about databases

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锟?/li>

How to search data pattern using LIKE operator

How to avoid duplicate records with MySQL DISTINCT

Welcome to the course 馃檪

Course Curriculum

Chapter 1: Introduction and Database Setup

Lecture 1: Introduction

Lecture 2: What is MySQL

Lecture 3: Installing MySQL Database

Lecture 4: MySQL Workbench Tool

Lecture 5: Database Concepts

Chapter 2: Querying MySQL Database

Lecture 1: Getting data from MySQL Database with SELECT query

Lecture 2: Filtering Data with MySQL WHERE clause

Lecture 3: Sorting Data with MySQL ORDER BY clause

Lecture 4: Avoiding duplicates with MySQL DISTINCT

Lecture 5: Specify multiple values with MySQL IN operator

Lecture 6: Retrieve values within a range with MySQL BETWEEN Operator

Lecture 7: Search for data pattern with MySQL LIKE Operator

Lecture 8: Combine results of multiple queries with MySQL UNION operators

Lecture 9: Limit number of records returned with MySQL LIMIT

Lecture 10: Thank You

Chapter 3: Data Modeling

Lecture 1: Introduction

Lecture 2: Creating a model : part 1

Lecture 3: Creating a model : part 2

Lecture 4: Basic Modeling

Instructors

Skill Tree
Skill based learning

Rating Distribution

1 stars: 0 votes

2 stars: 2 votes

3 stars: 3 votes

4 stars: 6 votes

5 stars: 6 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!