InstantForum.NET v4.1.4Persian Forum Network - Try to be a Professionalhttp://www.persianforum.net/noreply@persianforum.netچهار شنبه 17 مهر 1387 - 12:24 بعدازظهر20http://www.persianforum.net/Topic10835-8-1.aspxsalam age momkenee filhari toye site repaidshear gharar bedidi mamnon misham.. montazerre link fil ha hastam<DIV></DIV>شنبه 29 مهر 1385 - 3:27 صبحfarhadaminhttp://www.persianforum.net/Topic10835-8-1.aspx<font color="#000066">میتونی CD ها رو به صورت امانت به من قرض بدی ؟</font>چهار شنبه 19 مهر 1385 - 12:24 بعدازظهرfmh1http://www.persianforum.net/Topic10835-8-1.aspxاگه لینك rapidshare رو بزاری ممنون میشمچهار شنبه 19 مهر 1385 - 11:35 صبحamir_netmanhttp://www.persianforum.net/Topic10835-8-1.aspxآموزش کامل sql 2000 در 14 سی دی به صورت حرفه ای <br />میتونید اونو از rapidshare دانولد کنید - اگه کسی هم امکان دانلود نداره به من پیغام بده تا سی دی هارو بهش بدم.<br />developer_reza@yahoo.com<br /><br />سرفصل های اونم از قرار زیره:<br /><br />MODULE 1<br /><br />SQL Server Tour <br />SQL Server Editions <br />Graphical Tools <br />Exploring the Enterprise Manager <br />Working with SQL Server Books Online <br /><br />Installing SQL Server <br />Multiple Instances <br />Installing an Instance of SQL Server <br />Configuring the Server <br /><br />Designing and Creating a Database <br />Relational Database Design Principles <br /><br />MODULE 2<br /><br />Designing and Creating a Database (continued) <br />Implementing the Design <br /><br />Basic Querying <br />Introduction to the Query Analyzer <br />Retrieving Data <br /><br />MODULE 3<br /><br />Basic Querying (continued) <br />Joining Tables <br /><br />Action Queries <br />Modifying Data <br />Inserting Data <br />Updating Data <br />Deleting Data <br /><br />MODULE 4<br /><br />Using the Query Analyzer <br />Query Analyzer Features <br />The File Menu Items <br />The Edit Menu <br />Query Menu Items <br />Tools Menu Items <br />Window Menu Items <br />Help Menu Items <br /><br />Programming With Transact-SQL <br />Overview of Transact-SQL <br />Using Built-In Functions <br /><br />MODULE 5<br /><br />Programming With Transact-SQL (continued) <br />Control of Flow <br />Error Handling <br /><br />Transaction Processing <br />Transactions <br />Working with Locks <br />Monitoring Processes and Locks <br />Transaction Isolation <br />Blocking and Deadlocks <br /><br />Creating Views <br />What is a View? <br /><br />MODULE 6<br /><br />Creating Views (continued) <br />Creating Views <br />Updating Views <br /><br />Backups and Maintenance <br />Creating a Backup Strategy <br />Implementing Backups <br />Restoring from a Backup <br />The Database Maintenance Plan Wizard <br /><br />Stored Procedures and Triggers <br />Building Stored Procedures <br /><br />MODULE 7<br /><br />Stored Procedures and Triggers (continued) <br />Building Stored Procedures (continued) <br />Building Triggers <br />Using INSTEAD OF Triggers <br /><br />User-Defined Functions <br />User-Defined Functions in SQL Server 2000 <br />Scalar Functions <br />Inline Table-Valued Functions <br />Multi-Statement Table-Valued Functions <br />Functions, Views, and Stored Procedures <br /><br />MODULE 8<br /><br />Advanced Queries and Linked Servers <br />Dynamic SQL <br />Transact-SQL Cursors <br />Handling Large Data Sets <br />Distributed Queries <br /><br />Security <br />Security Overview <br />Authentication <br />Understanding Roles <br />Assigning Permissions <br /><br />MODULE 9<br /><br />Security (continued) <br />Application Roles <br /><br />Monitoring, Tuning, and Configuration <br />Evaluating Performance <br />Monitoring with SQL Server Profiler <br />Tuning Queries <br />Working with Indexes <br />Indexed Views <br />Using the Index Tuning Wizard <br />Data Caching <br />The System Monitor <br /><br />MODULE 10<br /><br />Using System Objects <br />Exploring System Objects <br />DBCC <br /><br />Automating Administration with SQL Agent <br />Configuring SQL Server Agent <br />Operators <br />Jobs <br />Alerts <br />Create an Alert <br /><br />Data Transformation Services (DTS) <br />Introduction <br />The DTS Import/Export Wizard <br /><br />MODULE 11<br /><br />Data Transformation Services (DTS) (continued) <br />DTS Packages <br />Controlling DTS Workflow <br /><br />Replication <br />Introduction to Replication <br />Implementing Replication <br /><br />Publish SQL Server Data to the Web <br />Publishing Data to the Web <br />The Web Assistant Wizard <br />The SQL Server Web Stored Procedures <br />Scheduling Web Jobs <br /><br />XML Features, Part I <br />XML Fundamentals <br /><br />MODULE 12<br /><br />XML Features, Part I (continued) <br />Generating XML from SQL Queries with FOR XML <br />Using FOR XML Explicit <br />Setting Up IIS for SQL Server <br />Accessing SQL Server Using a URL <br /><br /> XML Features, Part II <br />Creating XML Views with Annotated Schemas <br />Using Xpath to Retrieve SQL Server Data Directly <br />Using OpenXML to Work with XML Documents in Transact-SQL <br /><br />MODULE 13<br /><br />XML Features, Part II (continued) <br />Using Updategrams <br /><br />Full Text Search <br />What is Full-Text Search? <br />Configuring Full-Text Search <br />Writing Full-Text Queries <br />Using Full-Text Search with Documents Stored in SQL Server <br /><br />MODULE 14<br /><br />Analysis Services <br />Understanding Analysis Services <br />Building a Simple Cube <br />Browsing Data from a Cube <br />Exploring MDX <br />Data Mining <br /><br />English Query <br />Overview of English Query <br />Before You Start – Preparing Your Database <br />Creating and English Query Application <br />Deploying an English Query Application<br /><br /> چهار شنبه 19 مهر 1385 - 6:53 صبحreza_pc