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

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
  • 53,700 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

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

    53,700 تومان
    افزودن به سبد خرید