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 13Aug 13
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 12Aug 12
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 11Aug 11
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 10Aug 10
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 9Aug 9
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 14Jul 14
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 13Jul 13
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 12Jul 12
Learning Series #42: DELETEThe DELETE function can be used to remove rows of data within a table. The general syntax for DELETE isJul 11Jul 11