36072
SQL Querying Fundamentals - Part 2 Training
In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process.
Course Details
Duration
1 day
Prerequisites
No prior knowledge is presumed.
Target Audience
Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.
Skills Gained
- Use subqueries to generate query output.
- Manipulate table data by inserting, updating, and deleting records in a table.
- Manipulate the table structure.
- Create views, manipulate data through views, modify the view structure, and drop views.
- Create indices on table columns and drop inefficient indices.
- Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction.
Course Outline
- Using Subqueries to Perform Advanced Querying
- Manipulating Table Data
- Manipulating the Table Structure
- Working with Views
- Indexing Data
- Managing Transactions
