From the course: Learning MySQL Development
Unlock the full course today
Join today to access over 24,900 courses taught by industry experts.
SQL, a declarative language - MySQL Tutorial
From the course: Learning MySQL Development
SQL, a declarative language
- [Instructor] As you might guess from the name, MySQL uses SQL, or structured query language, as the means of programmatically interacting with its databases. SQL is a declarative language, one common among relational DBMSs, but very different from procedural or object oriented languages common when working with data outside a database. In a procedural language, a program is executed step by step, and the program flow explicitly lays out each step that the programmer wants performed. A declarative language leaves the exact control flow up to the computer. A programmer just states the logic of what they want the end result to look like. In database terms, a procedural program might run a loop wherein it checks the first row of data in a table for certain contents, and then displays those contents if they match the criteria or rejecting them if they don't. Then it would loop to the next row. SQL leaves all those…
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.