Monday, June 19, 2017

Article on Digital Marketing


 C:\Users\vijju\AppData\Local\Microsoft\Windows\INetCache\Content.Word\01.png

                 


 F:\0000000000000\2017\06-2017\19-06-2017\digital_online_marketing_1_comapny_agency_advertising_gurgaon_delhi_noida.jpg
Throughout Centuries, Marketing is a basic fundamental to any business success and it is primarily Customer centric. Promoting a product or service to reach right audience in a compelling way is the primary goal of any successful business. In order to promotion often entrepreneurs or small business owners don’t know where to start and how to start, whether it is online or offline to make their promotional campaigns more effective.  Promotional campaigns are of mainly two types offline and online.

C:\Users\vijju\AppData\Local\Microsoft\Windows\INetCache\Content.Word\02.png
  
 F:\0000000000000\2017\06-2017\19-06-2017\Reach-your-target-audience-graphic.gif

Effective online campaigns with powerful Digital Marketing strategies will take businesses to next level. Having Websites helps businesses of all kinds to connect people who are searching online. Most of the people are doing research before buying decisions online. Unlike Traditional marketing.

  
C:\Users\vijju\AppData\Local\Microsoft\Windows\INetCache\Content.Word\03.png
 F:\0000000000000\2017\06-2017\19-06-2017\socialmedia.jpg
There is an explosion in terms of number of people joining various Digital Media Networks such as Facebook, LinkedIn etc. Digital Marketing is the most sought after skill for any professional who has role to play in marketing. Understanding Target market beyond traditional marketing strategies with specific analysis, analytics & search that yields best user experience is possible with Digital Marketing Strategies. Often several Business work with a motto " We are not in the business of supporting a media industry, we are in the business of connecting with customers"
  
C:\Users\vijju\AppData\Local\Microsoft\Windows\INetCache\Content.Word\04.png
  
 

  
 C:\Users\vijju\AppData\Local\Microsoft\Windows\INetCache\Content.Word\05.png
F:\0000000000000\2017\06-2017\19-06-2017\Digital-Marketing-2.jpg


Evaluation of Tactics for effectively driving traffic that converts leads to customers in any business with changing Mindset along with the rise of Social Media irrespective of any industry. Understanding Day to Day challenges in building online brand reputation management for local and global companies that strikes a balance between Research and practical hands on experience that tie to real world considerations.
  
 C:\Users\vijju\AppData\Local\Microsoft\Windows\INetCache\Content.Word\06.png

 

The Revolution of social media and Smart phone usage have ensured that everything is setting up for building tomorrow’s brand today. Today’s Digital Marketers are upending Massive markets that brings great experience to test various marketing analytics assumptions that needs to built for a user centric approach with remarkable experiences.

 C:\Users\vijju\AppData\Local\Microsoft\Windows\INetCache\Content.Word\07.png

 F:\0000000000000\2017\06-2017\19-06-2017\news_sample_2060_1159_60_s.jpg

The major timeline innovations of Digital Marketing always found a space to grab the attention of Targeted audiences. The Major in demand skills for Digital Marketing are Content Marketing, Social Media Marketing, Search Engine Optimization and Mobile Marketing. Digital Marketing careers are not only in demand but they could also be the key to having a life outside of work

 C:\Users\vijju\AppData\Local\Microsoft\Windows\INetCache\Content.Word\08.png


 

Digital Marketing is a massive field with wide variety of career options. It is not only the future. It is the need of today. The Opportunities for a Digital Marketing are huge in India. A fresh graduate can get close to 25k per month to 6 Lakhs per annum where in an experienced can command remunerations in the range of 20 Lakhs to 75 Lakhs per annum.


Monday, April 17, 2017

Difference between OBIEE 11G & 12C



S.N0
                   OBIEE 11G
           OBIEE 12C
1
There is no testing and validation tool available after updating 11g                                            
Validation tool provided by oracle after upgrading  to 12c
2
Unable to build using external content from the front end
Report can be build by using external source as well
3
Heat matrix view is not present
Heat matrix view is present
4
Sorting for graphs/pivot table are not Present
Sorting added
5
Have to open the view to edit the Properties
Able to open properties of view from Compound layout only
6
Upload RPD through  User Interface
No more deployment  from Enterprise Manager
7
OPMNP process control is present
OPMN is removed
8
Security GUID’s used
Security GUID’s removed
9
Complicated Security Socket Layer (SSL) configuration
Simplified Security Socket Layer (SSL) configuration
10
RPD, Catalog, roles are scattered
BAR Archive Process used in 12c

