Calebthevideomaker2 Database And Mysql Classes

Tags: MySQL

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

Last updated 2022-01-10 | 4.3

- 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.

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.

* 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

What is a Database? Preview 06:52

Introduction Preview 01:11

Basic Terms Preview 09:32

Advanced Terms Preview 08:28

Primary Key Preview 02:27

Foreign Key Preview 03:47

Relationships Preview 02:41

1 to 1 Relationships Preview 04:39

1 to Many Relationships Preview 01:38

Many to Many relationships Preview 01:45

Why Many to Many relationships can be bad Preview 07:16

Designing relationships Preview 05:47

1nf (First Normal Form) Preview 06:06

2nf (Second Normal Form) Preview 05:19

3nf (Third Normal Form) Preview 05:12

Starting the Design and Normalization Preview 06:40

MySQL Workbench Preview 02:44

Building Our Database and 1nf Preview 08:13

Designing a Library for Books Preview 07:29

Building a Library for Books Pt1 - Following the Forms Preview 05:29

Building a Library for Books Pt2 Preview 05:34

Building a Library for Books pt3 and 2nf pt2 Preview 04:49

Building a Library for Books pt4 and 2nf/3nf Preview 05:24

Building a Library for Books Pt5 - Finishing the Database Preview 07:55

Concluding Lecture: Where to go from Here. Final Video! Preview 06:13

Char and Varchar Preview 05:17

Text Types Preview 04:11

Enum and Set Preview 06:31

Binary, Varbinary, and Blobs Preview 03:43

Integers Preview 08:55

Decimals, Floats, and Doubles Preview 05:24

Bit, Boolean, and Serial Preview 04:39

Date, Datetime, Time, and Year Preview 03:47

Timestamp (Last Video)! Preview 02:09

What is MySQL? Preview 09:31

How Data is Organized and Normalization Preview 06:31

Relationships Preview 04:25

Keys Preview 05:37

String Datatypes Preview 09:14

Numeric Datatypes Preview 07:02

Date and Time Datatypes Preview 06:40

Column Features and Extra Settings Preview 07:55

Indexes Preview 07:10

Quotes and Escaping Special Characters Preview 09:00

How to Build a Database Preview 10:08

Altering Data and More Advanced Queries Preview 07:00

Joins (MySQL in English) Preview 04:53

How to install XAMPP and start Using PhpMyAdmin Preview 05:10

How to Define Your Database Structure Preview 02:32

Programming Our Database Preview 09:49

Comments, Semi Colons, Deleting or Dropping Tables Preview 07:38

How to add Columns and Drop(Delete) Columns Preview 05:22

How to Insert and Update Data in a Table Using SQL Preview 09:01

How to use the Insert and Select Commands Preview 07:08

How to do Show Commands Preview 03:25

How to do Alter Commands Preview 05:02

How to be Consistent with MySQL Preview 07:22

How to use a Where Clause and Select Statement Preview 08:52

How to use an Order by Clause Preview 04:44

How to use a Limit Clause Preview 04:49

How to Properly Update Columns Preview 05:04

How to Delete Data Preview 04:04

Introduction to Character Sets and Collations Preview 06:21

How to search your Database using Like and Wildcards Preview 06:57

Introduction to MySQL Storage Engines Preview 04:56

How to Set and Alter Your Storage Engine Preview 04:57

Comparison Operators Preview 07:00

Foreign Key Constraints for the InnoDB Storage Engine Preview 10:09

Introduction to Joins Preview 07:38

Inner Joins Preview 06:17

Left Joins Preview 06:36

How to do an Inner Join and Useful Tips Preview 07:47

How to do Left Joins (outer joins) and Unions Preview 06:50

What is a Function? Introduction to Functions Preview 06:58

Aliases Preview 04:20

How to use Aliases with Joins and Functions Preview 07:10

String Functions PART 1! Preview 07:52

String Functions PART 2! Preview 08:32

How to Use Math Operators Preview 04:59

Numeric Functions PART 1! Preview 06:34

Numeric Functions PART 2 Preview 06:00

Date and Time Functions Preview 08:35

Formatting the Date Preview 07:01

What is Encryption? Preview 06:38

How to Encrypt Databases with 1-Way Encryption Preview 04:48

How to Encrypt Data with 2-Way Encryption Preview 05:47

Normalizing a Bank System Preview 04:29

Datatypes of a Bank System Preview 08:11

Indexes and Foreign Key Constraints for our Bank System Preview 06:23

Programming Our Bank System with phpMyAdmin Preview 08:03

Aggregate Grouping Functions and how they work! Preview 07:22

Keyword Distinct Preview 05:30

Group By Preview 07:27

How to use Aggregate Functions Preview 07:41

Comparison Functions Preview 05:29

if Function Preview 04:56

Case Operator Preview 04:18

Full Text Search Index Preview 05:00

In Boolean Mode Preview 07:23

Concluding Lecture: Final Video! How to Organize In Boolean Mode! Preview 05:38