<!-- 33 blog posts


Four ways to be more agile with data
https://www.jarmany.com/what-we-think/blog/four-ways-to-be-more-agile-with-data/
Tags (6) : Agile, Data analytics, Business transformation, Dark data, Data silos, Predictive analytics, 

What is Big Data as a Service?
https://www.jarmany.com/what-we-think/blog/what-is-big-data-as-a-service/
Tags (6) : Analytics for Twitter, BDaaS, Bid data as a service, Big data, Cloud, Data analytics, 

What is data consolidation?
https://www.jarmany.com/what-we-think/blog/what-is-data-consolidation/
Tags (6) : Data analytics, Data silos, Data consolidation, Data insights, Data integration, Single version of the truth, 

What prescriptive analytics can do
https://www.jarmany.com/what-we-think/blog/what-prescriptive-analytics-can-do/
Tags (5) : data, Data analytics, Data insights, Data science, Prescriptive analytics, 

Getting started with marketing analytics shouldn't be daunting!
https://www.jarmany.com/what-we-think/blog/getting-started-with-marketing-analytics-shouldnt-be-daunting/
Tags (5) : Data analytics, Marketing analytics, Marketing data, Proof of concept, Proof of value, 

The real benefits of real-time dashboards
https://www.jarmany.com/what-we-think/blog/the-real-benefits-of-real-time-dashboards/
Tags (6) : Data analytics, Data dashboards, Data platform, KPIs, Metrics, Real time dashboards, 

What is business intelligence?
https://www.jarmany.com/what-we-think/blog/what-is-business-intelligence/
Tags (6) : Data analytics, Data science, BI, Business intelligence, Data skills, Data software, 

What is econometric modelling?
https://www.jarmany.com/what-we-think/blog/what-is-econometric-modelling/
Tags (6) : Data analytics, Business forecasting, Econometric analysis, Econometric modelling, Marketing mix modelling, Statistical modelling, 

When software alone is rarely the answer
https://www.jarmany.com/what-we-think/blog/when-software-alone-is-rarely-the-answer/
Tags (6) : Big data, Data science, Data software, Big data software, Data as a service, Software agnostic, 

Why is data mining so important?
https://www.jarmany.com/what-we-think/blog/why-is-data-mining-so-important/
Tags (6) : Big data, Data analytics, Data analysis, Data mining, Loyalty cards, Transactional data, 

What is a growth mindset?
https://www.jarmany.com/what-we-think/blog/what-is-a-growth-mindset/
Tags (6) : Data analytics, Behavioural dynamics, David Beckham, Growth mindset, High performance, Matthew Syed, 

Future Technology Trends Explained
https://www.jarmany.com/what-we-think/blog/future-technology-trends-explained/
Tags (6) : Artificial Intelligence, Future Decoded, Michael Wignall, Mixed Reality, Quantum Computing, Satya Nadella, 

Agile data analytics in action!
https://www.jarmany.com/what-we-think/blog/agile-data-analytics-in-action/
Tags (4) : Agile, Data analytics, Customer journeys, Data management, 

Empower your people to be truly data driven
https://www.jarmany.com/what-we-think/blog/empower-your-people-to-be-truly-data-driven/
Tags (5) : Data analytics, Data silos, Data people, Data centric, Data driven culture, 

Inclusion means more of everybody
https://www.jarmany.com/what-we-think/blog/inclusion-means-more-of-everybody/
Tags (4) : Diversity, Inclusion, STEM, Women in Tech, 

Getting started as a data analyst
https://www.jarmany.com/what-we-think/blog/getting-started-as-a-data-analyst/
Tags (5) : Data analyst, Data visualisation, Machine learning, Reporting, SQL, 

The skills you’ll need to be a great data analyst
https://www.jarmany.com/what-we-think/blog/the-skills-you-ll-need-to-be-a-great-data-analyst/
Tags (5) : Data analytics, Data analyst, SQL, Python, R, 

What is data analytics? 5 things you need to know
https://www.jarmany.com/what-we-think/blog/what-is-data-analytics-5-things-you-need-to-know/
Tags (4) : Data analytics, CDA, EDA, Excel, 

The 5 tools a data analyst can’t do without
https://www.jarmany.com/what-we-think/blog/the-5-tools-a-data-analyst-can-t-do-without/
Tags (10) : SQL, Python, R, Excel, AWS, Azure, GCP, Power BI, Qlik, Tableau, 

Microsoft Ignite The Tour, London 2020
https://www.jarmany.com/what-we-think/blog/microsoft-ignite-the-tour-london-2020/
Tags (5) : Azure, AI, Microsoft Ignite, Power Automate, Surface Studio, 

Data in the fight against Covid-19
https://www.jarmany.com/what-we-think/blog/data-in-the-fight-against-covid-19/
Tags (6) : Big data, Data analytics, AI, 3D Printers, Coronavirus, Covid-19, 

Post COVID-19: The new normal
https://www.jarmany.com/what-we-think/blog/post-covid-19-the-new-normal/
Tags (5) : AI, Coronavirus, Covid-19, Cloud Computing, Cybersecurity, 

Can analytics change the way we play sport?
https://www.jarmany.com/what-we-think/blog/can-analytics-change-the-way-we-play-sport/
Tags (4) : Data analytics, Sports Analytics, Virtual Reality, Wearable Technology, 

Women in data
https://www.jarmany.com/what-we-think/blog/women-in-data/
Tags (7) : Diversity, Women in Tech, Machine learning, AI, Algorithms, Bias, Women in data, 

Visual impairment
https://www.jarmany.com/what-we-think/blog/visual-impairment/
Tags (3) : Big data, AI, Healthcare, 

The Rise of Data Visualisation
https://www.jarmany.com/what-we-think/blog/the-rise-of-data-visualisation/
Tags (6) : Big data, Data analytics, Data dashboards, Real time dashboards, Data visualisation, Power BI, 

