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

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

رابط الدرس:

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