Author - Joshua Mostafa

Total Time - 8 Hours

Getting Started
Welcome
What You'll Need

Database Basics
What Is A Database?
RDBMSs
Tables and Data

SQL Basics
Finding Your Way About
Creating a Database
Creating a Table
Column Types-String
Column Types-Numeric
Retrieving Data With Search Criteria
Changing Existing Data
Altering A Table
Keys And Indexes
Basics Syntax Recap

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

[Only Registered and Activated Users Can See Links. Click Here To Register...] ... rials_.rar

__________________
[Only Registered and Activated Users Can See Links. Click Here To Register...]