Four key features of Power BI
https://www.jarmany.com/what-we-think/blog/four-key-features-of-power-bi/
Tags (6) : Data analytics, Data insights, Data dashboards, Real time dashboards, Data visualisation, Power BI, 

Power BI tips & tricks
https://www.jarmany.com/what-we-think/blog/power-bi-tips-tricks/
Tags (4) : Big data, Data analytics, Data visualisation, Power BI, 

The Third Agricultural Revolution
https://www.jarmany.com/what-we-think/blog/the-third-agricultural-revolution/
Tags (6) : Data analytics, Data insights, Data science, Prescriptive analytics, Data management, AI, 

The EURO 2020 predictor
https://www.jarmany.com/what-we-think/blog/the-euro-2020-predictor/
Tags (7) : Data analytics, Machine learning, AI, EURO2020, Football, Phython, Programming, 

Ordinary data: extraordinary results
https://www.jarmany.com/what-we-think/blog/ordinary-data-extraordinary-results/
Tags (4) : Data analytics, Data insights, AI, Wearable Technology, 

How to Use Big Data Effectively
https://www.jarmany.com/what-we-think/blog/how-to-use-big-data-effectively/
Tags (1) : Big data, 

Data Visualisation Tools 2021
https://www.jarmany.com/what-we-think/blog/data-visualisation-tools-2021/
Tags (2) : Big data, Data visualisation, 

<!DOCTYPE html>

<html lang="en">
	<head>

        <!-- Meta tags -->
		<meta charset="utf-8">
		<meta name="viewport" content="width=device-width, initial-scale=1">
		<meta name="description" content="Thought leadership and news about SQL, from data analytics organisation Jarmany.">
        
        <!-- Google Tag Manager -->
<script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start':
new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0],
j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src=
'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f);
})(window,document,'script','dataLayer','GTM-T92L7XQ');</script>
<!-- End Google Tag Manager -->

        <!-- Favicon -->
        


        <link rel="apple-touch-icon" sizes="180x180" href="/media/1108/apple-icon.png">
        <link rel="icon" type="image/png" sizes="192x192" href="/media/1111/android-icon-192x192.png">
        <link rel="icon" type="image/png" sizes="96x96" href="/media/1112/ms-icon-310x310.png">
        <link rel="shortcut icon" type="image/x-icon" href="/media/1109/favicon.ico">



        <!-- Social meta tags -->
        

<meta property="og:title" content="SQL" />
<meta property="og:type" content="website" />
<meta property="og:url" content="https://www.jarmany.com/what-we-think/blog/sql/" />
<meta property="og:image" content="https://www.jarmany.com" />
<meta property="og:site_name" content="Jarmany" />
<meta property="og:description" content="Blog articles and thought pieces about the world of SQL." />

        <!-- dw canonical url -->
        <link rel="canonical" href="https://www.jarmany.com/what-we-think/blog/sql/" />
        <!-- Stylesheets -->
        <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
        <link rel="stylesheet" href="/css/main.min.css">
        <link rel="stylesheet" href="/css/dotwise.css" />
        <!-- Unit Gallery styles -->
        <link rel='stylesheet' href='/js/unitegallery/css/unite-gallery.css' type='text/css' />
        <link rel='stylesheet' href='/js/unitegallery/themes/default/ug-theme-default.css' type='text/css' />

        <!-- Title -->
		<title>SQL blog series | Jarmany</title>

        <!-- Scripts [Only those required to be in the head] -->
        <script src="https://code.jquery.com/jquery-3.5.0.min.js"></script>
        <script>
            $(document).on("mobileinit", function () {
                $.mobile.ajaxEnabled = false;
                $.mobile.loadingMessage = false;
                $.mobile.ignoreContentEnabled = true;
            });
        </script>
        <script src="/js/jquery.mobile.custom.min.js"></script>
        <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-validate/1.17.0/jquery.validate.min.js"></script>
        <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-validation-unobtrusive/3.2.10/jquery.validate.unobtrusive.min.js"></script>
        
        <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>
        <script type="text/javascript" src="/js/unitegallery/js/unitegallery.min.js"></script>

	</head>

	<body data-category="" data-role="none">
        <!-- Google Tag Manager (noscript) -->
<noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-T92L7XQ"
height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>
<!-- End Google Tag Manager (noscript) -->
		<div class="page--wrapper" data-enhance="false">
			
			


<style>
    .module--standfirst a {
        color:#FFFFFF;
        text-decoration:underline;
    }
</style>



<!-- Header -->



        <section class="container-fluid section--cookie-policy">
            <div class="row">
                <div class="container-fixed">
                    <div class="row">
                        <div class="col-11"><p>Our website uses cookies to help us to understand how you use our website and to provide you with advertising based on your use of our website. By continuing to use our website you consent to our use of such cookies. More information including how you can disable these cookies can be found in our <a data-udi="umb://document/a3613f91f2154d52acf732d5538a6c29" href="/privacy-policy/" title="Privacy Policy">Privacy Policy</a>.</p></div>
                        <div class="col-1 align-right">
                            <a href="#" class="button button-cookie">
                                <svg xmlns="http://www.w3.org/2000/svg" viewBox="-8780 7093 24 24" class="btn-close" aria-label="Accept">
                                    <path class="a" d="M24,21.1,14.8,12l9.1-9.2L21.1,0,12,9.2,2.8.1,0,2.9,9.2,12,.1,21.2,2.9,24,12,14.8l9.2,9.1Z" transform="translate(-8780 7093)" />
                                </svg>
                            </a>
                        </div>
                    </div>
                </div>
            </div>
        </section>






