In this course, you will work with advanced queries to manipulate and index tables. You will also create transactions so that you can choose to save or cancel the data entry process. Each topic has various types of activities designed to enable you to practice the guidelines and procedures as well as to solidify your understanding of the informational material presented in the course.
ISBN : 978-1-61691-564-3

### Here's what you will get

Lessons
Lessons
7+
Exercises
28+
Quizzes
20+
Flashcards
44+
Glossary of terms
44+
TestPrep
Pre-assessment Questions
30+
Full Length Tests
2+
Post-Assessment Questions
35+

### Videos and How To..

uCertify course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.

Video Lessons
Videos
2+
Minutes
05+

### Here's what you will learn

• 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

uCertify provides courses, simulator, labs, test prep kits for IT certifications including Microsoft, Oracle, Cisco, CompTIA, CIW, PMI, ISC2, Linux, Zend, IC3, Adobe and many more.