Forem: Hasan Aboul Hasan

How To Install SQL Server on Ubuntu

Hasan Aboul Hasan — Fri, 01 Jul 2022 17:10:51 +0000

In this post, we'll learn How to Install Microsoft SQL Server on Ubuntu VPS Server. and we will see how to connect and manage it remotely using SQL Server Management Studio on windows.

Let's Get a VPS Server

In this tutorial, I will use VULTR, and if you wanna follow with me a test, you can use this link to get 100$ free credits for two weeks!

Create a new VPS

Select Cloud compute.
Select any region you want.
Select Ubuntu as the OS.
Enter server name (anything you want)
Click deploy

VULTR will install, deploy, and prepare this Ubuntu Linux server in your account. And when it's finished, you will see the IP address, the username, and the password.

Great! we have an Ubuntu Server ✅ Let's Start the installation.

we will be using putty SSH client to connect and manage our server.

Open putty, enter the server IP, and connect:

Enter "root" as the user name, and get the password from Vultr Dashboard.

Install SQL Server

The first command is wget command:
wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

Adding SQL server package
sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/20.04/mssql-server-2019.list)"

NOTE: This may change depending on the Ubuntu version you are working with.

Update SQL Server
sudo apt-get update

sudo apt-get install -y mssql-server

*Configuration command *
sudo /opt/mssql/bin/mssqql-conf setup

Now Continue the wizard:

Select your edition, I will go with express.
Accept Terms (Y)

Set The SQL Server Password

And Congratulations! SQL Server is now starting 🎉

SQL Server Run Check Command:
systemctl status mssql-server --no-pager

And it's running perfectly.🚀🚀🚀

Managing With SQL Server Management Studio

Setting up SQL Server Remote Port

in putty, run this command:
Sudo iptables -A INPUT -p tcp –dport 1433 -j ACCEPT

Now we can connect to SQL server from our local PC.

Open SQL Management Studio, Enter your server IP.

Enter "sa" for the user name, and enter your sql server password that you chose in the setup.

Connect!
Yay, it did work!!!👌

I'll be answering questions in the comments below if you have any.

How To Build Your Own Keyword Tool With Google Ads API & C#

Hasan Aboul Hasan — Wed, 22 Jun 2022 19:06:52 +0000

What we will build?

We'll use Google Ads API to build a keyword Research tool that allows you to get keyword suggestions and metrics like Search volume data , CPC and Competition based on user input.

Examples of keyword tools:

If you go to keywordtool.io, you can search for a keyword, it will give you hundreds of keyword suggestions.

It is considered one of the best free keyword tools. (But it’s not totally Free)

Another example is H-supertools.

I developed H-supertools from scratch, and today this website is one of my main income streams.

Today, In this post, I will reveal how you can build similar tools, so maybe you can turn it also into an income source too!

How does our Keyword Tool works?

It's a simple C# console application. When you run it, you'll have two options:

Authenticate with Google Ads API
Perform keyword research

Let's perform Keyword Research and search for "C#"

After the search, our tool gets back ~500 keyword ideas with search volume data, competition, and CPC values.

Of course, In my case, it's a simple console application (just for simplicity reasons) But we can use and implement the same code in any type of applications like mobile, web, or even a desktop application.

Let's Start Coding!

Step 1: Setup Your Google Console Account

So, our first step is to go to Google cloud console and login with your Gmail account.

After you login, create a project, and then click on Enable APIs

Now search for “Google ad API” and Enable The API

Step 2: Create OAuth Credentials to access Google Ads API

Finish the wizard, then you will be able to get the client and secret IDs as shown in the images below:

We will use these Keys to authenticate our application.

Before we continue, if you are that person who loves to watch videos instead of reading long posts, you can check the full tutorial here:

Google Ads API Authentication Code

Open KeywordIdeasGoogleAPI.cs Class in our Project.

You will see we have two methods.

Authenticate()
Search()

I found the Google ads API authentication code on Github.

I tweaked it a little bit and Made it simpler for you to understand and use 😃

Let's Authenticate!

I will run the application.

Hit 1 to authenticate.

It will ask you for the client ID and secret

Copy From Google Console, Paste, hit enter, and authenticate your Gmail account.

Now it will prompt you to copy authentication keys:

Copy and paste these keys in the app.config file in your project files.

How To Get The Google Ads Developer Token

Now the next step is to get the developer token. As You can see, we need to set the developer token in the app.config file.

For this, you will need to create a Google ads Manager Account.

Click Here To Create a Google ads Manager Account.

Create one, Sign In, and click on tools, then click on API center and you'll see the developer token there.

We got the Token, Paste in the app.config file, and we are ready!

Perform a Keyword Research Test

In the Google Ads API, we have the keyword ideas service.

It is the service I used to perform keyword research.

The Sample Code mentioned on the page will not work directly, this is why again, I tweaked and simplified it so you can run easily and smoothly. (I think I deserve a Heart and maybe a Unicorn 😅)

The Search Method

In the main application, create an instance of our class KeywordIdeasGoogleAPI.

Create a new object of Google client, and pass it to the search method with other parms: locationId, customerId, languageId, and the searchTerm.

How to get the customer id?
Create a Google Ads Test Account

Login, and you will see a red message showing that this is a test account, just click and copy the customer ID as shown below:

Make sure to remove the dashes and keep only the numbers when you paste in your code.

we still have locationId and languageId.

