CHAPTER 6:CHAPTER 6:INTRODUCTION TO SQLINTRODUCTION TO SQL

© 2013 Pearson Education, Inc.  Publishing as Prentice Hall 1

Modern Database Management11th Edition

Jeffrey A. Hoffer, V. Ramesh, Heikki Topi

Chapter 6 © 2013 Pearson Education, Inc.  Publishing as Prentice Hall© 2013 Pearson Education, Inc.  Publishing as Prentice Hall

2

CATEGORIES OF SQL LANGUAGE Data Definition Language (DDL)

Commands that define a database, including creating, altering, and dropping tables and establishing constraints

Data Manipulation Language (DML) Commands that maintain and query a

database Data Control Language (DCL)

Commands that control a database, including administering privileges and committing data

3

Figure 6-4 DDL, DML, DCL, and the database development process

3Chapter 6 © 2013 Pearson Education, Inc.  Publishing as Prentice Hall© 2013 Pearson Education, Inc.  Publishing as Prentice Hall

4

Figure 6-10 SQL statement processing order (based on van der Lans, 2006 p.100)

4Chapter 6 © 2013 Pearson Education, Inc.  Publishing as Prentice Hall© 2013 Pearson Education, Inc.  Publishing as Prentice Hall

55

Copyright © 2013 Pearson Education, Inc.  Publishing as Prentice Copyright © 2013 Pearson Education, Inc.  Publishing as Prentice HallHall