Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай Database Management Systems Part 3 : SQL Interview Course, а также все другие курсы, прямо сейчас!
Премиум
  1. Урок 1. 00:01:51
    About the course
  2. Урок 2. 00:20:15
    Why we are learning SQL
  3. Урок 3. 00:02:52
    Difference between Relational Algebra and SQL
  4. Урок 4. 00:03:12
    Various DBMS softwares
  5. Урок 5. 00:17:48
    Create table
  6. Урок 6. 00:08:25
    Inserting tuples to table
  7. Урок 7. 00:03:41
    NOT NULL Constraint
  8. Урок 8. 00:03:54
    Unique constraint
  9. Урок 9. 00:10:11
    Primary Key Constraint
  10. Урок 10. 00:10:25
    Foreign Key Constraint
  11. Урок 11. 00:04:19
    Check Constraint
  12. Урок 12. 00:12:00
    Default Constraint
  13. Урок 13. 00:26:09
    How to use Referential Trigger Actions 1
  14. Урок 14. 00:09:00
    How to use Referential Trigger Actions 2
  15. Урок 15. 00:21:55
    Select-From-Where Explained
  16. Урок 16. 00:29:10
    Inner Join without using Join Keyword in query
  17. Урок 17. 00:11:22
    Aliasing explained
  18. Урок 18. 00:20:33
    Where to use Aliasing
  19. Урок 19. 00:03:04
    Difference between Distinct and All
  20. Урок 20. 00:13:04
    Union of tables in SQL
  21. Урок 21. 00:04:00
    Intersect and Except in SQL
  22. Урок 22. 00:32:17
    LIKE operator and Wildcards in SQL
  23. Урок 23. 00:09:25
    Concatenation in SQL
  24. Урок 24. 00:09:21
    Between in SQL
  25. Урок 25. 00:15:19
    Order By Clause in SQL
  26. Урок 26. 00:05:15
    Arithmetic Operations in SQL query
  27. Урок 27. 00:03:36
    Dealing with NULL values while performing arithmetic operations
  28. Урок 28. 00:09:27
    Dealing with NULL values while performing comparison operations
  29. Урок 29. 00:15:12
    Dealing with NULL values while performing logical operation AND
  30. Урок 30. 00:09:56
    Dealing with NULL values while performing logical operations OR and NOT
  31. Урок 31. 00:08:38
    Dealing with NULL values while performing Join
  32. Урок 32. 00:11:36
    Aggregate Functions
  33. Урок 33. 00:03:58
    Dealing with NULL values while performing Aggregate Functions
  34. Урок 34. 00:15:26
    Group By clause explained with example
  35. Урок 35. 00:02:00
    Group By clause explained with example 2
  36. Урок 36. 00:04:19
    More than one attribute in group by clause
  37. Урок 37. 00:19:03
    Having Clause in SQL
  38. Урок 38. 00:08:32
    Another Example on Group By Clause
  39. Урок 39. 00:03:30
    Another Example on Having Clause
  40. Урок 40. 00:05:33
    IN Operator
  41. Урок 41. 00:04:05
    NOT IN and dealing with NULL values
  42. Урок 42. 00:07:51
    Comparison using ANY,SOME,ALL
  43. Урок 43. 00:14:32
    Non Correlated Nested queries explained
  44. Урок 44. 00:09:53
    Non Correlated Nested Queries Explained 2
  45. Урок 45. 00:18:41
    Example on Non correlated Nested query
  46. Урок 46. 00:11:50
    Example on Non correlated Nested query 2
  47. Урок 47. 00:27:09
    Correlated Nested queries explained
  48. Урок 48. 00:08:32
    Correlated Nested queries explained 2
  49. Урок 49. 00:09:02
    Correlated Nested Queries explained 3
  50. Урок 50. 00:16:01
    Correlated Nested Queries explained 4,1
  51. Урок 51. 00:18:28
    Correlated Nested Queries explained 4,2
  52. Урок 52. 00:10:44
    Correlated Nested Queries explained 5