به کلاس SQL Server 2005 خوش آمديد
description
Transcript of به کلاس SQL Server 2005 خوش آمديد
![Page 1: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/1.jpg)
SQL Server 2005به کالس خوش آمديد
Exam : 70-431Microsoft SQL Server 2005 - Implementation and Maintenance
![Page 2: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/2.jpg)
مفاهيم مجموع�ه اطالع�ات ذخ�يره ش�ده و س�ازماندهي ش�ده ب�ه منظ�ور پايه
تحقق اهدافي خاص بانک اطالعاتي ناميده مي شود.
Data Base بانک اطالعاتي
DBMS سيستم مديريت بانک اطالعاتي
انواع مدل داده اي
DDL, DML, DCL, TCL
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
![Page 3: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/3.jpg)
مدل هاي توزيع بانک اطالعاتي
![Page 4: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/4.jpg)
پايگاه داده غيرتوزيع شده
![Page 5: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/5.jpg)
پايگاه داده توزيع شده
![Page 6: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/6.jpg)
مهمترين سيستمهاي مديريت بانک اطالعاتي
محصول شرکتMicrosoft
محصول شرکتOracle Corporation
محصول شرکتIBM
محصول شرکتSUN Microsystems
SQL Server
Oracle
DB2
MySQL
![Page 7: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/7.jpg)
مابين ها هزينه و SQL ServerمقايسهOracle
![Page 8: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/8.jpg)
SQL Serverتاريخچه SQL Server در آغ�از محص�ول ش�رکت Sybase 7 ب�ود و ت�ا قب�ل از نس�خه ، Sybase SQL
Server ناميده مي شد و بازاريابي و فروش آن به عهده شرکت Microsoft. بود
پدي�د 1989 در س�ال SQL Server 1.0 for OS/2 تحت عن�وان SQL Serverاولين نس�خه
Sybase SQL در واق�ع نس�خه جدي�دي نب�ود بلک�ه در اص�ل SQL Serverآم�د. اين نس�خه از
Server 3.0 on Unix, and VMS براي OS/2.بود
به بازار آمد.1992 در سال Windows NT براي SQL Serverاولين نسخه
و ف�روش 1994از تولي�د ب�ه مايکروس�افت و س�ايبيس جداگان�ه ، ش�رکتهاي SQL Server
را ادام�ه داد ، ام�ا س�ايبيس ن�ام تج�اري SQL Serverپرداخنت�د ک�ه مايکروس�افت ن�ام تج�اري
Adaptive Server Enterprise.را براي محصول خود برگزيد
SQL Server 7.0 نخس�تين بان�ک اطالع�اتي از اين س�ري ب�ود ک�ه داراي راب�ط گرافي�ک ب�راي
انجام مي شد.Text Basedطراحي بود ، پيش از آن طراحي بانکهاي اطالعاتي در محيطي
![Page 9: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/9.jpg)
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
![Page 10: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/10.jpg)
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
![Page 11: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/11.jpg)
Scalability and Performance
![Page 12: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/12.jpg)
High Availability
![Page 13: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/13.jpg)
High Availability
![Page 14: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/14.jpg)
Manageability
![Page 15: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/15.jpg)
Security
![Page 16: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/16.jpg)
Programmability
![Page 17: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/17.jpg)
Integration and Interoperability
![Page 18: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/18.jpg)
Main Parts Of SQL Server 2005
DataBase EngineReplicationAnalysis ServicesIntegration ServicesReporting ServicesNotification ServicesService BrokerFull Text SearchWorkstation & Client ToolsSQL Server ProfilerSQL Server Tuning
![Page 19: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/19.jpg)
راهنماي اين دورهInstalling and Configuring SQL Server 2005Implementing High Availability and Disaster Recovery Supporting Data Consumers Maintaining Databases Monitoring and Troubleshooting SQL Server Performance Creating and Implementing Database Objects
![Page 20: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/20.jpg)
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).
![Page 21: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/21.jpg)
Implementing High Availability and Disaster Recovery •Implement database mirroring. •Implement log shipping. •Manage database snapshots.
![Page 22: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/22.jpg)
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.
![Page 23: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/23.jpg)
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.
![Page 24: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/24.jpg)
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.
![Page 25: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/25.jpg)
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.
![Page 26: به کلاس SQL Server 2005 خوش آمديد](https://reader038.fdocument.pub/reader038/viewer/2022103006/56814202550346895dade21c/html5/thumbnails/26.jpg)
Q & R