Study Group (Read me)

[tsug!]

---

Wow..CooL..

[cute_6423]

yeah thats why sat nko gi sched

sorry to cute and psyc cause we cant adjust the sched for each member...majority wins na lang mga bro...

ok ra bro, i understand..pero pwede ko nangayo ug notes? gnhan jud ko makat-on ani DBMS oizt..kpoi n au dwat ug lapt n ma fail n grades..huhu

[cute_6423]

Hello Everyone!

I apologize for the wait for the outline.. nabusy jud ko lately.. leaving on a jetplane soon gud.. but ill still be around until july 27/28.. and july 25 man ang seminar..

anyway, here is a rough-outline i've come up for the past two days.. i didn't want to make it haphazard outline.. i asked some of my colleagues also what would be nice for a "crash course" on databases..

please insert and add things you want to be discussed so that i can adjust my presentation materials appropriately on what you want to learn... after all, this is for you guys who mentioned you'd be interested in learning.. i'm just here to share my knowledge (char! in memory of tugak the great! )


1. Introduction to Databases
- History
- Applications/Place in the information Age
- Contrast with other sources of information (heirarchical and network database)
- Personal accounts (experience sharing)

2. Relational Database Management System
- Current Available Software being used (open source and commercial, summary of differences between each that will be useful to you, as far as I know)
- Jump right into Short tutorial on installation and setup, with back-references to section 1, so that you'll know where the concepts in section 1 connects with this part
- This also includes a little overview of database connections, ports, networking, etc
- Definitions of terminologies used - straight-forward na ni
- Data implementations behind the scenes (for C and C++ programmers, linked-lists, pointers, trees, etc)
- Client and Server Model
- Web Model (3-tier model, Model–view–controller model)
- Requirements for RDBMS (more concepts, and back references to previous sections)

3. SQL
- DDL and DML
- Data types
- Security thru SQL
- Joins
- Functions, aggregates (group by, having)
- Optimizations via indexes and keys
- Transaction-SQL

4. Database Modelling
- Current software (used for database modelling)
- Diagrams
- Normalizations

........

Murag gina-compress jud ni tanan.. database is a 2-semester subject in college, but im sure some or most of you have had a course on it already.. this will be a supplementary, and i'll make sure you learn something new always na wala ma-cover sa 2-semesters in college. a lot in the industry is not found in academic, sad to say..

wow sir! very nice one..
sir, pwde ko mangayog notes and tips ky unfortunately, di mn ko kaadto sa seminar dis july 25..
please sir..thanks

[istoryansucks]

how about java gui di ai?

[bluedes]

wow sir! very nice one..
sir, pwde ko mangayog notes and tips ky unfortunately, di mn ko kaadto sa seminar dis july 25..
please sir..thanks

yah sure.. ill just email you the presentation materials after the seminar..

[cute_6423]

yah sure.. ill just email you the presentation materials after the seminar..

thanks sir..
PM'd you my email add..

[Deathnote]

Hello Everyone!

I apologize for the wait for the outline.. nabusy jud ko lately.. leaving on a jetplane soon gud.. but ill still be around until july 27/28.. and july 25 man ang seminar..

anyway, here is a rough-outline i've come up for the past two days.. i didn't want to make it haphazard outline.. i asked some of my colleagues also what would be nice for a "crash course" on databases..

please insert and add things you want to be discussed so that i can adjust my presentation materials appropriately on what you want to learn... after all, this is for you guys who mentioned you'd be interested in learning.. i'm just here to share my knowledge (char! in memory of tugak the great! )


1. Introduction to Databases
- History
- Applications/Place in the information Age
- Contrast with other sources of information (heirarchical and network database)
- Personal accounts (experience sharing)

2. Relational Database Management System
- Current Available Software being used (open source and commercial, summary of differences between each that will be useful to you, as far as I know)
- Jump right into Short tutorial on installation and setup, with back-references to section 1, so that you'll know where the concepts in section 1 connects with this part
- This also includes a little overview of database connections, ports, networking, etc
- Definitions of terminologies used - straight-forward na ni
- Data implementations behind the scenes (for C and C++ programmers, linked-lists, pointers, trees, etc)
- Client and Server Model
- Web Model (3-tier model, Model–view–controller model)
- Requirements for RDBMS (more concepts, and back references to previous sections)

3. SQL
- DDL and DML
- Data types
- Security thru SQL
- Joins
- Functions, aggregates (group by, having)
- Optimizations via indexes and keys
- Transaction-SQL

4. Database Modelling
- Current software (used for database modelling)
- Diagrams
- Normalizations

........

Murag gina-compress jud ni tanan.. database is a 2-semester subject in college, but im sure some or most of you have had a course on it already.. this will be a supplementary, and i'll make sure you learn something new always na wala ma-cover sa 2-semesters in college. a lot in the industry is not found in academic, sad to say..

thank you sir blue...i know your busy so we really appreciate you squeezing as in a already tight schedule...

[kurdapia.nikki]

pede muadto? nia mutan'aw lang sa mga taw. HAHAHAH LOL

[bluedes]

thank you sir blue...i know your busy so we really appreciate you squeezing as in a already tight schedule...

no probs.. just insert or add topics you wish to be discussed.. i'm all go for it.. i also told a colleague faculty of this, and he's interested to join.. i hope he clears up his schedule just fine.. coz from what i heard, he's been assigned a big project.. enrollment system of a university.. but he's not alone in it.. team sila.. at long last.. the university has waken up to its own pool of resources rather than looking for solutions outside..

[cute_6423]

no probs.. just insert or add topics you wish to be discussed.. i'm all go for it.. i also told a colleague faculty of this, and he's interested to join.. i hope he clears up his schedule just fine.. coz from what i heard, he's been assigned a big project.. enrollment system of a university.. but he's not alone in it.. team sila.. at long last.. the university has waken up to its own pool of resources rather than looking for solutions outside..

OT: asa diay kah n university nag teach sir?