More About Database

We continued learning about the DBMS this week. Started with the use of Joins in DBMS.
Then, learnt about the aggregate functions lke max(),min(),sum(),avg() etc.
Learned about Sub queries and covers problem on that concept.
Then, I practised all the queries by making a database with some tables in it and performed operations on it like inserting a new record ,updating an existing record and retrieving the records from the table and then also some complex queries on it using concept of foreign key and primary key i.e. by establishing a relation between more than one table using foreign key.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s