MIS710 Module 2Query Languages – RARC and SQL.pptVIP

MIS710 Module 2Query Languages – RA/RC and SQL Arijit Sengupta Structure of this semester Today’s Buzzwords Query Languages Formal Query Languages Procedural and Declarative Languages Relational Algebra Relational Calculus SQL Aggregate Functions Nested Queries Objectives At the end of the lecture, you should Get a formal as well as practical perspective on query languages Have a background on query language basics (how they came about) Be able to write simple SQL queries from the specification Be able to look at SQL queries and understand what it is supposed to do Be able to write complex S