SQL Querying Advanced Training
Course Duration: 1 Day
This Course Covers Version(s): N/A
Available Delivery Methods
In this SQL Querying Advanced Training course, students will learn how to use subqueries; how to insert, modify and delete data using a SQL statement; how to create, backup and delete tables and how to work with views, indexes and transactions.
Upon successful completion of this course, students will be able to:
- Use subqueries to generate query output
- Manipulate table data by inserting and updating records in a table and deleting records from 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
- 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
- Manipulating Table Data
- Insert Data
- Modify and Delete Data
- Manipulating the Table Structure
- Create a Table
- Create a Table with Constraints
- Add and Drop Table Columns
- Add and Drop Constraints
- Modify the Column Definition
- Back Up Tables
- Delete Tables
- Working with Views
- Create a View
- Manipulate Data in Views
- Create Aliases
- Modify and Drop Views
- Indexing Data
- Create Indices
- Drop Indices
- Managing Transactions
- Create Transactions
- Commit Transactions
Students should have attended or be familiar with the topics covered in the SQL Querying Introduction Training course.
Live, Instructor-Led Online Class for INDIVIDUALS
$325.00
Click here to load this Caspio Online Database.
Live, Instructor-Led Online or Onsite Class for GROUPS
Contact Us For Quote
Click here to load this Caspio Online Database.