We hope you enjoyed the free lessons above. To view the complete contents including the chapters below, please purchase the CD. Alternatively you can sign up to the Online University and gain full, instant access to this, and all 450+ tutorials for only $30/£15 per month by clicking here CLICK HERE TO BUY THIS TUTORIAL ON CD
Operators in MySQL Arithmetic Operators
Numeric Comparison Operators
String Comparison Operators
Logical Operators
Bitwise Operators
Regular Expressions - Tuition 1
Regular Expressions - Tuition 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
Sign up to the Online University and view over 400 titles for only $30/£15 per month
BENEFITS: 1 Minimum Sign Up: ONLY ONE MONTH! - Cancel at any Time 2 Unlimited Viewing 3 Downloadable Working Files 4 Learn from Expert Authors 5 View on any Computer in the World 6 Works on PC and Mac 7 Full Support Offered 8 450+ Courses for a Low Monthly Fee 9 New Titles Added Weekly 10 A Truely Professional Study Guide
UK & Europe
Marrutt Ltd
Bellbrook Industrial Estate
Uckfield, East Sussex, TN22 1QL
United Kingdom
UK Tel: +44 (0) 1825 764057
UK Fax: +44 (0)1825 768841
US & Canada
Marrutt Ltd
1133 Broadway, Suite 706
New York, NY 10010
United States
US Tel: 646-736-7932
US Fax: 646-895-7649