jueves, 5 de noviembre de 2015

The Sequel to SQL



La gente de codeschool publicaron varios cursos sobre base de datos, para la gente que quiere perfeccionar su conocimiento en sql.

Les dejo el programa:

COURSE OVERVIEW

  1. The Sequel to SQL Level 1 Badge

    LEVEL 1 FREE LEVELAggregate Functions 2 Videos | 10 Challenges

    Learn how to use SQL aggregate functions, including COUNT, SUM, and AVG, to do calculations on groups of data.
  2. The Sequel to SQL Level 2 Badge

    LEVEL 2Table Constraints 2 Videos | 11 Challenges

    Add constraints — like NOT NULL, UNIQUE, FOREIGN KEY, and PRIMARY KEY — to your tables to increase data integrity.
  3. The Sequel to SQL Level 3 Badge

    LEVEL 3Normalization and Relationships 2 Videos | 7 Challenges

    Apply normalization rules to create tables without duplicate data and build the appropriate relationships.
  4. The Sequel to SQL Level 4 Badge

    LEVEL 4Inner Joins, Aliases, and Outer Joins 3 Videos | 7 Challenges

    Explore writing a single query to pull data from multiple tables and using aliases to create succinct queries.
  5. The Sequel to SQL Level 5 Badge

    LEVEL 5Subqueries 1 Video | 3 Challenges

    Dive deeper as you learn how to write queries within queries.



Dejo link:
https://www.codeschool.com/courses/the-sequel-to-sql/