<header class="container-fluid section--header">
    <div class="row">
        <div class="container-fixed">
            <div class="row" id="header">
                <div class="col-sm-4 col-md-2">
                            <a href="/"><img src="/media/1001/jarmany-logo.svg" alt="Logo" class="header--logo" /></a>

                </div>
                

                    <a href="#" class="button button--mobile-nav" data-category="Navigation">
                        <span>Menu</span>
                        <svg xmlns="http://www.w3.org/2000/svg" viewBox="-7832 30 36 28" class="btn-nav">
                            <g transform="translate(-8534)">
                                <rect class="a" width="36" height="6" transform="translate(702 30)" />
                                <rect class="a" width="36" height="6" transform="translate(702 41)" />
                                <rect class="a" width="36" height="6" transform="translate(702 52)" />
                            </g>
                        </svg>
                        <svg xmlns="http://www.w3.org/2000/svg" viewBox="-8780 7093 24 24" class="btn-close">
                            <path class="a" d="M24,21.1,14.8,12l9.1-9.2L21.1,0,12,9.2,2.8.1,0,2.9,9.2,12,.1,21.2,2.9,24,12,14.8l9.2,9.1Z" transform="translate(-8780 7093)" />
                        </svg>
                    </a>

                <div class="col-md-8 col-lg-9">
                    <script>
    $(document).ready(function() {
        
       $('.sub-level-3-item').click(function(e) {
           var parent = $(this).parent().parent().parent();
           var topLevelList = $("#top-level-ul");
           console.log("clicked " + parent.attr('id'));
           topLevelList.hide();
           
       });
    });
</script>
        <div class="row">
            <nav class="module--main-nav">
                        <ul class="top-level" id="top-level-ul">
                <li class="top-level-item ">
                    <a href="/about-jarmany/" class="top-level-link" data-category="Navigation">
                        About Jarmany
                    </a>

                            <ul class="sub-level sub-level-0-list" id="list-0">
                <li class="sub-level-item sub-level-0-item" id="item-0-1">
                    <a href="/about-jarmany/philosophy/" class="sub-level-link" data-category="Navigation">
                        Philosophy
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-0-item" id="item-0-2">
                    <a href="/about-jarmany/people/" class="sub-level-link" data-category="Navigation">
                        Team
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-0-item" id="item-0-3">
                    <a href="/about-jarmany/culture/" class="sub-level-link" data-category="Navigation">
                        Culture
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-0-item" id="item-0-4">
                    <a href="/about-jarmany/case-studies/" class="sub-level-link" data-category="Navigation">
                        Case Studies
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-0-item" id="item-0-5">
                    <a href="/what-we-think/blog/" class="sub-level-link" data-category="Navigation">
                        Blog
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-0-item" id="item-0-6">
                    <a href="/what-we-think/resources/" class="sub-level-link" data-category="Navigation">
                        Resources
                    </a>

                    
                </li>
        </ul><span class="icon-arrow"></span>

                </li>
                <li class="top-level-item ">
                    <a href="/capabilities/" class="top-level-link" data-category="Navigation">
                        Capabilities
                    </a>

                            <ul class="sub-level sub-level-1-list" id="list-1">
                <li class="sub-level-item sub-level-1-item" id="item-1-1">
                    <a href="https://www.jarmany.com/capabilities/#data-strategy" class="sub-level-link" data-category="Navigation">
                        Data Strategy
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-1-item" id="item-1-2">
                    <a href="/capabilities/#data-platforms" class="sub-level-link" data-category="Navigation">
                        Data Platforms
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-1-item" id="item-1-3">
                    <a href="/capabilities/#data-science" class="sub-level-link" data-category="Navigation">
                        Data Science
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-1-item" id="item-1-4">
                    <a href="/capabilities/#data-people" class="sub-level-link" data-category="Navigation">
                        Data People
                    </a>

                    
                </li>
        </ul><span class="icon-arrow"></span>

                </li>
                <li class="top-level-item ">
                    <a href="/managed-services/" class="top-level-link" data-category="Navigation">
                        Managed Services
                    </a>

                            <ul class="sub-level sub-level-2-list" id="list-2">
                <li class="sub-level-item sub-level-2-item" id="item-2-1">
                    <a href="/managed-services/digital/" class="sub-level-link" data-category="Navigation">
                        Digital
                    </a>

                            <ul class="sub-level sub-level-3-list" id="list-3">
                <li class="sub-level-item sub-level-3-item" id="item-3-1">
                    <a href="/managed-services/digital#kpi-frameworks" class="sub-level-link" data-category="Navigation">
                        KPI Frameworks
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-3-item" id="item-3-2">
                    <a href="/managed-services/digital#tagging-and-tracking" class="sub-level-link" data-category="Navigation">
                        Tagging and Tracking
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-3-item" id="item-3-3">
                    <a href="/managed-services/digital#customer-journey-analysis" class="sub-level-link" data-category="Navigation">
                        Customer Journey Analysis
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-3-item" id="item-3-4">
                    <a href="/managed-services/digital#conversion-rate-optimisation" class="sub-level-link" data-category="Navigation">
                        CRO (Conversion Rate Optimisation)
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-3-item" id="item-3-5">
                    <a href="https://www.jarmany.com/managed-services/digital#ab-and-multivariate-testing" class="sub-level-link" data-category="Navigation">
                        A/B &amp; Multivariate Testing
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-3-item" id="item-3-6">
                    <a href="https://www.jarmany.com/managed-services/digital#visualisation" class="sub-level-link" data-category="Navigation">
                        Visualisation
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-3-item" id="item-3-7">
                    <a href="https://www.jarmany.com/managed-services/digital#propensity-modelling" class="sub-level-link" data-category="Navigation">
                        Propensity Modelling
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-3-item" id="item-3-8">
                    <a href="https://www.jarmany.com/managed-services/digital#web-crawlers" class="sub-level-link" data-category="Navigation">
                        Web Crawlers
                    </a>

                    
                </li>
        </ul><span class="icon-arrow"></span>

                </li>
                <li class="sub-level-item sub-level-2-item" id="item-2-2">
                    <a href="/managed-services/marketing/" class="sub-level-link" data-category="Navigation">
                        Marketing
                    </a>

                            <ul class="sub-level sub-level-3-list" id="list-3">
                <li class="sub-level-item sub-level-3-item" id="item-3-1">
                    <a href="https://www.jarmany.com/managed-services/marketing#investment-performance" class="sub-level-link" data-category="Navigation">
                        Investment Performance
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-3-item" id="item-3-2">
                    <a href="https://www.jarmany.com/managed-services/marketing#attribution-modelling" class="sub-level-link" data-category="Navigation">
                        Attribution Modelling
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-3-item" id="item-3-3">
                    <a href="https://www.jarmany.com/managed-services/marketing#promotion-management" class="sub-level-link" data-category="Navigation">
                        Promotion Management
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-3-item" id="item-3-4">
                    <a href="https://www.jarmany.com/managed-services/marketing#field-force-optimisation" class="sub-level-link" data-category="Navigation">
                        Field Force Optimisation
                    </a>

                    
                </li>
        </ul><span class="icon-arrow"></span>

                </li>
                <li class="sub-level-item sub-level-2-item" id="item-2-3">
                    <a href="/managed-services/operations/" class="sub-level-link" data-category="Navigation">
                        Operations
                    </a>

                            <ul class="sub-level sub-level-3-list" id="list-3">
                <li class="sub-level-item sub-level-3-item" id="item-3-1">
                    <a href="https://www.jarmany.com/managed-services/operations#data-collection-and-management" class="sub-level-link" data-category="Navigation">
                        Data Collection and Management
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-3-item" id="item-3-2">
                    <a href="https://www.jarmany.com/managed-services/operations/#channel-visibility" class="sub-level-link" data-category="Navigation">
                        Channel Visibility
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-3-item" id="item-3-3">
                    <a href="https://www.jarmany.com/managed-services/operations/#demand-planning" class="sub-level-link" data-category="Navigation">
                        Demand Planning
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-3-item" id="item-3-4">
                    <a href="https://www.jarmany.com/managed-services/channel-management/#inventory-management" class="sub-level-link" data-category="Navigation">
                        Inventory Management
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-3-item" id="item-3-5">
                    <a href="https://www.jarmany.com/managed-services/operations/#category-and-account-performance" class="sub-level-link" data-category="Navigation">
                        Category and Account Performance
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-3-item" id="item-3-6">
                    <a href="https://www.jarmany.com/managed-services/operations/#forecasting" class="sub-level-link" data-category="Navigation">
                        Forecasting
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-3-item" id="item-3-7">
                    <a href="https://www.jarmany.com/managed-services/operations/#dashboards" class="sub-level-link" data-category="Navigation">
                        Dashboards
                    </a>

                    
                </li>
        </ul><span class="icon-arrow"></span>

                </li>
        </ul><span class="icon-arrow"></span>

                </li>
                <li class="top-level-item ">
                    <a href="/professional-services/" class="top-level-link" data-category="Navigation">
                        Professional Services
                    </a>

                            <ul class="sub-level sub-level-3-list" id="list-3">
                <li class="sub-level-item sub-level-3-item" id="item-3-1">
                    <a href="https://www.jarmany.com/professional-services/#skills-gap" class="sub-level-link" data-category="Navigation">
                        Skills Gap
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-3-item" id="item-3-2">
                    <a href="https://www.jarmany.com/professional-services/#skills-gap" class="sub-level-link" data-category="Navigation">
                        Project Team
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-3-item" id="item-3-3">
                    <a href="https://www.jarmany.com/professional-services/#managed-team" class="sub-level-link" data-category="Navigation">
                        Managed Team
                    </a>

                    
                </li>
        </ul><span class="icon-arrow"></span>

                </li>
                <li class="top-level-item ">
                    <a href="/careers/" class="top-level-link" data-category="Navigation">
                        Careers
                    </a>

                            <ul class="sub-level sub-level-4-list" id="list-4">
                <li class="sub-level-item sub-level-4-item" id="item-4-1">
                    <a href="/opportunities/" class="sub-level-link" data-category="Navigation">
                        Opportunities
                    </a>

                    
                </li>
                <li class="sub-level-item sub-level-4-item" id="item-4-2">
                    <a href="/careers/grad-scheme/" class="sub-level-link" data-category="Navigation">
                        Grad Scheme
                    </a>

                    
                </li>
        </ul><span class="icon-arrow"></span>

                </li>
                <li class="top-level-item ">
                    <a href="/contact-us/" class="top-level-link" data-category="Navigation">
                        Contact Us
                    </a>

                    
                </li>
        </ul>

            </nav>
        </div>






        
                </div>
            </div>
        </div>
    </div>
