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
BIT Help Line - 1st year 2nd semester - 2011
Re: BIT Help Line - 1st year 2nd semester - 2011
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
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
Re: BIT Help Line - 1st year 2nd semester - 2011
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.
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.
Re: BIT Help Line - 1st year 2nd semester - 2011
Of cause yes. Without considering the topic category, you can ask all BIT related questions here.
Re: BIT Help Line - 1st year 2nd semester - 2011
Ah! Thanks
Now I am doing SQL from the link Enigma gave. I did little SQL form MySQL videos of VTC.
Now I am doing SQL from the link Enigma gave. I did little SQL form MySQL videos of VTC.
Re: BIT Help Line - 1st year 2nd semester - 2011
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
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
Re: BIT Help Line - 1st year 2nd semester - 2011
Nipuna - learn above stuff that Neo has gave. It will cover "Data manipulation using SQL" part. in your syllabusNeo 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
Re: BIT Help Line - 1st year 2nd semester - 2011
Thanks Friends.
I know some of them.
And Is It OK to learn only above ones?
I know some of them.
And Is It OK to learn only above ones?
Re: BIT Help Line - 1st year 2nd semester - 2011
I told you it will cover only the "Data manipulation using SQL" part. U need to study relational database model + relational algebra as wellNipuna wrote:Thanks Friends.
I know some of them.
And Is It OK to learn only above ones?
Re: BIT Help Line - 1st year 2nd semester - 2011
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?
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?