Header Ads

Khóa học database với ngôn ngữ SQL Server

Khóa học database với ngôn ngữ SQL Server

P01 Introduction to SQL Server 2005 1:30:32
L01 SQL SERVER OVERVIEW 32:15
L01_T01 Understanding Client Server Architecture
L01_T02 Introducing the Tools
L01_T03 Selecting an Addition
L01_T04 Creating Sample Databases
L02 USING MANAGEMENT STUDIO 22:44
L02_T01 Arranging the Workspace
L02_T02 Registering Servers
L02_T03 Explaining Items in the Object Explorer
L02_T04 Explaining the Database Properties Dialog
L02_T05 Explaining the Columns Properties Dialog
L02_T06 Continuing with Object Explorer Items
L02_T07 Using the Query Editor
L03 DESIGNING RELATIONAL DATABASES 35:33
L03_T01 Understanding Normalization
L03_T02 Discovering Patterns
L03_T03 Avoiding Over Complexity
L03_T04 Managing Optional Data
L03_T05 Creating Physical Keys
L03_T06 Using the Database Diagrammer Tool
L03_T07 Final Comments
P02 Selecting Data 3:14:29
L01 WORKING WITH SINGLE TABLE QUERIES 42:28
L01_T01 Understanding Query Flow
L01_T02 Filtering Data with the Where Clause
L01_T03 Columns, Expressions & Scalar Functions
L01_T04 Using Case Expressions
L01_T05 Working with Nulls & Coalesce
L01_T06 Selecting Environment Functions
L01_T07 Working with Dates & Times
L01_T08 Parsing Strings
L01_T09 Converting Data
L01_T10 Sorting Data
L01_T11 Topping Off the Query with Predicates
L02 MERGING DATA WITH JOINS & UNIONS 24:42
L02_T01 Working with Inner Joins
L02_T02 Using Left Outer Joins
L02_T03 Multiplying Data with Cross Joins
L02_T04 Referencing Self-Joins
L02_T05 Working with Complex Joins
L02_T06 Finding the Set Difference
L02_T07 Stacking Data with Unions
L03 WORKING WITH SUBQUERIES 19:05
L03_T01 Using Subqueries as Expressions
L03_T02 Including Subqueries as Lists
L03_T03 Adding Subqueries as Derived Tables
L03_T04 Working with Correlated Subqueries
L03_T05 Solving for X with Relations Division
L04 AGGREGATING DATA 34:41
L04_T01 Using the New Windowing Functions
L04_T02 Using Aggregate Functions
L04_T03 Grouping a Data Set
L04_T04 Nesting Aggregations
L04_T05 Filtering Groups & Adding Grand Totals
L04_T06 Generating Cross Tab Tables (Pivot)
L04_T07 Calculating Cumulative Sums
L05 USING FULL-TEXT SEARCH 14:19
L05_T01 Creating a Full-Text Index
L05_T02 Searching for Words
L05_T03 Using a Fuzzy Search to Search for Phrases
L06 SELECTING DATA THROUGH VIEWS 11:26
L06_T01 Creating Views
L06_T02 Preventing Disappearing Rows
L06_T03 Protecting from Schema Changes
L06_T04 Nesting Views
L07 DISTRIBUTED QUERIES 18:28
L07_T01 Linking to External Data Sources
L07_T02 Executing Distributed Queries
L07_T03 Looking at Where the Work Takes Place
L07_T04 Using Pass Through Queries
L07_T05 Controlling Distributed Transactions
L08 MODIFYING DATA 29:20
L08_T01 Inserting Data
L08_T02 Updating Data
L08_T03 Deleting Data
L08_T04 Using the Output Clause
L08_T05Final Comments & Credits
__________________________________________________________________
P03 Developing Solutions 3:33:01
L01 T-SQL & STORED PROCEDURES 1:08:36
L01_T01 Introducing T-SQL
L01_T02 Working with Variables
L01_T03 Controlling Procedural Flow
L01_T04 Examining SQL Server with Code
L01_T05 Using Temp Tables
L01_T06 Developing Dynamic SQL
L01_T07 Introducing Stored Procedures
L01_T08 Passing Parameters
L01_T09 Returning Parameters
L01_T10 Working with a Cursor
L01_T11 Handling Errors
L01_T12Explaining the Raise Error
L01_T13 Controlling Transactions
L02 TRIGGERS & AUDIT TRAILS 31:20
L02_T01 Introducing After Triggers
L02_T02 Using “Instead of” Trigger
L02_T03 Disabling Triggers
L02_T04 Using the Update ( ) Function
L02_T05 Selecting Transaction Data
L02_T06 Nesting & Recursion
L02_T07 Enforcing Complex RI
L02_T08 Auditing Data Changes
L03 USER-DEFINED FUNCTIONS 26:52
L03_T01 Creating Scalar Functions
L03_T02 Working with Inline Table-Valued Functions
L03_T03 Using Multi-Statement Table-Valued UDFs
L03_T04 Navigating a Hierarchy
L03_T05 Having Fun with Apply
L03_T06 Exploring Functions in Nordic
L04 INDEXING FOR PERFORMANCE 31:38
L04_T01Introducing Indexes
L04_T02 Creating Indexes
L04_T03 Examinging Query Execution Plans, Pt. 1
L04_T04 Examinging Query Execution Plans, Pt. 2
L05 TRANSACTIONS, LOCKING & BLOCKING 33:00
L05_T01 Introducing ACID
L05_T02 Understanding Transactional Faults
L05_T03 Stepping through a Transaction
L05_T04 Exploring Locks
L05_T05 Working with Locks
L05_T06 Viewing Deadlocks
L05_T07 Using Snapshot Isolation
L06 INTRODUCTION TO OPTIMIZATION THEORY 21:35
L06_T01 Deconstructing the Database System
L06_T02 Walking through Optimization Theory
L06_T03 Optimization Theory Continued
L06_T04 Final Comments & Credits

Download

No comments