</header>


<!-- Hero Section -->
        <section class="container-fluid content-section">
            <div class="row">
                <div class="hero-section">
                    <div class="container">
                        <div class="row">
                            <div class="col-md-12 column">
                                <div>
                                    <div class="hero--container hero--fade" style="background-image:url(/media/1754/sql1.jpg)">
                                        <div class="hero--inner">
                                            <h1>SQL</h1>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </section>


<section class="container-fluid content-section">
    <div class="row">
        <div class="standfirst-section">
            <div class="container">
                <div class="row">
                    <div class="col-md-12 column">
                        <div class="text-center">
                            <br />
                        
                            <div class="module--standfirst">
                                <h2>Category: SQL</h2>
                                <h4>3 articles</h4>
                                    <p><p>Jarmany is a thought-leading organisation in the world of SQL. We regularly produce content and research and share it on this page. Check back regularly or get in touch if you have any questions. </p></p>
                            </div>
                        </div>
                        </div>
                    </div>
            </div>
        </div>
    </div>
</section>

    

<!-- Page body -->
<section class="container-fluid filter-section" style="display:none;">
    <div class="row">
        <div class="container-fixed">
            <div class="row">
                <div class="col-sm-12">
                    <p>
                        Tags:
                            <a href="/what-we-think/blog/sql/?filter=data">data </a>
                            <a href="/what-we-think/blog/sql/?filter=Agile">Agile </a>
                            <a href="/what-we-think/blog/sql/?filter=Analytics for Twitter">Analytics for Twitter </a>
                            <a href="/what-we-think/blog/sql/?filter=BDaaS">BDaaS </a>
                            <a href="/what-we-think/blog/sql/?filter=Bid data as a service">Bid data as a service </a>
                            <a href="/what-we-think/blog/sql/?filter=Big data">Big data </a>
                            <a href="/what-we-think/blog/sql/?filter=Cloud">Cloud </a>
                            <a href="/what-we-think/blog/sql/?filter=Data analytics">Data analytics </a>
                            <a href="/what-we-think/blog/sql/?filter=Business transformation">Business transformation </a>
                            <a href="/what-we-think/blog/sql/?filter=Dark data">Dark data </a>
                            <a href="/what-we-think/blog/sql/?filter=Data silos">Data silos </a>
                            <a href="/what-we-think/blog/sql/?filter=Predictive analytics">Predictive analytics </a>
                            <a href="/what-we-think/blog/sql/?filter=Data consolidation">Data consolidation </a>
                            <a href="/what-we-think/blog/sql/?filter=Data insights">Data insights </a>
                            <a href="/what-we-think/blog/sql/?filter=Data integration">Data integration </a>
                            <a href="/what-we-think/blog/sql/?filter=Single version of the truth">Single version of the truth </a>
                            <a href="/what-we-think/blog/sql/?filter=Data science">Data science </a>
                            <a href="/what-we-think/blog/sql/?filter=Prescriptive analytics">Prescriptive analytics </a>
                            <a href="/what-we-think/blog/sql/?filter=Marketing analytics">Marketing analytics </a>
                            <a href="/what-we-think/blog/sql/?filter=Marketing data">Marketing data </a>
                            <a href="/what-we-think/blog/sql/?filter=Proof of concept">Proof of concept </a>
                            <a href="/what-we-think/blog/sql/?filter=Proof of value">Proof of value </a>
                            <a href="/what-we-think/blog/sql/?filter=Data dashboards">Data dashboards </a>
                            <a href="/what-we-think/blog/sql/?filter=Data platform">Data platform </a>
                            <a href="/what-we-think/blog/sql/?filter=KPIs">KPIs </a>
                            <a href="/what-we-think/blog/sql/?filter=Metrics">Metrics </a>
                            <a href="/what-we-think/blog/sql/?filter=Real time dashboards">Real time dashboards </a>
                            <a href="/what-we-think/blog/sql/?filter=BI">BI </a>
                            <a href="/what-we-think/blog/sql/?filter=Business intelligence">Business intelligence </a>
                            <a href="/what-we-think/blog/sql/?filter=Data skills">Data skills </a>
                            <a href="/what-we-think/blog/sql/?filter=Data software">Data software </a>
                            <a href="/what-we-think/blog/sql/?filter=Business forecasting">Business forecasting </a>
                            <a href="/what-we-think/blog/sql/?filter=Econometric analysis">Econometric analysis </a>
                            <a href="/what-we-think/blog/sql/?filter=Econometric modelling">Econometric modelling </a>
                            <a href="/what-we-think/blog/sql/?filter=Marketing mix modelling">Marketing mix modelling </a>
                            <a href="/what-we-think/blog/sql/?filter=Statistical modelling">Statistical modelling </a>
                            <a href="/what-we-think/blog/sql/?filter=Big data software">Big data software </a>
                            <a href="/what-we-think/blog/sql/?filter=Data as a service">Data as a service </a>
                            <a href="/what-we-think/blog/sql/?filter=Software agnostic">Software agnostic </a>
                            <a href="/what-we-think/blog/sql/?filter=Data analysis">Data analysis </a>
                            <a href="/what-we-think/blog/sql/?filter=Data mining">Data mining </a>
                            <a href="/what-we-think/blog/sql/?filter=Loyalty cards">Loyalty cards </a>
                            <a href="/what-we-think/blog/sql/?filter=Transactional data">Transactional data </a>
                            <a href="/what-we-think/blog/sql/?filter=Behavioural dynamics">Behavioural dynamics </a>
                            <a href="/what-we-think/blog/sql/?filter=David Beckham">David Beckham </a>
                            <a href="/what-we-think/blog/sql/?filter=Growth mindset">Growth mindset </a>
                            <a href="/what-we-think/blog/sql/?filter=High performance">High performance </a>
                            <a href="/what-we-think/blog/sql/?filter=Matthew Syed">Matthew Syed </a>
                            <a href="/what-we-think/blog/sql/?filter=Artificial Intelligence">Artificial Intelligence </a>
                            <a href="/what-we-think/blog/sql/?filter=Future Decoded">Future Decoded </a>
                            <a href="/what-we-think/blog/sql/?filter=Michael Wignall">Michael Wignall </a>
                            <a href="/what-we-think/blog/sql/?filter=Mixed Reality">Mixed Reality </a>
                            <a href="/what-we-think/blog/sql/?filter=Quantum Computing">Quantum Computing </a>
                            <a href="/what-we-think/blog/sql/?filter=Satya Nadella">Satya Nadella </a>
                            <a href="/what-we-think/blog/sql/?filter=Customer journeys">Customer journeys </a>
                            <a href="/what-we-think/blog/sql/?filter=Data people">Data people </a>
                            <a href="/what-we-think/blog/sql/?filter=Data centric">Data centric </a>
                            <a href="/what-we-think/blog/sql/?filter=Data driven culture">Data driven culture </a>
                            <a href="/what-we-think/blog/sql/?filter=Diversity">Diversity </a>
                            <a href="/what-we-think/blog/sql/?filter=Inclusion">Inclusion </a>
                            <a href="/what-we-think/blog/sql/?filter=STEM">STEM </a>
                            <a href="/what-we-think/blog/sql/?filter=Women in Tech">Women in Tech </a>
                            <a href="/what-we-think/blog/sql/?filter=Data analyst">Data analyst </a>
                            <a href="/what-we-think/blog/sql/?filter=Data visualisation">Data visualisation </a>
                            <a href="/what-we-think/blog/sql/?filter=Machine learning">Machine learning </a>
                            <a href="/what-we-think/blog/sql/?filter=Reporting">Reporting </a>
                            <a href="/what-we-think/blog/sql/?filter=SQL">SQL </a>
                            <a href="/what-we-think/blog/sql/?filter=Python">Python </a>
                            <a href="/what-we-think/blog/sql/?filter=R">R </a>
                            <a href="/what-we-think/blog/sql/?filter=CDA">CDA </a>
                            <a href="/what-we-think/blog/sql/?filter=EDA">EDA </a>
                            <a href="/what-we-think/blog/sql/?filter=Excel">Excel </a>
                            <a href="/what-we-think/blog/sql/?filter=AWS">AWS </a>
                            <a href="/what-we-think/blog/sql/?filter=Azure">Azure </a>
                            <a href="/what-we-think/blog/sql/?filter=GCP">GCP </a>
                            <a href="/what-we-think/blog/sql/?filter=Power BI">Power BI </a>
                            <a href="/what-we-think/blog/sql/?filter=Qlik">Qlik </a>
                            <a href="/what-we-think/blog/sql/?filter=Tableau">Tableau </a>
                            <a href="/what-we-think/blog/sql/?filter=Data management">Data management </a>
                            <a href="/what-we-think/blog/sql/?filter=AI">AI </a>
                            <a href="/what-we-think/blog/sql/?filter=Microsoft Ignite">Microsoft Ignite </a>
                            <a href="/what-we-think/blog/sql/?filter=Power Automate">Power Automate </a>
                            <a href="/what-we-think/blog/sql/?filter=Surface Studio">Surface Studio </a>
                            <a href="/what-we-think/blog/sql/?filter=3D Printers">3D Printers </a>
                            <a href="/what-we-think/blog/sql/?filter=Coronavirus">Coronavirus </a>
                            <a href="/what-we-think/blog/sql/?filter=Covid-19">Covid-19 </a>
                            <a href="/what-we-think/blog/sql/?filter=Cloud Computing">Cloud Computing </a>
                            <a href="/what-we-think/blog/sql/?filter=Covie-19">Covie-19 </a>
                            <a href="/what-we-think/blog/sql/?filter=Cybersecurity">Cybersecurity </a>
                            <a href="/what-we-think/blog/sql/?filter=Sports Analytics">Sports Analytics </a>
                            <a href="/what-we-think/blog/sql/?filter=Virtual Reality">Virtual Reality </a>
                            <a href="/what-we-think/blog/sql/?filter=Wearable Technology">Wearable Technology </a>
                            <a href="/what-we-think/blog/sql/?filter=Algorithms">Algorithms </a>
                            <a href="/what-we-think/blog/sql/?filter=Bias">Bias </a>
                            <a href="/what-we-think/blog/sql/?filter=Women in data">Women in data </a>
                            <a href="/what-we-think/blog/sql/?filter=Healthcare">Healthcare </a>
                            <a href="/what-we-think/blog/sql/?filter=EURO2020">EURO2020 </a>
                            <a href="/what-we-think/blog/sql/?filter=Football">Football </a>
                            <a href="/what-we-think/blog/sql/?filter=Phython">Phython </a>
                            <a href="/what-we-think/blog/sql/?filter=Programming">Programming </a>
                    </p>
                </div>
            </div>
        </div>
    </div>
