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
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!
You may also like
- Learn to Fix iPhones and Start a Delivery Service
- Make Money With High Ticket Sales (Even If You're A Newbie)
- Masterclass: Start a Profitable Internet Cafe Business
- Google Analytics for Shopify: A Complete Step-by-Step Guide
- Creating Amazing Property Video (Using Your Smartphone)
- The Fundamentals of Business Intelligence (BI)
- Outsource Easier!
- Amazon SEO & Listing Optimization SECRETS to Double Sales
- Strategic Workforce Planning: A Fundamental Beginner's Guide
- Start A Start Hustle And Build A Second Income
- SPA RETAIL 101 – how to create a sales culture in your Spa?
- Beyond Upwork: How to Find Freelance Clients Outside Upwork
- How to manage event venue
- Ultimate Amazon FBA Mastery Course – Start With Any Budget
- The Gaming Youtube Masterclass
- Power BI Business User
- PMI – PgMP | 2024 Real Practice Exams (1150 Questions)
- Six Sigma: Certified Lean Six Sigma Green Belt | Accredited
- International B2B Trade Shows Management
- Project Management Guide for Human Resources (HR)