[school-discuss] Re: Curriculum development : Databses

[imran@pimsat-khi.edu.pk]

In databases, need to start from scratch till end. However it shoud be
necessarily be the policy that directly considering the core topic for
teaching.  And prevent naming the product wise topic in syllabus. 

System Analysis and Design
Database Management Systems
Related Database Management System
Data Warehousing and Decision Support Systems
Data Warehousing and Data Mining

Moreover, after grading the mentioned databases, according to their complexity
measured by the parameteres of learning depth, understandablity, user
friendliness, frequent use, extensibility, popularity etc. need to put with the
above courses more than 40%, would be a more flexible sol. 

For example with RDBM, 60% Theory 40% MS Access/MySql with minimum 1 Project of
4 Weeks is enough to take start.

One more important point is that most of the institutions are offering Oracle
courses, OCP programs. Which are no doubt gave a student very good stands in
their jobs and interests. 

For example, I personally attended a certification distribution ceremony of NED.
They offered 6 Month Oracle certification with Oracle University (PECHS,
Karachi). I went to take the certificate of my brother, more than 400 students
were awarded by the certification. They six month's course fee was 18,500
rupees per student. (5 Months in NED and 1 month in Oracle University)

SSUET offers multiple courses, please visit (http://www.ssuet.edu.pk/cep/ ),
where all product /certifications/tool based prgrammes are offered. 

Continuing education department in an institution helps in enhancing the goal of
students into the market and make the name of the institution one step ahead.
Alumni should be the part of Continuing education.

All these product/tool/certification based courses should be directly taught
under CEO, (Continuing Education Opportunities). And launch as a seperate
project of PIMSAT will be more effective.

Thanks
Imran Siddiqui


References:
[1] http://www.pafkiet.edu.pk/BCSH.htm
[2] http://www.pafkiet.edu.pk/MSPHD.htm
[3] http://www.szabist.edu.pk/karachi/programs/cs/BS/BScourse.html
[4] http://www.ssuet.edu.pk/cep/

Quoting ahsan rafi <ahsanrafi@yahoo.com>:

> Comments please.
> Ahsan Rafi
> 
> Khawar Nehal <khawar@atrc.net.pk> wrote:
> I think the following is useful for curriculum development and can be 
> considered.
> 
> We need to teach the following Databases for the following reasons.
> 
> MySQL : Simple started database
> 
> PostgreSQL : Full featured Open Source Zero cost licence 
> 
> Oracle : Most popular in Pakistan 
> 
> IBM DB/2 : Popular in real life installations where governments and IBM is 
> involved.
> 
> Jet Max DB : Upcoming database supported by SAP (a pumped up turbo charged 
> version of MySQL) which is designed to replace all others like Oracle, MSSQL,
> 
> DB/2 and whatever else as the platform of choice for SAP.
> May be essential 1 to 2 years from now.
> 
> Databases to reduce teaching : 
> Sybase/MS-SQL : Getting outdated and replaced by Oracle and Postgres.
> 
> MS Access : Too complex and not to be considered as a starter database for
> new 
> students.
> To make life easier try PostgreSQL with Pgaccess.
> 
> Please send comments.
> 
> 
> ---------- Forwarded Message ----------
> 
> Subject: 
> Date: Wednesday 01 Sep 2004 08:25
> From: Rajesh Kumar 
> To: undisclosed-recipients: ;
> 
> Gecko/20040820 Debian/1.7.2-4
> X-Accept-Language: en
> MIME-Version: 1.0
> To: schoolforge-discuss@schoolforge.net
> Subject: Re: [school-discuss] MySQL in classroom
> In-Reply-To: <4127888E.2000607@cs1.mcm.edu>
> Content-Type: text/plain; charset=us-ascii; format=flowed
> Content-Transfer-Encoding: 7bit
> X-AntiAbuse: This header was added to track abuse, please include it
> with any abuse report
> X-AntiAbuse: Primary Hostname - host32.ipowerweb.com
> X-AntiAbuse: Original Domain - schoolforge.net
> X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12]
> X-AntiAbuse: Sender Address Domain - meetrajesh.com
> Sender: owner-schoolforge-discuss@schoolforge.net
> Precedence: list
> Reply-To: schoolforge-discuss@schoolforge.net
> X-To-Get-Off-This-List: mail majordomo@schoolforge.net, body unsubscribe
> schoolforge-discuss
> 
> Dr. Robert G. Rittenhouse once wrote:
> > A bit offtopic and at the risk of starting a flamewar I wouldn't really
> > recommend MySQL for this role. Prefer to work with a more standard SQL
> > compliant and more capable DBMS such as SAP DB/MaxDB or perhaps
> > PostgresSQL.
> 
> I respect your informed opinion, but here is what a MySQL user for 18
> months has to say:
> 
> If you're going to be teaching a bunch of high school students database
> basics (note I said "basics"), just close your eyes and go for MySQL.
> Don't bother about the licenses, don't bother about complexity and lack
> of features. And most important of all, don't listen to any
> "professional" or adult advice as they always tend to under-estimate the
> capability of a high school student. Mark me, I am myself a high-school
> student and a self-taught MySQL administrator, having learned everything
> by only reading the MySQL manual.
> 
> Are you going to be beginning day 1 with stored procedures and triggers?
> No! It wouldn't even make sense to explain stored procedures, triggers
> and UDF's after a year. And don't worry about MySQL deviating from the
> ANSI standard, because there is a specific purpose for each of these
> deviations. And most of the time, it's just increased comfort and usability.
> 
> Believe me, if people get used to MySQL, it isn't necessarily hard to
> switch to another database, as some would have you believe. I have been
> using MySQL for a long time, and when I tried to switch to PostGreSQL, I
> was able to do so without too much effort (I'm a fairly talented
> documentation reader, so I don't make a good example).
> 
> MySQL is very easy and doesn't overwhelm the user, and has pretty a
> comprehensive documentation. Want quick info. about ALTER? Try
> mysql.com/alter.
> 
> Nothing could be any more funny as this:
> 
> Q. What database do you recommend for first-time database users?
> A. MySQL
> Someone else: But MySQL doesn't implement transactions well! It doesn't
> do stored procedures the way it should. Its C code is not optimized well
> enough! It doesn't have Foreign key support! And it hangs when bombarded
> with 30 million records! And it does not support DB files spread across
> multiple file systems, and it doesn't implement....
> 
> Relax, we're talking about kids who don't even know the syntax for a
> SELECT! What good are triggers and procedures going to do for them? And
> you hardly are going to load in 100 rows of data.
> 
> Believe me, after about year, students will automatically find MySQL
> insufficient for their needs, and they will automatically move towards
> other feature-filled databases. Till then, as a high-school student
> myself, if you're teaching SQL to a set of first-timers, go for MySQL.
> Don't even think of PostGreSQL (although PostGreSQL is better than MySQL
> in some ways) Trust me, if you go for high-end databases at the start,
> that would just serve to overwhelm your students and chances are that
> they would simply reject the idea of learning anything at all about
> databases. And once they are at that stage, it is very hard to make them
> accept databases ever again.
> 
> Don't even go for MaxDB. Again, if students find MySQL incapable, they
> will automatically, by a very natural process, switch to other capable
> solution. But if you try to force this natural process, then be assured
> your very noble endeavors will go wasted. And I sincerely would love to
> see some high-school students learn MySQL, at a time when most students,
> when asked about databases in general, go "what?!? Whatssa dutabase? Is
> it that telephone directory which lists all names in alphabetical
> order?" And rest of the gang think Microsoft Access is the end of
> database technology in our world. Mind me, I'm speaking from experience
> and am saying exactly what people have said to me in the past.
> 
> Go MySQL, I tell you. I congratulate you for helping students learn
> databases! It truly is a noble service.
> 
> 
> 
> --
> [ Rajesh Kumar ]
> 
> -------------------------------------------------------
> 
> -- 
> Khawar Nehal
> 
> CEO
> Applied Technology Research Center (ATRC)
> C-55 Block A KDA Officers
> Karachi 75260
> Pakistan
> Voice : 92-21-4980523
> Mobile : 92-300-9284698
> Email : khawar@atrc.net.pk
> 
> Acting Registrar 
> Preston Institute of Management, Science and Technology (PIMSAT)
> 177/2 IEP Building, 
> Opposite Regent Plaza (Formerly Taj Mahal Hotel) 
> Shahrah-a-Faisal, 
> Karachi, 
> Pakistan
> Voice : 92-21-7789888 to 90 
> Fax : 92-21-7789891 
> Email : khawar@pimsat-khi.edu.pk
> General Inqiries : info@pimsat-khi.edu.pk
> 
> 
> 		
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail Address AutoComplete - You start. We finish.