</section>

<section class="container-fluid list-section">
    <div class="row">
        <div class="container-fixed">
            <div class="row">
                            <article class="col-sm-12 col-md-6 col-lg-4 module--listitem">
                                    <div class="module--listitem-image">
                                        <a href="/what-we-think/blog/getting-started-as-a-data-analyst/" data-category="Blog List"><img src="/media/1664/diverse-business-colleagues-shoo-c-1000.jpg" alt="Getting started as a data analyst" /></a>
                                    </div>
                                <div class="module--listitem-text">
                                    <p class="item--date">19 June 2019</p>
                                    <a href="/what-we-think/blog/getting-started-as-a-data-analyst/" data-category="Blog List"><h3>Getting started as a data analyst</h3></a>
                                    <p>The 5 + 1 things that a data analyst does in his or her day job and the skills required for each step to be successful.</p>
                                </div>
                                <span class="module--listitem-border"></span>
                            </article>
                            <article class="col-sm-12 col-md-6 col-lg-4 module--listitem">
                                    <div class="module--listitem-image">
                                        <a href="/what-we-think/blog/the-skills-you-ll-need-to-be-a-great-data-analyst/" data-category="Blog List"><img src="/media/1663/diverse-business-shoot-c-1000.jpg" alt="The skills you’ll need to be a great data analyst" /></a>
                                    </div>
                                <div class="module--listitem-text">
                                    <p class="item--date">10 July 2019</p>
                                    <a href="/what-we-think/blog/the-skills-you-ll-need-to-be-a-great-data-analyst/" data-category="Blog List"><h3>The skills you’ll need to be a great data analyst</h3></a>
                                    <p>The world is exploding with data - there&#39;s never been a better time to be a data analyst - what are the 5+1 skills you are going to need.</p>
                                </div>
                                <span class="module--listitem-border"></span>
                            </article>
                            <article class="col-sm-12 col-md-6 col-lg-4 module--listitem">
                                    <div class="module--listitem-image">
                                        <a href="/what-we-think/blog/the-5-tools-a-data-analyst-can-t-do-without/" data-category="Blog List"><img src="/media/1658/silhouette-trader-office-before-infographics-c-1000.jpg" alt="The 5 tools a data analyst can’t do without" /></a>
                                    </div>
                                <div class="module--listitem-text">
                                    <p class="item--date">12 September 2019</p>
                                    <a href="/what-we-think/blog/the-5-tools-a-data-analyst-can-t-do-without/" data-category="Blog List"><h3>The 5 tools a data analyst can’t do without</h3></a>
                                    <p>The tools that will will help any analyst be faster and better when it comes to analysing data, problem solving and providing insights.</p>
                                </div>
                                <span class="module--listitem-border"></span>
                            </article>

            </div>
        </div>
    </div>
