MySQL is a programming language used for creating databases. Databases run the back-end of almost every website, business, corporation, school, etc... Watch to learn about database programming with MySQL!
HELP ME! http://www.patreon.com/calebcurry
Videos Available for Download - http://www.udemy.com/calebthevideomaker2-database-and-mysql-classes/
What is MySQL?
How Data is Organized and Normalization.
Numeric Data Types
String Data Types
Date and Time Data Types
Column Features and Extra Settings
Quotes and Escaping Special Characters
Altering Data and More Advanced Queries
How to Build a Database
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
How to use the Insert and Select Commands
How to use the Show Command
How to Alter Commands
How to be Consistent with MySQL
How to use a Where Clause and Select Statements
How to use an Oder 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 Set 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 Engines
Foreign Key Constraints for the InnoDB Storage Engine
Introduction to Joins
How to do an Inner Join and Useful Tips
How to do Left Joins (Outer Joins) and Unions
Introduction to functions
String Functions Part 1
String Functions Part 2
How to Use Math Operations
Numeric Functions Part 1
Numeric Functions Part 2
How to Use Aliases with Your Joins and Functions
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
Data types of a Bank System
Indexes and Foreign Key Constraints for out Bank System
Programming Our Bank system with phpMyAdmin
Aggregate Grouping Functions and How They Work
How to use Aggregate Functions
Full Text Search Index
In Boolean Mode
How to Organize In Boolean Mode
Anything else upon request may be considered. This course is design to introduce you to many features of MySQL and teach you what they do. Did you hear that? This course will teach you features of MySQL and teach you what they do. This is to introduce you to advanced SQL but not completely overload you with information. You may or may not come out of this course being able to be a database administrator with a 6 digit income. I guarantee you though, this series will greatly help you understand the power of databasing.
Thank you again, please subscribe. I will see you all very soon.
Subscribe to my newsletter: http://eepurl.com/-8qtH
More content: http://CalebCurry.com
Amazing Web Hosting - https://www.dreamhost.com/r.cgi?1487063 (The best web hosting for a cheap price!)
Led Digital Marketing Efforts of Top 500 e-Retailers.
Worked with Top Brands at Leading Agencies.
Successfully Managed Over $50 million in Digital Ad Spend.
Developed Strategies and Processes that Enabled Brands to Grow During an Economic Downturn.
Taught Advanced Internet Marketing Strategies at the graduate level.
Your Cart 0
Manage research, learning and skills at NCR Works. Create an account using LinkedIn to manage and organize your omni-channel knowledge. NCR Works is like a shopping cart for information -- helping you to save, discuss and share.