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.
Objectives:
Audience:
Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology.
1. Using Subqueries to Perform Advanced Querying
2 . Manipulating Table Data
3. Manipulating the Table Structure
4. Working with Views
5. Indexing Data
6. Managing Transactions
To ensure your success, we recommend you first take the following Logical Operations courses, or have equivalent skills and knowledge:
Course Comments
This course expands on SQL Level 1: Fundamentals of Querying by adding insert, update and delete SQL statements. The course also examines the uses of indexes and transactions.
The SQL information is ANSI standards and can be applied to any RDBMS, including DB2, Oracle, SQL/Server, Sybase, etc.
You may also be interested in our Microsoft Querying Class: Writing Analytical Queries for Business Intelligence- Course 55232
Upcoming Classes
April 30, 2024
May 13, 2024
May 30, 2024
June 11, 2024
June 20, 2024
July 12, 2024
August 19, 2024
September 05, 2024