TutsPlus - SQL Essentials

Size 453.367 MB   0 seeders     Added 2012-10-19 14:41:20

To download or stream you need BitLord. Visit them at BitLord.com
Have you been wanting to learn SQL, but have not start yet? Or, maybe you know some SQL, but you need a better understanding of it. Either way, this course is just right for you. Andrew Burgess is teaching on the basic use of SQL with MySQL server and using it from PHP. So, let’s get started!


[b]Introduction 1m 46s[/b]
Introduction 1m 46s

[b]Basic SQL Usage 28m 58s[/b]
Setup 10m
Creating Database 3m 56s
Creating Tables 4m 28s
Adding Data to the Database 5m 2s
Selecting Records 5m 32s

[b]Intermediate SQL Concepts 32m 42s[/b]
Datatypes 9m 34s
Primary Keys 7m 12s
Altering Tables 7m 24s
Deleting Tables and Records 2m 48s
Updating Records 5m 44s

[b]Selecting Records 36m 56s[/b]
Where Clauses 9m 54s
Choosing a Number of Records 4m 32s
Ordering and Grouping Records 7m 30s
Subqueries and Joins 15m

[b]SQL Grab-Bag 45m 32s[/b]
Aliases 6m 14s
Foreign Keys and Relationships 8m 10s
SQL Functions 9m 34s
MySQL and PHP 11m 6s
GUIs 10m 28s

[b]Conclusion 2m 32s[/b]
Conclusion 2m 32s
Course Quiz
01-intro.mov 25.741 MB
02-setup.mov 26.762 MB
03-create-database.mov 9.991 MB
Gathering some info...

Register and log in Isohunt and see no captcha anymore!

4000 symbols left
Hash EDF84C9C0962AF641094199DCCB33538E585F652