Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай SQL - MySQL for Data Analytics and Business Intelligence, а также все другие курсы, прямо сейчас!
Премиум
  • Урок 1. 00:04:15
    What does the course cover?
  • Урок 2. 00:03:18
    Why SQL?
  • Урок 3. 00:01:58
    Why MySQL?
  • Урок 4. 00:04:45
    Introduction to databases
  • Урок 5. 00:02:12
    SQL as a declarative language
  • Урок 6. 00:04:14
    Data definition language (DDL)
  • Урок 7. 00:01:13
    SQL keywords
  • Урок 8. 00:04:56
    Data manipulation language (DML)
  • Урок 9. 00:05:04
    Data control language (DCL)
  • Урок 10. 00:03:03
    Transaction control language (TCL)
  • Урок 11. 00:04:52
    Relational database essentials
  • Урок 12. 00:08:07
    Databases vs spreadsheets
  • Урок 13. 00:04:18
    Database terminology
  • Урок 14. 00:04:56
    Relational schemas - Primary key
  • Урок 15. 00:05:00
    Relational schemas - Foreign key
  • Урок 16. 00:03:08
    Relational schemas - Unique key and null values
  • Урок 17. 00:04:40
    Relationships
  • Урок 18. 00:10:49
    Installing MySQL
  • Урок 19. 00:02:35
    Setting up a connection
  • Урок 20. 00:06:19
    New Authentication Plugin - Creating a New User
  • Урок 21. 00:05:10
    Introduction to the MySQL interface
  • Урок 22. 00:05:13
    Creating a Database - Part I
  • Урок 23. 00:02:23
    Creating a Database - Part II
  • Урок 24. 00:02:17
    Introduction to data types
  • Урок 25. 00:05:02
    String data types
  • Урок 26. 00:04:11
    Integers
  • Урок 27. 00:05:45
    Fixed and floating-point data types
  • Урок 28. 00:06:13
    Other useful data types
  • Урок 29. 00:05:18
    Creating a table
  • Урок 30. 00:03:04
    Using databases and tables
  • Урок 31. 00:02:13
    Additional notes on using tables
  • Урок 32. 00:05:24
    PRIMARY KEY constraint
  • Урок 33. 00:05:26
    FOREIGN KEY constraint - Part I
  • Урок 34. 00:05:27
    FOREIGN KEY constraint - Part II
  • Урок 35. 00:05:01
    UNIQUE Constraint
  • Урок 36. 00:05:25
    DEFAULT Constraint
  • Урок 37. 00:05:54
    NOT NULL Constraint - Part I
  • Урок 38. 00:02:00
    NOT NULL Constraint - Part II
  • Урок 39. 00:05:35
    Coding techniques and best practices - Part I
  • Урок 40. 00:04:12
    Coding techniques and best practices - Part II
  • Урок 41. 00:02:20
    Loading the 'employees' database
  • Урок 42. 00:04:58
    SELECT - FROM
  • Урок 43. 00:02:31
    WHERE
  • Урок 44. 00:02:15
    AND
  • Урок 45. 00:03:36
    OR
  • Урок 46. 00:03:35
    Operator precedence
  • Урок 47. 00:03:13
    IN - NOT IN
  • Урок 48. 00:03:37
    LIKE - NOT LIKE
  • Урок 49. 00:01:46
    Wildcard characters
  • Урок 50. 00:02:21
    BETWEEN - AND
  • Урок 51. 00:01:38
    IS NOT NULL - IS NULL
  • Урок 52. 00:04:31
    Other comparison operators
  • Урок 53. 00:02:07
    SELECT DISTINCT
  • Урок 54. 00:05:25
    Introduction to aggregate functions
  • Урок 55. 00:03:47
    ORDER BY
  • Урок 56. 00:06:01
    GROUP BY
  • Урок 57. 00:02:09
    Using Aliases (AS)
  • Урок 58. 00:03:27
    HAVING
  • Урок 59. 00:04:05
    WHERE vs HAVING- Part I
  • Урок 60. 00:03:09
    WHERE vs HAVING- Part II
  • Урок 61. 00:04:53
    LIMIT
  • Урок 62. 00:06:06
    The INSERT statement - Part I
  • Урок 63. 00:02:20
    The INSERT statement - Part II
  • Урок 64. 00:03:57
    Inserting data INTO a new table
  • Урок 65. 00:02:43
    TCL's COMMIT and ROLLBACK
  • Урок 66. 00:03:19
    The UPDATE Statement - Part I
  • Урок 67. 00:02:56
    The UPDATE Statement - Part II
  • Урок 68. 00:04:15
    The DELETE Statement - Part I
  • Урок 69. 00:01:31
    The DELETE Statement - Part II
  • Урок 70. 00:03:24
    DROP vs TRUNCATE vs DELETE
  • Урок 71. 00:04:15
    COUNT()
  • Урок 72. 00:01:32
    SUM()
  • Урок 73. 00:01:16
    MIN() and MAX()
  • Урок 74. 00:01:59
    AVG()
  • Урок 75. 00:02:07
    ROUND()
  • Урок 76. 00:06:26
    IFNULL() and COALESCE()
  • Урок 77. 00:01:37
    Another Example of Using COALESCE()
  • Урок 78. 00:04:24
    Introduction to JOINs
  • Урок 79. 00:06:04
    INNER JOIN - Part I
  • Урок 80. 00:05:34
    INNER JOIN - Part II
  • Урок 81. 00:04:10
    A Note on Using Joins
  • Урок 82. 00:04:22
    Duplicate Records
  • Урок 83. 00:04:32
    LEFT JOIN - Part I
  • Урок 84. 00:05:47
    LEFT JOIN - Part II
  • Урок 85. 00:04:31
    RIGHT JOIN
  • Урок 86. 00:04:18
    The new and the old join syntax
  • Урок 87. 00:02:54
    JOIN and WHERE Used Together
  • Урок 88. 00:07:43
    CROSS JOIN
  • Урок 89. 00:02:18
    Using Aggregate Functions with Joins
  • Урок 90. 00:04:28
    JOIN more than two tables in SQL
  • Урок 91. 00:05:40
    Tips and tricks for joins
  • Урок 92. 00:05:45
    UNION vs UNION ALL
  • Урок 93. 00:04:32
    SQL Subqueries with IN nested inside WHERE
  • Урок 94. 00:03:43
    SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE
  • Урок 95. 00:07:58
    SQL Subqueries nested in SELECT and FROM
  • Урок 96. 00:07:46
    Self Join
  • Урок 97. 00:07:13
    Views
  • Урок 98. 00:03:27
    Introduction to stored routines
  • Урок 99. 00:04:33
    The MySQL syntax for stored procedures
  • Урок 100. 00:02:46
    Stored procedures - Example - Part I
  • Урок 101. 00:04:50
    Stored procedures - Example - Part II
  • Урок 102. 00:03:20
    Another way to create a procedure
  • Урок 103. 00:06:30
    Stored procedures with an input parameter
  • Урок 104. 00:03:21
    Stored procedures with an output parameter
  • Урок 105. 00:06:51
    Variables
  • Урок 106. 00:06:15
    User-defined functions in MySQL
  • Урок 107. 00:03:56
    Stored routines - conclusion
  • Урок 108. 00:04:57
    Types of MySQL Variables - Local Variables
  • Урок 109. 00:05:22
    Session Variables
  • Урок 110. 00:02:19
    Global Variables
  • Урок 111. 00:04:13
    User-Defined vs System Variables
  • Урок 112. 00:07:28
    MySQL Indexes
  • Урок 113. 00:05:58
    The CASE Statement
  • Урок 114. 00:05:21
    The Advantages of Software Integration
  • Урок 115. 00:04:55
    Why Combining SQL and Tableau is useful
  • Урок 116. 00:01:52
    Installing Tableau Public
  • Урок 117. 00:03:23
    Loading the 'employees_mod' Database
  • Урок 118. 00:05:34
    Task 1
  • Урок 119. 00:04:42
    Task 1: SQL Solution
  • Урок 120. 00:04:14
    Transferring a Dataset from SQL to Tableau
  • Урок 121. 00:06:18
    Chart 1: Visualizing and Analyzing the Solution in Tableau - Part I
  • Урок 122. 00:05:26
    Chart 1: Visualizing and Analyzing the Solution in Tableau - Part II
  • Урок 123. 00:03:51
    Task 2
  • Урок 124. 00:03:44
    Task 2: SQL Solution
  • Урок 125. 00:06:09
    Chart 2: Visualizing and Analyzing the Solution in Tableau
  • Урок 126. 00:02:22
    Task 3
  • Урок 127. 00:03:15
    Task 3: SQL Solution
  • Урок 128. 00:04:57
    Chart 3: Visualizing and Analyzing the Solution in Tableau
  • Урок 129. 00:02:46
    Task 4
  • Урок 130. 00:02:48
    Task 4: Solution in SQL
  • Урок 131. 00:03:23
    Chart 4: Visualizing and Analyzing the Solution in Tableau
  • Урок 132. 00:06:05
    Task 5: Organizing Charts 1-4 into a Beautiful Dashboard using Tableau