SQL Queries
SQL Queries will help you learn to retrieve, manipulate and manage data in databases. Explore the power of SQL queries, from basic SELECT statements to advanced operations like JOINs and subqueries. Understand how to organize and analyze data effectively, laying the foundation for efficient database management. With hand-on lab and practical examples, you’ll gain the confidence to tackle real-world scenarios.
- Price: $279.99
- Delivery Method: eLearning
| Name | Buy |
|---|---|
| SQL Queries |
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
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