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