Generic filters
Exact matches only
Search in title
Search in content
Search in excerpt

SQL Querying: Advanced

This course is geared towards individuals with a solid foundation in basic SQL queries (SELECT, WHERE, JOIN etc.) and are ready to explore more complex functionalities.Advanced JOIN Techniques: Beyond basic inner joins, you’ll explore advanced join types like left joins, right joins, full outer joins, and self-joins to establish complex relationships between tables and retrieve comprehensive data sets.Subqueries: Learn how to write nested queries (subqueries) to solve complex data retrieval problems. Subqueries can be used to filter data based on results from other queries.Window Functions: Explore window functions like RANK, ROW_NUMBER, and PERCENTILE_CONTILE to perform calculations and aggregations on data within result sets based on defined ordering or windowing.Advanced Data Manipulation: The course might cover advanced techniques for data manipulation, such as working with Common Table Expressions (CTEs) for temporary named result sets, using MERGE statements for insert/update/delete operations in a single statement, and utilizing triggers for automated database actions.Performance Optimization: Learn strategies to optimize the performance of your SQL queries. This might involve understanding query execution plans, using indexes effectively, and writing efficient code to minimize processing time and resource usage.Database Security: Advanced courses might touch upon database security best practices, including user authentication and authorization, data encryption techniques, and secure coding practices to prevent vulnerabilities.
  • Price: $279.99
  • Delivery Method: eLearning
NameBuy
SQL Querying: Advanced
Test Prep
62+ Pre Assessment Questions | 4+ Full Length Tests | 65+ Post Assessment Questions | 120+ Practice Test Questions
Features
42+ LiveLab | 42+ Video tutorials | 01:15+ Hours
5+ Videos | 15+ Minutes
Find More E-Learning Courses

Why choose TOPTALENT?

  • Get assistance every step of the way from our Texas-based team, ensuring your training experience is hassle-free and aligned with your goals.
  • Access an expansive range of over 3,000 training courses with a strong focus on Information Technology, Business Applications, and Leadership Development.
  • Have confidence in an exceptional 95% approval rating from our students, reflecting outstanding satisfaction with our course content, program support, and overall customer service.
  • Benefit from being taught by Professionally Certified Instructors with expertise in their fields and a strong commitment to making sure you learn and succeed.

Outline

Lessons 1:
Executing a Simple Query

  • Lesson Objectives
  • Lesson Introduction
  • TOPIC A: Connect to the SQL Database
  • TOPIC B: Query a Database
  • TOPIC C: Save a Query
  • TOPIC D: Modify and Execute a Saved Query
  • Summary

Lessons 2:
Performing a Conditional Search

  • Lesson Objectives
  • Lesson Introduction
  • TOPIC A: Search Using One or More Conditions
  • TOPIC B: Search for a Range of Values and NULL Values
  • TOPIC C: Search Data Based on Patterns
  • Summary

Lessons 3:
Working with Functions

  • Lesson Objectives
  • Lesson Introduction
  • TOPIC A: Perform Date Calculations
  • TOPIC B: Calculate Data Using Aggregate Functions
  • TOPIC C: Manipulate String Values
  • Summary

Lessons 4:
Organizing Data

  • Lesson Objectives
  • Lesson Introduction
  • TOPIC A: Sort Data
  • TOPIC B: Rank Data
  • TOPIC C: Group Data
  • TOPIC D: Filter Grouped Data
  • TOPIC E: Summarize Grouped Data
  • TOPIC F: Use PIVOT and UNPIVOT Operators
  • Summary

Lessons 5:
Retrieving Data from Multiple Tables

  • Lesson Objectives
  • Lesson Introduction
  • TOPIC A: Combine the Results of Two Queries
  • TOPIC B: Compare the Results of Two Queries
  • TOPIC C: Retrieve Data by Joining Tables
  • Summary

Lessons 6:
Exporting Query Results

  • Lesson Objectives
  • Lesson Introduction
  • TOPIC A: Generate a Text File
  • TOPIC B: Generate an XML File
  • Summary

Lessons 7:
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

Lessons 8:
Manipulating Table Data

  • Lesson Objectives
  • Introduction
  • TOPIC A: Insert Data
  • TOPIC B: Modify and Delete Data
  • Summary

Lessons 9:
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

Lessons 10:
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

Lessons 11:
Indexing Data

  • Lesson Objectives
  • Introduction
  • TOPIC A: Create Indexes
  • TOPIC B: Drop Indexes
  • Summary

Lessons 12:
Managing Transactions

  • Lesson Objectives
  • Introduction
  • TOPIC A: Create Transactions
  • TOPIC B: Commit Transactions
  • Summary

Appendix A

  • The FullerAckerman Database
  • Schema