بسم الله الرحمن الرحيم
تحليل وتصميم وبناء أنظمة قواعد البيانات باستخدام
2012 SQL Server
رابط الدرس:
Syllabus:
Constraints, Relationships, Normalization and SELECT
Database Constraints
Not null Constraints
Unique Constraints
Primary key
Foreign key
Check Constraints
DEFAULT Constraint
Database Relationships
Relationship Types
One-to-one relationship
One-to-many relationship
Many-to-many relationship
Recursive relationship
Referential integrity
Database Normalization
First normal form
Second normal form
Third normal form
Denormalization
Introduction to Transact-SQL
Transact-SQL Commands
Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Control Language (DCL)
Data Definition Language (DDL)
Data Manipulation Language (DML)
SELECT
INSERT
UPDATE
DELETE
Data Control Language (DCL)
GRANT
DENY
REVOKE
Retrieving Data
SELECT
WHERE
IS Null Function
Customizing Data
Order BY
Examples : Sort Descending
Concatenate
Aliases (as)
Distinct
NOTES: SOME TOPICS WILL DISCUSS IN DETAILS LATER
ليست هناك تعليقات:
إرسال تعليق