Basic SQL Queries (SELECT, WHERE, ORDER BY)

71 lessons in Databases & SQL

• Removing Duplicates With DISTINCTQuiz
• Logical Order Of ClausesQuiz
• 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
• Sorting By Multiple ColumnsQuiz
• Limiting Result RowsQuiz
• String Literals And QuotingQuiz
• 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
• Sorting By Multiple ColumnsCode Quiz
• Removing Duplicates With DISTINCTCode Quiz
• Clause Order In A QueryCode Quiz
• Limiting Returned RowsCode Quiz
• Handling NULL ValuesCode Quiz
• Sorting With ORDER BYCode Quiz
• Sorting DescendingCode Quiz
• Selecting All ColumnsCode Quiz
• Selecting Specific ColumnsCode Quiz
• Column Aliases With ASCode Quiz
• WHERE Comparison OperatorCode Quiz
• Combining ConditionsCode Quiz
• Filtering Ranges With BETWEENCode Quiz
• Filtering With INCode Quiz
• Pattern Matching With LIKECode Quiz
• Selecting Specific Columns by NameSlides / Video
• Selecting All Columns With SELECT *Slides / Video
• The SELECT Statement's PurposeSlides / Video
• Filtering with IS NULL / IS NOT NULLFlashcard
• WHERE Clause for FilteringFlashcard
• IN Operator for Value ListsFlashcard
• Sorting by Multiple ColumnsFlashcard
• String Literals and QuotingFlashcard
• Case Sensitivity and ConventionsFlashcard
• SELECT Statement Basic SyntaxFlashcard
• Selecting All Columns with *Flashcard
• FROM Clause and Table NameFlashcard
• SELECT DISTINCT for Unique ValuesFlashcard
• Comparison OperatorsFlashcard
• BETWEEN Operator for RangesFlashcard
• Selecting Specific ColumnsFlashcard
• Ascending vs Descending SortFlashcard
• LIMIT Clause to Restrict RowsFlashcard
• Column Aliases with ASFlashcard
• Logical Operators AND, OR, NOTFlashcard
• LIKE Operator and WildcardsFlashcard
• ORDER BY for SortingFlashcard
• Statement Termination with SemicolonFlashcard