أسطوانات تعليميه من APPDEV ل SQL SERVER 2005 و برابط واحد (iso)

[eshrag.net]

السلام عليكم

احتراف قاعدة بيانات SQL SERVER

قامة كبيرة من الفيديوات مقدمة من شركة APPDEV
المدة : 9 ساعات

أنصح الجميع بمشاهدة القرص وتطبيقه

هده هي المواد التي يعالجها الدرس



---------------------------------------------------

Introduction to SQL Server 2005

Database Engine

Security

Analysis Services

Integration Services

Reporting Services

Notification Services

SQL Management Tools

Management Studio

Reports

Template Explorer

SQL Server Profiler

Database Tuning Advisor

Configuration Manager

Surface Area Configuration

SQLCMD

Authorization

Strong Password Policies

Password Policies

Changing a Login

SQL 2005 Principals

Securable Objects

Metadata Visibility

Security in Practice

Execution Contexts

Ownership Chains

When to Use Each Option

Users and Schemas

Synonyms

Encryption

Algorithms

Encryption Hierarchy

Service Master Key

Database Master Key

Use a Certificate

Asymmetric Keys

Symmetric Keys

SQLCLR

Introduction to SQLCLR

Why Use SQLCLR Code?

Creating Raw SQLCLR Code

Create with Visual Studio

Deploy the UDF

Deployment Notes

Data Access in SQLCLR

User-Defined Functions

Stored Procedures

More SQLCLR

Write a SQLCLR Stored Procedure

User-Defined Aggregates

Triggers

User-Defined Types

Troubleshooting Code

Security in SQLCLR

Permission Sets

Secure Coding Practices

T-SQL vs SQLCLR

SQL Management Objects

Management Frameworks

SMO Object Model

SMO Class Types

Code Behind the SMO Demo

Code to Connect to the Server

Create a Database

Delete a Database

Create a Table

SQL Express & Visual Studio Integration

Introducing SQL Express

Client and Management Tools

Design Time Features

Create a Database Application

Deploy the Database Application

Server Explorer Features

SQL Reporting Services

ADO.NET Enhancements

New Data Types

Multiple Active Result Sets

Asynchronous Queries

Asynchronous Methods

Error Handling

Query Notifications

Working with Service Broker

Setup Database for Service Broker

Client Access Enhancements

Batch Updates

Bulk Copy

Changes to the DataTable

Stream Data into DT/DS

DataTable from a DataView

New Rowstate Features

XML

XML Data Type

Typed XML Data

Indexing XML Data

Using the XML Schema

Querying XML

XML Data Type Methods

XQuery Limits in SQL Server

T-SQL XML Enhancements

Retrieving XML

Path for Returning XML Data

Include Multiple Paths

Output Column Data as a TN

Include an Inline XML Schema

Nested FOR XML Queries

OpenXML Enhancements

XML Bulk Load

Web Services

Exposing Web Services

Create a Stored Procedure

Create a Web Service

View the WSDL

T-SQL Enhancements - Part 1

New Data Types

Using TOP

Using DML Output

Pivot/Unpivot Operators

T-SQL Enhancements - Part 2

Ranking Functions

Using Other Ranking Functions

Common Table Expressions

Using DDL Triggers

---------------------------------------------------

الحجم 959.28 MB

التحميل

---------------------------------------------------

شرح التحميل من موقع FileServe

أولا انزل إلى أسفل الصفحة و اضغط على Download File كما هو مبين في الصورة

أتمنى أن تعجبكم
تحياتي


الموضوع منقول من موضوع قديم لي