Wednesday, October 5, 2016

Installing MySQL 5.7.15 on Microsoft Windows 7

Prerequisites:
To be able to install and run MySQL 5.7.15 your System needs to have library Microsoft .Net Framework installed.
Download and Install Microsoft .Net Framework
1.Download Microsoft .Net Framework from below link
and Click on Download button to download Installer file.
2. Move to the folder to which the MSI file was downloaded and double-click on it to start  Microsoft. NetFramework Installer. – click “Yes” when prompted.


3. Accept the terms in the License   by checking the box and hit “Install”.
             
4. It would take some time for the progress bar to start moving… be patient.
5.Finally Click on Finish button.
Download and Install MySQL 5.7.15
  1. Download MySQL 5.7.15 from this link   http://dev.mysql.com/downloads/installer/
  2. please click on that link to load it in a browser
  1. Scroll down and locate the MSI installer file corresponding to your system type – 32 bit or 64 bit. Click the Download link/button beside it as below.
  1. You will be asked to register or sign in at your account. Registering has its benefits, but if you are in a hurry, simply click on the No thanks, just start my download! Link its automatically gets downloaded.


Setting up MySQL

  1. Move to the folder to which the MSI file was downloaded and double-click on it to start MySQL installation – click “Run” when prompted.



  1. Selecting “Yes” prompts another window as below and take few minutes for processing.


  1. Accept the terms in the License Agreement by checking the box and hit “Next”.


  1. Choose the appropriate Setup Type for your system. Typically, you will choose Developer Default to install MySQL server and other MySQL tools related to MySQL development, helpful tools like MySQL Workbench. Or, choose the Custom setup type to manually select your desired MySQL products. Here I am selecting Custom Setup Type.


  1. Select the products from MySQL package as below screen. As per my requirement I am selecting MySQL-Server 5.7.15(X86).
  1. You are now ready to install MySQL on Windows 7 operating system. Click “Execute”.
  1. Later It will prompt following wizard and take time for Execution.
  1. After successful Execution It will prompt following window and click “Next”
  1. Click on “Next” to configure the MySQL
  1. Select the Config Type as Development Machine from different config types as below.
  1. Click on “Next”
  1. The password for the MySQL server instance has to be typed in twice as below. Remember to keep a note of it and don’t lose it. The password doesn’t have to be very strong because, I suppose, you would be using MySQL on your computer for learning/development and NOT production. And hit “Next”.
If you want to add User, you create user by clicking “Add User” button from below instructions. This is optional one.


Here provide the password for twice enable OK to create user.
  1. Click on “Next” button
  1. The configuration window prompts Plugins and Extensions Wizard. Just hit “Next”
  1. Finally, Server Configuration wizard has received all the information it needs and is ready to create a MySQL server instance. Click “Execute” button
  1. After Successful configuration it enables Message to Click on “Finish” button
  1. Product Configuration Completion Wizard Appears with successful completion of our selected product. Check once and hit on “Next”
  1. After successful completion of our selected products will prompts Product completion wizard simply click on “Finish”.

Checking the MySQL installation
  1. The easiest way to check MySQL installation and confirm that it’s working properly is to use the MySQL Command Line Client. Fire it up from “All Programs” -> “MySQL” -> “MySQL Server 5.7“
  1. Now enter the MySQL password – the characters you type will be replaced by the asterisk sign (the password is not shown for security reasons – obviously).




  1. The MySQL client displays the MySQL> prompt on successful login.
  1. Type show databases; (the semi-colon at the end is not a typo) and hit the enter key. This simple SQL command instructs MySQL to display the names of the installed databases and there should be four of these. Hurray! Rejoice because you have been able to correctly install MySQL on Windows 7.

Tuesday, October 4, 2016

MySql 5.5.16 Database Installation

Download MySQL installer file
  1. Download mysql-5.5.16-winx64.msi from this webpage link http://www.mysql.com/downloads/mysql/
  2. You will be asked to register or sign in at your account. Registering has its benefits, but if you are in a hurry, simply click on the No thanks, just start my downloads! Link.
  3. A list of sites from where you can download the MySQL file will be displayed.
  4. Choose a ‘mirror’ which is closest to your geographical location to get the file fast. FYI, there is no problem in choosing a site located in Europe even though you are in the United States

