SQL Essentials

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!

Table of content

Introduction

• Introduction

Basic SQL Usage

• Setup
• Creating Database
• Creating Tables
• Adding Data to the Database
• Selecting Records

Intermediate SQL Concepts

• Datatypes
• Primary Keys
• Altering Tables
• Deleting Tables and Records
• Updating Records

Selecting Records

• Where Clauses
• Choosing a Number of Records
• Ordering and Grouping Records
• Subqueries and Joins

SQL Grab-Bag

• Aliases
• Foreign Keys and Relationships
• SQL Functions
• MySQL and PHP
• GUIs

Conclusion

• Conclusion

 Uploaded.net

1. http://ul.to/k6h2rtp0

 Cloudzer.net 

1. http://clz.to/xd8kt03b