Page 44 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

Sartaj Singh, Lovely Professional University Unit 3: Structured Query Language

Unit 3: Structured Query Language Notes

CONTENTS

Objectives
Introduction

3.1 Structured Query Language (SQL)
3.2 Data Definition

3.3 Data Types
3.4 Schema Definition

3.5 Basic Structure of SQL Queries
3.6 Creating Tables

3.7 DML Operations
3.7.1 SELECT Command

3.7.2 Insert Command
3.7.3 Update Command

3.7.4 Delete Command
3.8 DDL Commands for Creating and Altering

3.9 Set Operations
3.10 Aggregate Functions

3.11 Null Values
3.12 Summary

3.13 Keywords
3.14 Self Assessment

3.15 Review Questions
3.16 Further Readings

Objectives

After studying this unit, you will be able to:
 Describe SQL and data types
 Explain the basic structures of SQL queries
 Know how to create tables

 Realise aggregate functions and null values

LOVELY PROFESSIONAL UNIVERSITY 37