Finish SQL studies
SQL Studies
Goal Accomplishment Criteria
Courses are finished and I'm able to make complex subqueries using JOINs
-
SQL course at CMTV youtube-channel
-
1. Введение
-
2. О SQL
-
3. Установка MySQL
-
4. Базовые команды
-
5. Дружим с SELECT
-
6. Работа с записями
-
7. Норматизация (1 форма)
-
8. Изменяем поля - ALTER
-
9. Изменяем поля - строковые функции
-
10. CASE и ORDER BY
-
11. Числа. и еще о SELECT
-
12. Полезные фишки
-
13. Внешний ключ и виды связей
-
14. Соединения JOIN
-
15. Фишки и подзапросы
-
-
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 Welcome to SQL
-
1.2 Creating a table and inserting data
-
1.3 Challenge: Book list database
-
1.4 Querying the table
-
1.5 Challenge: Box office hits database
-
1.6 Aggregationg data
-
1.7 Challenge: TODO list database stats
-
1.7 S-Q-L or SEQUEL?
-
1.8 Project: Design a store database
-
2.1 More complex queries with AND/OR
-
2.2 Challenge: Caraoke song selector
-
2.3 Querying IN subqueries
-
2.4 Challenge: Playlist maker
-
2.5 Restricting grouped results with HAVING
-
2.6 Challenge: The wordiest author
-
2.7 Who issues SQL queries?
-
2.8 Calculating results with CASE
-
2.9 Challenge: Gradebook
-
2.10 Project: Data big
-
3.1 Splitting data into repated tables
-
3.2 JOINing related tables
-
3.3 Challenge: Bobby's Hobbies
-
3.4 Joining related tables with left outer joins
-
3.5 Challenge: Customers orders
-
3.6 Joining tables to themselves with self-joins
-
3.7 Challenge: Sequel in SQL
-
3.9 Combining multiple joins
-
3.10 Challenge: FriendBook
-
3.11 Project: Famous People
-
3.12 More efficient SQL with query planning and optimization
-
4.1 Using SQL to update a database
-
4.2 Changing rows with UPDATE and DELETE
-
4.3 Challenge: Dynamic documents
-
4.4 Altering tables after creation
-
4.5 Challenge: Closing alterations
-
4.6 Make your SQL safer
-
4.7 Project: App an impersonator
-
-
SQL excercises at sql-tutorial.ru
- 2629
- 23 August 2016, 13:21
Don't miss new posts!
Subscribe for the Goal and follow through to its completion
Similar goals
-
-
-
Finish XMPP book
from RiaVlad