From the course: AWS Certified Database – Specialty (DBS-C01) Cert Prep: 1 Introduction and Services

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Working with database objects

Working with database objects - Amazon Web Services (AWS) Tutorial

From the course: AWS Certified Database – Specialty (DBS-C01) Cert Prep: 1 Introduction and Services

Start my 1-month free trial Buy for my team

Working with database objects

“

- The final set of SQL statements I want to talk to you about fall into that DDL category, the Data Definition Language. We're defining the actual schema or structure of our database, including tables and other objects as well. Now we're going to do this in the MySQL Workbench. And what I'm going to do is actually use the GUI interface to show you there are so many parameters that can be configured. And the good news is we have tools like this. And then when we click Apply, we'll see what the actual SQL code looks like if we want to understand that maybe for scripting purposes or automation at later times. Keep in mind that DDL commands are not run nearly as often as DML commands. Probably you run DML the most, that's your SELECT, INSERT, UPDATE and DELETE, then DCL, that's your GRANT, REVOKE, DENY, then DDL, that's your CREATE, ALTER, DROP type commands. The reason is you don't change your schema every day. At least I…

Contents