Database using SQL Server - EduMeFree

123-456-7890

تابعنا علي:

قواعد البيانات باستخدام نظام ادارة قواعد البيانات SQL-Server

محتوى الكورس

Lecture 1 – Introduction

Lecture 2 – Concepts

Lecture 3 – ER Entity and attributes

Lecture 4 – ER Relationship Part1

Lecture 5 – ER Relationship Part 2

Lecture 6 – Applications : Company Database

Lecture 7 – Mapping ER to Relational Model

Lecture 8 – Create,Alter,Drop Database

Lecture 9 – Data type in SQL Server

Lecture 10 – Create,alter,drop tables

Lecture 11 – Not Null Constraint

Lecture 12 – Unique Constraint

Lecture 13 – Default Constraint

Lecture 14 – Check Constraint

Lecture 15 – Primary key Constraint part 1

Lecture 16 – Primary key Constraint part 2

Lecture 17 – Foreign key Constraint

Lecture 18 – Application : Creating Company database

Lecture 19 – Detach (Export) and attach (Import) database

Lecture 20 – DML : Insert Statement

Lecture 21 – DML : Update Statement

Lecture 22 – DML : Delete Statement

Lecture 23 – DQL : Select Statement part 1

Lecture 24 – DQL : Select Statement part 2

Lecture 25 – Restricting and Sorting (WHERE) part one

Lecture 26 – Restricting (Like) and Sorting part 2