Eğitim İçerikleri
6232 - Implementing a Microsoft SQL Server 2008 Database
- Creating Databases and Database Files
- Creating Data Types and Tables
- Creating and Tuning Indexes
- Implementing Data Integrity by Using Constraints and Triggers
- Using XML
- Implementing Views
- Implementing Stored Procedures
- Implementing Functions
- Implementing Managed Code in the Database
- Managing Transactions and Locks
- Using Service Broker
http://www.microsoft.com/learning/en/us/Course.aspx?ID=6232A
2778 - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
- Getting Started with Databases and Transact-SQL in SQL Server 2008
- Querying and Filtering Data
- Grouping and Summarizing Data
- Joining Data from Multiple Tables
- Working with Subqueries
- Modifying Data in Tables
- Querying Metadata, XML, and Full-Text Indexes
- Using Programming Objects for Data Retrieval
- Using Advanced Querying Techniques
http://www.microsoft.com/learning/en/us/Course.aspx?ID=2778A
6231 - Maintaining a Microsoft SQL Server 2008 Database
- Installing and Configuring SQL Server
- Managing Databases and Files
- Disaster Recovery
- Managing Security
- Transferring Data
- Automating Administrative Tasks
- Implementing Replication
- Maintaining High Availability
- Monitoring SQL Server
- Troubleshooting and Performance Tuning
http://www.microsoft.com/learning/en/us/Course.aspx?ID=6231A
6234 - Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
- Introduction to Microsoft SQL Server Analysis Services
- Creating Multidimensional Analysis Solutions
- Working with Cubes and Dimensions
- Working with Measures and Measure Groups
- Querying Multidimensional Analysis Solutions
- Customizing Cube Functionality
- Deploying and Securing an Analysis Services Database
- Maintaining a Multidimensional Solution
- Introduction to Data Mining
http://www.microsoft.com/learning/en/us/Course.aspx?ID=6234A
6235 - Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
- Introduction to SQL Server 2008 Integration Services
- Developing Integration Services Solutions
- Implementing Control Flow
- Implementing Data Flow
- Implementing Logging
- Debugging and Error Handling
- Implementing Checkpoints and Transactions
- Configuring and Deploying Packages
- Managing and Securing Packages
http://www.microsoft.com/learning/en/us/Course.aspx?ID=6235A
6236 - Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
- Introduction to Microsoft SQL Server Reporting Services
- Authoring Basic Reports
- Enhancing Basic Reports
- Manipulating Data Sets
- Using Report Models
- Publishing and Executing Reports
- Using Subscriptions to Distribute Reports
- Administering Reporting Services
- Programming Reporting Services
http://www.microsoft.com/learning/en/us/Course.aspx?ID=6236A
10774a - Querying Microsoft SQL Server 2012
- Write SELECT queries
- Query multiple tables
- Use built-in functions
- Use subqueries
- Use set operators
- Implement error handling
- Implement transactions
- Use table expressions
- Sort and filter data
- Use window ranking, offset and aggregate functions
- Query SQL Server metadata
- Program with T-SQL
- Improve query performance
http://www.microsoft.com/learning/en-us/course.aspx?id=10774a