ROBOT.LK

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

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

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.

Of cause yes. Without considering the topic category, you can ask all BIT related questions here.

Ah! Thanks

Now I am doing SQL from the link Enigma gave. I did little SQL form MySQL videos of VTC.

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

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

Thanks Friends.

I know some of them.

And Is It OK to learn only above ones?

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

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?