1

Step 1

SQL course at CMTV youtube-channel

2

Step 2

Intro to SQL at Khan Academy

3

Step 3

SQL excercises at sql-tutorial.ru

1

Step 1

SQL course at CMTV youtube-channel

2

Step 2

Intro to SQL at Khan Academy

3

Step 3

SQL excercises at sql-tutorial.ru

23 August 2016 16 October 2016
Goal completed 7 October 2016
General

Finish SQL studies

SQL Studies

 Goal Accomplishment Criteria

Courses are finished and I'm able to make complex subqueries using JOINs

  1. SQL course at CMTV youtube-channel

    1. 1. Введение

    2. 2. О SQL

    3. 3. Установка MySQL

    4. 4. Базовые команды

    5. 5. Дружим с SELECT

    6. 6. Работа с записями

    7. 7. Норматизация (1 форма)

    8. 8. Изменяем поля - ALTER

    9. 9. Изменяем поля - строковые функции

    10. 10. CASE и ORDER BY

    11. 11. Числа. и еще о SELECT

    12. 12. Полезные фишки

    13. 13. Внешний ключ и виды связей

    14. 14. Соединения JOIN

    15. 15. Фишки и подзапросы

  2. Intro to SQL at Khan Academy

    Lessons is divided into 4 stages:

    1. SQL basics

    2. More advances SQL queries

    3. Relational queries in SQL

    4. Modifying databases with SQL

    1. 1.1 Welcome to SQL

    2. 1.2 Creating a table and inserting data

    3. 1.3 Challenge: Book list database

    4. 1.4 Querying the table

    5. 1.5 Challenge: Box office hits database

    6. 1.6 Aggregationg data

    7. 1.7 Challenge: TODO list database stats

    8. 1.7 S-Q-L or SEQUEL?

    9. 1.8 Project: Design a store database

    10. 2.1 More complex queries with AND/OR

    11. 2.2 Challenge: Caraoke song selector

    12. 2.3 Querying IN subqueries

    13. 2.4 Challenge: Playlist maker

    14. 2.5 Restricting grouped results with HAVING

    15. 2.6 Challenge: The wordiest author

    16. 2.7 Who issues SQL queries?

    17. 2.8 Calculating results with CASE

    18. 2.9 Challenge: Gradebook

    19. 2.10 Project: Data big

    20. 3.1 Splitting data into repated tables

    21. 3.2 JOINing related tables

    22. 3.3 Challenge: Bobby's Hobbies

    23. 3.4 Joining related tables with left outer joins

    24. 3.5 Challenge: Customers orders

    25. 3.6 Joining tables to themselves with self-joins

    26. 3.7 Challenge: Sequel in SQL

    27. 3.9 Combining multiple joins

    28. 3.10 Challenge: FriendBook

    29. 3.11 Project: Famous People

    30. 3.12 More efficient SQL with query planning and optimization

    31. 4.1 Using SQL to update a database

    32. 4.2 Changing rows with UPDATE and DELETE

    33. 4.3 Challenge: Dynamic documents

    34. 4.4 Altering tables after creation

    35. 4.5 Challenge: Closing alterations

    36. 4.6 Make your SQL safer

    37. 4.7 Project: App an impersonator

  3. SQL excercises at sql-tutorial.ru

  • 2629
  • 23 August 2016, 13:21
Sign up

Signup

Уже зарегистрированы?
Quick sign-up through social networks.
Sign in

Sign in.
Allowed.

Not registered yet?
 
Log in through social networks
Forgot your password?