COURSE DESCRIPTION
MySQL is an open source relational database management system (RDBMS) based on Structured Query Language (SQL), is developed, distributed, and supported by Oracle Corporation. A database is a structured collection of data. In this course, we will walk you through this (MySQL) RDBMS and your database management skills will be better for it.
CERTIFICATION
On completion.
LEARNING OUTCOME
- Understand how to Create Database
- Understand the Rule of SQL Statement
- Understand SQL Key Words
- Sorting and Filtering
- Understand how Search Engine Works
- Understand Functions
- Understand how to Join Table
- And Many More…
Course Features
- Lectures 33
- Quizzes 0
- Duration
- Skill level All levels
- Language English
- Students 16
- Assessments Yes
-
MySQL Database
- MySQL Database – 1 – Introduction to Databases
- MySQL Database – 2 – Getting a MySQL Server
- MySQL Database – 3 – Creating a Database
- MySQL Database – 4 – SHOW and SELECT
- MySQL Database – 5 – Basic Rules for SQL Statements
- MySQL Database – 6 – Getting Multiple Columns
- MySQL Database – 7 – DISTINCT and LIMIT
- MySQL Database – 8 – Sorting Results
- MySQL Database – 9 – Sort Direction
- MySQL Database – 10 – Basic Data Filtering and WHERE
- MySQL Database – 11 – Advanced Filtering Using AND and OR
- MySQL Database – 12 – Are you IN or are you NOT IN?
- MySQL Database – 13 – How Search Engines Work
- MySQL Database – 14 – More on Wildcards
- MySQL Database – 15 – Regular Expressions
- MySQL Database – 16 – Creating Custom Columns
- MySQL Database – 17 – Functions
- MySQL Database – 18 – More on Aggregate Functions
- MySQL Database – 19 – GROUP BY
- MySQL Database – 20 – Subqueries
- MySQL Database – 21 – Another Subquery Example
- MySQL Database – 22 – How to Join Tables
- MySQL Database – 23 – Outer Joins
- MySQL Database – 24 – UNION
- MySQL Database – 25 – Full-Text Searching
- MySQL Database – 26 – INSERT INTO
- MySQL Database – 27 – How to Insert Multiple Rows
- MySQL Database – 28 – UPDATE & DELETE
- MySQL Database – 29 – CREATE TABLE
- MySQL Database – 30 – NOT NULL & AUTO INCREMENT
- MySQL Database – 31 – ALTER / DROP / RENAME TABLE
- MySQL Database – 32 – Views
- MySQL Database – 33 – Final Video!