learnex

 
SQL DEV
  • Course Contents 

    • SQL Server 2012 Overview
      • Version History
      • Feature Overview
      • Development Tools
    • Programming with Transact SQL (TSQL) - the Basics
      • Using Variables
      • Control of Flow Statements
      • Error Handling
      • Using Cursors

     

    • Programming Views
      • Creating Views
      • Updating Through Views
      • Indexed Views
    • Programming Stored Procedures
      • Creating Procedures
      • Passing Parameters

     

    • Programming User Defined Functions
      • Scalar, Inline Table and Multi-Statement
      • Data Manipulation in UDFs
      • Profiling UDFs
    • Programming Triggers
      • Trigger Syntax
      • Trigger Events
      • Enabling/Disabling Triggers
      • Nested Triggers

     

    • TSQL Enhancements
      • Ranking Functions
      • Recursive Queries
      • Relational Operators
    • Monitoring your SQL Server
      • Data Definition Language Triggers
      • DDL Event Notifications
      • Metadata Views

     

    • Messaging with the SQL Server 2012 Service Broker
      • Architecture Overview
      • Service Broker Example
      • Conversation Architecture
      • Conversation Process
      • Security
    • Using SQL Server 2012 Integration Services (SSIS)
      • Work Flow and Data Flow
      • Package Design
      • Deployment
      • Worked Examples

     

    • XML-Based Solutions
      • XML Data Type
      • FOR XML Enhancements
      • OPENXML Enhancements
      • XML Schemas
      • XML Indexes
    • Web Services and HTTP Endpoints
      • Web Services Architecture
      • Native HTTP Support
      • HTTP Endpoint Declaration
      • XML Input/Output Types

     

    • Programming with Notification Services
      • Notification Applications
      • Design Patterns
      • Instance and Configuration Files
    • Coding SQL Server with .NET
      • Enabling the .NET CLR
      • Creating Managed Stored Procedures
      • Creating Managed UDFs
      • Creating Managed Triggers

     

    • Building SQL 2012 Client Applications
      • ADO.NET Client Development
      • ADO.NET Enhancements
      • Asynchronous Support
      • Snapshot Isolation
      • Bulk Import
    • SQL Management Objects
      • Managing SQL Server
      • Managing Replication

     

    • Programming SQL 2012 Reporting Services
      • Report Manager
      • Report Server
      • Creating Reports
      • Deploying Reports
      • Viewing Reports