تعلم SQL Server 2008 مجانا

[Monzer Osama]

السلام عليكم
حمل من هنا ملفات فيديو ممتازة حول تعلم إسكيول سيرفر 2008 SQL Server ... مجانا
سيطلب منك التسجيل وتفعيل بريدك الالكتروني وبعدها تحمل برنامج على جهازك 22ميجا , وتختار بعدها الكورسات التي تريد مشاهدتها:
http://www.appdev.com/promo/freetrai...208&T=d%5FSGEN


المواضيع المقدمة:

Module 1
Tour of SQL 08
Editions

Server Components
Management Tools
Documentation
Feature Pack
SSMS
Demo: SSMS
Server Activity
Demo: Activity Monitor

Tables, Queries, Views
Demo: Table Designer
Demo: Template Explorer
SSIS
BIDS
Demo: BIDS
Reporting Services
SSAS
back to top
Module 2
Installation Preparation
Requirements

Network Software
Service Accounts
Multiple Instances
Scenarios
Named Instances
Instance Components
Upgrading
Upgrade Advisor
Demo: Upgrade Advisor
Installation Steps
Demo: Installation Center

Setup Support Rules
Product Key
Feature Selection
Instance Config
Disk Space
Server Configuration
Database Engine
Error Reporting
Ready to Install
Configuring
Demo: Server Services

Server Protocols
SQL Native Client
Management Studio
Server Properties
Memory Options
Processors
Security
Connections
Database Settings
Advanced
Permissions
back to top
Module 3
Relational Design
Design Principles

Key Terms
Relational Theory
Surrogate Keys
Demo: DB Design
Data Normalization
First Normal Form
Second Normal Form
Third Normal Form
Computed Columns
Key Dependance
Postal Lookup Tables
Beyond Normal Forms
Referentail Integrity
Relationships
One-to-One
Enfrorcing Integrity
Cascading
Cascading Updates
Cascading Deletes
Cascading Actions
Beyond Normalization
Business Rules
Implementation
Database Storage

Storage
Data Integrity
Recovery Models
Demo: Implementation
Rules for Identifiers
Demo: DB Properties
back to top
Module 4
Data Types
Charater-based

Numeric Data
Date and Time
Binary Types
Identifier Types
sql_variant
Variable-only
XML Type
System SQLCLR Types
Demo: Data Types
Creating Constraints
Demo: Constraints
Triggers
Creating Indexes
Demo: Index
Data Selection Queries
Transact-SQL

Schemas and Naming
Demo: T-SQL Code
Three-Valued Logic
Demo: Nulls
back to top
Module 5
Sorting
Demo: Order By

Group By Clause
Aggregate Functions
Demo: Count Rows
Demo: Top
Joining Tables
Demo: Join Tables
Demo: Outer Join
Demo: Inner & Outer
Modifying Data
Inserting Data

Demo: INSERT
Temporary Tables
Demo: Temp Tables
Uses for Temp Tables
Demo: Global Temps
back to top
Module 6
Updating Data
Demo: Update Statement

Demo: With Transaction
Demo: Deleting Data
Transaction Isolation
Isolation Levels
Blocking and Deadlocks
Deadlocks
Demo: Isolation Levels
Snapshot Isolation
Caveats
Demo: Snapshot Isolation
Management Studio
Demo: Connecting

Configure Options
Customize Toolbars
Menu Items
Query Designer
Projects and Solutions
Object Explorer
Filter Nodes
View Dependencies
Object Details
Designers
back to top
Module 7
Query Editor
Demo: Overview

Editing Options
Script Table as
Stored Procedure
Debuging
Template Explorer
Execution Plans
Results to a File
SQLCMD Mode
New Project
Working Offline
Books Online
Demo: Help Features
Transact SQL
T-SQL Extenstions

Batches and Scripts
Demo: Batches
Data Type Precedence
Demo: Converting Types
Built-In Functions
Working with Nulls
Demo: Nulls
back to top
Module 8
Handling Functions
Demo: ISNUMERIC

Using RAND
ROUND
REPLACE
STUFF
LEN, LEFT, RIGHT
SUBSTRING
CHARINDEX
PATINDEX
SPACE
CHAR and ASCII
LOWER and UPPER
LTRIM and RTRIM
GETDATE
MONTH, DATE, YEAR
DATEPART
DATENAME
DATE Math
Global Functions
Controlling Flow
Demo: IF...ELSE

BEGIN...END
GOTO
RETURN
CASE
WHILE
WAITFOR
Ranking Results
Demo: Ranking
back to top
Module 9
Security
The Threats

Security Philosophy
Two Stages
Security Terms
Authentication
Windows Integrated
Configure Settings
Demo: SQL Security
SQL Server Authentication
Demo: New Logins

Windows and SQL Logins
sa Login
Password Policy
Demo: Passwords
Authorization
Principals

Server Roles
Demo: Server Roles
Database Roles
Demo: Database Roles
Special Roles
Demo: Special Roles
Securable Objects
back to top
Module 10
Permissions
Permission Types

Permission Statements
Granting Permissions
Demo: Permissions
Roles, Permission...
Demo: Schemas
Execution Context
Ownership Chaining
Execution Context
Demo: Execution Context
Metadata Security
Demo: Metadata
Encryption
Encryption Keys

Key Management
Demo: Encryption

[nany4mg]

مرسيييييييييييييييييييييييييييييييي

[alialirs]

مشكورررررررررررررررررررررر