1. Урок 1.00:01:16
    Introduction
  2. Урок 2.00:01:01
    Tools Used in This Course
  3. Урок 3.00:02:08
    Download PostgreSQL
  4. Урок 4.00:02:34
    Install PostgreSQL
  5. Урок 5.00:01:32
    Download SQLectron
  6. Урок 6.00:00:34
    Install SQLectron
  7. Урок 7.00:01:19
    Connect to PostgreSQL - Credentials
  8. Урок 8.00:01:34
    Connect to PostgreSQL Using SQLectron
  9. Урок 9.00:02:21
    Import Course Data Using SQLectron
  10. Урок 10.00:07:52
    FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data
  11. Урок 11.00:05:43
    Check Imported Data
  12. Урок 12.00:01:21
    So.. What is a Database?
  13. Урок 13.00:01:47
    SQL Data Types
  14. Урок 14.00:00:52
    Finally Some Fun! Extracting Data Based on Requirements
  15. Урок 15.00:08:29
    Filtering Data using WHERE Keyword
  16. Урок 16.00:02:43
    Filter Data by Range Using BETWEEN
  17. Урок 17.00:03:16
    Filter Data by Set of Values Using IN
  18. Урок 18.00:05:25
    Filter Data by Date
  19. Урок 19.00:03:10
    More Filtering by Date
  20. Урок 20.00:01:00
    Another Query Filtering by Date
  21. Урок 21.00:04:16
    Filter Data by Strings (Names, Addresses, ...)
  22. Урок 22.00:04:56
    More Filtering by Strings
  23. Урок 23.00:09:42
    More Filtering by Strings 2
  24. Урок 24.00:01:33
    More Filtering by Strings 3
  25. Урок 25.00:03:55
    How to Ignore Caps when Filtering by String
  26. Урок 26.00:10:05
    AND Operator
  27. Урок 27.00:12:16
    OR Operator
  28. Урок 28.00:09:25
    NOT Operator
  29. Урок 29.00:06:27
    AND, OR & NOT Operators: Which Has The Highest Priority?
  30. Урок 30.00:05:31
    Basic Math Operations
  31. Урок 31.00:04:26
    Modulo Operator
  32. Урок 32.00:06:22
    It's Payday! Calculate The Net Salary for Employees
  33. Урок 33.00:02:44
    Filter Data with Math Equations
  34. Урок 34.00:05:58
    Concatenate Strings with '||' Operator
  35. Урок 35.00:01:51
    Concatenate Strings with Numbers
  36. Урок 36.00:04:11
    Give Your Report Fields A Cool Name
  37. Урок 37.00:07:06
    A Report for Payroll
  38. Урок 38.00:06:23
    Order Records by Column
  39. Урок 39.00:12:08
    Order Records by Multiple Columns
  40. Урок 40.00:01:58
    How Alias Names Cannot Be Used with WHERE
  41. Урок 41.00:07:57
    LIMIT Record Count Fetched by Your Query
  42. Урок 42.00:02:43
    Fetch A Field's Unique Values Using DISTINCT
  43. Урок 43.00:05:45
    Using DISTINCT Keyword with Multiple Columns
  44. Урок 44.00:05:02
    What is a NULL Value Anyway?
  45. Урок 45.00:10:05
    Build More Sophisticated Queries with CASE Statements
  46. Урок 46.00:09:17
    Your Knowledge So Far Under A Great Test
  47. Урок 47.00:04:12
    Let Me Introduce You to Functions
  48. Урок 48.00:04:13
    SUM Function
  49. Урок 49.00:04:10
    AVG (Average) Function
  50. Урок 50.00:06:33
    COUNT Function
  51. Урок 51.00:03:49
    MIN & MAX Functions
  52. Урок 52.00:03:46
    How To Count Your Field's Unique Values
  53. Урок 53.00:05:54
    GROUP BY Clause: Use Functions with Dimensions
  54. Урок 54.00:04:53
    GROUP BY More Than One Dimension
  55. Урок 55.00:08:54
    Now For Some Tough Workout
  56. Урок 56.00:08:14
    Filter By Aggregate Functions with HAVING Clause
  57. Урок 57.00:07:50
    Character Functions - UPPER, LOWER & INITCAP
  58. Урок 58.00:10:25
    Character Functions - CONCAT & LENGTH
  59. Урок 59.00:13:30
    Character Functions - LPAD & RPAD
  60. Урок 60.00:03:36
    Character Functions - TRIM
  61. Урок 61.00:09:19
    Character Functions - REPLACE
  62. Урок 62.00:09:35
    Character Functions - SUBSTR
  63. Урок 63.00:11:14
    Number Functions - MOD & ROUND
  64. Урок 64.00:06:57
    Number Functions - TRUNC
  65. Урок 65.00:06:15
    Selectception: A Select Query Inside Another Select Query!
  66. Урок 66.00:10:35
    Auto Data Conversion in SQL
  67. Урок 67.00:10:16
    Cast Date to Character
  68. Урок 68.00:09:23
    Cast Number to Character
  69. Урок 69.00:06:39
    Cast Timestamp to Character
  70. Урок 70.00:07:35
    Cast Character to Number
  71. Урок 71.00:08:48
    Cast Character to Date & Timestamp
  72. Урок 72.00:03:28
    UNION
  73. Урок 73.00:01:46
    UNION ALL
  74. Урок 74.00:01:52
    Important Note about Combining Queries
  75. Урок 75.00:00:59
    INTERSECT
  76. Урок 76.00:01:26
    EXCEPT
  77. Урок 77.00:02:41
    Employees & Departments Tables Revised
  78. Урок 78.00:09:14
    Entity Relationship Diagram (ERD)
  79. Урок 79.00:09:28
    Cartesian Join
  80. Урок 80.00:06:44
    Table Aliases with Joins
  81. Урок 81.00:07:43
    Why I Don't Recommend Cartesian Joins
  82. Урок 82.00:05:57
    Inner Join
  83. Урок 83.00:03:00
    In-Depth Look into Join Types in SQL
  84. Урок 84.00:08:26
    Outer Join - Right, Left & Full
  85. Урок 85.00:08:45
    INSERT a New Record to a Table
  86. Урок 86.00:09:11
    Insert Without Specifying Column Names
  87. Урок 87.00:07:13
    UPDATE a Record's Field Values
  88. Урок 88.00:04:09
    CAUTION! How an UPDATE Query Can Go Wrong
  89. Урок 89.00:04:16
    Update a Record Using Single-Row Functions
  90. Урок 90.00:01:51
    A Good Exercise: Extract Employee's Email Address
  91. Урок 91.00:12:54
    Solution: Extract Employee's Email Address
  92. Урок 92.00:06:09
    DELETE a Table's Record
  93. Урок 93.00:06:00
    Insert Records with Nested Select Queries
  94. Урок 94.00:12:35
    SQL Data Types Revised
  95. Урок 95.00:03:52
    Bookstore Data Set: Let's Move It to Database
  96. Урок 96.00:08:20
    Create Your First Table!
  97. Урок 97.00:07:32
    Insert Data to Your New Table
  98. Урок 98.00:07:12
    Change Column Data Type
  99. Урок 99.00:03:34
    Rename Column
  100. Урок 100.00:04:12
    Add a New Column to Table
  101. Урок 101.00:01:05
    Constraints in SQL
  102. Урок 102.00:14:05
    Primary Keys
  103. Урок 103.00:04:35
    NOT NULL Constraint
  104. Урок 104.00:04:22
    UNIQUE Constraint
  105. Урок 105.00:04:11
    DEFAULT Constraint
  106. Урок 106.00:07:32
    Foreign Keys
  107. Урок 107.00:06:20
    Use Foreign Keys with Joins - Books & Publishers
  108. Урок 108.00:06:16
    Foreign Keys - Properties
  109. Урок 109.00:00:41
    Drop Column
  110. Урок 110.00:01:02
    DROP Table
  111. Урок 111.00:04:36
    Create a New Table with Select Statement
  112. Урок 112.00:02:46
    A Trick to Create an Empty Table with Select Statement
  113. Урок 113.00:05:39
    Insert New Records Using Select Statement
  114. Урок 114.00:03:30
    Views
  115. Урок 115.00:01:33
    Schemas
  116. Урок 116.00:04:12
    Create & Use Schemas
  117. Урок 117.00:01:22
    Introduction to Access Control
  118. Урок 118.00:03:02
    Create User
  119. Урок 119.00:02:31
    Grant SELECT to User
  120. Урок 120.00:03:05
    Grant Insert & Update to User
  121. Урок 121.00:01:52
    Revoke Privilege from User
  122. Урок 122.00:04:30
    User Groups