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