Érdekel

Kíváncsi vagy a tananyagunkra? Fedezd fel vállalati e-learning megoldásainkat, és szerezd meg a hozzáférést több száz tananyaghoz, hogy korlátlanul fejleszthesd tudásodat!

Érdekel

  • Változatos témák, tanulási útvonalak
  • Érd el tananyagainkat bárhonnan, bármikor
  • Tanulj első kézből a területükön elismert előadóktól

Developing a Microsoft SQL Server 2008/2012 Database

0
(0)
15 óra
Haladó

  • Overview: Developing Microsoft SQL Server 2012 Databases (10776)

  • Overview: Introduction to SQL Server 2012 and its Toolset
  • Lesson 1: Introduction to the SQL Server Platform
  • Lesson 2: Working with SQL Server Tools
  • Lesson 3: Configuring SQL Server Services
  • Lab 1: Introduction to SQL Server and its Toolset

  • Overview: Working with Data Types
  • Lesson 1: Using Data Types
  • Lesson 2: Working with Character Data
  • Lesson 3: Converting Data Types
  • Lesson 4: Working with Specialized Data Types
  • Lab 2: Working with Data Types

  • Overview: Designing and Implementing Tables
  • Lesson 1: Designing Tables
  • Lesson 2: Working with Schemas
  • Lesson 3: Creating and Altering Tables
  • Lab 3: Designing and Implementing Tables

  • Overview: Ensuring Data Integrity through Constraints
  • Lesson 1: Enforcing Data Integrity
  • Lesson 2: Implementing Domain Integrity
  • Lesson 3: Implementing Entity and Referential Integrity
  • Lab 4: Ensuring Data Integrity through Constraints

  • Overview: Planning for SQL Server 2012 Indexing
  • Lesson 1: Core Indexing Concepts
  • Lesson 2: Data Types and Indexes
  • Lesson 3: Single Column and Composite Indexes
  • Lab 5: Planning for SQL Server Indexing

  • Overview: Implementing Table Structures in SQL Server 2012
  • Lesson 1: SQL Server Table Structures
  • Lesson 2: Working with Clustered Indexes
  • Lesson 3: Designing Effective Clustered Indexes
  • Lab 6: Implementing Table Structures in SQL Server

  • Overview: Reading SQL Server 2012 Execution Plans
  • Lesson 1: Execution Plan Core Concepts
  • Lesson 2: Common Execution Plan Elements
  • Lesson 3: Working with Execution Plans
  • Lab 7: Reading SQL Server Execution Plans

  • Overview: Improving Performance through Nonclustered Indexes
  • Lesson 1: Designing Effective Nonclustered Indexes
  • Lesson 2: Implementing Nonclustered Indexes
  • Lesson 3: Tracing and Tuning Queries
  • Lab 8: Improving Performance through Nonclustered Indexes

  • Overview: Designing and Implementing Views
  • Lesson 1: Introduction to Views
  • Lesson 2: Creating and Managing Views
  • Lesson 3: Performance Considerations for Views
  • Lab 9: Designing and Implementing Views

  • Overview: Designing and Implementing Stored Procedures
  • Lesson 1: Introduction to Stored Procedures
  • Lesson 2: Working With Stored Procedures
  • Lesson 3: Implementing Parameterized Stored Procedures
  • Lesson 4: Controlling Execution Context
  • Lab 10: Designing and Implementing Stored Procedures

  • Overview: Merging Data and Passing Tables
  • Lesson 1: Using the MERGE Statement
  • Lesson 2: Implementing TABLE Types
  • Lesson 3: Using TABLE Types As Parameters
  • Lab 11: Passing Tables and Merging Data

  • Overview: Designing and Implementing User-Defined Functions
  • Lesson 1: Overview of Functions
  • Lesson 2: Designing and Implementing Scalar Functions
  • Lesson 3: Designing and Implementing Table-valued Functions
  • Lesson 4: Considerations for Implementing Functions
  • Lesson 5: Alternatives to Functions
  • Lab 12: Designing and Implementing User-defined Functions

  • Overview: Creating Highly Concurrent SQL Server 2012 Applications
  • Lesson 1: Introduction to Transactions
  • Lesson 2: Introduction to Locks
  • Lesson 3: Management of Locking
  • Lesson 4: Transaction Isolation Levels
  • Lab 13: Creating Highly Concurrent SQL Server Applications

  • Overview: Handling Errors in T-SQL Code
  • Lesson 1: Understanding T-SQL Error Handling
  • Lesson 2: Implementing T-SQL Error Handling
  • Lesson 3: Implementing Structured Exception Handling
  • Lab 14: Handling Errors in T-SQL Code

  • Overview: Responding to Data Manipulation via Triggers
  • Lesson 1: Designing DML Triggers
  • Lesson 2: Implementing DML Triggers
  • Lesson 3: Advanced Trigger Concepts
  • Lab 15: Responding to Data Manipulation via Triggers

  • Overview Implementing Managed Code in SQL Server 2012
  • Lesson 1: Introduction to SQL CLR Integration
  • Lesson 2: Importing and Cataloging Assemblies
  • Lesson 3: Implementing SQL CLR Integration
  • Lab 16: Implementing Managed Code in SQL Server

  • Overview: Storing XML Data in SQL Server 2012
  • Lesson 1: Introduction to XML and XML Schemas
  • Lesson 2: Storing XML Data and Schemas in SQL Server
  • Lesson 3: Implementing XML Indexes
  • Lab 17: Storing XML Data in SQL Server

  • Overview: Querying XML Data in SQL Server 2012
  • Lesson 1: Using the T-SQL FOR XML Statement
  • Lesson 2: Getting Started with XQuery
  • Lesson 3: Shredding XML
  • Lab 18: Querying XML Data in SQL Server

  • Overview: Working with SQL Server 2012 Spatial Data
  • Lesson 1: Introduction to Spatial Data
  • Lesson 2: Working with SQL Server Spatial Data Types
  • Lesson 3: Using Spatial Data in Applications
  • Lab 19: Working with SQL Server Spatial Data

  • Overview: Working with Full-Text Indexes and Queries
  • Lesson 1: Introduction to Full-Text Indexing
  • Lesson 2: Implementing Full-Text Indexes in SQL Server
  • Lesson 3: Working with Full-Text Queries
  • Lab 20: Working with Full-Text Indexes and Queries

  • Bonus 1: SQL Azure

Az oktatóról

Árva Gábor

Mások ezeket választották