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

SQL Querying: Fundamentals

An “SQL Querying: Fundamentals” course is designed to introduce you to the foundational concepts and functionalities of SQL (Structured Query Language).This course is ideal for beginners with little to no prior experience with SQL or database querying.Understanding Relational Databases: You’ll gain a basic understanding of relational databases, including tables, columns, data types, primary and foreign keys, and how data is organized within them.The Core SQL Clauses: The course will focus on the fundamental SQL clauses used for data retrieval and manipulation: SELECT: This clause is used to specify the data you want to retrieve from a table.FROM: This clause specifies the table(s) from which you want to retrieve data.WHERE: This clause allows you to filter data based on specific conditions.ORDER BY: This clause sorts the retrieved data in a particular order (ascending or descending).GROUP BY: This clause groups data based on a specific column and allows you to perform aggregate functions (SUM, COUNT, AVG etc.) on the grouped data.Joining Tables: You’ll learn how to combine data from multiple tables using JOIN operations (e.g., INNER JOIN, LEFT JOIN) based on shared columns to create comprehensive datasets.Introduction to Functions: The course might introduce basic SQL functions for performing calculations and manipulations on data retrieved through queries (e.g., mathematical functions, string manipulation functions).
  • Price: $279.99
  • Delivery Method: eLearning
NameBuy
SQL Querying: Fundamentals
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