Your Learning Process might get lost. SignIn to save your progress.
The Basics of Writing SQL Queries
home
Course Overview
-
slideshow
Subqueries and CTEs: Topics, Examples, Application, Best Practices
circle
-
description
Subqueries & CTEs: Module Topics, Explanations, & Best Practices
circle
-
menu_book
Subqueries & CTEs: Topics, Explanations, Examples & Best Practices
circle
-
quiz
Subqueries and CTEs: Quiz on Practical Applications and Best Practices
circle
-
slideshow
Optimizing Query Performance: Indexing, Plans, Bottlenecks - Module Topics
circle
-
description
Optimizing SQL Query Performance: Module Topics
circle
-
menu_book
Optimizing SQL Query Performance: Core Concepts for Advanced Topics
circle
-
quiz
Quiz: Optimizing Query Performance - Indexing, Plans, Bottlenecks
circle
book
Course
The Basics of Writing SQL Queries
completed
0%
calendar_clock
None hours
show_chart
Introductory
person
{'Employee'}
+0 pts
The Basics of Writing SQL Queries is a foundational course designed to equip individuals with the essential skills to retrieve and manipulate data from relational databases. This course covers fundamental SQL concepts, including selecting data, filtering results with WHERE clauses, sorting data with ORDER BY, joining tables, and using aggregate functions like COUNT, SUM, AVG, MIN, and MAX. Through hands-on exercises and real-world examples, students will learn how to construct effective and efficient SQL queries to extract valuable insights from data.
1. Introduction and Fundamentals
2. Core Concepts and Principles
3. Data Manipulation Techniques
4. Joining Tables
5. Aggregate Functions
6. Performance Optimization
7. Subqueries and Common Table Expressions (CTEs)
8. Optimizing Query Performance