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

Economic Environmental Analysis

 Fundamental analysis is determining - If somebody is providing you advices services based on company’s balance sheet ,Cash flow statement and income statement .

Technical analysis is all about charts and candles .

To see like analyst trading view website.

There 2 ways to analyse a particular stock 

Top to Down Approach -

Global scenario   (International market )

Indian Economy

Sector Performing good

Which company is performing good in sector ?


Down to Top Approach  -  

Company Chose 

Sector seen 

Indian Economy study 

Global scenario


Economic Analysis - HNWI , Foreign firms conduct economic analysis for their HNWI Clients .

It is not popular in India but prominent in Foreign country.

We can take action in particular stock . Example - Inflation , deflation , GDP , GNP Analysis .

The clients depend on analyst and give numbers about growth with calculations .

They want a particular number . 

It is related to interest rate , inflation etc.

Every country has its balance sheet called Balance of Payment , which tells about whether company is doing good or not . 

It will tell you whether the economy is in good condition or not.

How to read BOP?

Check the site where you can see the country's reserves , CA etc .




                                               

Comments

Popular Posts