TAILIEUCHUNG - Lecture Database systems: Structured Query Language (SQL) – Nguyễn Ngọc Thiên An

In this chapter includes content as: SQL development: an overview; DDL: create, alter, drop; DML: select, insert, update, delete; DCL: commit, rollback, grant, revoke; assertions; triggers; views. Inviting you to refer lecture for more information. | DATABASE SYSTEMS . í 7 J t . kE - kl __ _iJk _________ 5 STRUCTURED QUERY LANGUAGE Spring 2014 Nguyen Ngoc Thien An EMPLOYEE Fname Minit Lname SSN Bdate Address Sex Salary Super_SSN Dno DEPARTMENT Dname Dnumber Mgr_SSN Mgr_start_date 4 4 4 DEPT_LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber Plocation Dnum WORKS_ON Essn Pno Hours 2 DEPENDENT Essn Dependent_name Sex Bdate Relationship One possible database state for the COMPANY relational database schema EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Super ssn Ono John B Smith 123456789 1 965-01 -09 731 Fondren Houston TX M 30000 333445555 5 Franklin T Wong 333445555 1 955-1 2-08 638 Voss Houston TX M 40000 888665555 5 Alicia J Zelaya 999887777 1 968-01 -19 3321 Castle Spring TX F 25000 987654321 4 Jennifer s Wallace 987654321 1 941 -06-20 291 Berry Bellaire TX F 43000 888665555 4 Ramesh K Narayan 666884444 1 962-09-1 5 975 Fire Oak Humble TX M 38000 333445555 5 Joyce A English 453453453 1 972-07-31 5631 Rico Houston TX F 25000 333445555 5 Ahmad V Jabbar 987987987 1 969-03-29 980 Dallas Houston TX M 25000 987654321 4 James E Borg 888665555 1 937-1 1-10 450 Stone Houston TX M 55000 N u LL 1 DEPARTMENT Dname Dnumber Mgr ssn Mgr start date Research 5 333445555 1 988-05-22 Administration 4 987654321 1 995-01 -O1 Headquarters 1 888665555 1 981 -06-1 9 DEPT LOCATIONS Dn umber Dlocation 1 Houston 4 Stafford 5 Bellaire 5 Sugarland 5 Houston WORKS ON Essn Pno Hours 123456789 1 123456789 2 666884444 3 453453453 1 453453453 2 333445555 2 1 333445555 3 1 333445555 1 o 1 333445555 20 1 999887777 30 999887777 1 o 1 987987987 1 o 987987987 30 987654321 30 987654321 20 1 888665555 20 NULL PROJ ECT Rname Rnumber Rlocation Dnum RroductX 1 Bellaire 5 Product Y 2 Sugarland 5 Rroductz 3 Houston 5 Computerization 1 o Stafford 4 Reorganization 20 Houston 1 Newbenefits 30 Stafford 4 DEPENDENT Essn Dependent name Sex Bdate Relationship 333445555 Alice

• Cơ sở dữ liệu
• Database systems
• Lecture Database systems
• SQL development
• Data Definition Language
• Data Manipulation Language
• Data Control Language
• Database systems concepts
• Database systems architecture
• Database languages
• Data management systems framework
• Introduction to Database Systems
• Database system concepts
• Entity Relationship model
• Database security
• Distributed database systems
• Principles of distributed database systems
• Cơ sở dữ liệu phân tán
• Parallel database systems
• Load balancing
• Database architecture
• Database approach
• Database management systems
• Lecture Database management systems
• File based system
• Characteristics of the database
• Data dictionary
• Database integration
• Schema matching
• Fundamentals of database systems
• The relational data model
• Database design
• Database programming techniques
• Relational database constraints
• Database System
• Relational databases
• Relational database design algorithms
• Relational database systems
• Computer networks
• Practical Database Design
• Physical Database Design in Relational Databases
• An Overview of Database Tuning in Relational Systems
• Physical Database Design Decisions
• Data models
• Hierarchical model
• Designing a set of relations
• Relational decompositions
• Relational database schema
• Database users
• Database applications
• Typical DBMS functionality
• Databases and database users
• Relational calculus
• Physical database design
• Concurrency control techniques
• Database recovery techniques
• Distributed databases
• Multivalued dependencies
• Fundamentals of database management systems
• Logical database design
• Object oriented database management
• Data administration
• Design problem
• Dimensions of the problem
• Database development
• Database environments
• Object database management systems
• Object database
• Bài giảng Hệ quản trị cơ sở dữ liệu
• Operating systems
• Attribute alias
• Lecture Database system concepts
• Database system architectures
• Relational database design