1

Step 1

Transact SQL - SELECT - SELECT clause

2

Step 2

Transact SQL - SELECT

3

Step 3

Transact SQL - SELECT - FROM clause

4

Step 4

Transact SQL - SELECT - WHERE clause

5

Step 5

Transact SQL - SELECT - GROUP BY clause

6

Step 6

Transact SQL - SELECT - HAVING clause

7

Step 7

Transact SQL - SELECT - UNION

8

Step 8

Transact SQL - SELECT - ORDER Y

9

Step 9

Transact SQL - SELECT - EXCEPT & INTERSECT

10

Step 10

Transact SQL - SELECT - FOR clause

11

Step 11

Transact SQL - SELECT - OPTION clause

12

Step 12

Transact SQL - SELECT - OVER clause

1

Step 1

Transact SQL - SELECT - SELECT clause

2

Step 2

Transact SQL - SELECT

3

Step 3

Transact SQL - SELECT - FROM clause

4

Step 4

Transact SQL - SELECT - WHERE clause

5

Step 5

Transact SQL - SELECT - GROUP BY clause

6

Step 6

Transact SQL - SELECT - HAVING clause

7

Step 7

Transact SQL - SELECT - UNION

8

Step 8

Transact SQL - SELECT - ORDER Y

9

Step 9

Transact SQL - SELECT - EXCEPT & INTERSECT

10

Step 10

Transact SQL - SELECT - FOR clause

11

Step 11

Transact SQL - SELECT - OPTION clause

12

Step 12

Transact SQL - SELECT - OVER clause

05 May 2019

Goal abandoned

The author does not write in the goal 6 years 7 months 21 days

General

Learn SQL Server

Learning of MSSQL Server:

Querying, setting up, maintenance.

Official documentation is placed here:

https://docs.microsoft.com/ru-ru/sql/sql-server/sql-server-technical-documentation?view=sql-server-2017

Разделы доступны из меню, кнопка "Больше".

Например, Больше - Справочник - Справочник - Transact SQL.

Рабочий каталог d:\PROJECTS\STUDY\SQL Server 2017\

процесс: 1.5 часа в день на разбор какой-то темы из документации (запросы, администрирование, и т.д.)

 Goal Accomplishment Criteria

I passed the 70-761 Exam

  1. Transact SQL - SELECT - SELECT clause

  2. Transact SQL - SELECT

    d:\PROJECTS\STUDY\SQL Server 2017\Transact SQL - SELECT.mm

  3. Transact SQL - SELECT - FROM clause

  4. Transact SQL - SELECT - WHERE clause

  5. Transact SQL - SELECT - GROUP BY clause

  6. Transact SQL - SELECT - HAVING clause

  7. Transact SQL - SELECT - UNION

  8. Transact SQL - SELECT - ORDER Y

  9. Transact SQL - SELECT - EXCEPT & INTERSECT

  10. Transact SQL - SELECT - FOR clause

  11. Transact SQL - SELECT - OPTION clause

  12. Transact SQL - SELECT - OVER clause

  • 199
  • 05 May 2019, 06:07
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?