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
 
                             
                             
                             
                            