انا الايام دى هبدأ اخد سكول سرفر ادمن
Sql server administrator 2008
فكنت بدور على مركز علشان اتعلم
فبعتوا ليه ملف ورد فيه محتوى الكورس
فسالت واحد عن المحتوى فقالوا ده بتاع الديفلبر
فكنت عاوز اتاكد هل المحتوى ده ادمن ولا ديفلبر
ولو كان ده مش ادمن ايه هو محتوى الادمن
سكول سرفر 2008
دى المحتوى اللى انبعت ليه
Microsoft SQL Server 2008 Training Outline
Microsoft SQL Server 2008 Training Objectives
All attendees will learn to:
• Use the programming environment in SQL Server Management Studio and learn the Transact-SQL language
• Understand the differences between view, stored procedures, triggers, and user-defined functions, and know the advantages and drawbacks of each
• Implement the SQL Server 2008 security model; and create logins, users and permissions to protect your data
• Utilize the fundamentals of Reporting Services, Analysis Services, Integration Services and the Service Broker
• Configure and tune SQL Server 2008 and monitor database activity
Important Note: We would be delighted to add or remove units from this course to meet your specific needs.
• Introducing SQL Server 2008
o What's New in SQL Server?
o SQL Server Editions
o Installing SQL Server
• Basics of Database Design
o Normalization
o Denormalization
o Tools for Normalization in SQL Server
o Introducing SQL Server Management Studio
o Creating a Database
o Adding Tables
o Creating Indexes and Constraints
o Building Relations
• T-SQL Basics
o What is T-SQL?
o Syntax Conventions
o Introducing AdventureWorks2008
o Executing SQL Statements
o Identifiers
o Creating Data Types
o Operators
o Variables
o Functions
o Using T-SQL to Build and Alter Objects
• SELECT queries
o The SELECT Clause
o The FROM Clause
o The WHERE Clause
o The ORDER BY Clause
o Using GROUP BY and HAVING
o Using TOP N and TOP N PERCENT
o UNION Queries
o Full-Text Search
• Action Queries
o SELECT INTO queries
o DELETE queries
o TRUNCATE TABLE queries
o INSERT queries
o UPDATE queries
o MERGE queries
• Locking and Execution Plans
o What is Locking?
o Monitoring Locks
o Tuning Locking
o Deadlocks
o Tuning Queries
o Management Data Warehouse
o Performance Studio
• Views, Stored Procedures, and Functions
o Using Views
o Using Stored Procedures
o Using Functions
• Advanced Transact-SQL
o Transactions
o Rowset Functions
o Ranking Functions
o Cursors
o Structured Error Handling
• XML and SQL Server
o XML Columns and Indexes
o Querying and Modifying XML Data
o Using OPENXML
o Using FOR XML
• Triggers
o Creating DML Triggers
o Altering DML Triggers
o Using the Inserted and Deleted Tables
o Checking Updated Columns
o Recursive and Nested Triggers
o Creating DDL Triggers
• .NET inside of SQL Server
o Creating CLR User-Defined Functions
o Creating CLR Stored Procedures
o Using the Sql Namespace
o Creating CLR Triggers
o Creating CLR User-Defined Types
o Choosing When To Use CLR Objects
• SMO and RMO Programming
o Retrieving Server Information
o Working With Database Objects
o Generating Scripts
o Viewing and Modifying Server Configuration
o Understanding RMO
• Data Protection/Tracking
o Understanding Change Data Capture
o Data Capture Schema and Tables
o Transparent Data Encryption
• SQL Server 2008 Analysis Services
o Understanding Analysis Services
o Introducing Business Intelligence Development Studio
o Creating a Data Cube
o Exploring a Data Cube
• SQL Server 2008 Integration Services
o The Import and Export Wizard
o Creating a Package
o Working with Connection Managers
o Building Control Flows
o Building Data Flows
o Creating Event Handlers
o Saving and Running Packages
• SQL Server 2008 Reporting Services
o The Reporting Services Architecture
o Using Report Designer
o Publishing a Report
o Using Report Builder
o Using Report Manager
• Service Broker
o Service Broker Terminology
o Creating a Service Broker Application
o Processing Messages with Stored Procedures
o Using Service Broker Across Servers
• Security and SQL Server
o Choosing Service Accounts
o Authentication Modes
o Roles and Users
o Permissions
o Object Ownership
• Conclusion