</section>

<section class="container-fluid pagination-section">
    <div class="row">

    </div>
</section>

<!-- Footer -->



<footer class="container-fluid section--footer">
    <div class="row">
        <div class="container-fixed">
            <div class="row footer--fat-footer">
                <div class="col-md-6 col-lg-3">
                    <h3>What we do</h3>
<p><a data-udi="umb://document/15488220658242b3aad0b65eca80d42b" href="/data/data-analytics-consultancy/" title="Data Analytics Consultancy">Data Analytics</a> <a href="/data/data-consultancy" title="Consultancy">Consultancy</a></p>
<p><a data-udi="umb://document/445137e5f4584b0a996c282d7f8581fb" href="/data/data-management-company/" title="Data Management Company">Data Management</a></p>
<p><a href="/data/big-data-consultancy/">Big Data</a></p>
<p><a href="/data/data-science-consultancy/">Data Science</a></p>
                </div>
                <div class="col-md-6 col-lg-3">
                    <h3>Get in touch</h3>
<p><a href="mailto:hello@jarmany.com"><strong>hello@jarmany.com</strong></a></p>
<p><a href="tel:+442030514960" aria-label="Call us">+44 (0)203 051 4960</a></p>
                </div>
                <div class="col-md-12 col-lg-6">
                    <h3>STAY CONNECTED</h3>
