|
MySQL Tutorials Online |
![]() |
|
Description
MySQL
Virtual Training Company's MySQL tutorial is just what you need to begin designing and developing database management systems. Joshua Mostafa will help you go from a beginner's understanding of databases and SQL to gaining mastery knowledge in only 8 hours of training. He starts the tutorial by covering the basics of databases and SQL. Once you are comfortable with the basics, move on to the more complex aspects of SQL, such as variables and security. You can start right away by simply clicking one of the movie topics below. |
01 Getting Started
0101 Welcome
0102 What You Will Need
02 Database Basics
0201 What Is A Database?
0202 RDBMSs
0203 Tables and Data Pt 1
0204 Tables and Data Pt 2
03 SQL Basics
0301 Finding Your Way About
0302 Creating a Database
0303 Creating a Table
0304 Column Types-String Pt 1
0305 Column Types-String Pt 2
0306 Column Types-Numeric Pt 1
0307 Column Types-Numeric Pt 2
0308 Retrieving Data With Search Criteria
0309 Changing Existing Data
0310 Altering A Table
0311 Keys And Indexes
0312 Basics Syntax Recap
04 Operators in MySQL
0401 Arithmetic Operators
0402 Numeric Comparison Operators
0403 String Comparison Operators
0404 Logical Operators
0405 Bitwise Operators
0406 Regular Expressions 1
0407 Regular Expressions 2 Pt 1
0408 Regular Expressions 2 Pt 2
0409 Operators Syntax Recap
05 Querying Your Data
0501 Sorting Retrieved Data
0502 Specifying Numbers of Results
0503 Joining Tables Pt 1
0504 Joining Tables Pt 2
0505 More On Joining Tables
0506 Data Aggregation
0507 Queries Syntax Recap
06 More Complex SQL
0601 Using Default Data
0602 Date And Time 1 Pt 1
0603 Date And Time 1 Pt 2
0604 Date And Time 2
0605 ENUM column type
0606 SET column type Pt 1
0607 SET column type Pt 2
0608 Using Variables
0609 Conditional: IF()
0610 Complex Syntax Recap
07 Good Practices
0701 Using SQL batch files Pt 1
0702 Using SQL batch files Pt 2
0703 Data Modeling Pt 1
0704 Data Modeling Pt 2
0705 Normalization Pt 1
0706 Normalization Pt 2
0707 Optimizations
08 Security
0801 Users And Privileges
0802 More About Users And Privileges
0803 The mysql Database Pt 1
0804 The mysql Database Pt 2
0805 Encryption
0806 Security Syntax Recap
09 Building A Database Application
0901 Planning The Structure
0902 Designing The Database Pt 1
0903 Designing The Database Pt 2
0904 Creating The Database Pt 1
0905 Creating The Database Pt 2
0906 Logging In And Out
0907 Checking Videos In And Out Pt 1
0908 Checking Videos In And Out Pt 2
0909 Searching For A Video
0910 Adding A New Title
0911 Signing Up A New Customer
0912 Hiring And Firing Employees Pt 1
0913 Hiring And Firing Employees Pt 2
0914 Listing Debtors
10 Credits
1001 About the Author
sku |
|
