Intermediate MySQL: Create & manage databases
4.1 (181 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
20,854 students enrolled

Intermediate MySQL: Create & manage databases

Learn how to create, manage & update databases using MySQL the easy way
4.1 (181 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
20,854 students enrolled
Created by Alkas H
Last updated 7/2019
English
English [Auto-generated]
Current price: $10.99 Original price: $19.99 Discount: 45% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 3,500+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • MySQL Database Administration
  • MySQL queries
  • MySQL databases updating
  • MySQL - Learn how to filter the data
  • Learn how to create MySQL databases
Requirements
  • There are no prerequisites to this class, other than a pc/mac, and a healthy appetite for learning new things
Description

MySQL is an open source relational database management system (DBMS) that has experienced a phenomenal growth in popularity and use. Known for its speed and ease of use, MySQL has proven itself to be particularly well-suited for developing database-backed websites and applications.

MySQL runs on anything from modest hardware all the way up to enterprise servers, and its performance rivals any database system put up against it. It offers the power of a relational database in a package that's easy to set up and administer, and this course will provide all the tools you need to get started.

In this course, you'll learn methodically, systematically, and simply–in 50 short, quick lessons that will each take very less to complete.

The course is ideal for the inexperienced programmer interested in adding these skills to their toolbox. New coders who′ve made it through an online course or boot camp will also find great value in how this course builds on what you already know.

Who this course is for:
  • Any student wanting to learn about data management and MySQL programming.
Course content
Expand all 52 lectures 05:46:18
+ MySQL Database - Practice
50 lectures 05:40:23
MySQL - Setup a Package Manager
07:59
MySQL - Setup Working Environment
10:44
MySQL - Select, Keyword, Expressions and Functions
05:45
MySQL Row Selection
07:15
MySQL Column Selection
03:24
ORDER BY ASC and DESC
04:06
WHERE Clause
05:40
LIKE and IN Clauses
04:30
REGEXP and RLIKE
09:56
Using INSERT INTO to Insert Data
03:50
Using UPDATE SET to Update Data
02:56
DELETE and DROP
03:49
MySQL Strings
04:55
What is NULL
05:24
CREATE and USE DATABASE
05:22
Using Tables
09:49
Using Indexes
08:48
Using Constraints
05:17
AUTO_INCREMENT, PRIMARY KEY and SERIAL
09:12
ALTER TABLE
06:32
MySQL Data Type Introduction
05:16
Numeric Types
10:19
MySQL String Types
03:31
MySQL DATE and TIME Types
06:01
BIT
02:57
BOOLEAN Types
04:57
ENUM and SET
04:56
MySQL String Function
10:49
MySQL Numeric Functions
12:48
Date and Time Functions
08:21
MySQL Time Zone Support
03:33
DTAE_FORMAT Function
05:48
MySQL Grouping Functions
09:39
MySQL Conditional Function
08:11
MySQL - How To Use Transactions
06:37
Transactions and Performance
04:00
Using TRIGGER
06:33
Using TRIGGER Preventing Auto Update
09:39
Triggers and Transactions
05:49
How To Use Subselect and SUBSTR
10:21
MySQL - Searching Within a Result Set
09:54
How To Create VIEWs
08:29
How To Create JOIN VIEW
06:03
MySQL - Routines
02:44
MySQL Functions
08:54
MySQL Procedures
12:36
What is PDO
11:31
PDO and Prepared Statement
05:56