Skip to main content

Featured

Constraints

NOT NULL CONSTRAINT -    Ensures that a column cannot have a null value. DEFAULT CONSTRAINT -    Provides a default value for a column when none is specified  UNIQUE CONSTRAINT -   Ensures that all values in columns are different  CHECK CONSTRAINT -   Makes sure that all values in a column satisfy certain criteria  PRIMARY KEY CONSTRAINT -   Used to uniquely identify a row in the table  FOREIGN KEY CONSTRAINT -   Used to ensure referential integrity of the data  Primary Key - is used uniquely to identify each row in a table . It can consist of one or more columns on a table . When Multiple columns are used on a table it is called composite key.  Foreign Key - Foreign key is a column or columns that references a column most often primary key of another table . The purpose of foreign key is to maintain referential integrity of the data. Pg admin  Data base - training - right click on training - query click  Always add semi colen to run the query  Int - integer  varchar - variable charact
Post a Comment
Read more

Mutual Funds

 Mutual Funds is when a company asks a small amount of money from different people. They divide a amount in different parts which is called unit . 

Net Asset value is 10 rs 

40000 Is Units 

Mutual fund will invest 400000 in different fields. So your money indirectly goes to than company whose share price is greater .

Mutual fund is professionally managed vehicle made up money from investors in order to invest on their behalf.

Mutual fund charges fees for the same called expense ratio . 

Per unit value increases because company so mutual fund value also increases .

Investors can sell their units at a higher NAV.

Invest in Systematic Investment Plan. Every month deduct your bank money in mutual fund .

SIP 

5000/- every month invested 

12% return in mutual fund . (assume)

after 20 years it will be approx 49 lakhs.

If you continue your portfolio will be a 1cr value . 

This is known as power of compounding.


Comments

Post a Comment

Popular Posts