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

Financial Planning

What is Financial Planning ?

In simple words financial planning is a process of making decisions in order to use your finances in a best possible way.

Why to use Financial Planning ?

1. Mitigate the Risk - A proper planning helps to reduce the risk , which is unpredictable in the future , it can be in the form of insurance coverage . 

2. Goal Setting - Financial planning helps in maintaining the goal for future by making budget.

3. Building Wealth - The important point is building wealth for retirement and other future plans , by optimum utilisation of resources . 

4. Retirement - It is when you are at a certain age limit after which you cannot work , then the money you saved or invested comes into picture. It will be Plan to Sustain Ourselves .


Comments

Post a Comment

Popular Posts