Transcript www.maj.ir
Exam : 70-431
Microsoft SQL Server 2005 - Implementation and Maintenance
مجموعه اطالعات ذخيره شده و سازماندهي شده به منظور تحقق اهدافي خاص بانک
.اطالعاتي ناميده مي شود
مجموعه اي نرم افزاري – سخت افزاري است که ايجاد و مديريت بانک اطالعاتي به
. عهده آن نهاده شده
HDBMS : Hierarchical DataBase Management System (DBMS, DB)
NDBMS : Network DataBase Management System (DB)
RDBMS : Relational DataBase Management System (DBMS, DB)
ORDBMS : Object Relational Database Management System (DBMS,
DB)
OODBMS : Object Orientated Database Management System (DBMS,
DB)
Data Base بانک اطالعاتي
DBMS سيستم مديريت بانک اطالعاتي
انواع مدل داده اي
The Data Definition Language (DDL)
CREATE TABLE , ALTER TABLE , DROP TABLE , CREATE INDEX , DROP
INDEX
The Data Manipulation Language (DML)
SELECT , UPDATE , DELETE , INSERT INTO
The Data Control Language (DCL)
GRANT , REVOKE
The Transaction Control (TCL)
COMMIT , ROLLBACK
DDL, DML, DCL, TCL
پايگاه داده غيرتوزيع شده
پايگاه داده توزيع شده
Microsoft محصول شرکت
Oracle Corporation محصول شرکت
IBM محصول شرکت
SUN Microsystems محصول شرکت
SQL Server
Oracle
DB2
MySQL
مهمترين سيستمهاي مديريت بانک اطالعاتي
SQL Serverدر آغاز محصول شرکت Sybaseبود و تا قبل از نسخه Sybase SQL Server ، 7
ناميده مي شد و بازاريابي و فروش آن به عهده شرکت Microsoftبود .
اولين نسخه SQL Serverتحت عنوان SQL Server 1.0 for OS/2در سال 1989پديد آمد.
اين نسخه از SQL Serverدر واقع نسخه جديدي نبود بلکه در اصل Sybase SQL Server
3.0 on Unix, and VMSبراي OS/2بود.
اولين نسخه SQL Serverبراي Windows NTدر سال 1992به بازار آمد.
از ، 1994شرکتهاي مايکروسافت و سايبيس جداگانه به توليد و فروش SQL Server
پرداخنتد که مايکروسافت نام تجاري SQL Serverرا ادامه داد ،اما سايبيس نام تجاري
Adaptive Server Enterpriseرا براي محصول خود برگزيد.
SQL Server 7.0نخستين بانک اطالعاتي از اين سري بود که داراي رابط گرافيک براي
طراحي بود ،پيش از آن طراحي بانکهاي اطالعاتي در محيطي Text Basedانجام مي شد.
SQL Server 4.21 for Windows NT | Year: 1993
SQL Server 6.0, codenamed SQL95 | Year: 1995
SQL Server 6.5, codenamed Hydra | Year: 1996
SQL Server 7.0, codenamed Sphinx | Year: 1999
SQL Server 7.0 OLAP, codenamed Plato | Year: 1999
SQL Server 2000 32-bit, codenamed Shiloh (version 8.0) | Year: 2000
◦ Standard Edition
◦ Enterprise Edition
◦ Developer Edition
◦ Evaluation Edition
SQL Server 2000 64-bit, codenamed Liberty | Year: 2003
SQL Server 2005, codenamed Yukon (version 9.0) | Year: 2005
SQL Server next release is codenamed Katmai | Year: 2008
Main SQL Server 2005 Editions :
•Express Edition *
•Workgroup Edition *
•Standard Edition **
•Enterprise Edition **
Other Editions :
•Developers Edition *
•Mobile Edition ***
•* All Windows Expect for Windows 98 or lower
•** Windows Server Family
•*** Windows Mobile Edition
DataBase Engine
Replication
Analysis Services
Integration Services
Reporting Services
Notification Services
Service Broker
Full Text Search
Workstation & Client Tools
SQL Server Profiler
SQL Server Tuning
Installing and Configuring SQL Server 2005
Implementing High Availability and Disaster Recovery
Supporting Data Consumers
Maintaining Databases
Monitoring and Troubleshooting SQL Server Performance
Creating and Implementing Database Objects
Installing and Configuring SQL Server 2005
• Install SQL Server 2005.
• Configure SQL Server 2005 instances and databases.
• Configure SQL Server security.
• Configure linked servers by using SQL Server Management Studio (SSMS).
Implementing High Availability and Disaster Recovery
•Implement database mirroring.
•Implement log shipping.
•Manage database snapshots.
Supporting Data Consumers
•Retrieve data to support ad hoc and recurring queries.
•Manipulate relational data.
•Manage XML data.
•Implement an HTTP endpoint.
•Implement Service Broker components.
•Import and export data from a file.
•Manage replication.
Maintaining Databases
•Implement and maintain SQL Server Agent jobs.
•Manage databases by using Transact-SQL.
•Back up a database.
•Restore a database.
•Move a database between servers.
Monitoring and Troubleshooting SQL Server
Performance
•Gather performance and optimization data by using the SQL Server Profiler.
•Gather performance and optimization data by using the Database Engine Tuning
Advisor.
•Monitor and resolve blocks and deadlocks.
•Diagnose and resolve database server errors.
•Monitor SQL Server Agent job history.
•Gather performance and optimization data by using DMVs.
Creating and Implementing Database Objects
•Implement a table.
•Implement a view.
•Implement triggers.
•Implement functions.
•Implement stored procedures.
•Implement constraints.
•Implement indexes.
•Create user-defined types.