• Lesson Content
  1. Data Analysis > 
  2. SQL Part 4: Subqueries, CTEs, UNION, INTERSECT, EXCEPT > 
  3. Lesson

Lesson

Lesson Content

  • SQL Subqueries
  • Nested Subqueries
  • Common Table Expressions
  • UNION, INTERSECT, EXCEPT
Mar 12, 2024
LaunchCode
  • Home
    • Introduction to Data
      • Spreadsheet Mastery
        • SQL Part 1: Introduction and Visual Studio Code SQL Setup
          • SQL Part 2: String and Date Functions
            • SQL Part 3: Joins
              • SQL Part 4: Subqueries, CTEs, UNION, INTERSECT, EXCEPT
                • Lesson
                  • SQL Subqueries
                  • Nested Subqueries
                  • Common Table Expressions
                  • UNION, INTERSECT, EXCEPT
                  • Exercises
                  • Studio
                  • Next Steps
                • SQL Part 5: Schemas and CRUD Operations
                  • Data and Variables
                    • Making Decisions with Conditionals
                      • Loops
                        • Collections
                          • Functions are at Your Beck and Call
                            • Exploratory Data Analysis with pandas
                              • Cleaning Data with Pandas
                                • Data Manipulation
                                  • Data Visualization with Python
                                    • Databases with Python and pandas
                                      • Tableau Part 1: Intro to Visualization
                                        • Tableau Part 2: Data Preparation
                                          • Tableau Part 3: Calculations, Parameters and Relationships
                                            • Tableau Part 4: Stories and Dates
                                              • Projects
                                                • Installations
                                                  • Appendices
                                                      •