SQL Tutorial & Video Lessons

SQLStructured Query Language is a domain-specific language used in programming and designed for managing data held in a relational database management system  (RDBMS),  or for stream processing in a  relational data stream management system  (RDSMS). It is particularly useful in handling  structured data,  i.e. data incorporating relations among entities and variables. SQL offers two main advantages over older read–write  APIs  such as ISAM  or VSAM.  Firstly, it introduced the concept of accessing many records with one single command. Secondly, it eliminates the need to specify how to reach a record, e.g. with or without an  index.

Таймкоды:

  1. 00:00 – План на урок
  2. 00:50 – Виды баз данных
  3. 02:53 – О реляционных БД
  4. 03:15 – 1 нормальная форма
  5. 03:45 – 2 нормальная форма
  6. 04:50 – Связи между таблицами
  7. 06:12 – Начало работы с MySQL
  8. 06:47 – SHOW DATABASES
  9. 07:00 – CREATE DATABASE
  10. 07:16 – DROP DATABASE
  11. 07:40 – SHOW TABLES
  12. 07:55 – CREATE TABLE
  13. 08:50 – SHOW COLUMNS
  14. 10:10 – INSERT INTO
  15. 10:45 – SELECT *
  16. 11:15 – SELECT id, surname
  17. 11:40 – DISTINCT
  18. 12:10 – WHERE
  19. 12:45 – LIMIT
  20. 13:07 – AS
  21. 13:30 – ORDER BY
  22. 14:04 – ALTER TABLE
  23. 14:40 – UPDATE SET
  24. 15:30 – LIKE
  25. 16:20 – where AND OR
  26. 17:25 – BETWEEN
  27. 17:45 – DELETE
  28. 18:10 – Multiple INSERT
  29. 19:10 – Объединение таблиц \ JOINS
  30. 20:05 – INNER JOIN
  31. 21:00 – LEFT OUTER JOIN
  32. 21:15 – RIGHT OUTER JOIN
  33. 21:30 – UNION
  34. 22:04 – Агрегатные функции
  35. 23:10 – GROUP BY
ArmenianEnglish