<div id="umbraco_form_0a57a1ff0ca0468ab02ad78ad2a7f6ef" class="umbraco-forms-form newslettersignup umbraco-forms-">

<form action="/what-we-think/blog/sql/" enctype="multipart/form-data" method="post"><input name="__RequestVerificationToken" type="hidden" value="EB5POf3A8pnRjgncGwdUueXKZF8_XYQ83SBgYK_qD-p4wHlfOXI3YSVEuuVMGoeW9Vma1abyrbV8bbxF4Ow07MgCP2vs2gMEx7-C8iTf7Bw1" /><input data-val="true" data-val-required="The FormId field is required." id="FormId" name="FormId" type="hidden" value="0a57a1ff-0ca0-468a-b02a-d78ad2a7f6ef" /><input id="FormName" name="FormName" type="hidden" value="Newsletter Signup" /><input data-val="true" data-val-required="The RecordId field is required." id="RecordId" name="RecordId" type="hidden" value="00000000-0000-0000-0000-000000000000" /><input id="PreviousClicked" name="PreviousClicked" type="hidden" value="" />            <input type="hidden" name="FormStep" value="0" />
            <input type="hidden" name="RecordState" value="OEE2NDQ5RUYzRTZBM0Y5OTA3NjQyOTU2NTUzQjg1QjI1NzA2OTRDRDMyQjNFQjY5QUQwMjE1Q0QwN0JDMjIyNzYzNEQ2RUMyMDc1QUE4MkQ0NjBFRDAzMEY1MTIzNkU1Q0I5RDU4Njg2Q0E1QzMxMDcyN0ExNDgzMDhEQkIzNUQxMUQyRDM0QjNCNTMzNDQ5MTUyQzkzNDExM0VDOUM3QTM1RkNEQTZDNThEMzVDMzcwNDAzQjEwQkFEMkM0RTNCMDQxMDhDNDJFQkZBODRBRTlFODY1NDhEOUEyQkE5QkYzQjM1RkZERTU2NzlGN0EwMkFBQkQ3QTg5RTFDMkJGODVGNjM4OTE4N0Q4QUFGRjBBMzc3NjIwQzkxQTYzQTc3MThFQTQyMEMwRDJFMTVEMDNBNkUwN0EzNjU4QjBBQ0NGMkVBQzc2NTUwQ0Y2NkYwRDNGQzBFRTZCQTQ3N0Q2M0FEQTQ0MDRGRDg1RDk3OUUyRDY0NzQyQzFDMEVEMkY4OEQ4QjhBNDAzNDcxNkUwMTczOTM2Qzc0QkMwNzE2OTYxQTM2NkVDNUU0OTMxODZGNzk0MzhEOUUwRENDNEI3QTBFOTY5NjQ5NjU0N0Q5QTQxNjJGRjg2QTgyNTE4RkU3MjFDNjdFMTRBNzYzRTIwOTI0NjE4MzIwOUFCMjRDOTIzQkIyMTdCQzM1NEVENkM1RkVDM0NDREE3ODVCMkVCQUU4REYzQjY4OTFCMDY1MTM5NDNGQjE1NjYyRjZCNURBMzFBMjkyN0M1RTA4Q0FCOTQ1NEM5QkEzMTdDRkEzMzAyMjU1ODlDNEJENTE5MDdFQzg1RjMyOUQwOUExQTJBODRENkM2Rjg4RkNFNTU3RDEzOUQ4NzE3MkZFM0UzODND" />





<div class="umbraco-forms-page">




        <fieldset class="umbraco-forms-fieldset" id="52ce0e3c-2fac-4b15-bf30-c2d37fd5e0ca">


            <div class="row-fluid">

                    <div class="umbraco-forms-container col-md-12">

                            <div class=" umbraco-forms-field enteryouremail shortanswer mandatory" >

                                    <label for="02f096e4-c67f-4014-ed29-8ceb0569a217" class="umbraco-forms-label">
                                        Enter Your Email                                             <span class="umbraco-forms-indicator">*</span>
                                    </label>


                                <div class="umbraco-forms-field-wrapper">

                                    
<input type="text" 
       name="02f096e4-c67f-4014-ed29-8ceb0569a217" 
       id="02f096e4-c67f-4014-ed29-8ceb0569a217" 
       class=" text" 
       value="" 
       maxlength="500"
       placeholder="Enter Your Email"
data-val="true"
 data-val-required="Please enter your email address"

