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

Importance of Marketing services

 1. Importance of relationships - Product is something you can make along with products services are higher because they make relationship with customers . It adds value to the product . If service is good then only considered good.

2. Customer retention - Retaining customer sis even more important , think about customers , we change our brands on the basis of services and products , considering different personalities of customers . Feedback and requirements of customer. If you see whatever product you buy , there is feedback option. Retaining customers has became the biggest challenge for any brand .While you are buying product , there is service , where customer has to decide whether they will come back or not. Example - the moment you order , they say  product will take time and that is how service is provided because you know they will keep you as priority.

3. Multiple touchpoints - Touchpoints work together in consumer mind . There are lot of brands where customer feedback is reflected . The brand will emphasise to see the website to check the feedback of customer.

4. Services proliferate - Consumers have many service options to choose from . The product is tangible . They offer customer needs . They build relationships by speaking in their regional language. 

5. Feedback improves servicing - Just selling a product is not only good an then giving value added services is really important .

6. Technology impact - Technology having major impact . Decathlon Brand - you go there and bill yourself , so technology even plays a greater role.

Comments

Post a Comment

Popular Posts