LEARN MORE...

Access Millions of academic & study documents

Sql lecture 4

Content type
User Generated
Showing Page:
1/21

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/21

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/21

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 21 pages?
Access Now
Unformatted Attachment Preview
SQL What is SQL? • SQL stands for Structured Query Language • SQL lets you access and manipulate databases • SQL is an ANSI (American National Standards Institute) standard SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database RDBMS • RDBMS stands for Relational Database Management System. • RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access. • The data in RDBMS is stored in database objects called tables. • A table is a collection of related data entries and it consists of columns and rows. COMPONENTS OF SQL 1. Data Manipulation Language (DML) DML is used to retrieve, insert and modify database information. These commands will be used by all database users during the routine operation of the database. Examples of DML commands: INSERT SELECT UPDATE DELETE COMPONENTS OF SQL 2. Data Definition Language (DDL) The Data Definition Language (DDL) is used to create and destroy databases and database objects. These commands will primarily be used by database administrators during the setup and removal phases of a database project Examples of DDL commands: CREATE USE ALTER DROP COMPONENTS OF SQL 3. Data Control Language (DCL) The Data Control Language (DCL) is used to manage user access to databases. These two commands below form the core of the relational database security model. Examples of DCL commands: GRANT – To add databa ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Similar Documents

SFC Human Relations Be Ethical at Work Ethics Power & Politics Discussion
6A-Be Ethical at Work: Read Chapter 5-Be Ethical at Work in the ebook "Human Relations" and answer the following questions...
North Carolina Central University Lab Biology Discussion
all the data in the papers please let me know if you have any question about the lab...
New Bulgaria Investigating Media Awareness Amongst Civil Servants Discussion
You need to find, select, and research and discuss an academic article. Please view the detailed description of the task! ...
homeland security, 700-900 words, writing homework help
700-900 wordsYou have been asked to make a recommendation to homeland security agencies to better utilize technology to mi...
Ajman University Drug Information Worksheet
Evaluate Sources of Online Drug Information OBJECTIVES: • To evaluate online drug information websites. • Understand t...
Profit Margin - Discussion 2, accounting homework help
Respond to each of the discussion posts separately listed below by telling what changes you would recommend to improve the...
Assignment Work 1 Revised
Question 1. Critically discuss the organizational development process at San Diego Airport The organizational development ...
Nr503 epidemiology midterm study guide version 2
NR 503 Midterm Exam Study Guide: Chamberlain College of Nursing How does social justice and health inequities influence po...
Dominican religious order
Dominican, byname Black Friar, member of the Order of Friars Preachers, also called Order of Preachers (O.P.), one of the ...