Class02.1_ch01A_Spring_2010

Class02.1_ch01A_Spring_2010 - BCIS 4620 INTRODUCTION TO...

Info iconThis preview shows pages 1–14. Sign up to view the full content.

View Full Document Right Arrow Icon
BCIS 4620 INTRODUCTION TO DATABASE PROCESSING Class 2 Spring 2010 Dr. Jack D. Becker
Background image of page 1

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

View Full DocumentRight Arrow Icon
CLASS 2 – Components of DB Processing Systems, DB Devel. Process, & NX SQL Overview NX SQL Tips DB Development Process Kroenke 5 Component DB Model DBMS Definition Homework #1 SQL Tutorial
Background image of page 2
Tutors BCIS 4620 DRAFT All 4620 Tutors in Room 333
Background image of page 3

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

View Full DocumentRight Arrow Icon
CLASS02 DOC B1 CLASS #2 -- DATABASE PROCESSING Roll Call Class Announcements (CISO) CISO meetings Tutor Schedules (also on course website) Cabinets on 3rd Floor BCIS A - Z Top Shelf
Background image of page 4
NX SQL Tips MicroFocus NX SQL Product 5.0 UE HELP/Getting Started & Getting Started – Additional Topics Create and Use SQL DB2 (XDB) “Sqldemo” Project Folder in NX Help Chapter 11 tutorial SQL DB2 Server/Start/Stop feature PRINTING Use COBA lab printers for first assignments EMAIL policies becker@unt.edu for personal email WebCT for Group-email or Eagle mail (used sparingly)
Background image of page 5

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

View Full DocumentRight Arrow Icon
Start Here!
Background image of page 6
Background image of page 7

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

View Full DocumentRight Arrow Icon
Integrated Development Environment (IDE)
Background image of page 8
New Project Folder When you install Net Express, Setup creates, within the system folders containing Net Express, a folder called by default Net Express\Base\Workarea . This folder is intended as your work area, and we suggest that you put all your project folders within it.
Background image of page 9

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

View Full DocumentRight Arrow Icon
NX SQL Tips (continued) SQL Wizard SYSTEM/SYSXDB Locations TUTORIAL Location SQL Results options Table Results/Form Results XDB Mode This implementation is a superset of DB2, with a number of extensions and some differences in handling of character values. ANSI Mode Supports Level 2 of the ANSI standard for SQL DB2 Mode Supports IBM's DB2 Version 6.
Background image of page 10
SQL Wizard Mode
Background image of page 11

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

View Full DocumentRight Arrow Icon
SQL Wizard
Background image of page 12
Tutorial Tables Most of the example results in the SQL Tutorial are based upon the sample tables contained in your TUTORIAL location (see XDB Server TUTORIAL Location). The TUTORIAL location (along with the sample tables) is generally created automatically (the default) when XDB Server software is installed. You may find it useful to execute the example commands as you work through the tutorial (all commands are executed in XDB mode). Unless otherwise noted, the results printed in this reference reflect the result obtained if the command is applied to the unchanged tables as shown in the
Background image of page 13

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

View Full DocumentRight Arrow Icon
Image of page 14
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 56

Class02.1_ch01A_Spring_2010 - BCIS 4620 INTRODUCTION TO...

This preview shows document pages 1 - 14. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online