MySQL Database

0( 0 REVIEWS )
2 STUDENTS

Contents:
Introduction to Databases – Getting a MySQL Server – Creating a Database – SHOW and SELECT – Basic Rules for SQL Statements – Getting Multiple Columns – DISTINCT and LIMIT – Sorting Results – Sort Direction – Sort Direction – Basic Data Filtering and WHERE – Advanced Filtering Using AND and OR.

Are you IN or are you NOT IN? – How Search Engines Work – More on Wildcards – Regular Expressions – Creating Custom Columns – Functions – More on Aggregate Functions – GROUP BY – Subqueries – Another Subquery Example – How to Join Tables – Outer Joins – UNION – Full-Text Searching – INSERT INTO – How to Insert Multiple Rows.

UPDATE & DELETE – CREATE TABLE – NOT NULL & AUTO INCREMENT – ALTER / DROP / RENAME TABLE – Views – Final Video!.

Course Curriculum

MySQL Database Tutorial – 1 – Introduction to Databases Details 7:32
MySQL Database Tutorial – 2 – Getting a MySQL Server Details 4:34
MySQL Database Tutorial – 3 – Creating a Database Details 9:37
MySQL Database Tutorial – 4 – SHOW and SELECT Details 6:36
MySQL Database Tutorial – 5 – Basic Rules for SQL Statements Details 4:15
MySQL Database Tutorial – 6 – Getting Multiple Columns Details 5:11
MySQL Database Tutorial – 7 – DISTINCT and LIMIT Details 5:48
MySQL Database Tutorial – 8 – Sorting Results Details 6:56
MySQL Database Tutorial – 9 – Sort Direction Details 4:18
MySQL Database Tutorial – 10 – Basic Data Filtering and WHERE Details 4:56
MySQL Database Tutorial – 11 – Advanced Filtering Using AND and OR Details 6:59
MySQL Database Tutorial – 12 – Are you IN or are you NOT IN? Details 6:17
MySQL Database Tutorial – 13 – How Search Engines Work Details 6:27
MySQL Database Tutorial – 14 – More on Wildcards Details 3:14
MySQL Database Tutorial – 15 – Regular Expressions Details 7:33
MySQL Database Tutorial – 16 – Creating Custom Columns Details 8:44
MySQL Database Tutorial – 17 – Functions Details 6:14
MySQL Database Tutorial – 18 – More on Aggregate Functions Details 7:57
MySQL Database Tutorial – 19 – GROUP BY Details 7:20
MySQL Database Tutorial – 20 – Subqueries Details 6:9
MySQL Database Tutorial – 21 – Another Subquery Example Details 7:11
MySQL Database Tutorial – 22 – How to Join Tables Details 8:29
MySQL Database Tutorial – 23 – Outer Joins Details 8:8
MySQL Database Tutorial – 24 – UNION Details 5:22
MySQL Database Tutorial – 25 – Full-Text Searching Details 7:5
MySQL Database Tutorial – 26 – INSERT INTO Details 8:7
MySQL Database Tutorial – 27 – How to Insert Multiple Rows Details 8:41
MySQL Database Tutorial – 28 – UPDATE & DELETE Details 7:48
MySQL Database Tutorial – 29 – CREATE TABLE Details 7:5
MySQL Database Tutorial – 30 – NOT NULL & AUTO INCREMENT Details 7:7
MySQL Database Tutorial – 31 – ALTER / DROP / RENAME TABLE Details 6:5
MySQL Database Tutorial – 32 – Views Details 8:49
MySQL Database Tutorial – 33 – Final Video! Details 3:48

Course Reviews

N.A

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

No Reviews found for this course.

FreeVideoLectures.com All rights reserved.

Setup Menus in Admin Panel