Learning SQL

In this SQL training course, expert author Guy Vaccaro teaches you how to use SQL to manage data that is held in relational databases. This training course is designed for beginners who have no previous experience with SQL of any kind.

SQL Essential Training

Whatever a database is being used for—websites, bookkeeping, sales and inventory, or even the lowly to-do list—it’s still all about the data. Completely updated for 2014, SQL Essential Training is designed to help users understand the most common language for database wrangling, SQL. Beginning with a quick start introduction for those who want to start working with data immediately, instructor Bill Weinman teaches all the major features of SQL: creating tables; defining relationships; manipulating strings, numbers, and dates; using triggers to automate actions; and working with subselects and views. He offers a solid working knowledge of the language, and shows how to retrieve and manage data efficiently. The final chapter includes a real-world example of building a simple CRUD (Create, Read, Update, and Delete) application using SQL.

Tutsplus – PostgreSQL Essentials

This course will get you up to speed on using PostgreSQL databases. We will cover the command line tools, the PGAdmin GUI tool, the unique hstore extension, and much more. By the conclusion of this course, hopefully, you’ll feel confident to kick-start your own Postgres-based projects!

SQL Big Data Convergence – The Big Picture

This course explains what Big Data, Hadoop and Massively Parallel Processing (MPP) data warehouse technologies are, and how the latter two are converging technologically. Products from Hadapt, Teradata, ParAccel, Microsoft and Cloudera — all of which integrate with Apache Hadoop — are investigated.

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!