Day 283 of writing every day.
After 9 chapters dedicated to how to manipulate data in SQL, I finally reached the chapter on creating tables. I’m not sure this is the best approach to how SQL should be taught in terms of the ordering of things, but it’s a relief from the last couple of chapters where the content was starting to feel a little hard to grasp without some rereading and time to digest and experiment.
Before you can start inserting data into a table, you have to have a table to insert it into in the first place. Making a table is simple in SQL, but customizing the settings can allow you to optimize your tables so that you only have specific types of data allowed in specific columns, as an example. You can also set a default value for a column when a user does not enter a value for their entry, or require that something be entered for an entry to be committed. The code for creating and altering tables and their properties falls under the subcategory of Data Defining Language (DDL) in SQL, if I read correctly.
Exciting stuff maybe if I can start using it for work. In the meantime I’m just trudging through the textbook and testing my understanding of the material with practice questions included at the end of each chapter.
I’m still learning but it’s starting to come together for me.
Thanks for reading!
One Chance Works 