Database Revision Lecture PDF
Document Details
Uploaded by RazorSharpWalnutTree160
كلية تكنولوجيا الصناعة والطاقة
Dr. Nehal El Azaly
Tags
Summary
This document provides an overview of data bases and database management systems. It covers different types of database relationships (one-to-one, one-to-many, and many-to-many) and SQL commands such as SELECT, INSERT, UPDATE, and DELETE. SQL categories, DQL, DDL and DML are also included in the slides.
Full Transcript
Lecture "Data Base Revision" Presented by : Dr. Nehal El Azaly 1 What is the Data Base? Data base is simply the previous arranged data using applications such as excel sheet or any other application....
Lecture "Data Base Revision" Presented by : Dr. Nehal El Azaly 1 What is the Data Base? Data base is simply the previous arranged data using applications such as excel sheet or any other application. 2 Data base is consisted of groups of tables, where each table has rows and columns. 3 The created tables can be connected with each other by the relationships. 4 DBMS: Data Base Management System Components of a Data Base Management System 5 program 6 Compounds of Table 7 Access Data Base 8 DB Relationship Types One-to-One One- to-Many May-to-Many 9 One-to-One Relationship 10 One-to-Many Relationship 11 Many-to-Many Relationship 12 Access Data Base 13 Access Data Base 14 Lecture (4) "Introduction to Data Base" Presented by : Dr. Nehal El Azaly 15 Lecture (4) "Introduction to Data Base" Presented by : Dr. Nehal El Azaly 16 Basic SQL Commands Basic SQL Commands Basic SQL Commands Introduction to SQL Introduction to Database SQL Categories: Common DQL statements: 1. Data Query Language (DQL) 1. SELECT 2. SELECT DISTINCT Common DDL statements: 1. CREATE DATABASE 2. DROP DATABASE 2. Data Definition Language (DDL) 3. CREATE TABLE 4. DROP TABLE Common DML statements: 1. INSERT INTO 3. Data Manipulation 2. UPDATE Language (DML) 3. DELETE FROM SQL Introduction to 1. Data Query Language (DQL) : Database 1. SELECT : The SELECT statement is used to select data from a database. Syntax : column1, column2 are the field names of the table you want to select data from. The table_name represents the name of the table you want to select data from. “ WHERE condition “ is optional and allows you to specify a condition for filtering the results. SQL Introduction to 1. Data Query Language (DQL) : Database 1. SELECT DISTINCT : The SELECT DISTINCT “ Unique Values ” statement is used to return only distinct ( Unique ) values. Syntax : SQL Introduction to 2. Data Definition Language (DDL) : Database 1. CREATE DATABASE : The CREATE DATABASE statement is used to create a new SQL database. Syntax : Example : SQL Introduction to 2. Data Definition Language (DDL) : Database 2. DROP DATABASE : The DROP DATABASE statement is used to DELETE a SQL database. Syntax : Example : SQL Introduction to Database 2. Data Definition Language (DDL) : 3. CREATE TABLE : CREATE TABLE statement is used to create a new table in a database. Syntax : The table_name represents the name of the table you want to create. column1, column2 are the field names of the table you want to create in the table. The datatype parameter specifies the type of data the column can hold (varchar, integer, date, etc.). SQL Introduction to 2. Data Definition Language (DDL) : Database 3. CREATE TABLE : Commonly used SQL data types: INTEGER (INT): Used for whole numbers. VARCHAR: Used for variable-length character strings. DATE: Used for date values. DATETIME: Used for date and time values. BOOLEAN (BOOL): Used for true or false values. SQL 28