Video TrainingOnline Video Training, video training software, video editing training, total training video, microsoft training video, corporate training videos, ...
Title: MySQL
Author: Joshua Mostafa
SKU: 33364
ISBN: 1930519745
Release Date: 2002-07-25
Price: Single User: US$ 99.95
Multi User(10): US$ 500.00
Duration: 8 hrs / 71 lessons
Compatibility: Win Vista, XP, 2000, 98SE, Mac OS X, OS 9, Linux
Work Files: Yes
- Quick and easy way to learn through a series of movies.
- No expensive classroom training courses.
- No boring hard to follow books to read.
- Learn from your own desk at a pace that suits you.
- High quality affordable training that is easy to use and follow.
- Use our unique training method, it makes learning easy no matter what your learning style.
Chapters:
1 - Getting Started
2 - Database Basics
3 - SQL Basics
4 - Operators in MySQL
5 - Querying Your Data
6 - More Complex SQL
7 - Good Practises
8 - Security
9 - Building a Database Application
Getting Started
Welcome (01:19)
What You Will Need (07:24)
Database Basics
What Is A Database? (03:2
RDBMSs (05:0
Tables and Data Pt 1 (05:5
Tables and Data Pt 2 (05:54)
SQL Basics
Finding Your Way About (05:55)
Creating a Database (02:33)
Creating a Table (04:3
Column Types-String Pt 1 (05:15)
Column Types-String Pt 2 (04:44)
Column Types-Numeric Pt 1 (08:23)
Column Types-Numeric Pt 2 (06:54)
Retrieving Data With Search Criteria (05:34)
Changing Existing Data (04:34)
Altering A Table (05:53)
Keys And Indexes (05:31)
Basics Syntax Recap (04:23)
Operators in MySQL
Arithmetic Operators (05:03)
Numeric Comparison Operators (08:07)
String Comparison Operators (05:34)
Logical Operators (08:4
Bitwise Operators (07:21)
Regular Expressions 1 (08:40)
Regular Expressions 2 Pt 1 (06:3
Regular Expressions 2 Pt 2 (05:09)
Operators Syntax Recap (04:52)
Querying Your Data
Sorting Retrieved Data (03:37)
Specifying Numbers of Results (03:04)
Joining Tables Pt 1 (05:24)
Joining Tables Pt 2 (03:36)
More On Joining Tables (07:54)
Data Aggregation (08:04)
Queries Syntax Recap (02:59)
More Complex SQL
Using Default Data (08:0
Date And Time 1 Pt 1 (05:16)
Date And Time 1 Pt 2 (04:02)
Date And Time 2 (04:54)
ENUM column type (06:4
SET column type Pt 1 (06:51)
SET column type Pt 2 (05:2
Using Variables (03:12)
Conditional: IF() (05:24)
Complex Syntax Recap (03:17)
Good Practices
Using SQL batch files Pt 1 (05:14)
Using SQL batch files Pt 2 (04:41)
Data Modeling Pt 1 (05:17)
Data Modeling Pt 2 (05:55)
Normalization Pt 1 (05:10)
Normalization Pt 2 (03:55)
Optimizations (13:31)
Security
Users And Privileges (07:30)
More About Users And Privileges (08:0
The mysql Database Pt 1 (04:36)
The mysql Database Pt 2 (04:16)
Encryption (05:42)
Security Syntax Recap (03:25)
Building A Database Application
Planning The Structure (07:12)
Designing The Database Pt 1 (05:33)
Designing The Database Pt 2 (04:4
Creating The Database Pt 1 (06:24)
Creating The Database Pt 2 (04:33)
Logging In And Out (06:3
Checking Videos In And Out Pt 1 (05:59)
Checking Videos In And Out Pt 2 (07:06)
Searching For A Video (06:26)
Adding A New Title (08:05)
Signing Up A New Customer (03:50)
Hiring And Firing Employees Pt 1 (04:45)
Hiring And Firing Employees Pt 2 (04:2
Listing Debtors (08:03)