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�
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!

Menu