From the course: Relational Databases Essential Training

Unlock the full course today

Join today to access over 24,100 courses taught by industry experts.

Data definition queries

Data definition queries

From the course: Relational Databases Essential Training

Start my 1-month free trial Buy for my team

Data definition queries

“

- [Instructor] Relational databases used structured query language or SQL in order to perform tasks on the data base. These tasks include everything from creating tables and relationships, adding record to the tables, querying the database for information, and running maintenance tasks like backups and index repairs. Every relational database platform uses the SQL language, but there could be slight variations from platform to platform on the exact syntax that they use. For instance, one platform might use double quotation marks where another uses square brackets, or a function might have a slightly different name. I'm working with Microsoft Sequel Server database management system, so the commands that I show you here might not translate perfectly if you try and implement them word for word on Postgress, or MySQL, or Auricle, but the concepts will be exactly the same, and that's really what I want to get across in…

Contents