Find a list of Location IDs by clicking here. And Find a list of Language Ids here.

For Example, "English" Id is 1000, and "New York" Id is 21167.

Now we are ready to perform a keyword research!

Run the application again

Let's say, we wanna search for this keyword: “subscribe to my channel.” 😅

Hit Enter, and you will see the Magic🎩

Note: CPC Bids means that advertisers are paying these numbers to advertise on Google.

Check The Full Project Here on Github.

If you did it. Congratulations 🥳

The Google Ads API is free but has some limitations.Did you know you can use the Free Google Suggestions API To Develop a Keyword Research Tool with no limits! Yes! If you wanna learn how. Check this post.

Develop a Keyword Research Tool in Minutes (Python and C#)

Hasan Aboul Hasan — Tue, 21 Jun 2022 16:04:47 +0000

I reverse engineered 2 Big Keyword Research Tools, and I found out how they work and how you can build the same on your own.

The Sites Are:

Answerthepublic: a website that allows users to type in a keyword or phrase and receive a list of related questions that people have searched for on the internet.
Keywordtool.io: a keyword research and analysis tool that helps users find and analyze the best keywords for their website or online business.

Even if you are not so experienced in programming, you can still easily follow up with this tutorial and Develop a Keyword Research Tool with Python or C#.

How do Keyword Research Tools Work?

Well, it depends on the scope and functionality of the Tools you’re making, and the SEO metrics you want your Tool to Provide.

In our case, we will focus on “google search suggestions” and “Question Suggestions.” I will also tell you later how you can get more metrics.

Let’s see how these tools are getting results, Open Google Search, and Type “Python Tutorial” press space and type the letter “f”, you will see Google suggesting keyword ideas and search queries!

And if you Add “how” before the “python tutorial” keyword in Google Search. you will get question suggestions.

That's it!

How To Read Google autosuggestions programmatically?

We have two approaches:

Using Web Automation and Scraping
Using Google Search Free API Call

I chose the second approach simply because with web automation, the operation will be slower, and you may get Re-captcha to solve, and things will be complicated.

API Call for Google Keyword Suggestions:

open your browser, and paste this url:

http://google.com/complete/search?output=toolbar&gl=COUNTRY&q=Your_QUERY

You can change the country and the query to get google autosuggestions in XML format using this call as shown below:

I think you got the point, we will call the Google Suggestions API, then fetch the results from our code.

Python code:




import requests
import xml.etree.ElementTree as ET

# Define Class

class QuestionsExplorer:
    def GetQuestions(self, questionType, userInput, countryCode):
        questionResults = []
        # Build Google Search Query
        searchQuery = questionType + " " + userInput + " "
        # API Call
        googleSearchUrl = "http://google.com/complete/search?output=toolbar&gl=" + \
            countryCode + "&q=" + searchQuery

        # Call The URL and Read Data
        result = requests.get(googleSearchUrl)
        tree = ET.ElementTree(ET.fromstring(result.content))
        root = tree.getroot()
        for suggestion in root.findall('CompleteSuggestion'):
            question = suggestion.find('suggestion').attrib.get('data')
            questionResults.append(question)

        return questionResults


# Get a Keyword From The User
userInput = input("Enter a Keyword: ")

# Create Object of the QuestionsExplorer Class
qObj = QuestionsExplorer()

# Call The Method and pass the parameters
questions = qObj.GetQuestions("is", userInput, "us")

# Loop over the list and pring the questions
for result in questions:
    print(result)

print("Done")

C# code:



//start

using System;
using System.Collections.Generic;
using System.Net.Http;
using System.Xml.Linq;

namespace GoogleSuggestion
{
    //Define Class
    class QuestionsExplorer
    {
        public List<string> GetQuestions(string questionType, string userInput, string countryCode)
        {
            var questionResults = new List<string>(); //List To Return

            //Build Google Search Query
            string searchQuery = questionType + " " + userInput + " ";
            string googleSearchUrl =
            "http://google.com/complete/search?output=toolbar&gl=" + countryCode + "&q=" + searchQuery;


            //Call The URL and Read Data
            using (HttpClient client = new HttpClient())
            {
                string result = client.GetStringAsync(googleSearchUrl).Result;

                //Parse The XML Documents
                XDocument doc = XDocument.Parse(result);

                foreach (XElement element in doc.Descendants("CompleteSuggestion"))
                {
                    string question = element.Element("suggestion")?.Attribute("data")?.Value;
                    questionResults.Add(question);
                }

            }

            return questionResults;

        }



    }

    class Program
    {
        static void Main(string[] args)
        {
            //Get a Keyword From The User
            Console.WriteLine("Enter a Keyword:");
            var userInput = Console.ReadLine();

            //Create Object of the QuestionsExplorer Class
            var qObj = new QuestionsExplorer();

            //Call The Method and pass the parameters
            var questions = qObj.GetQuestions("what", userInput, "us");

            //Loop over the list and pring the questions
            foreach (var result in questions)
            {
                Console.WriteLine(result);
            }

            //Finish
            Console.WriteLine();
            Console.WriteLine("---Done---");
            Console.ReadLine();
        }
    }



}

//end

Get Source Codes on Github:

Conclusion

In this post, I showed you how you can build a keyword research tool based on Google's Suggestion API with the power of two popular programming languages, C# and Python.

Maybe you are wondering how to get search metrics, like CPC, Monthly Search Volume, and Competition. The answer is in this post.

Take care, and Happy Coding!