From the course: Relational Databases Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Data definition queries
From the course: Relational Databases Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.