وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

RDBMS – SQL Course – Step by Step Guide to learn SQL

سرفصل های دوره

1. Welcome to the Course
  • 1. Introduction to RDBMS

  • 2. Installation
  • 1. Virtual Box Installation
  • 2. Ubuntu Installation
  • 3. MySQL Installation

  • 3. Introduction
  • 1. Data vs Information
  • 2. Why do we need Data
  • 3. Different ways of Storing Data
  • 4. Systems to store Data

  • 4. RDBMS
  • 1. History of RDBMS
  • 2. What is RDBMS
  • 3. What is Database
  • 4. What is Database Components
  • 5. Database Components - Hands - On
  • 6. What is Datatypes
  • 7. Datatypes - Hands - On
  • 8. What is Database Object
  • 9. Database Object - Index
  • 10. Database Object - Sequence
  • 11. Database Object - View
  • 12. Database Object - Views Hands On
  • 13. Database Design
  • 14. ER Diagram Part1
  • 15. ER Diagram with Component Part 2
  • 16. ER Diagram Part 3
  • 17. Keys Introduction
  • 18. SuperKey
  • 19. Candidate Key
  • 20. PrimaryKey
  • 21. Unique-Surrogate-Alternate-Composite Keys
  • 22. Foreign Key
  • 23. Data Integrity Introductions
  • 24. Domain Integrity Check Constraints Theory
  • 25. Check Constraint Hands-On
  • 26. Default Constraint
  • 27. Not Null Constraint
  • 28. Unique Constraint
  • 29. Entity Integrity Constraint
  • 30. Entity Integrity Constraint Hands-On
  • 31. Referential Integrity
  • 32. Referential Integrity Hands-On
  • 33. Introduction - Normalization
  • 34. Need for Normalization with Example
  • 35. Dependencies
  • 36. Normalization - First Normal Form
  • 37. Second Normal Form
  • 38. Third Normal Form
  • 39. BCNF Normal Form
  • 40. Transactions
  • 41. Transactions - ACID Properties
  • 42. Atomicity
  • 43. Consistency
  • 44. Isolation
  • 45. Durability

  • 5. SQL
  • 1. Introduction to SQL
  • 2. Types of SQL Commands
  • 3. Create and Alter Theory and Hands-On
  • 4. Rename Theory and Hands-On
  • 5. Drop and Truncate Theory and Hands-On
  • 6. Comment Theory and Hands-On
  • 7. DML Commands Theory
  • 8. DML Commands Hands-On
  • 9. Ways of Inserting Data into Tables Theory
  • 10. Ways of Inserting Data into Tables Hands-On
  • 11. DCL Commands Theory
  • 12. DCL Commands Hands-On
  • 13. TCL Commands Theory
  • 14. TCL Commands Hands-On
  • 15. DQL Commands Theory
  • 16. DQL Commands Hands-On
  • 17. SQL Statements
  • 18. Alias Theory and Hands-On
  • 19. Distinct Theory and Hands-On
  • 20. What are Operators
  • 21. Arithmetic Operators Theory
  • 22. Arithmetic Operators Hands-On
  • 23. Comparison Operators
  • 24. Logical Operators - And & Between
  • 25. Logical Operators - In & Not In
  • 26. Logical Operators - Like & OR
  • 27. Logical Operators - Exists & Not Exists
  • 28. Aggregate Functions Theory
  • 29. Aggregate Functions Hands-On
  • 30. SQL Clauses
  • 31. Where Clause Theory
  • 32. Where Clause Hands-On
  • 33. Order By Clause Introduction
  • 34. Order By Clause - Ascending Order Theory and Hands-On
  • 35. Order By Clause - Descending Order Theory and Hands-On
  • 36. Order By Clause - Ascending & Descending Order Theory and Hands-On
  • 37. Order By Clause - Ascending with Null Values Theory and Hands-On
  • 38. Order By Clause - Descending with Null Values Theory and Hands-On
  • 39. Group By Clause Theory
  • 40. Group By Clause Hands-On Part-1
  • 41. Group By Clause Hands-On Part-2
  • 42. Having Clause Theory
  • 43. Having Clause Hands-On
  • 44. What is Null Value
  • 45. Inserting Null Values Theory
  • 46. Inserting Null Values Hands-On
  • 47. Null vs Empty Space-Theory
  • 48. Null vs Empty Space -Hands On
  • 49. How to find Null Values Theory
  • 50. How to find Null Values Hands-On
  • 51. Null Values in Arithmetic Expressions- Theory
  • 52. Null Values in Arithmetic Expressions Hands-On
  • 53. Subquery Theory
  • 54. Subquery Hands-On
  • 55. Subquery Types Theory Part 1
  • 56. Subquery Types Theory Part 2
  • 57. Subquery Types Hands-On Part 1
  • 58. Subquery Types Hands-On Part-2
  • 59. What are Joins
  • 60. How Joins work
  • 61. Inner Joins Theory
  • 62. Inner Joins Hands-On
  • 63. Outer Joins Theory
  • 64. Outer Joins Hands-On
  • 65. Self Joins Theory
  • 66. Self Joins Hands-On
  • 67. Cross Joins Theory
  • 68. Cross Joins Hands-On
  • 69. Set Operator Introduction
  • 70. Union Set Operator Theory
  • 71. Union Set Operator Hands-On
  • 72. Union All Set Operator Theory
  • 73. Union All Set Operator Hands-On
  • 74. Intersect Set Operator Theory and Hands-On
  • 75. Minus Set Operator Theory
  • 76. Minus Set Operator Hands-On
  • 77. Introduction to String Functions
  • 78. Strings Case Manipulation Theory And Hands-On
  • 79. Adding and Removing Spaces Theory Part-1
  • 80. Adding and Removing Spaces Theory Part-2
  • 81. Adding and Removing Spaces Theory Part-3
  • 82. Adding and Removing Spaces Hands-On Part-1 ,Part-2 & Part-3
  • 83. Substring Theory Part-1
  • 84. Substring Theory Part-2
  • 85. Substring Hands-On
  • 86. Substring Index Theory
  • 87. Substring Index Hands-On
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    شناسه: 9217
    حجم: 5237 مگابایت
    مدت زمان: 777 دقیقه
    تاریخ انتشار: ۲۲ فروردین ۱۴۰۲
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید