BIT Help Line - 1st year 2nd semester - 2011

Other topics related to computer science
User avatar
Neo
Site Admin
Site Admin
Posts: 2642
Joined: Wed Jul 15, 2009 2:07 am
Location: Colombo

BIT Help Line - 1st year 2nd semester - 2011

Post by Neo » Sun Jul 24, 2011 10:23 pm

Hello guys,

Most of you all know that our great friend Nipuna is bit stuck with his exams at the moment. I have created this topic exclusively for him to ask any question without wasting time to select the category, etc.. Let's get together to give him some helping hand.

Kind Regards,

Neo
User avatar
Enigma
Lieutenant
Lieutenant
Posts: 74
Joined: Sun Jan 16, 2011 12:40 am
Location: Colombo, Sri Lanka

Re: BIT Help Line - 1st year 2nd semester - 2011

Post by Enigma » Mon Jul 25, 2011 12:24 am

Hello Nipuna
I checked some DBMS past papers and it seems most of the questions are targeting on SQL. Also they have allocated 16 hours for SQL in their syllabus. So focus more on SQL. check this link for more details

http://www.w3schools.com/sql/default.asp - This link will cover "Data manipulation using SQL" part

Also you can expect few questions from ER diagrams and relational algebra
For those theory parts I'm still saying , Use the LMS

I have emailed you some notes on DBMS and another book for java. Please check them out.
Hope this will help you

Thanks
User avatar
Nipuna
Moderator
Moderator
Posts: 2729
Joined: Mon Jan 04, 2010 8:02 pm
Location: Deraniyagala,SRI LANKA

Re: BIT Help Line - 1st year 2nd semester - 2011

Post by Nipuna » Mon Jul 25, 2011 8:36 am

Thanks Friends You all Are Really Helping Me.

I will try with those Enigma but by the way you have already given me 2 books :)

Thanks Neo also You are helping me lot. That's why I always say Without ROBOT.LK i am finished :)

I will ask more questions when i get.

Is it OK to ask BIT paper questions in this topic? since they are not only for BIT they all are parts of CS.
User avatar
Neo
Site Admin
Site Admin
Posts: 2642
Joined: Wed Jul 15, 2009 2:07 am
Location: Colombo

Re: BIT Help Line - 1st year 2nd semester - 2011

Post by Neo » Mon Jul 25, 2011 11:18 am

Of cause yes. Without considering the topic category, you can ask all BIT related questions here.
User avatar
Nipuna
Moderator
Moderator
Posts: 2729
Joined: Mon Jan 04, 2010 8:02 pm
Location: Deraniyagala,SRI LANKA

Re: BIT Help Line - 1st year 2nd semester - 2011

Post by Nipuna » Mon Jul 25, 2011 11:33 am

Ah! Thanks

Now I am doing SQL from the link Enigma gave. I did little SQL form MySQL videos of VTC.
User avatar
Neo
Site Admin
Site Admin
Posts: 2642
Joined: Wed Jul 15, 2009 2:07 am
Location: Colombo

Re: BIT Help Line - 1st year 2nd semester - 2011

Post by Neo » Mon Jul 25, 2011 11:52 am

Here are some of the most commonly used SQL syntaxes. If you can list down the questions, we can discuss.

CREATE TABLE, ALTER TABLE

SELECT DISTINCT, COUNT, AVG, FROM, WHERE, LIKE, INNER JOIN, OUTER JOIN, GROUP BY, ORDER BY

INSERT INTO, VALUES

UPDATE, SET, WHERE

DELETE, FROM, WHERE
User avatar
Enigma
Lieutenant
Lieutenant
Posts: 74
Joined: Sun Jan 16, 2011 12:40 am
Location: Colombo, Sri Lanka

Re: BIT Help Line - 1st year 2nd semester - 2011

Post by Enigma » Mon Jul 25, 2011 11:56 am

Neo wrote:Here are some of the most commonly used SQL syntaxes. If you can list down the questions, we can discuss.

CREATE TABLE, ALTER TABLE

SELECT DISTINCT, COUNT, AVG, FROM, WHERE, LIKE, INNER JOIN, OUTER JOIN, GROUP BY, ORDER BY

INSERT INTO, VALUES

UPDATE, SET, WHERE

DELETE, FROM, WHERE
Nipuna - learn above stuff that Neo has gave. It will cover "Data manipulation using SQL" part. in your syllabus
User avatar
Nipuna
Moderator
Moderator
Posts: 2729
Joined: Mon Jan 04, 2010 8:02 pm
Location: Deraniyagala,SRI LANKA

Re: BIT Help Line - 1st year 2nd semester - 2011

Post by Nipuna » Mon Jul 25, 2011 12:16 pm

Thanks Friends.

I know some of them.

And Is It OK to learn only above ones?
User avatar
Enigma
Lieutenant
Lieutenant
Posts: 74
Joined: Sun Jan 16, 2011 12:40 am
Location: Colombo, Sri Lanka

Re: BIT Help Line - 1st year 2nd semester - 2011

Post by Enigma » Mon Jul 25, 2011 12:29 pm

Nipuna wrote:Thanks Friends.

I know some of them.

And Is It OK to learn only above ones?
I told you it will cover only the "Data manipulation using SQL" part. U need to study relational database model + relational algebra as well
User avatar
Nipuna
Moderator
Moderator
Posts: 2729
Joined: Mon Jan 04, 2010 8:02 pm
Location: Deraniyagala,SRI LANKA

Re: BIT Help Line - 1st year 2nd semester - 2011

Post by Nipuna » Mon Jul 25, 2011 1:27 pm

Ah! It's OK.

I was going to ask about "Data manipulation using SQL" sorry I forgot to ask that well. :)

Then I will practice those Commands that Neo gave me. Then the rest. Is it OK?
Post Reply

Return to “Other”