-
Урок 1. 00:02:26Course Introduction
-
Урок 2. 00:03:10What is a Database?
-
Урок 3. 00:04:12Relational Databases and SQL
-
Урок 4. 00:05:17Installing PostgreSQL for Mac
-
Урок 5. 00:07:52Installing PostgreSQL for Windows
-
Урок 6. 00:01:17Section Introduction
-
Урок 7. 00:04:03Database Tables
-
Урок 8. 00:07:45Data Types Explained
-
Урок 9. 00:04:16Primary Keys and Foreign Keys
-
Урок 10. 00:04:29Unique, Not Null and Check Constraints
-
Урок 11. 00:09:37Creating Our First Table
-
Урок 12. 00:05:22Creating the Actors Table
-
Урок 13. 00:05:30Creating a Table with a Foreign Key
-
Урок 14. 00:06:06Creating the Movie Revenues Table
-
Урок 15. 00:04:24Creating a Junction Table
-
Урок 16. 00:07:34Modifying Tables Part 1: Adding Columns
-
Урок 17. 00:04:12Modifying Tables Part 2: Changing a Columns Data Type
-
Урок 18. 00:02:45Deleting Tables from a Database
-
Урок 19. 00:01:12Challenge: Data Definition Language
-
Урок 20. 00:06:26Solution: Data Definition Language
-
Урок 21. 00:01:02Section Summary
-
Урок 22. 00:00:41Section Introduction
-
Урок 23. 00:09:13Inserting Data into a Table
-
Урок 24. 00:07:23Updating Data in a Table
-
Урок 25. 00:03:48Deleting Data from a Table
-
Урок 26. 00:07:14Inserting Data into Our Movie Data Database
-
Урок 27. 00:01:18Challenge: Data Manipulation Language
-
Урок 28. 00:09:16Solution: Data Manipulation Language
-
Урок 29. 00:00:40Section Summary
-
Урок 30. 00:01:38Section Introduction
-
Урок 31. 00:03:10Select Queries
-
Урок 32. 00:06:06Where Clauses
-
Урок 33. 00:07:35Logical Operators
-
Урок 34. 00:01:02Challenge 1: Select Queries
-
Урок 35. 00:04:20Solution 1: Select Queries
-
Урок 36. 00:05:48In, Not In
-
Урок 37. 00:07:30Like
-
Урок 38. 00:07:33Between
-
Урок 39. 00:01:07Challenge 2: Select Queries
-
Урок 40. 00:04:55Solution 2: Select Queries
-
Урок 41. 00:08:39Order By
-
Урок 42. 00:04:40Limiting the Number of Results
-
Урок 43. 00:03:59Fetch
-
Урок 44. 00:03:51Distinct Values
-
Урок 45. 00:00:45Challenge 3: Select Queries
-
Урок 46. 00:04:02Solution 3: Select Queries
-
Урок 47. 00:05:12Null Values
-
Урок 48. 00:05:11Setting a Column Name Alias
-
Урок 49. 00:06:45Concatenation
-
Урок 50. 00:00:45Challenge 4: Select Queries
-
Урок 51. 00:04:52Solution 4: Select Queries
-
Урок 52. 00:01:12Section Summary
-
Урок 53. 00:00:57Section Introduction
-
Урок 54. 00:01:57Aggregate Functions Explained
-
Урок 55. 00:04:08Count Aggregate Functions
-
Урок 56. 00:04:01Sum Aggregate Function
-
Урок 57. 00:05:30Min and Max Aggregate Functions
-
Урок 58. 00:02:45Average Aggregate Functions
-
Урок 59. 00:01:06Challenge 1: Aggregate Functions
-
Урок 60. 00:04:24Solution 1: Aggregate Functions
-
Урок 61. 00:11:27Grouping Data
-
Урок 62. 00:04:52Having Clauses
-
Урок 63. 00:00:47Challenge 2: Aggregate Functions
-
Урок 64. 00:04:43Solution 2: Aggregate Functions
-
Урок 65. 00:07:57Mathematical Operators
-
Урок 66. 00:00:58Section Summary
-
Урок 67. 00:00:55Section Introduction
-
Урок 68. 00:01:32What Are Database Relationships?
-
Урок 69. 00:03:28One to One Relationships
-
Урок 70. 00:04:01One to Many Relationships
-
Урок 71. 00:04:36Many to Many Relationships
-
Урок 72. 00:02:28(Optional) Challenge: Database Relationships
-
Урок 73. 00:05:22Solution: Database Relationships
-
Урок 74. 00:00:42Section Summary
-
Урок 75. 00:01:10Section Introduction
-
Урок 76. 00:10:08SQL Joins Explained
-
Урок 77. 00:11:29Inner Joins Part 1
-
Урок 78. 00:05:31Inner Joins Part 2
-
Урок 79. 00:04:35Inner Joins Part 3
-
Урок 80. 00:01:09Challenge 1: Joins
-
Урок 81. 00:07:23Solution 1: Joins
-
Урок 82. 00:05:56Left Joins
-
Урок 83. 00:03:24Right Joins
-
Урок 84. 00:03:33Full Joins
-
Урок 85. 00:00:39Challenge 2: Joins
-
Урок 86. 00:05:28Solutions 2: Joins
-
Урок 87. 00:11:34Joining More Than Two Tables
-
Урок 88. 00:01:07Challenge 3: Joins
-
Урок 89. 00:08:47Solution 3: Joins
-
Урок 90. 00:06:10Union
-
Урок 91. 00:03:49Union All
-
Урок 92. 00:00:43Challenge 4: Joins
-
Урок 93. 00:04:46Solution 4: Joins
-
Урок 94. 00:03:45Intersect
-
Урок 95. 00:04:08Except
-
Урок 96. 00:00:43Challenge 5: Joins
-
Урок 97. 00:03:59Solution 5: Joins
-
Урок 98. 00:01:03Section Summary
-
Урок 99. 00:00:48Section Introduction
-
Урок 100. 00:05:04Subqueries Explained
-
Урок 101. 00:08:16Uncorrelated Subqueries Part 1
-
Урок 102. 00:06:02Uncorrelated Subqueries Part 2
-
Урок 103. 00:01:30Challenge 1: Subqueries
-
Урок 104. 00:08:55Solution 1: Subqueries
-
Урок 105. 00:07:20Correlated Subqueries
-
Урок 106. 00:01:13Challenge 2: Subqueries
-
Урок 107. 00:07:42Solution 2: Subqueries
-
Урок 108. 00:00:59Summary
-
Урок 109. 00:01:35Section Introduction
-
Урок 110. 00:04:03Cloning a Database
-
Урок 111. 00:06:20Upper and Lower String Functions
-
Урок 112. 00:04:09Initcap Function
-
Урок 113. 00:08:44Left and Right String Functions
-
Урок 114. 00:02:18Reverse Function
-
Урок 115. 00:01:20Challenge 1: String Functions
-
Урок 116. 00:11:55Solution 1: String Functions
-
Урок 117. 00:05:17Substring Function
-
Урок 118. 00:09:05Replace Function
-
Урок 119. 00:07:21Split Part Function
-
Урок 120. 00:05:41Using the Cast Operator to Apply String Functions to Non-String Data Types
-
Урок 121. 00:00:54Challenge 2: String Functions
-
Урок 122. 00:06:53Solution 2: String Functions
-
Урок 123. 00:01:05Summary
- Категории
- Источники
- Все курсы
- Разделы
- Книги
подойдет если вы давно не работали с постргес, я слушал на скорости 1.5.
https://www.valentina-db.com/en/get-free-valentina-studio