Database Design and MySQL
4.0 (328 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
24,120 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Database Design and MySQL to your Wishlist.

Add to Wishlist

Database Design and MySQL

Database Design, MySQL Fundamentals and more advanced programming concepts. Learn how to program banks, libraries, etc.
4.0 (328 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
24,120 students enrolled
Created by Caleb Curry
Last updated 3/2015
English
Price: Free
Includes:
  • 10 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
View Curriculum
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 is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
100 Lectures
10:11:26
+
Database Design and Normalization
25 Lectures 02:13:10
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
+
MySQL Datatypes
9 Lectures 44:36
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
+
Complete MySQL Series
66 Lectures 07:13:40
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
About the Instructor
Caleb Curry
4.2 Average rating
2,243 Reviews
78,718 Students
8 Courses
Educator, YouTube Partner.

My name is Caleb Curry and I have a passion for video and education. I have been creating videos for many years. I first started creating classes 5 years ago. I created some here and there over the years but it has been my primary focus for nearly a year now.
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 500 educational classes over database Design, programming, web development, and more. I have also done classes over Audio Production, social networking, Music theory, and a wide variety of interesting topics. On top if this, I continued to create my comedy videos as I have my entire life. I believe I have come a long way in such a short period of time and I would now like to offer payed classes for viewers to download or watch ad free.