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

Basics of DBMS and MySQL for Data Analytics Full Course

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

A Comprehensive Course for all students


1 - Introduction To Course
  • 1 - Introduction to Course

  • 2 - Introduction To Database Management System
  • 2 - What is Database
  • 3 - Introduction To Database Management System
  • 4 - Degree and Cardinality of Relation
  • 5 - Relationships in DBMS
  • 6 - DBMS vs File Systems
  • 7 - DBMS Architecture

  • 3 - Relationships in DBMS
  • 8 - Concepts of Keys in DBMS
  • 9 - Referential Integrity
  • 10 - Entity Relationship Model ER Model

  • 4 - Normalization in DBMS
  • 11 - Normalization in Database Management System
  • 12 - Functional Dependency
  • 13 - Closure Property
  • 14 - First Normal Form 1NF
  • 15 - Second Normal Form 2NF
  • 16 - Third Normal Form 3NF
  • 17 - BCNF 35NF
  • 18 - Fourth Normal Form 4NF
  • 19 - Fifth Normal Form 5NF
  • 20 - Summary of Normalization Forms
  • 21 - Normalization Practice Problem I
  • 22 - Normalization Practice Problem II

  • 5 - Joins In Database Management System
  • 23 - Joins in DBMS
  • 24 - Cross Join
  • 25 - Natural Join
  • 26 - Theta Conditional Join
  • 27 - Equi Join
  • 28 - Self Join
  • 29 - Left Outer Join
  • 30 - Right Outer Join
  • 31 - Full Outer Join

  • 6 - Introduction to Relational Algebra in Database
  • 32 - Introduction to Relational Algebra
  • 33 - Projection in Relational Algebra
  • 34 - Selection in Relational Algebra
  • 35 - Cross Product in Relational Algebra
  • 36 - Set Difference in Relational Algebra
  • 37 - Union Operator in Relational Algebra
  • 38 - Division Operator in Relational Algebra
  • 39 - Join Operator in Relational Algebra
  • 40 - Relational Algebra Problem I

  • 7 - MySQL
  • 41 - Introduction To SQL
  • 42 - Install MySQL Workbench
  • 43 - Data Types in MySQL
  • 44 - Command Prompt Interface
  • 45 - Create Database In MySQL
  • 46 - Create Table In MySQL
  • 47 - Alter Table In MySQL
  • 48 - Drop Table In MySQL
  • 49 - Truncate Table In MySQL
  • 50 - Rename Table In MySQL
  • 51 - Difference Between Drop Truncate and Delete
  • 52 - Insert Data Into Table using MySQL
  • 53 - Update Data using MySQL
  • 54 - Delete from Table using MySQL
  • 55 - Commit Rollback and Save Point
  • 56 - Primary Key Constraint
  • 57 - Unique Key Constraint
  • 58 - Not Null Key Constraint
  • 59 - Check Key Constraint
  • 60 - Foreign Key Constraints and Referential Integrity
  • 61 - Select and Where Clause in MySQL
  • 62 - Order By Clause in MySQL
  • 63 - Group By Clause in MySQL
  • 64 - Having Clause in MySQL
  • 65 - Distinct Clause in MySQL
  • 66 - MySQL Functions
  • 67 - Logical Operator in MySQL
  • 68 - SQL Joins using MySQL
  • 69 - Set Operators in MySQL
  • 70 - Subqueries in MySQL
  • 71 - All and ANY keyword in MySQL
  • 72 - BETWEEN and IN keywords in MySQL
  • 73 - LIKE in MySQL
  • 74 - EXISTS in MySQL
  • 75 - EXISTS and IN with Subqueries in MySQL
  • 76 - SQL Practice Problem I
  • 77 - SQL Practice Problem II
  • 78 - SQL Practice Problem III
  • 79 - SQL Practice Problem IV

  • 8 - Transactions in Database Management System
  • 80 - Transactions in DBMS
  • 81 - Conflicts in Transaction
  • 82 - Recoverable and NonRecoverable Schedule
  • 83 - Schedules
  • 84 - Conflict Equivalent

  • 9 - Serializability
  • 85 - Serializability
  • 86 - Conflict Serializability
  • 87 - View Serializability
  • 88 - Concurrency Control Protocol
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 13394
    حجم: 2157 مگابایت
    مدت زمان: 330 دقیقه
    تاریخ انتشار: ۲۰ خرداد ۱۴۰۲
    دیگر آموزش های این مدرس
    طراحی سایت و خدمات سئو

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