1 / 11

Database Development

Database Development. Vladimir Camilleri vladimir@icemalta.com. 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)

iliana
Download Presentation

Database Development

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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

More Related