Setting up MySQL

  1. Move to the folder to which the MSI file was downloaded and double-click on it to start MySQL installation – click “Run” when prompted.Double-click on the MySQL installer (.msi) file. Choose Run when prompted.
  1. Click “Next” button in the introductory window
C:\Users\SSS2015052\Desktop\Mysql\1.png
  1. Accept the terms in the License Agreement by checking the box and hit “Next”
C:\Users\SSS2015052\Desktop\Mysql\2.png
  1. In the following screen, select Custom installation which will allow you to specify the folder to which MySQL will be installed. FYI, choosing Typical will put MySQL deep down in the “Program Files” folder.
  1. Click the “Browse” button
  1. And enter C:\MySQL in the Folder name field. Hit “OK” when done.
  1. The installer will change the MySQL installation folder to the one specified by you – C:\MySQL
  1. You are now ready to install MySQL on Windows 7 operating system. Click “Install”
  1. It would take some time for the progress bar to start moving… be patient.
C:\Users\SSS2015052\Desktop\Mysql\4.png
C:\Users\SSS2015052\Desktop\Mysql\5.png
C:\Users\SSS2015052\Desktop\Mysql\6.png
  1. You may also get messages along the way – simply click on “Next” to proceed.
  1. When the process finishes, you’ll get to see the final screen. Congratulations – MySQL has been installed on your computer. You are now prompted to Configure the MySQL server; click “Finish.

Configuring a MySQL instance

  1. The MySQL Instance Configuration Wizard will now launch click “Next” to proceed. Please note that you cannot use MySQL until an instance has been configured, so these steps are quite important.
C:\Users\SSS2015052\Desktop\Mysql\11.png
  1. Select “Detailed Configuration” option
C:\Users\SSS2015052\Desktop\Mysql\12.png
  1. Choose “Developer Machine
C:\Users\SSS2015052\Desktop\Mysql\13.png
  1. I suggest going ahead with “Multifunctional Database” unless you know what you are doing.
C:\Users\SSS2015052\Desktop\Mysql\14.png
  1. In the following screen, don’t mess with the default values and click “Next”.
C:\Users\SSS2015052\Desktop\Mysql\15.png
  1. The same goes for the subsequent screen; click “Next”
C:\Users\SSS2015052\Desktop\Mysql\16.png
  1. For the networking options configuration, put a check mark in front of “Enable Strict Mode” if it’s not there
C:\Users\SSS2015052\Desktop\Mysql\17.png

  1. Move ahead with the “Standard Character Set” C:\Users\SSS2015052\Desktop\Mysql\18.png

  1. Yes, it’s recommended to install MySQL as a Windows service and have the system include the MySQL bin directory in the Windows PATH variable.
C:\Users\SSS2015052\Desktop\Mysql\19.png
  1. The password for the MySQL server instance has to be typed in twice as below. Remember to keep a note of it and don’t lose it. The password doesn’t have to be very strong because, I suppose, you would be using MySQL on your computer for learning/development and NOT production.    
      
  1. The configuration wizard has received all the information it needs and is ready to create a MySQL server instance. Click “Execute” button
Instance Configuration Wizard is ready with all information - Click Execute button. MySQL instance configured successfully - click Finish.
Ignore messages from the anti-virus program and answer in the affirmative when the Windows 7 UAC (User Account Control) asks whether you want to run MySQLInstanceConfig.exe file. Generally, the instance should be configured without any problem.
However, if the MySQL Instance Configuration Wizard becomes unresponsive (the window shows a ‘Not Responding’ message), launch the Task Manager either from the Control Panel or use the old Ctrl-Alt-Del key combination and kill the program. Now go to C:\MySQL\bin folder and double click on MySQLInstanceCOnfig.exe file to launch the wizard once again.

Checking the MySQL installation

  1. The easiest way to check MySQL installation and confirm that it’s working properly is to use the MySQL Command Line Client. Fire it up from “All Programs” -> “MySQL” -> “MySQL Server 5.5“
  1. Now enter the MySQL password – the characters you type will be replaced by the asterisk sign (the password is not shown for security reasons – obviously)
  1. The MySQL client displays the mysql> prompt on successful login.


  1. Type show databases; (the semi-colon at the end is not a typo) and hit the enter key. This simple SQL command instructs MySQL to display the names of the installed databases and there should be four of these. Hurray! Rejoice because you have been able to correctly install MySQL on Windows 7.