Video: MySQL tutorial for beginners (intro + installation) ?


Curso: MySQL tutorial for beginners
Idioma:   Course LanguageDificuldade:  
Básico

Categorias: Desenvolvimento,

Descrição:
SQL tutorial for beginners

Progresso:

MySQL tutorial for beginners (intro + installation) ?
MySQL: How to create a DATABASE
MySQL: How to create a TABLE
MySQL: How to INSERT rows into a TABLE
MySQL: How to SELECT data from a TABLE
MySQL: How to UPDATE and DELETE data from a TABLE
MySQL: AUTOCOMMIT, COMMIT, ROLLBACK
MySQL: CURRENT_DATE() & CURRENT_TIME()
MySQL: UNIQUE constraint
MySQL: NOT NULL constraint
MySQL: CHECK constraint is easy
MySQL: DEFAULT constraint is easy
MySQL: PRIMARY KEYS are easy
MySQL: AUTO_INCREMENT is awesome
MySQL: FOREIGN KEYS are easy (kind of)
MySQL: JOINS are easy (INNER, LEFT, RIGHT)
Functions in MySQL are easy
MySQL logical operators are easy
MySQL wild cards are easy
MySQL ORDER BY clause is easy
MySQL LIMIT clause is easy
MySQL UNIONS are easy
MySQL SELF JOINS are ... ughhh
MySQL VIEWS are awesome
MySQL: INDEXES are awesome
MySQL: SUBQUERIES
MySQL: GROUP BY
MySQL: ROLLUP
MySQL: ON DELETE
MySQL: STORED PROCEDURES
MySQL: TRIGGERS