|
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
|
|
| |
|
|
|
| |
| |
|
|
|
|
| |
|
|
|
| |

|
|