MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Database Design and MySQL

Course Summary

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


  • +

    Course Syllabus

    • Database Design and Normalization
      • What is a Database?
      • Introduction
      • Basic Terms
      • Advanced Terms
      • Primary Key
      • Foreign Key
      • Relationships
      • 1 to 1 Relationships
      • 1 to Many Relationships
      • Many to Many relationships
      • Why Many to Many relationships can be bad
      • Designing relationships
      • 1nf (First Normal Form)
      • 2nf (Second Normal Form)
      • 3nf (Third Normal Form)
      • Starting the Design and Normalization
      • MySQL Workbench
      • Building Our Database and 1nf
      • Designing a Library for Books
      • Building a Library for Books Pt1 - Following the Forms
      • Building a Library for Books Pt2
      • Building a Library for Books pt3 and 2nf pt2
      • Building a Library for Books pt4 and 2nf/3nf
      • Building a Library for Books Pt5 - Finishing the Database
      • Concluding Lecture: Where to go from Here. Final Video!
    • MySQL Datatypes
      • Char and Varchar
      • Text Types
      • Enum and Set
      • Binary, Varbinary, and Blobs
      • Integers
      • Decimals, Floats, and Doubles
      • Bit, Boolean, and Serial
      • Date, Datetime, Time, and Year
      • Timestamp (Last Video)!
    • Complete MySQL Series
      • What is MySQL?
      • How Data is Organized and Normalization
      • Relationships
      • Keys
      • String Datatypes
      • Numeric Datatypes
      • Date and Time Datatypes
      • Column Features and Extra Settings
      • Indexes
      • Quotes and Escaping Special Characters
      • How to Build a Database
      • Altering Data and More Advanced Queries
      • Joins (MySQL in English)
      • How to install XAMPP and start Using PhpMyAdmin
      • How to Define Your Database Structure
      • Programming Our Database
      • Comments, Semi Colons, Deleting or Dropping Tables
      • How to add Columns and Drop(Delete) Columns
      • How to Insert and Update Data in a Table Using SQL
      • How to use the Insert and Select Commands
      • How to do Show Commands
      • How to do Alter Commands
      • How to be Consistent with MySQL
      • How to use a Where Clause and Select Statement
      • How to use an Order by Clause
      • How to use a Limit Clause
      • How to Properly Update Columns
      • How to Delete Data
      • Introduction to Character Sets and Collations
      • How to search your Database using Like and Wildcards
      • Introduction to MySQL Storage Engines
      • How to Set and Alter Your Storage Engine
      • Comparison Operators
      • Foreign Key Constraints for the InnoDB Storage Engine
      • Introduction to Joins
      • Inner Joins
      • Left Joins
      • How to do an Inner Join and Useful Tips
      • How to do Left Joins (outer joins) and Unions
      • What is a Function? Introduction to Functions
      • Aliases
      • How to use Aliases with Joins and Functions
      • String Functions PART 1!
      • String Functions PART 2!
      • How to Use Math Operators
      • Numeric Functions PART 1!
      • Numeric Functions PART 2
      • Date and Time Functions
      • Formatting the Date
      • What is Encryption?
      • How to Encrypt Databases with 1-Way Encryption
      • How to Encrypt Data with 2-Way Encryption
      • Normalizing a Bank System
      • Datatypes of a Bank System
      • Indexes and Foreign Key Constraints for our Bank System
      • Programming Our Bank System with phpMyAdmin
      • Aggregate Grouping Functions and how they work!
      • Keyword Distinct
      • Group By
      • How to use Aggregate Functions
      • Comparison Functions
      • if Function
      • Case Operator
      • Full Text Search Index
      • In Boolean Mode
      • Concluding Lecture: Final Video! How to Organize In Boolean Mode!


Course Fee:
Free

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top