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

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 دقیقه
    تاریخ انتشار: 20 خرداد 1402
    دیگر آموزش های این مدرس
    طراحی سایت و خدمات سئو

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