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