Database Design and MySQL

Database Design, MySQL Fundamentals and more advanced programming concepts. Learn how to program banks, libraries, etc.
Rating: 3.9 out of 5 (1,434 ratings)
60,118 students
Database Design and MySQL
Rating: 3.9 out of 5 (1,434 ratings)
60,118 students
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.

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.
Course content
3 sections • 100 lectures • 10h 11m total length
  • What is a Database?
    06:52
  • Introduction
    01:11
  • Basic Terms
    09:32
  • Advanced Terms
    08:28
  • Primary Key
    02:27
  • Foreign Key
    03:47
  • Relationships
    02:41
  • 1 to 1 Relationships
    04:39
  • 1 to Many Relationships
    01:38
  • Many to Many relationships
    01:45
  • Why Many to Many relationships can be bad
    07:16
  • Designing relationships
    05:47
  • 1nf (First Normal Form)
    06:06
  • 2nf (Second Normal Form)
    05:19
  • 3nf (Third Normal Form)
    05:12
  • Starting the Design and Normalization
    06:40
  • MySQL Workbench
    02:44
  • Building Our Database and 1nf
    08:13
  • Designing a Library for Books
    07:29
  • Building a Library for Books Pt1 - Following the Forms
    05:29
  • Building a Library for Books Pt2
    05:34
  • Building a Library for Books pt3 and 2nf pt2
    04:49
  • Building a Library for Books pt4 and 2nf/3nf
    05:24
  • Building a Library for Books Pt5 - Finishing the Database
    07:55
  • Concluding Lecture: Where to go from Here. Final Video!
    06:13
  • Char and Varchar
    05:17
  • Text Types
    04:11
  • Enum and Set
    06:31
  • Binary, Varbinary, and Blobs
    03:43
  • Integers
    08:55
  • Decimals, Floats, and Doubles
    05:24
  • Bit, Boolean, and Serial
    04:39
  • Date, Datetime, Time, and Year
    03:47
  • Timestamp (Last Video)!
    02:09
  • What is MySQL?
    09:31
  • How Data is Organized and Normalization
    06:31
  • Relationships
    04:25
  • Keys
    05:37
  • String Datatypes
    09:14
  • Numeric Datatypes
    07:02
  • Date and Time Datatypes
    06:40
  • Column Features and Extra Settings
    07:55
  • Indexes
    07:10
  • Quotes and Escaping Special Characters
    09:00
  • How to Build a Database
    10:08
  • Altering Data and More Advanced Queries
    07:00
  • Joins (MySQL in English)
    04:53
  • How to install XAMPP and start Using PhpMyAdmin
    05:10
  • How to Define Your Database Structure
    02:32
  • Programming Our Database
    09:49
  • Comments, Semi Colons, Deleting or Dropping Tables
    07:38
  • How to add Columns and Drop(Delete) Columns
    05:22
  • How to Insert and Update Data in a Table Using SQL
    09:01
  • How to use the Insert and Select Commands
    07:08
  • How to do Show Commands
    03:25
  • How to do Alter Commands
    05:02
  • How to be Consistent with MySQL
    07:22
  • How to use a Where Clause and Select Statement
    08:52
  • How to use an Order by Clause
    04:44
  • How to use a Limit Clause
    04:49
  • How to Properly Update Columns
    05:04
  • How to Delete Data
    04:04
  • Introduction to Character Sets and Collations
    06:21
  • How to search your Database using Like and Wildcards
    06:57
  • Introduction to MySQL Storage Engines
    04:56
  • How to Set and Alter Your Storage Engine
    04:57
  • Comparison Operators
    07:00
  • Foreign Key Constraints for the InnoDB Storage Engine
    10:09
  • Introduction to Joins
    07:38
  • Inner Joins
    06:17
  • Left Joins
    06:36
  • How to do an Inner Join and Useful Tips
    07:47
  • How to do Left Joins (outer joins) and Unions
    06:50
  • What is a Function? Introduction to Functions
    06:58
  • Aliases
    04:20
  • How to use Aliases with Joins and Functions
    07:10
  • String Functions PART 1!
    07:52
  • String Functions PART 2!
    08:32
  • How to Use Math Operators
    04:59
  • Numeric Functions PART 1!
    06:34
  • Numeric Functions PART 2
    06:00
  • Date and Time Functions
    08:35
  • Formatting the Date
    07:01
  • What is Encryption?
    06:38
  • How to Encrypt Databases with 1-Way Encryption
    04:48
  • How to Encrypt Data with 2-Way Encryption
    05:47
  • Normalizing a Bank System
    04:29
  • Datatypes of a Bank System
    08:11
  • Indexes and Foreign Key Constraints for our Bank System
    06:23
  • Programming Our Bank System with phpMyAdmin
    08:03
  • Aggregate Grouping Functions and how they work!
    07:22
  • Keyword Distinct
    05:30
  • Group By
    07:27
  • How to use Aggregate Functions
    07:41
  • Comparison Functions
    05:29
  • if Function
    04:56
  • Case Operator
    04:18
  • Full Text Search Index
    05:00
  • In Boolean Mode
    07:23
  • Concluding Lecture: Final Video! How to Organize In Boolean Mode!
    05:38

Instructor
Educator, YouTube Partner.
Caleb Curry
  • 4.2 Instructor Rating
  • 7,719 Reviews
  • 210,443 Students
  • 9 Courses

Hi! I'm Caleb. I have created over 1,500 tutorials on data, software development, cryptocurrency, etc. I believe that the way I teach is what matters. I don’t flash big words without explaining them and I don’t assume knowledge.

I keep it simple

My goal is to simplify complex problems for anyone to understand. I'm not your typical "teachers who can create an entire course without actually explaining anything.

I keep it detailed

I also like to be thorough. If you watch my content and don’t leave with a new understanding, then I am not doing my job.


I keep it fun

My primary goal is not to put you to sleep as I read an encyclopedia from slides (I prefer dictionaries). Actually, I kinda hate Powerpoint. My unique approach has caused my videos to be watched 91 years (that’s 800K hours of watchtime on YouTube alone).


I am now a tech trainer with this resume:

170k+ YouTube subscribers

180k+ Udemy students

Ex-IBMer and Ex-Software Engineer

O’reilly Live trainer and course author

International speaker on data and Software Development

10 years of coding experience


I love teaching, and I’m beyond excited to have you join me in the learning process.

~~~~~~~~~~~

June 4th, 2012.  I decided to take my skill set to the next level and learn how to professionally program databases as well as websites.  After just graduating my Junior year of high school, I did not have a typical summer vacation.  Rather, I studied daily and prepared for this new goal of mine.  By July 23rd, I uploaded my first class in this new mindset of determination.  Since then, I have created over 1,500 educational classes over database Design, programming, web development, and more.