الجمعة، 27 مارس، 2015

الدرس (8) - تحليل وتصميم وبناء أنظمة قواعد البيانات باستخدام SQL Server

بسم الله الرحمن الرحيم


تحليل وتصميم وبناء أنظمة قواعد البيانات باستخدام


2012 SQL Server



رابط الدرس:





Syllabus:

The Query Designer
Query Designer
USE Query Designer
Query Designer is for pre-existing queries also
Operator, Joining Data, DML (Inserting Data)
Using SQL Operators
Arithmetic operators
Comparison operators
Logical operators
Set Operators
Other operators
UNION & Intersect & Except
Joining Data
Using Aliases for Table Names
Combining Data from Multiple Tables
Introduction to Joins
Inner Join
Using Inner Joins
Left Outer Join
Using Outer Joins
Right Outer join
Full Join
Self- Join
Cross Join
Using Cross Joins
Data Manipulation Language
Inserting Data
INSERT  Statement
The SELECT INTO statement
Updating and Deleting Data

ليست هناك تعليقات:

إرسال تعليق