Database Design and MySQL

Database Design, MySQL Fundamentals and more advanced programming concepts. Learn how to program banks, libraries, etc.

Created byCaleb Curry

Last updated 3/2015

English

What you'll learn

By the end of the course, you will be able to Design a database, Build a database and Upkeep a database.
Manage Data in a organized, non-redundant, speedy method.
You will be able to recognize potential Database faults that could lead to disaster and fix them through Foreign Key Constrains, proper MySQL Datatypes, storage engines, and more.
You will understand the back end of a website in areas such as retrieving data from users and data encryption.
You will have an awesome skill to add to any Résumé.
Much more.

Course content

3 sections • 100 lectures • 10h 11m total length

What is a Database?6:52
Introduction1:11
Basic Terms9:32
Advanced Terms8:28
Primary Key2:27
Foreign Key3:47
Relationships2:41
1 to 1 Relationships4:39
1 to Many Relationships1:38
Many to Many relationships1:45
Why Many to Many relationships can be bad7:16
Designing relationships5:47
1nf (First Normal Form)6:06
2nf (Second Normal Form)5:19
3nf (Third Normal Form)5:12
Starting the Design and Normalization6:40
MySQL Workbench2:44
Building Our Database and 1nf8:13
Designing a Library for Books7:29
Building a Library for Books Pt1 - Following the Forms5:29
Building a Library for Books Pt25:34
Building a Library for Books pt3 and 2nf pt24:49
Building a Library for Books pt4 and 2nf/3nf5:24
Building a Library for Books Pt5 - Finishing the Database7:55
Concluding Lecture: Where to go from Here. Final Video!6:13

What is MySQL?9:31
How Data is Organized and Normalization6:31
Relationships4:25
Keys5:37
String Datatypes9:14
Numeric Datatypes7:02
Date and Time Datatypes6:40
Explore date and time datatypes in MySQL, including date, time, and timestamp with fractional seconds and epoch milliseconds since 1970.
Column Features and Extra Settings7:55
Explore column features in MySQL, including signed versus unsigned values, not null constraints, auto increment keys, default values, and zero fill to preserve leading zeros.
Indexes7:10
Quotes and Escaping Special Characters9:00
How to Build a Database10:08
Altering Data and More Advanced Queries7:00
Joins (MySQL in English)4:53
How to install XAMPP and start Using PhpMyAdmin5:10
How to Define Your Database Structure2:32
Programming Our Database9:49
Comments, Semi Colons, Deleting or Dropping Tables7:38
How to add Columns and Drop(Delete) Columns5:22
How to Insert and Update Data in a Table Using SQL9:01
How to use the Insert and Select Commands7:08
How to do Show Commands3:25
How to do Alter Commands5:02
How to be Consistent with MySQL7:22
How to use a Where Clause and Select Statement8:52
How to use an Order by Clause4:44
How to use a Limit Clause4:49
How to Properly Update Columns5:04
How to Delete Data4:04
Learn to delete data in MySQL by using delete from table with a where clause to target specific rows, apply a limit for safety, and beware drop table risks.
Introduction to Character Sets and Collations6:21
How to search your Database using Like and Wildcards6:57
Introduction to MySQL Storage Engines4:56
How to Set and Alter Your Storage Engine4:57
Comparison Operators7:00
Foreign Key Constraints for the InnoDB Storage Engine10:09
Introduction to Joins7:38
Inner Joins6:17
Left Joins6:36
How to do an Inner Join and Useful Tips7:47
How to do Left Joins (outer joins) and Unions6:50
What is a Function? Introduction to Functions6:58
Aliases4:20
How to use Aliases with Joins and Functions7:10
String Functions PART 1!7:52
String Functions PART 2!8:32
How to Use Math Operators4:59
Numeric Functions PART 1!6:34
Numeric Functions PART 26:00
Date and Time Functions8:35
Formatting the Date7:01
What is Encryption?6:38
How to Encrypt Databases with 1-Way Encryption4:48
How to Encrypt Data with 2-Way Encryption5:47
Normalizing a Bank System4:29
Datatypes of a Bank System8:11
Indexes and Foreign Key Constraints for our Bank System6:23
Programming Our Bank System with phpMyAdmin8:03
Aggregate Grouping Functions and how they work!7:22
Keyword Distinct5:30
Group By7:27
How to use Aggregate Functions7:41
Comparison Functions5:29
if Function4:56
Case Operator4:18
Full Text Search Index5:00
In Boolean Mode7:23
Concluding Lecture: Final Video! How to Organize In Boolean Mode!5:38

Requirements

No prerequisite knowledge is required, besides basic understanding of the English language and beginner computer knowledge (seriously, we're talking very basic).
We download PhpMyAdmin (free) in this course, but once it is installed you will not need an internet connection to practice your databasing. Each step is shown,

Description

This course is offered to allow for download and anytime use as well as for anybody who wishes to support my YouTube channel.

About this course:

This is an introductory course that dives into the basics of many topics in databasing, including:

Database Design

Datatypes

Inserting and manipulating data

Joins

Character sets and collations

Storage engines

functions

and much more.

This master course has 3 sub-courses with a total of over 100 videos teaching the absolute basics, intermediate topics, and the start of many advanced databasing concepts that will have you programming databases in no time.

Who this course is for:

This course will work for any beginner who has never worked with databases or spreadsheets.
This course is perfect for those with a small skill set in computers, but need assistance in fully grasping technical aspects of data management.
This course is perfect for those in almost any databasing course in college.
This course will work for tech geeks who need some refreshers or a broader view of database technology.

Database Design and MySQL

What you'll learn

Explore related topics

Course content

Database Design and Normalization25 lectures • 2hr 13min

MySQL Datatypes9 lectures • 45min

Complete MySQL Series66 lectures • 7hr 14min

Requirements

Description

Who this course is for: