Relationships 
Relationships
by CalebTheVideoMaker2
◀ ← Video Lecture 3 of 67 → ▶
Not yet rated
Views: 722
Date Added: August 11, 2016

Lecture Description

This video lecture, part of the series MySQL Tutorial Series with Caleb by Prof. , does not currently have a detailed description and video lecture title. If you have watched this lecture and know what it is about, particularly what Web Development topics are discussed, please help us by commenting on this video with your suggested description and title. Many thanks from,

- The CosmoLearning Team

Course Index

  1. What is MySQL
  2. How Data is Organized and Normalization
  3. Relationships
  4. Keys
  5. String Data Types
  6. Numeric Data Types
  7. Date and Time Data Types
  8. Column Features and Extra Settings
  9. Indexes
  10. Quotes and Escaping Special Characters
  11. How to Build a Database (MySQL in English)
  12. Altering Data and More Advanced Queries (MySQL in English)
  13. Joins (MySQL in English)
  14. How to Install XAMPP and start Using PhpMyAdmin
  15. How to Define Your Database Structure
  16. Programming Our Database
  17. Comments, Semi Colons, Deleting or Dropping Tables
  18. How to add Columns and Drop (Delete) Columns in MySQL
  19. How to Insert and Update Data in a Table Using SQL
  20. How to use the Insert and Select Commands
  21. How to use the Show Command
  22. How to do Alter Commands
  23. How to be Consistent with MySQL
  24. How to use a Where Clause and Select Statements
  25. How to use an Order by Clause
  26. How to use a Limit Clause
  27. How to Update Columns
  28. How to Delete Data
  29. Introduction to Character Sets and Collations
  30. How to Set Character Sets and Collations
  31. How to Search your Database using Like and Wildcards
  32. Introduction to MySQL Storage Engines
  33. How to Set and Alter Your Storage Engines
  34. Comparison Operators
  35. Foreign Key Constraints for the InnoDB Storage Engine
  36. Introduction to Joins
  37. Inner Joins
  38. Left Joins
  39. How to do an Inner Join and Useful Tips
  40. How to do Left Joins (Outer Joins) and Unions
  41. What is a Function? Introduction to Functions
  42. Aliases
  43. How to use Aliases with your Joins and Functions
  44. String Functions PART 1!
  45. String Functions PART 2!
  46. How to Use Math Operators
  47. Numeric Functions PART 1!
  48. Numeric Functions PART 2!
  49. Date and Time Functions
  50. Formatting the Date
  51. What is Encryption?
  52. How to Encrypt Databases with 1-Way Encryption
  53. How to Encrypt Data with 2-Way Encryption
  54. Normalizing a Bank System
  55. Data Types of a Bank System
  56. Indexes and Foreign Key Constraints for our Bank System
  57. Programming Our Bank System with phpMyAdmin
  58. Aggregate Grouping Functions and How They Work!
  59. Keyword Distinct
  60. Group By
  61. How to use Aggregate Functions
  62. Comparison Functions
  63. If Function
  64. Case Operator
  65. Full Text Search Index
  66. In Boolean Mode
  67. How to Organize In Boolean Mode FINAL VIDEO!

Course Description

This series is an introductory course to MySQL Database Programming. This is an awesome series that explains concepts in real life and shows examples on the computer. After this series you will have all of the skills that you need to start programming your own databases.

Comments

There are no comments. Be the first to post one.
  Post comment as a guest user.
Click to login or register:
Your name:
Your email:
(will not appear)
Your comment:
(max. 1000 characters)
Are you human? (Sorry)