1 / 26

به کلاس SQL Server 2005 خوش آمديد

به کلاس SQL Server 2005 خوش آمديد. Exam : 70-431 Microsoft SQL Server 2005 - Implementation and Maintenance. مفاهيم پايه. مجموعه اي نرم افزاري – سخت افزاري است که ايجاد و مديريت بانک اطلاعاتي به عهده آن نهاده شده. HDBMS : Hierarchical DataBase Management System (DBMS, DB)

kaelem
Download Presentation

به کلاس SQL Server 2005 خوش آمديد

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. به کلاس SQL Server 2005 خوش آمديد Exam : 70-431 Microsoft SQL Server 2005 - Implementation and Maintenance

  2. مفاهيم پايه مجموعه اي نرم افزاري – سخت افزاري است که ايجاد و مديريت بانک اطلاعاتي به عهده آن نهاده شده . 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) مجموعه اطلاعات ذخيره شده و سازماندهي شده به منظور تحقق اهدافي خاص بانک اطلاعاتي ناميده مي شود. 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

  3. مدل هاي توزيع بانک اطلاعاتي

  4. پايگاه داده غيرتوزيع شده

  5. پايگاه داده توزيع شده

  6. مهمترين سيستمهاي مديريت بانک اطلاعاتي SQL Server Oracle • محصول شرکت Microsoft • محصول شرکت Oracle Corporation • محصول شرکت IBM • محصول شرکت SUN Microsystems DB2 MySQL

  7. مقايسه هزينه ها مابين SQL Server و Oracle

  8. تاريخچه SQL Server SQL Server در آغاز محصول شرکتSybase بود و تا قبل از نسخه 7، Sybase SQL Server ناميده مي شد و بازاريابي و فروش آن به عهده شرکت 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 انجام مي شد.

  9. نسخه هاي مختلف SQL Server • 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

  10. SQL Server 2005 Editions • 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

  11. Scalability and Performance

  12. High Availability

  13. High Availability

  14. Manageability

  15. Security

  16. Programmability

  17. Integration and Interoperability

  18. Main Parts Of SQL Server 2005 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

  19. راهنماي اين دوره 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

  20. 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).

  21. Implementing High Availability and Disaster Recovery Implement database mirroring. Implement log shipping. Manage database snapshots.

  22. 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.

  23. 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.

  24. 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.

  25. 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.

  26. Q & R

More Related