Why to learn the DDL syntax when a program like SQLITE provides us with an easy way to create a database with tables ?

Question

At today's session , DDL was explained, it was hard to understand and memorize the create syntax + constrains + alter ...etc
then why should we learn them ?

Answer 1

The syntax is used by your program or app for accessing or creating a database.

For example say you have a website that users can register onto. When they register their username, password, e-mail, etc. you will need to write this data into your database with DDL. (Not you personally, but website's code, of course).
Later, when the user is accessing the website, again you'll need DDL to retrieve his credentials from the database.

Similar principle applies if you make an desktop application that stores or retrieves data from an SQL database.