SQL - Level 2 Advanced Querying
Learning Method: Instructor led
Duration: 1 Day
Overview:
Because of various business conditions and requirements, in addition to querying the database, you may need to restructure and index tables. You may also need to manipulate the data in the tables. In this course, you will create advanced SQL queries, and manipulate and index tables.
- Code subqueries to generate query output.
- Manipulate table data by inserting, updating, and deleting records in a table.
- Create a simple table, create tables with constraints, modify the table structure, and delete tables.
- Create views, manipulate data through views, modify the view structure, and drop views.
- Create indexes on table columns and drop inefficient indexes.
Prerequisites:
To ensure your success, we recommend you first take the following Element K courses, or have equivalent skills and knowledge: SQL: Fundamentals of Querying and Windows XP: Introduction or Windows XP Professional: Level 1 and Windows XP Professional: Level 2
Who Should Attend:
Students should have basic introductory SQL skills, basic computer skills and be familiar with concepts related to database structure and terminology.
Lesson 1: Advanced Querying Using Subqueries
- Search Based on an Unknown Value
- Search Based on Multiple Unknown Values
- 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 or Drop Table Columns
- Add or Drop Constraints
- Modify the Column Definition
- Delete Tables
Lesson 4: Working with Views
- Create a View
- Manipulate Data in Views
- Modify and Drop Views
Lesson 5: Indexing Data
- Create Indexes
- Drop Indexes