/>





<span class="field-validation-valid" data-valmsg-for="02f096e4-c67f-4014-ed29-8ceb0569a217" data-valmsg-replace="true"></span>
                                </div>

                            </div>
                            <div class=" umbraco-forms-field pleaseconfirmyouarenotarobot recaptcha2 mandatory alternating" >

                                    <label for="90b2dd48-7f93-4ffc-e81f-22ec27ba8ff7" class="umbraco-forms-label">
                                        Please confirm you are not a robot                                             <span class="umbraco-forms-indicator">*</span>
                                    </label>


                                <div class="umbraco-forms-field-wrapper">

                                            <script src="https://www.google.com/recaptcha/api.js" async defer></script>
        <div class="g-recaptcha" data-sitekey="6LeSqOMZAAAAABj_PkE2N0IMR2HYGO9lEhU_O1Ae" data-theme="dark" data-size="normal"></div>


<span class="field-validation-valid" data-valmsg-for="90b2dd48-7f93-4ffc-e81f-22ec27ba8ff7" data-valmsg-replace="true"></span>
                                </div>

                            </div>
                            <div class=" umbraco-forms-field optintoreceiveindustryupdatesandourlatestthinking checkbox mandatory" >

                                    <label for="6de11701-e464-4890-91cf-e0c88a7b0b75" class="umbraco-forms-label">
                                        Opt in to receive industry updates and our latest thinking.                                             <span class="umbraco-forms-indicator">*</span>
                                    </label>


                                <div class="umbraco-forms-field-wrapper">

                                    
<input type="checkbox" name="6de11701-e464-4890-91cf-e0c88a7b0b75" id="6de11701-e464-4890-91cf-e0c88a7b0b75" 
       class="" 

      data-val="true" data-val-requiredcb="You must opt in to receive communications from us."                                                                                                             
/>

<span class="field-validation-valid" data-valmsg-for="6de11701-e464-4890-91cf-e0c88a7b0b75" data-valmsg-replace="true"></span>
                                </div>

                            </div>

                    </div>
            </div>

        </fieldset>

    <div style="display: none">
        <input type="text" name="0a57a1ff0ca0468ab02ad78ad2a7f6ef" />
    </div>


    <div class="umbraco-forms-navigation row-fluid">

        <div class="col-md-12">
                <input type="submit" 
                       class="float-left btn primary" 
                       value="JOIN OUR MAILING LIST" 
                       name="__next" />
        </div>
    </div>
</div><input name='ufprt' type='hidden' value='B82EB85B44B3AF9AEED603BED1CA21AAEE5FA1A521BC69484AEBBB0C3E70B0E7453874B7CEFF108F3271A109F78696099E6162DD00491A19B6D7E8DB6598D2FDD5855E361B3E8C97E33C0BDC50F022D4EAD2FFCE819B5D3199F6C28848330B21ED6F50ED325BD547D6677C7E19DE266164865C3822E93C8B766ACB85BF2615D98ACA9E4B55B8BB4E2A63306E8AB0E687' /></form>

        





            <script type="text/javascript" src="/App_Plugins/UmbracoForms/Assets/Themes/Default/umbracoforms-dependencies.js"></script>
            <script type="text/javascript" src="/App_Plugins/UmbracoForms/Assets/Themes/Default/umbracoforms.js"></script>
            <script type="text/javascript" src="/App_Plugins/UmbracoForms/Assets/Themes/Default/umbracoforms-conditions.js"></script>
        <script type="text/javascript">
            (function () {
          

            var contourDateFormat = 'm/d/yy',
                formId = '0a57a1ff0ca0468ab02ad78ad2a7f6ef',
                fieldSetConditions = {},
                fieldConditions = {},
                recordvalues = {};
            
            umbracoForms.dependencyCheck(formId);

            var form = $('#umbraco_form_' + formId + ' .umbraco-forms-page');
            var conditions = new umbracoForms.conditions(form, fieldSetConditions, fieldConditions, recordvalues);
            conditions.watch();
            }());
        </script>
                    <link rel="stylesheet" href="/App_Plugins/UmbracoForms/Assets/Themes/Default/style.css" />
    </div>
<br />
                    
        <ul class="module--social-links">
                <li>
                    <a href="https://www.linkedin.com/company/jarmany-ltd/" target="_blank" class="button social-button" title="link to LinkedIn" rel="noopener">
                        <img src="/media/1030/footer_linkedin.svg" alt="LinkedIn" class="svg" style="float:right;" />
                    </a>
                </li>
                <li>
                    <a href="https://instagram.com/jarmany_ltd" target="_blank" class="button social-button" title="link to Instagram" rel="noopener">
                        <img src="/media/1339/instagram-logo-400.png" alt="Instagram" class="svg" style="float:right;" />
                    </a>
                </li>
                <li>
                    <a href="https://twitter.com/JarmanyLtd" target="_blank" class="button social-button" title="link to Twitter" rel="noopener">
                        <img src="/media/1031/footer_twitter.svg" alt="Twitter" class="svg" style="float:right;" />
                    </a>
                </li>
        </ul>



                    
        <div class="footer--legal-links">
            <a href="/privacy-policy/">Privacy Policy</a>
            <a href="/terms-and-conditions/">Terms and Conditions</a>
        </div>

                </div>
            </div>
            <div class="row">
                <div class="col-sm-12">
                    <div class="footer--border-top">
                        <p><strong>Jarmany Ltd</strong>. 1-3 Union Street, Kingston upon Thames, KT1 1RP, United Kingdom</p>
                        <p class="footer--copyright">
                            &copy; 2022 Jarmany Ltd. All rights reserved
                        </p>
                    </div>
                    
                </div>
            </div>
        </div>
    </div>
</footer>						

		</div>

        <!-- Scripts -->
        <script src="/js/bundle.min.js"></script>
        

<!-- moved Google Analytics into GTM - DW 24/2/2019 -->
	</body>
</html>