SQL Server 2005 Exam 70 431 Microsoft SQL
- Slides: 26
ﺧﻮﺵ SQL Server 2005 ﺑﻪ کﻼﺱ آﻤﺪﻳﺪ Exam : 70 -431 Microsoft SQL Server 2005 - Implementation and Maintenance
ﻣﺠﻤﻮﻋﻪ ﺍﻃﻼﻋﺎﺕ ﺫﺧﻴﺮﻩ ﺷﺪﻩ ﻭ ﺳﺎﺯﻣﺎﻧﺪﻫﻲ ﺷﺪﻩ ﺑﻪ ﻣﻨﻈﻮﺭ ﺗﺤﻘﻖ ﺍﻫﺪﺍﻓﻲ ﺧﺎﺹ ﺑﺎﻧک ﺍﻃﻼﻋﺎﺗﻲ . ﻧﺎﻣﻴﺪﻩ ﻣﻲ ﺷﻮﺩ ﻣﺠﻤﻮﻋﻪ ﺍﻱ ﻧﺮﻡ ﺍﻓﺰﺍﺭﻱ – ﺳﺨﺖ ﺍﻓﺰﺍﺭﻱ ﺍﺳﺖ کﻪ ﺍﻳﺠﺎﺩ ﻭ ﻣﺪﻳﺮﻳﺖ ﺑﺎﻧک ﺍﻃﻼﻋﺎﺗﻲ ﺑﻪ ﻋﻬﺪﻩ آﻦ . ﻧﻬﺎﺩﻩ ﺷﺪﻩ HDBMS : Hierarchical Data. Base Management System (DBMS, DB) NDBMS : Network Data. Base Management System (DB) RDBMS : Relational Data. Base 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
SQL Server ﻧﺴﺨﻪ ﻫﺎﻱ ﻣﺨﺘﻠﻒ SQL Server 4. 21 for Windows NT | Year: 1993 SQL Server 6. 0, codenamed SQL 95 | 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
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
Scalability and Performance
High Availability
High Availability
Manageability
Security
Programmability
Integration and Interoperability
Main Parts Of SQL Server 2005 Data. Base 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.
Q&R
- Microsoft sql server 2005 analysis services
- Microsoft sql server 2005 management studio express
- How to monitor log shipping in sql server 2005
- Sql server 2005 performance
- Sql server 2005 sp
- Dts vs ssis
- Sql server 2005 encryption
- Sql server 2005 report builder download
- Change data capture sql server 2005
- Ssis sql server 2005
- Sql server ml services
- Microsoft sql server introduction
- Sql server security best practices
- Microsoft sql server data virtualization
- Sql server parallel data warehouse
- Xxxdbo
- Sql server kerberos configuration manager
- Azure sql edge raspberry pi
- Sql server 2008 auditing best practices
- Sql server compact edition
- Visual studio 2005 team
- Bio 431
- Me 431
- Hdl buspro setup tool 2
- Eee 431
- Eee 431
- Eee 431