O'Reilly logo

Concepts of Database Management System by Shefali Naik

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 6

Managing Data Using Structured Query Language (SQL)

CHAPTER OBJECTIVES
  • Knowing usage of Structured Query Language (SQL) in managing data.
  • Knowing usefulness of data definition and manipulation commands.
  • Learning SELECT statement to fetch data from a database.
  • Understanding different types of constraints.
  • Learning how to use different functions given in a database management system.
  • Understanding the application of special operators.
  • Retrieving data with complex nested, or sub query.
  • Summarizing data using advanced SQL, such as rollup, cube and crosstab.
  • Summary
6.1 INTRODUCTION

In Relational Database Management System, data is managed by using Fourth Generation Language (4GL), named as Structured Query Language (SQL). Using simple ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required