Download
database development n.
Skip this Video
Loading SlideShow in 5 Seconds..
Database Development PowerPoint Presentation
Download Presentation
Database Development

Database Development

220 Vues Download Presentation
Télécharger la présentation

Database Development

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Database Development Vladimir Camilleri vladimir@icemalta.com

  2. Course Outline • Databases Overview • Data Definition Language (DDL) • Working with queries – Retrieving Data • Modifying data in a table • Using SQL functions in queries • Working with multi-table queries (Joins) • Implementing data integrity • Using databases for software applications

  3. What is a database? • An organized collection of data • Designed according to the business use • Independent of technology • A database consists of: • Tables • Columns (Every Column has an attribute) • Rows

  4. What is a database used for? • Storing Information • Providing Information for multiple users • Easy Access to Data • Secure Data Management • Almost every system uses a database: • Facebook • You tube • Gmail

  5. Types of Databases • Relational Databases • Object Oriented Databases • Cloud Databases • Data Warehouse • Distributed Databases • Embedded Databases • Spatial Databases

  6. What is a DBMS? • Database Management System • A software that allows users to: • Create a database (DDL) • Maintain a database (DDL) • Query a database (DML) • Improve database performance • Adjust database security • Data Administration

  7. Different Vendor DBMS • Microsoft SQL Server • Oracle • MySQL • IBM DB2 • Sybase • PostgreSQL • SQLite

  8. What is SQL? • Structured Query Language • A programming language designed for managing data in a RDBMS • Queries • Data manipulation Language (DML) • Data Definition Language (DDL) • Data Control Language (DCL)

  9. Basic SQL Features • The SELECT command • The INSERT command • The UPDATE command • The DELETE command • The CREATE/ALTER/DROP table commands

  10. Basic Data Types • Character Strings • Char(n) and Varchar(n) • Bit (Yes/No) • Date and Time • Date/Time/DateTime • Numbers • Integer/Decimal/Numeric/Float

  11. Next Lecture • Creating a database • Creating tables • Table attributes and properties • Introduction to Querying tables using SQL • Introduction to the SELECT command