[Udemy] The Complete SQL Bootcamp (PostgreSQL) [2016, ENG]

Видео уроки, книги, учебники по языкам программирования
Торрент Сидеров Личеров Размер
torrent_5351703.torrent
0 0 1.09 ГБ
Аватара пользователя
Stepan
Администратор
Сообщения: 52267
Зарегистрирован: 05 ноя 2011, 20:36

[Udemy] The Complete SQL Bootcamp (PostgreSQL) [2016, ENG]

Сообщение Stepan » 25 янв 2018, 23:27

The Complete SQL Bootcamp (PostgreSQL)
Год выпуска: 2016
Производитель: Udemy
Сайт производителя: https://www.udemy.com/the-complete-sql-bootcamp/
Автор: Jose Portilla
Продолжительность: 8.5 h
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание: Learn how to use SQL quickly and effectively with this course!
You'll learn how to read and write complex queries to a database using one of the most in demand skills - PostgreSQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more.
Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in demand tech skills! In this course you'll learn quickly and receive challenges and tests along the way to improve your understanding!
Check out the free preview videos for more information!
Стань экспертом в SQL!
0 / 7
Course Introduction
1. Introduction
2:15
2. Course Curriculum Overview
1:41
3. Overview of Databases
7:37
4. Course FAQs
0:00
SQLNotes.pdf
PostgreSQL-Sample-Database.png
5. Time to get your Computer Set-Up!
0:00
6. Setting Up with pgAdmin 4
14:57
dvdrental.tar
7. Installation Notes
0:00
Раздел: 2
1 / 5
PostGreSQL Installation (Mac OS)
8. Mac OS X - Quick Note
0:00
9. Mac OS Installation
5:56
dvdrental.zip
10. Mac Sample Database Download
0:00
dvdrental.zip
Database_Schema.png
11. Mac Database Set-up
10:42
12. Review of Set-up
0:00
Раздел: 3
0 / 4
PostGreSQL Installation (Windows)
13. Windows - Quick Note
0:00
14. Windows Installation
4:07
dvdrental.zip
Database_Schema.png
15. Sample Database Download
0:00
dvdrental.zip
Database_Schema.png
16. Windows Command Line Installation Lecture
19:45
Раздел: 4
0 / 7
Databases and Tables
17. Databases and Tables Overview
1:12
18. Creating and Restoring a Database
6:21
19. Overview of Challenges!
1:36
20. Challenge: Restore a Database!
0:42
21. Restoring a Table Schema
6:13
22. Challenge: Restore a Table Schema!
0:43
23. Review of Section
0:00
Раздел: 5
0 / 16
SQL Statement Fundamentals
24. SQL Cheat Sheet
0:00
Screen Shot 2016-04-17 at 12.22.49 PM.png
25. SQL Statement Fundamentals
0:42
26. SELECT Statement
10:48
27. Challenge: SELECT task.
2:45
28. SELECT DISTINCT
5:46
29. Challenge: SELECT DISTINCT
2:05
30. SELECT WHERE
14:03
31. Challenge: SELECT WHERE
3:45
32. COUNT
5:00
33. LIMIT
2:59
34. ORDER BY
10:05
35. Challenge: ORDER BY
3:38
36. BETWEEN
8:44
37. IN
8:27
38. LIKE
10:24
39. General Challenge 1
9:54
general challenge 1.pptx
Раздел: 6
0 / 6
GROUP BY Statements
40. MIN MAX SUM and AVG
8:06
41. GROUP BY
18:10
42. Challenge:GROUP BY
12:15
43. HAVING
10:17
44. Quick Note
0:00
45. Challenge:HAVING
3:43
Раздел: 7
0 / 3
Assessment Test 1
46. Overview of Assessment Test 1
1:08
47. Assessment Test 1
0:00
48. Solutions to Assessment Test 1
0:00
Раздел: 8
0 / 8
JOINS
49. Overview of JOINS
0:00
50. AS Statement
3:37
51. Overview of Inner Join
18:52
52. Examples of Inner Joins
16:21
53. Overview of Join types
12:55
JOINS Overview 2.pptx
54. Example of Outer Joins
11:47
55. Union
6:21
56. Join Challenges
0:00
Раздел: 9
0 / 6
Advanced SQL Commands
57. Overview of Advanced SQL Commands
0:00
58. Timestamps and Extract
9:26
59. Mathematical Functions
6:37
60. String Function and Operators
7:11
61. SubQuery
15:01
62. Self-Join
14:17
Раздел: 10
0 / 3
Assessment Test 2
63. Assessment Test 2 Overview
6:36
exercises.zip
exercises.tar
64. Assessment Test 2
0:00
65. Solutions to Assessment Test 2
0:00
Раздел: 11
0 / 16
Creating Databases and Tables
66. Overview of Section
3:28
67. Data Types
7:21
68. Primary Keys and Foreign Keys
9:43
69. Resource for Create Table Code
0:00
70. Note on Constraints
0:00
71. Create Table
19:47
72. Challenge: Create Table
0:00
73. Challenge: Create Table - SOLUTION
5:50
74. Insert
15:31
75. Update
10:30
76. Delete
4:23
77. Alter Table
6:38
78. Drop Table
5:24
79. CHECK Constraint
9:48
80. NOT NULL Constraint
6:09
81. UNIQUE Constraint
4:53
Раздел: 12
0 / 2
Assessment Test 3
82. Assessment Test 3
0:00
83. Solutions to Assessment Test 3
0:00
Раздел: 13
0 / 1
Extra: Views
84. Views
8:48
Раздел: 14
0 / 3
Extra: PostGreSQL with Python
85. Overview of Python and PostgreSQL
0:00
Pgsql with Python.py
86. Psycopg2 Example Usage
10:24
Pgsql with Python.py
87. Psycopg2 Resources
0:00
Pgsql with Python.py
Раздел: 15
0 / 1
Bonus Offers
88. Bonus Offers
0:00
Thank you for taking the course!
Файлы примеров: присутствуют
Формат видео: MP4
Видео: AVC, 1920x1090, 16:9, 30fps, 600kbps
Аудио: AAC, 44.1kHz, 192kbps, stereo
У вас нет необходимых прав для просмотра вложений в этом сообщении.