Setup Menus in Admin Panel

MySQL Database for Beginners

194 STUDENTS ENROLLED

Go from Beginner to Pro in MySQL Databases

Course Curriculum

Introduction to Databases
Introduction to Databases Details 00:08:00
Getting a MySQL Server
Getting a MySQL Server Details 00:05:00
Creating a Database
Creating a Database Details 00:10:00
SHOW and SELECT
SHOW and SELECT Details 00:06:00
Basic Rules for SQL Statements
Basic Rules for SQL Statements Details 00:04:00
Getting Multiple Columns
Getting Multiple Columns Details 00:05:00
DISTINCT and LIMIT
DISTINCT and LIMIT Details 00:06:00
Sorting Results
Sorting Results Details 00:07:00
Sort Direction
Sort Direction Details 00:04:00
Basic Data Filtering and WHERE
Basic Data Filtering and WHERE Details 00:05:00
Advanced Filtering Using AND and OR
Advanced Filtering Using AND and OR Details 00:07:00
Are you IN or are you NOT IN?
Are you IN or are you NOT IN? Details 00:06:00
How Search Engines Work
How Search Engines Work Details 00:06:00
More on Wildcards
More on Wildcards Details 00:03:00
Regular Expressions
Regular Expressions Details 00:08:00
Creating Custom Columns
Creating Custom Columns Details 00:09:00
Functions
Functions Details 00:06:00
More on Aggregate Functions Details 00:08:00
GROUP BY
GROUP BY Details 00:07:00
Subqueries
Subqueries Details 00:06:00
Another Subquery Example Details 00:07:00
How to Join Tables
How to Join Tables Details 00:09:00
Outer Joins
Outer Joins Details 00:08:00
Union
Union Details 00:05:00
Full-Text Searching
Full-Text Searching Details 00:07:00
INSERT INTO
INSERT INTO Details 00:08:00
How to Insert Multiple Rows
How to Insert Multiple Rows Details 00:09:00
UPDATE and DELETE
UPDATE and DELETE Details 00:08:00
CREATE TABLE
CREATE TABLE Details 00:07:00
NOT NULL and AUTO INCREMENT
NOT NULL and AUTO INCREMENT Details 00:07:00
ALTER / DROP / RENAME TABLE
ALTER / DROP / RENAME TABLE Details 00:06:00
Views
Views Details 00:09:00
MySQL Database (Summary)
MySQL Database (Summary) Details 00:04:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
  • FREE
  • 100 Days

Course Reviews

Abuja Centre:

Millennium Builders Plaza,
Plot 251, Herbert Macaulay Way,
Central Business District
(opposite NNPC Towers),
Abuja.
Telephone: 08032030196, 08062757345, 08072653279

Lagos Centre:

27 Obafemi Awolowo Way,

Beside Obafemi Awolowo House,

Ikeja, Lagos.
Telephone: 08161660043, 08022705992, 08072653279

Kano Centre:

Al-Usabs House,
15/17, Zaria Road,
Kano.
Telephone: 08032030202, 08032922059 08072653279.

Ibadan Centre:

Old Kingsway building (2nd floor), Oba Adebimpe Road,Opposite Radio Nigeria,Dugbe. Telephone: 08032030201, 08126157210
top