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
Labels

Bitly Analytics

What is the UTM?

-> Urchin Tracking Module it is used to track where the traffic is coming from , it helps in easier way and getting attributes much accurate, When you do any marketing campaign to reap fruitful benefit .

They have certain components - 

1. UTM Source - where the person saw the content . Example - WhatsApp , Instagram etc.

2. UTM Medium - Tool or channel through which the communication reached the audience. It is the specification of the source . Example - G mass to send bulk mails , Instagram story etc.

3. UTM Campaign - Objective or product promoting about , end goal. Objective of what you are promoting .Where your audience actually gonna reach . Example - Internship Registrations etc.

4. UTM Content - Communication /Theme , It is a peace of content .You have to define the campaign in 1 or 2 words , it helps to distinguish between different campaigns . Example - Highlights of the Internship etc. 

5. UTM Term - Audience you are targeting in other words defining the audience . Example - Undergraduate Students , Graduate Students , Instagram Followers etc 

If Instagram story is just of 24 hours and after that people are asking for the link , the parameters are now changed 

Source - Instagram 

Medium - Direct Message 

Campaign  - same 

Content - Know more, enquiry 

Term- Followers 

Bitly-Bitly is a platform which shortens any kind of link and can be customised also.

Labels:

Comments

Post a Comment

Popular Posts