Norton 360 v5.0--only £24.97 when you spend £30 or more
Save ££s on Norton 360 v5.0 - 1 User 3 PC--only £24.97 when you spend £30 or more on items sold by Amazon.co.uk. Here's how (terms and conditions apply). *Offer ends 23:59 GMT on 29 February (originally due to end at 23:59 GMT on 31st December 2011 and then extended to end at 23:59 GMT on 31st January 2012)
System Requirements
Product Features
- High quality video training works on Pc or Mac
- Ideal for people that learn quicker by being shown
- Unique training method, learn any application in days
- Learn from your own desk at a pace that suits you
- Expert trainer guides you step by step
- Find answers quickly, each CD is fully indexed
- It's just like having a expert sat next to you
Product details
|
Product Description
Manufacturer's Description
Author: Joshua Mostafa
Training Duration: 8 hours
Number of Movies: 71
This MySQL training CD 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.
Tutorials included on this training CD:
Getting Started
Welcome
What You Will Need
Database Basics
What Is A Database?
RDBMSs
Tables and Data Pt 1
Tables and Data Pt 2
SQL Basics
Finding Your Way About
Creating a Database
Creating a Table
Column Types-String Pt
Column Types-String Pt
Column Types-Numeric Pt 1
Column Types-Numeric Pt 2
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 Pt 1
Regular Expressions 2 Pt 2
Operators Syntax Recap
Querying Your Data
Sorting Retrieved Data
Specifying Numbers of Results
Joining Tables Pt 1
Joining Tables Pt 2
More On Joining Tables
Data Aggregation
Queries Syntax Recap
More Complex SQL
Using Default Data
Date And Time 1 Pt 1
Date And Time 1 Pt 2
Date And Time 2
ENUM column type
SET column type Pt 1
SET column type Pt 2
Using Variables
Conditional: IF()
Complex Syntax Recap
Good Practices
Using SQL batch files Pt 1
Using SQL batch files Pt 2
Data Modeling Pt 1
Data Modeling Pt 2
Normalization Pt 1
Normalization Pt 2
Optimizations
Security
Users And Privileges
More About Users And Privileges
The mysql Database Pt 1
The mysql Database Pt 2
Encryption
Security Syntax Recap
Building A Database Application
Planning The Structure
Designing The Database Pt 1
Designing The Database Pt 2
Creating The Database Pt 1
Creating The Database Pt 2
Logging In And Out
Checking Videos In And Out Pt 1
Checking Videos In And Out Pt 2
Searching For A Video
Adding A New Title
Signing Up A New Customer
Hiring And Firing Employees Pt 1
Hiring And Firing Employees Pt 2
Listing Debtors
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
Customer Reviews
|
There are no customer reviews yet on Amazon.co.uk.
|
||||||||||||||||||||
|
Customer Discussions
|
This product's forum
Active discussions in related forums
Search Customer Discussions
|
Related forums
|
