دراسة هذا الكورس لا تتطلب اي معرفة مسبقة في البرمجة
محتوى الكورس
Introdction
Available in
days
days
after you enroll
Installing SQL Sever 2022
Available in
days
days
after you enroll
Revision
Available in
days
days
after you enroll
Introduction
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)
Database Design: Conceptual Design
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)
Relational Schema
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)
SQL
Available in
days
days
after you enroll
SQL - Data Definition Language - DDL
Available in
days
days
after you enroll
DDL - Alter Table Statement
Available in
days
days
after you enroll
Backup & Restore Database
Available in
days
days
after you enroll
Data Manipulation Language - DML
Available in
days
days
after you enroll
Misc 1
Available in
days
days
after you enroll
Hints
Available in
days
days
after you enroll
SQL - Queries
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)
Joins
Available in
days
days
after you enroll
Views
Available in
days
days
after you enroll
SQL - More Queries
Available in
days
days
after you enroll
More about Constraints
Available in
days
days
after you enroll
Normalization
Available in
days
days
after you enroll
Course Completed
Available in
days
days
after you enroll
