{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

1.4 - Introduction to SQL and database objects.pdf

1.4 - Introduction to SQL and database objects.pdf -...

Info icon This preview shows pages 1–11. Sign up to view the full content.

View Full Document Right Arrow Icon
1 © 2011 IBM Corporation Introduction to SQL and database objects IBM Information Management – Cloud Computing Center of Competence IBM Canada Labs
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
2 © 2011 IBM Corporation Agenda Overview Database objects SQL introduction The SELECT statement The UPDATE, INSERT and DELETE statements Working with JOINs
Image of page 2
3 © 2011 IBM Corporation Reading materials Getting started with DB2 Express-C eBook Chapter 8: Working with database objects Database Fundamentals eBook Chapter 5: Introduction to SQL Getting started with IBM Data Studio for DB2 eBook Chapter 4: Creating SQL and XQuery scripts Videos db2university.com course AA001EN Lesson 6: Working with database objects Lesson 7: Introduction to SQL Supporting reading material & videos
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
4 © 2011 IBM Corporation Agenda Overview Database objects SQL introduction The SELECT statement The UPDATE, INSERT and DELETE statements Working with JOINs
Image of page 4
5 © 2011 IBM Corporation Overview ° Schema ° Table ° View ° Index ° Synonyms / Alias ° Database application objects Sequences Triggers User Defined Functions (UDFs) Stored Procedures Database objects SQL
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
6 © 2011 IBM Corporation Agenda Overview Database objects SQL introduction The SELECT statement The UPDATE, INSERT and DELETE statements Working with JOINs
Image of page 6
7 © 2011 IBM Corporation ° Schema ° Table ° View ° Index ° Synonyms / Alias ° Database application objects Sequences Triggers User Defined Functions (UDFs) Stored Procedures Database objects These will be covered later in the course, in the topic about application development
Image of page 7

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
8 © 2011 IBM Corporation Schemas ° Schemas are name spaces for a collection of database objects ° All database objects (except public synonyms) are qualified by a two-part name: <schema_name>.<object_name> ° A fully qualified object name must be unique To create a schema explicitly, use this statement: CREATE SCHEMA <schema_name> ° Implicit schemas ° Uses the connection ID as the implicit schema ° Can be set with the SET SCHEMA command
Image of page 8
9 © 2011 IBM Corporation Tables Tables store data A table consists of data logically arranged in columns and rows Each column contains values of the same data type Each row contains a set of values for each column available Lastname Firstname Age Country Pan Peter 15 Singapore Austin Susan 32 Australia ... EMPLOYEE Table
Image of page 9

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
10 © 2011 IBM Corporation Tables Tables store data A table consists of data logically arranged in columns and rows Each column contains values of the same data type Each row contains a set of values for each column available Lastname Firstname Age Country Pan Peter 15 Singapore Austin Susan 32 Australia ...
Image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern