Is there any way of getting integrate marketing cloud with the saleforce Instance. 

I am new to Integrations and trying to integrate with the 3rd party URL - Kindly provide me the sample snippet code how to write 
in APEX with REST/SOAP Integration. The question is "to fetch all the needed data and insert & update(infuture)
in our custom fields of an object from the URL "www.xyz.com.json" I have already parsed, As well I need to update the records in 
future without overrding of the existing data, and alongside which is the best option for updating the records in future for every 90days 
(either Schedule APEX or Future method) from the above said URL".

public class XXXXClass { 
    Public void <MethodName>() {
        string url = 'https://www.XYZ.com.json'; 
        Http http = new Http(); 
        HttpRequest req = new HttpRequest(); 
        req.setEndpoint(url); 
        req.setMethod('GET'); 
        HttpResponse res = http.send(req); 
        if(res.getStatusCode() == 200){ 
            system.debug('response'); 
            map<string,object> resp=(map<string,object>) json.deserializeUntyped(res.getBody()); 
            system.debug(resp); 
        }
    }
}

If I want exclude records starting with '__%' on an Account object how can we write a SOQL query  
Eg: SELECT Id, Name, Status from Account where Name Like 'HA%' - this query will fetch all the receords starting with HA.  But Here I want all the records by 

If I want exclude records starting with '__%' on an Account object how can we write a SOQL query  
Eg: SELECT Id, Name, Status from Account where Name Like 'HA%' - this query will fetch all the receords starting with HA.  But Here I want all the records by