Learning Series #51: Import & ExportThis marks the last post in my SQL learning journey 🥹🥹. It took a longer time than expected but here we are!Aug 13, 2024Aug 13, 2024
Learning Series #50: VIEWThroughout my learning journey, I have had to use similar queries often within the same table and database. Each time, I had to recall and…Aug 12, 2024Aug 12, 2024
Learning Series #49:NULLIFThe NULLIF condition takes just two inputs. From my understanding, it combines both theNULL and IF statement. That is, check for this…Aug 11, 2024Aug 11, 2024
Learning Series #48: CASTThe CAST expression allows the conversion of one data type to another. With this expression, we can convert strings to integers, integers…Aug 10, 2024Aug 10, 2024
Learning Series #47: CoalesceThe COALESCE function is used to query tables when a table contains NULL values. It accepts an unlimited amount of arguments. When queried…Aug 9, 2024Aug 9, 2024
Learning Series #45: CHECKThe CHECK function can be used to add or confirm constraints within a table or column. The syntax for the CHECK constraint isJul 14, 2024Jul 14, 2024
Learning Series #44: DROPIn the previous post, I shared my learnings on the ALTER clause and how it can be used to update a column, table or constraints within a…Jul 13, 2024Jul 13, 2024
Learning Series #43: ALTERThe ALTER clause is used to make updates to a table, or a column or constraints with a table. The ALTERperforms a different function than…Jul 12, 2024Jul 12, 2024
Learning Series #42: DELETEThe DELETE function can be used to remove rows of data within a table. The general syntax for DELETE isJul 11, 2024Jul 11, 2024