SQL Advanced
Duration
One Day
Course Content
This class will be taught using Server 2005
Lesson 1: Advanced Querying Using Subqueries
- Search Based on an Unknown Valuez
- Search Based on Multiple Unknown Valuesz
- Compare a Value with Unknown Values
- Search Based on the Existence of Records
- Generate Output Using Correlated Subqueries
- Filter Grouped Data Within Subqueries
- Perform Multiple-Level Subqueries
Lesson 2: Manipulating Table Data
- Insert Data
- Modify Data
- Delete Data
Lesson 3: Manipulating the Table Structure
- Create a Simple Table
- Create a Table with Constraints
- Add and Drop Table Columns
- Add and Drop Constraints
- Modify the Column Definition
- Back Up Tables
- Delete Tables
Lesson 4: Working with Views
- Create a View
- Manipulate Data in Views
- Create Aliases
- Modify and Drop Views
Lesson 5: Indexing Data
- Create Indices
- Drop Indices
Lesson 6: Managing Transactions
- Create Transactions
- Commit Transactions