From the course: Microsoft Azure Data Fundamentals (DP-900) Exam Tips

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Querying relational data

Querying relational data - Azure Tutorial

From the course: Microsoft Azure Data Fundamentals (DP-900) Exam Tips

Start my 1-month free trial

Querying relational data

“

- [Instructor] Now that we know the different relational database offering in Azure, let's have a primer on how to query this data. The SQL language as most all the languages is quite extensive, but for the exam, you just need to have basic notions about it. SQL or structured query language was originally created in the 1970s as a way to query relational database. By 1987, it had being made the standard by both ANSI and ISO and it has been the main language used by most relational database systems ever since. In fact, a lot of this Vendors create their own dialects of the SQL language exchanging them with additional features. For example, SQL Server uses Transact-SQL, Oracle uses PL-SQL. Postgres SQL uses pgSQL and so on. If most of the work you're doing is in one of these platforms, you should is use this specific SQL dialect for them to leverage the additional functionality that each one of them has. If you…

Contents