SQL Querying: Advanced
(SQL-Advance)
/ ISBN: 9781616915643
This course includes
Lessons
TestPrep
SQL Querying: Advanced
Gain hands-on expertise in working with advanced SQL Queries with the SQL Querying: Advanced course. The SQL training course teaches you how to use subqueries to perform advanced querying, manipulate table data, and table structure, work with views, index data, and manage transactions. By understanding SQL, you get the knowledge of fundamental queries associated with data management so that you can verify, monitor, and control all the activities operating in the database.
Lessons
-
7+ Lessons
-
28+ Exercises
-
20+ Quizzes
-
44+ Flashcards
-
44+ Glossary of terms
TestPrep
-
30+ Pre Assessment Questions
-
2+ Full Length Tests
-
35+ Post Assessment Questions
-
60+ Practice Test Questions
Video Lessons
-
2+ Videos
-
05+ Minutes
- Lesson Objectives
- Introduction
- TOPIC A: Search Based on Unknown Values
- TOPIC B: Compare a Value with Unknown Values
- TOPIC C: Search Based on the Existence of Records
- TOPIC D: Generate Output Using Correlated Subqueries
- TOPIC E: Filter Grouped Data Within Subqueries
- TOPIC F: Perform Multiple-Level Subqueries
- Summary
- Lesson Objectives
- Introduction
- TOPIC A: Insert Data
- TOPIC B: Modify and Delete Data
- Summary
- Lesson Objectives
- Introduction
- TOPIC A: Create a Table
- TOPIC B: Create a Table with Constraints
- TOPIC C: Modify a Table's Structure
- TOPIC D: Back Up Tables
- TOPIC E: Delete Tables
- Summary
- Lesson Objectives
- Introduction
- TOPIC A: Create a View
- TOPIC B: Manipulate Data in Views
- TOPIC C: Create Aliases
- TOPIC D: Modify and Delete Views
- Summary
- Lesson Objectives
- Introduction
- TOPIC A: Create Indexes
- TOPIC B: Drop Indexes
- Summary
- Lesson Objectives
- Introduction
- TOPIC A: Create Transactions
- TOPIC B: Commit Transactions
- Summary
- The FullerAckerman Database
- Schema
×
