IT manager

Training Course: Data Analytics: SQL for newbs, beginners and marketers


Register Now
Quick Inquiry
Discount Group Download Brochure (36)

IT234740

25 - 29 May 2025

Dubai (UAE)

Cost : 4565 € Euro

Introduction

In this course, SQL for marketers, we’ll start from the basics – installing SQL onto your Mac, Linux, or Windows machine and explaining what a relational database is. Next, we’ll look at basic tasks like creating tables and loading data into those tables. We will look at a wide variety of SQL commands and I will show you how to speed things up using indexes.

By end of this course you will learn about Advanced SQL queries on Spark, the big data framework that is the successor to MapReduce and also runs on top of Hadoop.

Course Objective of Data Analytics: SQL for newbs, beginners and marketers

Participant will learn to:

  • Know how to answer all of their marketing-related questions using a SQL query
  • Understand what a relational database is
  • How to install SQL on Mac, Linux, or Windows
  • How to create a table
  • How to import data into a table
  • How to query a table
  • How to insert into, update, and delete from a table
  • Speed things up using indexes
  • Join tables together to merge data
  • Aggregate data using count, sum, and average
  • Determine where in the sales funnel customers are being lost
  • Chart your year over year revenue
  • Group and sort sales by location
  • Use SQL on Spark
  • Install Spark
  • Create a Spark cluster on AWS EC2

Target Audience of Data Analytics: SQL for newbs, beginners and marketers

  • Everyone who want a different approach to learning SQL
  • Product managers who want to make data-driven decisions

Course Outline for Data Analytics: SQL for newbs, beginners and marketers

Introduction to SQL

  • Overview of SQL database
  • Instllation of SQLite
  • Mac
  • Linux
  • Windows

Relational database & Basic Commands

  • Whats is relational database?
  • Loading data used in class
  • Basic commands
  • Queyring a table
  • Creating table
  • Modifying a table's structure

Indexes and Speed Comparison

  • Speeding with Indexes
  • Index examples in the console

Modifying a table's data

  • Insert,Update & Delete
  • What is CRUD

Joining Tables

  • Joining & merging tables
  • Joins in the console

Aggregating, grouping & sorting; the real marketing queries

  • Count, Distinct & Sum
  • Min, Max & Avg
  • Group by, Sort & Limit
  • Funnels, YOY revenue, & Sales by Location

Advanced SQL on Spark

  • Spark SQL
  • Create your own Spark cluster 

Practice, & Exercises 

  • Loading extra dataset
  • Tab-seperated-tables
  • The"IN" Keyword
  • The"BETWEEN" Keyword
  • Style Exercises

IT manager

Training Course: Data Analytics: SQL for newbs, beginners and marketers


Register Now
Quick Inquiry
Discount Group Download Brochure (36)

IT234740

25 - 29 May 2025

Dubai (UAE) -

Cost: 4565 € Euro


  About Dubai

Dubai, located on the Persian Gulf, is one of the seven United Arab Emirates and one of the most popular tourist destinations in the world. The discovery of oil in the region has made Dubai extremely wealthy, allowing it to build the glittering skyscrapers that it is now famous for. That wealth is strongly in evidence in Dubai and visitors will see luxurious buildings and supercars aplenty. Perfect beaches and endless shopping opportunities are to key to Dubai's attractions. Flights to Dubai open up the city's cultural attractions to tourists, with beautiful mosques, museums and art galleries scattered throughout this ultra-modern metropolis.


  Things to do and places to visit in Dubai

Dubai's wealth has made it famous for building ever taller buildings and creating artificial islands off its shores. The city's hotels are luxurious and shoppers will love its extensive shopping malls which showcase all the world's top brands. Dubai's attractions don't end there. Dubai also caters to adventure lovers, who can jump in a 4x4 or on a board to speed over dunes outside the city. Local culture mustn't be forgotten either, and visitors have wonderful mosques to visit and old districts to explore. All that combined means that a flight to Dubai is sure to lead to an unforgettable holiday.

When visiting Dubai, be sure to:

  • Go to the observation deck of the Burj Khalifa, the tallest building in the world.
  • Admire the intricately beautiful Grand Mosque, which has the tallest minaret in the city.
  • Understand the local history and culture with a visit to the Dubai Museum.
  • Discover objects from the 6th century at Jumeirah Archaeological Site.
  • Go skiing – That's not a joke, the Mall of the Emirates houses a snowdome.
  • Go shopping at the Mall of the Emirates or the Dubai Mall.
  • Explore the desert surrounding the city – either by 4x4 or atop a camel.
  • Eat fantastic seafood at Dubai Marina.
  • Cool off at the Wild Wadi Waterpark.
  • Marvel at gorgeous Arabic calligraphy at Jumeirah Mosque, the biggest in the city.
  • Take a yacht tour around the artificial islands of Palm Jumeirah.
  • Haggle for souvenirs in one of the city's souks.
  • Wander around the traditional building in Bastakiya District.
 22 Portman Square, Marylebone, London W1H 7BG, UK
 3 Oudai street, Aldouki, Giza, Giza Governorate, Egypt
 0020233379764
 00201095004484
 00201102960555
 00201102960666
 19 Mayıs Mahallesi, 19 Mayis Street No 2 Sisli, 34360 Istanbul/Turkey
 00905357839460
 Australia Street, Raouche Beirut, Lebanon .، Beirut, Lebanon
 0096181746278
 811 Massachusetts Avenue, Boston, Massachusetts, 02118, USA
 6 Beirut Street - Fifth Circle Abdoun, P.O. Box 831370, 11183 Amman, Jordan
Copyright Global Horizon Training Center © 2019