Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай SQL for Newcomers - The Full Mastery Course, а также все другие курсы, прямо сейчас!
Премиум
  • Урок 1. 00:01:16
    Introduction
  • Урок 2. 00:01:01
    Tools Used in This Course
  • Урок 3. 00:02:08
    Download PostgreSQL
  • Урок 4. 00:02:34
    Install PostgreSQL
  • Урок 5. 00:01:32
    Download SQLectron
  • Урок 6. 00:00:34
    Install SQLectron
  • Урок 7. 00:01:19
    Connect to PostgreSQL - Credentials
  • Урок 8. 00:01:34
    Connect to PostgreSQL Using SQLectron
  • Урок 9. 00:02:21
    Import Course Data Using SQLectron
  • Урок 10. 00:07:52
    FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data
  • Урок 11. 00:05:43
    Check Imported Data
  • Урок 12. 00:01:21
    So.. What is a Database?
  • Урок 13. 00:01:47
    SQL Data Types
  • Урок 14. 00:00:52
    Finally Some Fun! Extracting Data Based on Requirements
  • Урок 15. 00:08:29
    Filtering Data using WHERE Keyword
  • Урок 16. 00:02:43
    Filter Data by Range Using BETWEEN
  • Урок 17. 00:03:16
    Filter Data by Set of Values Using IN
  • Урок 18. 00:05:25
    Filter Data by Date
  • Урок 19. 00:03:10
    More Filtering by Date
  • Урок 20. 00:01:00
    Another Query Filtering by Date
  • Урок 21. 00:04:16
    Filter Data by Strings (Names, Addresses, ...)
  • Урок 22. 00:04:56
    More Filtering by Strings
  • Урок 23. 00:09:42
    More Filtering by Strings 2
  • Урок 24. 00:01:33
    More Filtering by Strings 3
  • Урок 25. 00:03:55
    How to Ignore Caps when Filtering by String
  • Урок 26. 00:10:05
    AND Operator
  • Урок 27. 00:12:16
    OR Operator
  • Урок 28. 00:09:25
    NOT Operator
  • Урок 29. 00:06:27
    AND, OR & NOT Operators: Which Has The Highest Priority?
  • Урок 30. 00:05:31
    Basic Math Operations
  • Урок 31. 00:04:26
    Modulo Operator
  • Урок 32. 00:06:22
    It's Payday! Calculate The Net Salary for Employees
  • Урок 33. 00:02:44
    Filter Data with Math Equations
  • Урок 34. 00:05:58
    Concatenate Strings with '||' Operator
  • Урок 35. 00:01:51
    Concatenate Strings with Numbers
  • Урок 36. 00:04:11
    Give Your Report Fields A Cool Name
  • Урок 37. 00:07:06
    A Report for Payroll
  • Урок 38. 00:06:23
    Order Records by Column
  • Урок 39. 00:12:08
    Order Records by Multiple Columns
  • Урок 40. 00:01:58
    How Alias Names Cannot Be Used with WHERE
  • Урок 41. 00:07:57
    LIMIT Record Count Fetched by Your Query
  • Урок 42. 00:02:43
    Fetch A Field's Unique Values Using DISTINCT
  • Урок 43. 00:05:45
    Using DISTINCT Keyword with Multiple Columns
  • Урок 44. 00:05:02
    What is a NULL Value Anyway?
  • Урок 45. 00:10:05
    Build More Sophisticated Queries with CASE Statements
  • Урок 46. 00:09:17
    Your Knowledge So Far Under A Great Test
  • Урок 47. 00:04:12
    Let Me Introduce You to Functions
  • Урок 48. 00:04:13
    SUM Function
  • Урок 49. 00:04:10
    AVG (Average) Function
  • Урок 50. 00:06:33
    COUNT Function
  • Урок 51. 00:03:49
    MIN & MAX Functions
  • Урок 52. 00:03:46
    How To Count Your Field's Unique Values
  • Урок 53. 00:05:54
    GROUP BY Clause: Use Functions with Dimensions
  • Урок 54. 00:04:53
    GROUP BY More Than One Dimension
  • Урок 55. 00:08:54
    Now For Some Tough Workout
  • Урок 56. 00:08:14
    Filter By Aggregate Functions with HAVING Clause
  • Урок 57. 00:07:50
    Character Functions - UPPER, LOWER & INITCAP
  • Урок 58. 00:10:25
    Character Functions - CONCAT & LENGTH
  • Урок 59. 00:13:30
    Character Functions - LPAD & RPAD
  • Урок 60. 00:03:36
    Character Functions - TRIM
  • Урок 61. 00:09:19
    Character Functions - REPLACE
  • Урок 62. 00:09:35
    Character Functions - SUBSTR
  • Урок 63. 00:11:14
    Number Functions - MOD & ROUND
  • Урок 64. 00:06:57
    Number Functions - TRUNC
  • Урок 65. 00:06:15
    Selectception: A Select Query Inside Another Select Query!
  • Урок 66. 00:10:35
    Auto Data Conversion in SQL
  • Урок 67. 00:10:16
    Cast Date to Character
  • Урок 68. 00:09:23
    Cast Number to Character
  • Урок 69. 00:06:39
    Cast Timestamp to Character
  • Урок 70. 00:07:35
    Cast Character to Number
  • Урок 71. 00:08:48
    Cast Character to Date & Timestamp
  • Урок 72. 00:03:28
    UNION
  • Урок 73. 00:01:46
    UNION ALL
  • Урок 74. 00:01:52
    Important Note about Combining Queries
  • Урок 75. 00:00:59
    INTERSECT
  • Урок 76. 00:01:26
    EXCEPT
  • Урок 77. 00:02:41
    Employees & Departments Tables Revised
  • Урок 78. 00:09:14
    Entity Relationship Diagram (ERD)
  • Урок 79. 00:09:28
    Cartesian Join
  • Урок 80. 00:06:44
    Table Aliases with Joins
  • Урок 81. 00:07:43
    Why I Don't Recommend Cartesian Joins
  • Урок 82. 00:05:57
    Inner Join
  • Урок 83. 00:03:00
    In-Depth Look into Join Types in SQL
  • Урок 84. 00:08:26
    Outer Join - Right, Left & Full
  • Урок 85. 00:08:45
    INSERT a New Record to a Table
  • Урок 86. 00:09:11
    Insert Without Specifying Column Names
  • Урок 87. 00:07:13
    UPDATE a Record's Field Values
  • Урок 88. 00:04:09
    CAUTION! How an UPDATE Query Can Go Wrong
  • Урок 89. 00:04:16
    Update a Record Using Single-Row Functions
  • Урок 90. 00:01:51
    A Good Exercise: Extract Employee's Email Address
  • Урок 91. 00:12:54
    Solution: Extract Employee's Email Address
  • Урок 92. 00:06:09
    DELETE a Table's Record
  • Урок 93. 00:06:00
    Insert Records with Nested Select Queries
  • Урок 94. 00:12:35
    SQL Data Types Revised
  • Урок 95. 00:03:52
    Bookstore Data Set: Let's Move It to Database
  • Урок 96. 00:08:20
    Create Your First Table!
  • Урок 97. 00:07:32
    Insert Data to Your New Table
  • Урок 98. 00:07:12
    Change Column Data Type
  • Урок 99. 00:03:34
    Rename Column
  • Урок 100. 00:04:12
    Add a New Column to Table
  • Урок 101. 00:01:05
    Constraints in SQL
  • Урок 102. 00:14:05
    Primary Keys
  • Урок 103. 00:04:35
    NOT NULL Constraint
  • Урок 104. 00:04:22
    UNIQUE Constraint
  • Урок 105. 00:04:11
    DEFAULT Constraint
  • Урок 106. 00:07:32
    Foreign Keys
  • Урок 107. 00:06:20
    Use Foreign Keys with Joins - Books & Publishers
  • Урок 108. 00:06:16
    Foreign Keys - Properties
  • Урок 109. 00:00:41
    Drop Column
  • Урок 110. 00:01:02
    DROP Table
  • Урок 111. 00:04:36
    Create a New Table with Select Statement
  • Урок 112. 00:02:46
    A Trick to Create an Empty Table with Select Statement
  • Урок 113. 00:05:39
    Insert New Records Using Select Statement
  • Урок 114. 00:03:30
    Views
  • Урок 115. 00:01:33
    Schemas
  • Урок 116. 00:04:12
    Create & Use Schemas
  • Урок 117. 00:01:22
    Introduction to Access Control
  • Урок 118. 00:03:02
    Create User
  • Урок 119. 00:02:31
    Grant SELECT to User
  • Урок 120. 00:03:05
    Grant Insert & Update to User
  • Урок 121. 00:01:52
    Revoke Privilege from User
  • Урок 122. 00:04:30
    User Groups