'Create table student' diaporamas de présentation

Chapter 5 Relational Database Management Systems and SQL

1.47k views • 92 slides

Chapter 5 Relational Database Management Systems and SQL

1.25k views • 92 slides

Chapter Six

Chapter Six. Objectives Introduction to SQL Types of SQL statements Concepts of DDL & DML Creating Tables Restrictions on Tables Data Definition Language(DDL) Data Manipulation Language (DML). SQL. Structured Query Language Developed by IBM Used in most Commercial DBMS

899 views • 63 slides

Chapter 6

Chapter 6. SQL. Agenda. Data Definition Language (DDL) Access Control. String Data Types. Boolean data: true, false, null, unknown value (true > false) Character data Fixed length: CHAR(4) Variable length: VARCHAR(30) Bit data: binary string BIT(4). Numeric Data Types.

432 views • 43 slides

Chapter 6

Chapter 6. SQL. Agenda. Data Definition Language (DDL) Access Control. String Data Types. Boolean data: true, false, null, unknown value (true > false) Character data Fixed length: CHAR(4) Variable length: VARCHAR(30) Bit data: binary string BIT(4). Numeric Data Types.

512 views • 40 slides

Oracle 9i

Oracle 9i. Agenda. Start and exit SQL Plus (General) Start and exit SQL Plus (Tah 1006) Syntax Create a new user Create a new table Enter data into a new table Export & import data. Start and Exit SQL Plus. Start SQL Plus Start Select Program Select Oracle-ORACLE_9i

542 views • 30 slides

Oracle 9i

Oracle 9i. Agenda. Start and exit SQL Plus (General) Start and exit SQL Plus (Tah 1006) Syntax Create a new user Create a new table Enter data into a new table Export & import data. Start and Exit SQL Plus. Start SQL Plus Start Select Program Select Oracle-ORACLE_9i

274 views • 26 slides

SQL in Oracle

SQL in Oracle. Set up Oracle access at IU. You need to install Oracle Client: http://kb.iu.edu/data/anhl.html For windows: http://kb.iu.edu/data/aznp.html Connecting to Oracle with SQL*Plus http://kb.iu.edu/data/aznp.html#connecting

217 views • 21 slides

Constraints

Constraints. B term 2004: lecture 15. Keys: Primary keys and unique. CREATE TABLE Student ( sNumber int, sName varchar (20), dept char (2), CONSTRAINT key PRIMARY KEY (sNumber), CONSTRAINT uniqueName UNIQUE (sName));. Unique vs. primary keys.

259 views • 13 slides

MySQL

MySQL. S511. Software Requirement. MySQL server 5.0 Download: http://dev.mysql.com/downloads/mysql/ (MySQL Community Server 5. up) Client side browser: http://www.webyog.com/en/ Aqua data studio (free for IU): http://iuware.iu.edu/title.aspx?id=585. How to start. Start your MySQL server

265 views • 12 slides

MySQL

MySQL. Software Requirement. MySQL server 5.0 Download: http://dev.mysql.com/downloads/mysql/ (MySQL Community Server 5. up) Client side browser: http://www.webyog.com/en/ Aqua data studio (free for IU): http://iuware.iu.edu/title.aspx?id=585. How to start. Start your MySQL server

131 views • 12 slides

SQL in Access

SQL in Access. S511. Create Table Schema. CREATE TABLE student ( student_id INTEGER NOT NULL, name CHAR(25), major CHAR(10), gpa INTEGER, CONSTRAINT index1 PRIMARY KEY(student_id)); CREATE TABLE course ( course_id CHAR(15), name CHAR(25), department_id CHAR(10),

303 views • 10 slides