دراسة هذا الكورس لا تتطلب اي معرفة مسبقة في البرمجة ، لكن معرفة بسيطة فيها ستفيدك
محتوى الكورس
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
- What is Database? (20:55)
- What is NULL? (8:33)
- Primary Key vs Foreign Key / Referential Integrity (24:36)
- What is Redundancy? and why it's a problem? (19:22)
- What is Data Integrity? and Why it's Important and Critical? (21:38)
- What is Constraint? and Why it's Important? (13:47)
- What is SQL? (17:51)
- DBMs vs RDBMS Summary (8:50)
Available in
days
days
after you enroll
- What is ERD? and Why? (20:22)
- ERD Symbols (12:33)
- Components of ERD (2:27)
- Entity (Strong) and Weak Entity (9:25)
- Attributes (7:08)
- Relationships (16:39)
- One-to-One Relationship (16:21)
- One-to-Many/Many-to-One Relationship (15:01)
- Many-to-Many Relationship (6:26)
- Cardinality vs Ordinality (11:57)
- Cardinality Symbols and Practices (29:44)
- Total Vs Partial Participation (5:54)
- Process of Creating ERD Step by Step - Small Project (26:57)
- Recommended ERD Software to Use (2:51)
- Aggregation / Associative Entities (5:45)
- Generalization (13:26)
- Specialization (15:38)
Available in
days
days
after you enroll
- What is Relational Schema? (13:58)
- Convert Self Referential ==> Relational Schema (7:07)
- Convert Composite-Multivalued-Derived Attributes ==> Relational Schema (15:19)
- Convert One-to-One ==> Relational Schema (8:45)
- Convert One-to-Many/Many-to-One ==> Relational Schema (8:16)
- Convert Many-to-Many ==> Relational Schema (16:41)
- Generalization and Specialization to Relational Schema
- Convert Associative Entity to Relational Schema (7:20)
- How to create Relational Schema on ERDPlus.com? (5:08)
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
- Restore Sample HR Database and Get Ready . (4:29)
- Select Statement (6:37)
- Select Distinct Statement (5:35)
- Where Statement + AND , OR, NOT (10:33)
- "In" Operator (8:55)
- Sorting : Order By (7:01)
- Select Top Statement (13:45)
- Select As (11:27)
- Between Operator (1:40)
- Count, Sum, Avg, Min, Max Functions (6:00)
- Group By (7:46)
- Having (8:14)
- Like (6:13)
- WildCards (7:42)
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll