MS SHAREPOINT

Introducing SharePoint Apps

• Understanding the new SharePoint app model
• Understanding SharePoint app model architecture
• Packaging and distributing apps
• Conclusion

Client-side Programming

• Introducing JavaScript for SharePoint developers
• Introducing jQuery for SharePoint developers
• Working with the CSOM
• Working with the REST API
• Conclusion

SharePoint App Security

• Reviewing the concepts of authentication and authorization
• Understanding SharePoint 2013 authentication
• Managing app permissions
• Establishing app identity by using OAuth
• Establishing app identity by using S2S trusts
• Conclusion

Developing SharePoint Apps

• Understanding app patterns
• Using the chrome control
• Calling across domains
• Going beyond the basics
• Conclusion

SQL SERVER

SQL Server 2005 & 2008 Overview

• Availability and Scalability Features
• Security Features
• Data Management Features
• Administration and Maintenance Features
• Development Features
• To enable SQLiMail
• Testing mail delivery

Installing SQL Server 2005 & 2008

• SQL Server 2005 & 2008 Editions
• Installing Microsoft SQL Server
• System Requirements
• Preparing for a SQL 2005 Installation
• Installation Checklist
• Setup Features
• Using the System Consistency Checker
• Component Install
• Unattended Installation
• Installation Sequence
• Installation Maintenance

Upgrading to SQL Server Management Studio

• Management Studio Windows
• Registered Servers
• Object Explorer
• Review Database Objects
• Modify Database Properties
• Create Database Scripts
• The Maintenance Plans Node
• Solution Explorer
• Query Editor
• Template Explorer
• Dynamic Help
• Upgrading to SQL Server Computer Manager
• SQL Server 2005 & 2008 Services node
• SQL Server 2005 & 2008 Network Configuration node
• SQL Server 2005 & 2008 Native Client Configuration node
• The SQLCMD Management Utility
• SQLCMD Syntax
• SQLCMD Variables
• Dedicated Administrative Connection
• SQL Server Management Studio SQLCMD Mode

Monitoring the Database Server

• Managing Metadata Views
• Metadata Storage
• System Views
• Information Schema
• Catalog Views
• Sys All
• Dynamic Management Views
• System Stored Procedures

Database and Index Maintenance

• Index Management
• New Index Features
• Creating Indexes
• Online Index Maintenance
• Parallel (multiple CPU) Index Operations
• Lock Options
• Included Columns in Indexes
• Partitioned Tables and Indexes
• XML Index Support
• Altering an Index
• Rebuilding an Index
• Reorganizing an Index
• Disabling an Index
• Dropping an Index
• Index Fragmentation
• Using the Database Tuning Advisor

Securing SQL Server 2005 & 2008

• Implementing Securable
• New Security Features
• Principals
• Securable
• Permissions
• Permission Types
• Managing Logins
• Managing Schemas
• Managing Users
• Schema Definition
• Using Schemas
• Managing Execution Context
• Managing Permissions
• Manage Server Permissions
• Manage Server-Scope Securable Permissions
• Manage Database Permissions
• Manage Database-Scope Securable Permissions
• Native Data Encryption
• Code and Module Signing

SQL Server Disaster Recovery

• Disaster Recovery
• SQL 2005 Disaster Recovery Feature
• Enhanced Features
• Database Snapshots
• Creating a Snapshot
• Common Snapshot Applications
• Undeleting table rows
• Undoing a table update
• Recovering a dropped object
• Backup and Restore
• Media Integrity Changes
• Recovering the MASTER Database
• Create a mirrored backup
• Restore from the backup mirror
• Create a snapshot
• Restore the snapshot data
• Automate the creation of daily snapshots

Database Availability

• SQL 2005 Data Availability
• Database Mirroring
• The Witness Server and Automatic Failover
• Configuring Database Mirroring
• Transaction Safety Level
• Operating Modes
• High Availability Operating Mode
• High Protection Operating Mode
• High Performance Operating Mode
• Monitoring Mirroring
• Database States for Database Mirroring
• Prepare the Servers
• Configure Mirroring
• Verify Principal and Mirror Access
• Execute the Mirror Failover
• Verify Mirror and Witness Status
• Terminating the Mirror Session

Replicating Information

• Replication Enhancements
• Stand-alone Replication Monitor
• Support for Oracle Publishing
• HTTP Synchronization for Merge Replication
• Subscriber Initialization
• Replicating DDL Statements
• Modified User Interface
• Replication Management Objects
• To Configure Publishing and Distribution
• Configuring Peer-to-Peer Replication
• Create a Publication
• Create a Subscription with RMO

SQL Server 2005 & 2008 Integration Services

• Creating the Database Objects
• Creating a Package Using Business Intelligence Studio
• Integration Services Project Template
• OLE DB Command object
• Column Mappings
• Adding a Data Viewer

Monitoring and Performance

• SQL Server Profiler
• Optimal Data Storage
• Diagnostic Tools
• Query Analyzer
• Database Engine Tuning Advisor
• Index Optimization
• Federated Database Servers
• Partitioned Indexes
• Lock Optimization
• Best Practices for Native XML Web Services