|
Course ID: 5374
| Course Duration: 1 Day
|
|
Course Dates:
|
| |
|
| |
SQL Querying - Level 2 Advanced Querying Training Class
Course ID: 5374
|
|
| |
|
|
| |
|
|
| |
SQL Querying - Level 2 Advanced Querying Training Seminar
Overview:
In this course, students create advanced SQL queries, and manipulate and index tables.
Who Should Attend:
Students should have basic introductory SQL skills, basic computer skills and be familiar with concepts related to database structure and terminology.
At Course Completion:
Upon successful completion of this course, students will be able to: - 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.
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
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
| |
|
| |
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
SQL Querying - Level 1 Fundamentals of Querying
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
|
| |
SQL Querying - Level 2 Advanced Querying Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 5374
| Course Duration: 1 Day
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
 Gift card when you register today!
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request
More Info |
|
Print/Fax
Register |
|
|
| |
|
|
| |
|
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|
| |
|
|
|
| |
|
|