SQL Server

خلاصه ای از دوره:


۴۰ساعت
مدت برگزاری دوره:
پنج شنبه ها
زمان برگزاری:
ندارد
پيش نياز:
مخاطبان:
هدف دوره:
۶۶۰۷۵۶۲۶
مشاوره و ثبت نام :
- نفر
نفرات آموزش دیده تا به امروز:
- دوره
دفعات برگزاری دوره تا به امروز:
۷۰۰,۰۰۰ تومان ۹۰۰,۰۰۰ تومان
شهریه(تومان):

Introduction to RDBMS-

         SQL Server Installation

SQL Server Services overview-

Service Account

Authentications

collation settings

Security in SQL Server Over View-

Server Role

Database Role

schema concept

Logical Design-

Entities

Primary Key & Foreign Key

Relations

Cardinality

Join Concepts

Data Base Implementation-

Data Types

Exact numerics

Approximate numerics

Decimal

Date and Time

Character Strings

BLOB

Referential Integrity laws

Check Constraints

  DDL Statements to CREATE / ALTER / DROP tables

Basic syntax of SELECT Statements-

Expression List-

Working with Scalar Functions

Using Case Expressions

Predicates-

ALL

DISTINCT

TOP

FROM-

Table

View

(Derived Table and Common Table Expressions (CTE

Table Valued Functions

Synonyms

WHERE-

GROUP BY-

Grouping Sets

Conditional Aggregate Functions

HAVING-

ORDER BY-

Special topics in the simple SELECT statement-

Casting and conversion

Working with Date and Time data types

Getting Data from more than one table-

INNER JOIN-

OUTER JOIN-

LEFT and Right JOIN-

(SUBQUERY (Nested Select-

Combining result sets-

UNION

INTERSECT

EXCEPT

Saving the query result using SELECT INTO-

Modifying data-

(INSERT (VALUES & RESULTS-

UPDATE-

Update from existing data

WRITE extension to the UPDATE command

DELETE-

Deleting related data

Truncate Table

(Ranking Functions (Windows Functions-

ROW_NUMBER

RANK

Aggregation using the OVER clause-

T-SQL Building Blocks-

 Working with Variables

IF Statement

CASE Expressions

WHILE Loop

Transaction-

Auto Commit Transactions

BEGIN TRAN and compound transactions

دیدگاه خود را به اشتراک بگذارید

avatar
  اشتراک  
به من اطلاع بده


دسته: علوم داده ،

برچسب: جهاد دانشگاهی صنعتی شریف ،

مطالب پیشنهادی