November 14th - Database Workshop - open discussion
Submitted by timinflorida on November 21, 2008 - 11:07pm
Discussion moved here from google groups.
Hello everyone,
This is sort of a trial run for what I hope we can start after each
session.
We do not get much of a chance to discuss the meetings and workshops
so I thought I would open a discussion on Professor Steve Mannions
Database Design Workshop. I hope that others will participate.
I thought he gave a good basic introduction to relational databases.
I havent taken any of his classes and one thing I probably should have
asked was how in depth they go. I found his opinion that the classes
he taught in access, sql and oracle would give you a good grounding to
start in the field very interesting as many jobs have bloated
requirements and it is nice to know what someone who works in the
field thinks.
I look forward to seeing some thoughts from others in the group.
Do databases interest you?
Did you find the workshop helpful / interesting?
Do you have experiences in his courses?
What is your real world experience?
Tim Moore
------------------------------
Do databases interest you?
- Yes very very much
Did you find the workshop helpful / interesting?
- was not present sorry
Do you have experiences in his courses?
- Yes, taking ORacle 10G administration and Advance Pl/SQL
What is your real world experience?
- I have worked in Access mostly, build a couple databases, but nothing as extensive as what I am getting from his class.
Earlin J. Thimbriel
------------------------------
I have no real world experience however, Prof. Mannion's workshop has definitely demystified the basic aspects of databases. I feel that for people like myself, these workshops help because even though I have a decent computer background there are certain aspects of computing that scare me in their complexity and these workshop help me want to attempt to explore those aspects.
Daryl Campbell
------------------------------
Yeah I do agree with you there. I am confortable with databases, and currently enrolled in both of Prf. Mannion calls, however, I am afraid of networking, web design and linux to a certain degree. I have worked with them, but I am not 100% confident, so yeah sure, when workshops come up, maybe we ought to have some hands on, and more time.
Earlin J. Thimbriel
------------------------------
Great idea on the hands on part of the workshops it is the best way for people learn. I also feel that if I am taking out time that I could spend with my family just to go to the meeting then staying longer to get a greater benefit is fine for me.
Daryl Campbell
My (possibly inaccurate) notes on the workshop.
Steve Mannion has worked in the field since 1977. He teaches courses in SQL, Oracle and PL/SQL
Most current Databases are Relational Databases.
They are made up primarily of Tables and Relationships
The Primary Key is important. Sometimes there are 'Natural Keys' but often auto number (Access), ID (SQL) and Sequences (Oracle) provide an alternative.
Normalization and Entity Relationship Diagrams are used to help create separate tables. Bridging tables are used to create the One to Many Relationships necessary for efficient use.
Many to Many relationships will cause extensive duplication and query problems
There is one important language for database and that is Structure Query Language
Select *
From
Where
Groupby
DML (data manipulation language)
Add Change and Remove
Example: Insert into student2 value ('123', 'joe', '4')
DDL (data definition language)
Create and Author Objects
Example:
create table student2
(
ssn varchar2(9),
name varchar29(30),
gpa number
)
DCL (data control language)
Security and Users
Opinion of company use and market trend
Large – DB2, Oracle, SQL Server
Medium – SQL Server
Small – MySQL
Trend Moving MySQL upwards because it is free.
Previous AIPT National Competition
Using SQL: From case study information 1) Design Database, 2) Populate and 3) Create Reports and Queries.
Very good post, thanks a lot.
Post new comment