• Home
uCertify Logo
  • 0
    • Your cart is empty
    • Continue Shopping
    • View Cart
  • Login or Signup
    • Help & Support
    • Accessibility
    • Testimonials
  • Powered by uCertify
  • Request Demo
  • Cart 0
    • Your cart is empty
    • Continue Shopping
    • View Cart
  • Hello GuestLogin or Signup
  • Feedback & Support
    • Support
    • Keyboard Shortcuts
    • Send Feedback
Scroll to top button

SQL Querying: Advanced

(SQL-Advance) / ISBN: 9781616915643
This course includes
Lessons
TestPrep
SQL-Advance : SQL Querying: Advanced
Share
$121
Try This Course Buy Now
Are you an instructor?
Request a free evaluation copy

SQL Querying: Advanced

Use the SQL Querying: Advanced course to gain hands-on expertise in working with advanced SQL Queries. 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.
Here's what you will get

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
Here's what you will learn
Download Course Outline
Lesson 1: Using Subqueries to Perform Advanced Querying
  • 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 2: Manipulating Table Data
  • Lesson Objectives
  • Introduction
  • TOPIC A: Insert Data
  • TOPIC B: Modify and Delete Data
  • Summary
Lesson 3: Manipulating the Table Structure
  • 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 4: Working with Views
  • 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 5: Indexing Data
  • Lesson Objectives
  • Introduction
  • TOPIC A: Create Indexes
  • TOPIC B: Drop Indexes
  • Summary
Lesson 6: Managing Transactions
  • Lesson Objectives
  • Introduction
  • TOPIC A: Create Transactions
  • TOPIC B: Commit Transactions
  • Summary
Appendix A
  • The FullerAckerman Database
  • Schema
×
uc logo for app downloadDownload our uCertify App [lms_setting_placeholder: This filed is used to set the LMS settings.

Share with your friends and colleagues

We use cookies to enhance your experience. By continuing to visit this site you agree to our use of cookies. More information
Accept