MOAC Labs Online available for purchase
Wiley offers a three-year subscription to DreamSpark Premium, which provides SQL Server 2012 software available for students, instructors, and labs
MeasureUP Practice Certification exams available for purchase
Sprache
Verlagsort
Zielgruppe
Für höhere Schule und Studium
Für Beruf und Forschung
ISBN-13
978-1-118-44165-7 (9781118441657)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
Part 1: Preparing for the Course Lesson 1: Working with SQL Server 2012 Tools Lesson 2: Understanding Processing Sequences Lesson 3: Introducing T-SQL Query Syntax Lesson 4: Understanding the Role of the Query Optimizer Lesson 5: Creating Scripts Lesson 6: Understanding Data Types Part 2: Programming Database Object Queries Lesson 7: Writing Simple SELECT Statements Lesson 8: Querying Multiple Tables Lesson 9: Sorting and Filtering Data Lesson 10: Using Functions Lesson 11: Grouping and Aggregating Data Lesson 12: Using Subqueries Lesson 13: Using Derived Data Structures Lesson 14: Using Set Operators Lesson 15: Controlling with Windows Lesson 16: Pivoting and Grouping SETS Lesson 17 Creating and Working with Full-Text Data Lesson 18: Querying XML Data Part 3: Creating Database Objects Lesson 19: Generating Databases Lesson 20: Generating Tables Lesson 21: Creating Views Lesson 22: Generating Stored Procedures Lesson 23: Generating Functions Lesson 24: Generating Triggers Lesson 25: Programming Access to Database Objects Part 4: Managing System Efficiencies Lesson 26: Using Management Functions Lesson 27: Controlling Transactions and Locks
