eshrag.net
07-24-2010, 12:20 AM
السلام عليكم
احتراف قاعدة بيانات SQL SERVER
قامة كبيرة من الفيديوات مقدمة من شركة APPDEV
المدة : 9 ساعات
أنصح الجميع بمشاهدة القرص وتطبيقه
http://www.appdev.com/images/LT.Screen.DK.jpg
هده هي المواد التي يعالجها الدرس
---------------------------------------------------
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
التحميل (http://www.fileserve.com/file/2CSvNeZ)
---------------------------------------------------
(http://www.fileserve.com/file/2CSvNeZ)
شرح التحميل من موقع FileServe
http://www.mlfnt.com/up_6_2010/12785942381.png
أولا انزل إلى أسفل الصفحة و اضغط على Download File كما هو مبين في الصورة
http://www.mlfnt.com/up_6_2010/12785942382.png
http://www.mlfnt.com/up_6_2010/12785942383.png
أتمنى أن تعجبكم
تحياتي
الموضوع منقول من موضوع قديم لي
احتراف قاعدة بيانات SQL SERVER
قامة كبيرة من الفيديوات مقدمة من شركة APPDEV
المدة : 9 ساعات
أنصح الجميع بمشاهدة القرص وتطبيقه
http://www.appdev.com/images/LT.Screen.DK.jpg
هده هي المواد التي يعالجها الدرس
---------------------------------------------------
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
التحميل (http://www.fileserve.com/file/2CSvNeZ)
---------------------------------------------------
(http://www.fileserve.com/file/2CSvNeZ)
شرح التحميل من موقع FileServe
http://www.mlfnt.com/up_6_2010/12785942381.png
أولا انزل إلى أسفل الصفحة و اضغط على Download File كما هو مبين في الصورة
http://www.mlfnt.com/up_6_2010/12785942382.png
http://www.mlfnt.com/up_6_2010/12785942383.png
أتمنى أن تعجبكم
تحياتي
الموضوع منقول من موضوع قديم لي