MySQL Tutorial Try for FREE
Select a tutorial category
Discounted Training Courses
Members of the VTC Online University have unlimited access to this tutorial. At the moment, you are in demo mode and only the first 3 chapters will play. But members have access to EVERY SINGLE TITLE IN OUR RANGE, i.e., over 40,000 tutorials on 400+ titles all with expert tutors. Where else can you get high quality one to one training for just $30.00 per month!
Benefits
:- 01. Unlimited viewing.
- 02. Downloadable working files.
- 03. Expert instructors.
- 04. Use at home / work or both.
- 05. Works on PC or Mac.
- 06. Telephone Tech support.
- 07. Cancel at any time.
- 08. 300+ courses for 1 low fee.
- 09. New titles added regularly.
- 10. 100% Guaranteed
Should you need any help, just call - contact details at the bottom of the page.
You are in Demo mode which only allows access to the first 3 chapters of this MySQL training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining. If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 400 professionally created video tutorials, you will be able to access the content from any location and no restrictions are placed on the amount of content you can watch, you can also cancel at any time you wish. Over 4000 hours of training for just $30.00.
Getting Started
- Welcome Demo
- What You'll Need Demo
Database Basics
- What Is A Database? Demo
- RDBMSs Demo
- Tables and Data Demo
SQL Basics
- Finding Your Way About Demo
- Creating a Database Demo
- Creating a Table Demo
- Column Types-String pt1 Demo
- Column Types-String pt2 Demo
- Column Types-Numeric pt1 Demo
- Column Types-Numeric pt2 Demo
- Retrieving Data With Search Criteria Demo
- Changing Existing Data Demo
- Altering A Table Demo
- Keys And Indexes Demo
- Basics Syntax Recap Demo
Operators in MySQL
- Arithmetic Operators
- Numeric Comparison Operators
- String Comparison Operators
- Logical Operators
- Bitwise Operators
- Regular Expressions 1
- Regular Expressions 2
- Operators Syntax Recap
Querying Your Data
- Sorting Retrieved Data
- Specifying Numbers of Results
- Joining Tables
- More On Joining Tables
- Data Aggregation
- Queries Syntax Recap
More Complex SQL
- Using Default Data
- Date And Time 1
- Date And Time 2
- ENUM column type
- SET column type
- Using Variables
- Conditional: IF()
- Complex Syntax Recap
Good Practises
- Using SQL batch files
- Data Modeling
- Normalization
- Optimizations
Security
- Users And Privileges
- More About Users And Privileges
- The 'mysql' Database
- Encryption
- Security Syntax Recap
Building A Database Application
- Planning The Structure
- Designing The Database
- Creating The Database
- Logging In And Out
- Checking Videos In And Out
- Searching For A Video
- Adding A New Title
- Signing Up A New Customer
- Hiring And Firing Employees
- Listing Debtors
If you would like to own this MySQL training title on CD, you may purchase it from our online store, because we don't have to use the same level of compression on the CDs as we do with the online, the audio and video playback is of a higher quality. For a single low payment you can buy this
After you have completed a tutorial, a
In order to view the training, you must have the latest version of QuickTime installed. Please note that the online movies have been compressed for quicker downloads, CDs and DVDs have far higher audio and video quality.