Basic SQL Queries (SELECT, WHERE, ORDER BY)

84 lessons in Databases & SQL

• Join and Filter Customer OrdersCode Quiz
• SELECT with WHERE FilterQuiz
• Fix the JOIN ConditionCode Quiz
• Selecting and Ordering Query ResultsQuiz
• Clause Order in a Grouped Join QueryCode Quiz
• Filtering Rows with WHEREQuiz
• Filtering Rows With NULL ValuesCode Quiz
• SQL Clause Execution OrderQuiz
• Filter Aggregates with HAVINGCode Quiz
• Filtering and Sorting ResultsQuiz
• Core SQL Querying EssentialsSlides / Video
• Filtering Aggregated ResultsQuiz
• SQL Query Building BlocksFlashcard
• Selecting All Columns With The WildcardSlides / Video
• Removing Duplicates With DISTINCTQuiz
• Limiting Result RowsQuiz
• Selecting All ColumnsQuiz
• Selecting Specific ColumnsQuiz
• Column Aliases With ASQuiz
• Filtering With WHEREQuiz
• Comparison OperatorsQuiz
• Combining With AND / ORQuiz
• Negating With NOTQuiz
• Range Filtering With BETWEENQuiz
• Set Membership With INQuiz
• Pattern Matching With LIKEQuiz
• Filtering NULL ValuesQuiz
• Sorting With ORDER BYQuiz
• Ascending vs Descending SortQuiz
• String Literals And QuotingQuiz
• Sorting By Multiple ColumnsQuiz
• Logical Order Of ClausesQuiz
• SQL Syntax BasicsSlides / Video
• Limiting Rows With LIMIT and TOPSlides / Video
• Removing Duplicates With DISTINCTSlides / Video
• Sorting by Multiple ColumnsSlides / Video
• Ascending and Descending OrderSlides / Video
• Sorting Results With ORDER BYSlides / Video
• Handling NULLs With IS NULLSlides / Video
• Set Membership Filtering With INSlides / Video
• Range Filtering With BETWEENSlides / Video
• Pattern Matching With LIKESlides / Video
• Combining Conditions With AND, OR, NOTSlides / Video
• SQL Comparison Operators in WHERESlides / Video
• Filtering Rows With WHERESlides / Video
• Renaming Columns With AS AliasesSlides / Video
• Specifying Tables With FROMSlides / Video
• Handling NULL ValuesCode Quiz
• Clause Order In A QueryCode Quiz
• Limiting Returned RowsCode Quiz
• Removing Duplicates With DISTINCTCode Quiz
• Sorting By Multiple ColumnsCode Quiz
• Sorting DescendingCode Quiz
• Sorting With ORDER BYCode Quiz
• Pattern Matching With LIKECode Quiz
• Filtering With INCode Quiz
• Filtering Ranges With BETWEENCode Quiz
• Combining ConditionsCode Quiz
• WHERE Comparison OperatorCode Quiz
• Column Aliases With ASCode Quiz
• Selecting Specific ColumnsCode Quiz
• Selecting All ColumnsCode Quiz
• Selecting Specific Columns by NameSlides / Video
• The SELECT Statement's PurposeSlides / Video
• BETWEEN Operator for RangesFlashcard
• Comparison OperatorsFlashcard
• SELECT DISTINCT for Unique ValuesFlashcard
• Filtering with IS NULL / IS NOT NULLFlashcard
• FROM Clause and Table NameFlashcard
• Selecting All Columns with *Flashcard
• SELECT Statement Basic SyntaxFlashcard
• Case Sensitivity and ConventionsFlashcard
• String Literals and QuotingFlashcard
• Sorting by Multiple ColumnsFlashcard
• IN Operator for Value ListsFlashcard
• WHERE Clause for FilteringFlashcard
• Statement Termination with SemicolonFlashcard
• ORDER BY for SortingFlashcard
• LIKE Operator and WildcardsFlashcard
• Logical Operators AND, OR, NOTFlashcard
• Column Aliases with ASFlashcard
• LIMIT Clause to Restrict RowsFlashcard
• Ascending vs Descending SortFlashcard
• Selecting Specific ColumnsFlashcard