إنشاء حساب
الرئيسية
الكورسات
Launch a new career
Database Management Systems (DBMS) & SQL Full Course – From Fundamentals to Advanced Queries
DBMS Characteristics

DBMS Characteristics

Database Management Systems (DBMS) & SQL Full Course – From Fundamentals to Advanced Queries

الدرس السابق الدرس التالي

محتوى الكورس

جميع الدروس
56 درس
11:03 Introduction to Database Management Systems
12:46 DBMS Characteristics
10:51 Database Users
15:50 Advantages & Disadvantages of DBMS
08:21 History of Database Applications
06:25 Fundamentals of Database Systems
06:49 Three-Schema Architecture & Data Independence
12:23 DBMS Languages, Interfaces, and Classification
07:28 Database System Environment
08:01 DBMS Architecture
08:49 Basic Concepts of Entity-Relationship Model
11:20 Database Design Process
15:06 Concept of Relationships in ER Diagram
14:41 Exercises based on ER Model Concepts (Part 1)
11:54 Exercises based on ER Model Concepts (Part 2)
06:53 Introduction to Relational Data Model
07:40 Characteristics of Relations
12:49 Relational Model Constraints
09:56 Update Operations/Dealing with Constraint Violations
12:29 Exercises based on Relational Model (Part 1)
08:31 Exercises based on Relational Model (Part 2)
15:25 Relational Algebra Operations - Unary
11:49 Relational Algebra Operations - Set Theory
19:04 Relational Algebra Operations - Binary
21:58 Additional Relational Algebra Operations
21:39 Relational Algebra Queries (Part 1)
11:36 Relational Algebra Queries (Part 2)
08:41 Introduction to Structured Query Language (SQL)
06:00 Data Definition Language (DDL)
13:56 DDL Commands - CREATE
07:24 Constraints in SQL
09:50 Constraints in SQL (Example Queries)
12:40 Primary Key and Foreign Key Constraints in SQL
11:15 DDL Commands - ALTER
06:05 DDL Commands - TRUNCATE, DROP, and RENAME
11:25 DML Commands - INSERT and UPDATE
10:55 DML Commands - DELETE and SELECT
10:31 Data Control Language (DCL)
08:44 Transaction Control Language (TCL)
11:41 Aggregate Functions in SQL
07:57 GROUP BY and HAVING Clause in SQL
05:37 ORDER BY in SQL
08:55 LIKE in SQL
06:13 IN in SQL
06:26 BETWEEN in SQL
10:06 Alias (AS) in SQL
07:03 TOP, LIMIT, FETCH FIRST, and ROWNUM in SQL
15:03 NULL Functions in SQL
11:07 ANY and ALL Operators in SQL
09:42 CASE Expression in SQL
11:36 Introduction to Database Management Systems
24:08 DBMS Characteristics
08:55 Database Users
07:29 Advantages & Disadvantages of DBMS
06:22 History of Database Applications
22:25 Fundamentals of Database Systems