Revision Library
Structured Query Language Sql I
Browse all available micro learning modules for this topic. Each module includes concise learning content designed to help you master individual learning objectives.
Subject
Informatics Practices
Micro Learning Modules
Select a micro learning module below to begin your revision.
Basic Functions3a Date Time Now Curdate Year Month Day
→Open the micro learning lesson and start revising this learning objective.
Basic Functions3a Numeric Round Ceil Floor Abs Mod Power
→Open the micro learning lesson and start revising this learning objective.
Basic Functions3a String Upper Lower Length Left Right Substring Ltrim Rtrim Concat
→Open the micro learning lesson and start revising this learning objective.
Creating And Selecting Databases3a Create Database Use
→Open the micro learning lesson and start revising this learning objective.
Creating Tables3a Create Table With Common Data Types And Constraints Not Null Primary Key Default
→Open the micro learning lesson and start revising this learning objective.
Filtering Rows3a Where With Comparison Operators 3c 3e 3c 3e
→Open the micro learning lesson and start revising this learning objective.
Handling Null3a Is Null Is Not Null Ifnull Coalesce
→Open the micro learning lesson and start revising this learning objective.
Inserting Data3a Insert Into Column List Values
→Open the micro learning lesson and start revising this learning objective.
Logical Operators3a And Or Not
→Open the micro learning lesson and start revising this learning objective.
Membership And Range3a In Between
→Open the micro learning lesson and start revising this learning objective.
Pattern Matching3a Like With Wildcards And
→Open the micro learning lesson and start revising this learning objective.
Simple Retrieval3a Select Selecting Specific Columns Distinct
→Open the micro learning lesson and start revising this learning objective.
Sorting And Limiting3a Order By Asc Desc Limit
→Open the micro learning lesson and start revising this learning objective.
Updating And Deleting3a Update With Where Delete With Where
→Open the micro learning lesson and start revising this learning objective.
Viewing And Modifying Structure3a Describe Desc Show Alter Table Add Modify Drop Column Drop Table Basics
→Open the micro learning lesson and start revising this learning objective.