SQL Querying - Level 2 Advanced Querying هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

In this course, students will learn how to identify and use advanced querying techniques. You may perform tasks such as modifying the structure of a table: inserting, updating, deleting data and indexing tables to optimize query performance.

Course Outline

1 - Using Subqueries to Perform Advanced Querying

• Search Based on 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

2 - Manipulating Table Data

• Insert Data
• Modify and Delete Data

3 - Manipulating the Table Structure

• Create a Table
• Create a Table with Constraints
• Modify a Table's Structure
• Back Up Tables
• Delete Tables

4 - Working with Views

• Create a View
• Manipulate Data in Views
• Create Aliases
• Modify and Delete Views

5 - Indexing Data

• Create Indexes 
• Drop Indexes

6 - Managing Transactions

• Create Transactions 
• Commit Transactions

Target Audience: Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology.