|
Formål:
At give deltageren viden om hvordan man skriver Transact-SQL mod SQL server 2008.
Forudsætninger:
Følgende kurser eller tilsvarende viden:
- SU-239 Database Design Grundkursus
- SU-240 SQL Programmering Grundkursus
- SU-241 SQL Programmering Videregående (fordel)
Beskrivelse:
På kurset lærer man om SQL og T-SQL.
Vi anbefaler at man ser på SU-242, som SuperUsers har meget gode erfaringer med.
Kontakt gerne SuperUsers på tlf. 4828 0706.
Lærebøger:
Microsoft Official Curriculum (MOC) materiale.
Varighed / Pris:
3 dage / 11.100,- kr. (ekskl. moms)
Videre forløb:
- MS-6232 Implementing a Microsoft SQL Server 2008 Database
|
Indhold:
- Getting Started with Databases and Transact-SQL in SQL Server 2008
- Overview of SQL Server 2008
- Overview of SQL Server Databases
- Overview of the SQL Language
- Syntax Elements of T-SQL
- Working with T-SQL Scripts
- Using T-SQL Querying Tools
- Querying and Filtering Data
- Using the SELECT Statement
- Filtering Data
- Working with NULL Values
- Formatting Result Sets
- Performance Considerations for Writing Queries
- Grouping and Summarizing Data
- Summarizing Data by Using Aggregate Functions
- Summarizing Grouped Data
- Ranking Grouped Data
- Creating Crosstab Queries
- Joining Data from Multiple Tables
- Querying Multiple Tables by Using Joins
- Applying Joins for Typical Reporting Needs
- Combining and Limiting Result Set
- Working with Subqueries
- Writing Basic Subqueries
- Writing Correlated Subqueries
- Comparing Subqueries with Joins and Temporary Tables
- Using Common Table Expressions
- Modifying Data in Tables
- Overview of Transactions
- Inserting Data into Tables
- Deleting Data from Tables
- Updating Data in Tables
- Querying Metadata, XML, and Full-Text Indexes
- Querying Metadata
- Overview of XML
- Querying XML Data
- Overview of Full-Text Indexes
- Querying Full-Text Indexes
- Using Programming Objects for Data Retrieval
- Encapsulating Expressions by Using User-Defined Functions
- Encapsulating Queries by Using Views
- Overview of Stored Procedures
- Writing Distributed Queries
- Using Advanced Querying Techniques
- Considerations for Querying Complex Data
- Querying Complex Table Structures
- Writing Efficient Queries
- Using Different Techniques for Complex Queries
- Maintaining Query Files
|
