An Essential Online Course: Marketing Analytics


  • An Essential Online Course: Marketing Analytics, Singapore SKillsFuture elarning online course
  • An Essential Online Course: Marketing Analytics, Singapore SKillsFuture elarning online course
  • An Essential Online Course: Marketing Analytics, Singapore SKillsFuture elarning online course
  • An Essential Online Course: Marketing Analytics, Singapore SKillsFuture elarning online course
  • An Essential Online Course: Marketing Analytics, Singapore SKillsFuture elarning online course
  • An Essential Online Course: Marketing Analytics, Singapore SKillsFuture elarning online course

Course Description

Technical marketers are in high demand and low supply. Being able to dive into data on your own, with no help from analysts, makes you a much better marketer. This is why Structured Query Language (SQL) is so powerful - it allows you to see all your customers’ data and make decisions based on accurate analysis. Knowing how to use SQL is literally a marketing superpower, and that’s exactly what this course will teach you! The concepts and queries in this course are used every day by the marketing teams at successful companies like eBay, Moz and HubSpot.

Maximize your marketing analytics with SQL.

- Understand the basics and fundamentals of SQL
- Learn how to apply SQL into real-time data
- Know how to make full use of data and analysis
- Learn how adopt SQL into your database

This course is SkillsFuture Credit Eligible.


Course Objectives

1. Know the six key components of every SQL query
2. Know how to use and write SQL queries 
3. Able to use SQL efficiently in database 
4. Know how to apply queries in different situations of data extractions 


Related Courses

  • Get Ready and Start Your Own Business: An Essential Course

    Get Ready and Start Your Own Business: An Essential Course

    SGD $45.00

    Course Description

    Take the first steps to becoming your own boss by taking our Start Your Own Business course. Making the transition from employee to employer is a challenge, however our online course will help you on your way to starting your own business. Whether you wish to open an online ski wear store or launch a cake decorating business, there are some fundamental principles and practices that will help you achieve business success. From building customer loyalty to negotiating terms with suppliers to setting up accounting to organizational structures, our course spans a syllabus that is broad and informative. Start your journey as an entrepreneur today! - Learn how to adapt to the scene of being an entrepreneur  - Know how to manage your newly-found business with the right tools - Understand your customers and learn how to retain loyalty  - Learn how to take your business to new heights 

    Read more...

  • Essential Online Course - Quickbooks Point of Sale (POS)

    Essential Online Course - Quickbooks Point of Sale (POS)

    SGD $299.00

    Course Description

    QuickBooks Point of Sale helps retailers go far beyond the cash register with an easy-to use, affordable, scalable, customizable, integrated software and hardware system. It handles routine tasks so retailers can pay more attention to running their business. The solution can track inventory, sales, and customer information, giving retailers more time to think about what to stock, how to price merchandise, when to reorder, and how to serve their customers better. As you master the basics, you'll learn how to deal with tricky situations. - Learn how to tackle your accounts with QuickBooks  - Know how you can avoid tricky accounting conflicts  - Take advantage of the cloud-based platform for your accounts

    Read more...

  • An Essential Online Course: Successful Business Analysis

    An Essential Online Course: Successful Business Analysis

    SGD $79.60

    Course Description

    This course will take you through a proven, structured process to improve your ability to collect, analyses and forecast business and financial data in order to generate valuable insights from business data. It will also teach you how to report on business data and present information and analysis to clients and stakeholders. It is aimed particularly, but not exclusively, at financial and business analysts, managers, planners, customer-service staff, operations staff and information-management personnel.  This course will take you on a structured and thorough journey that will teach you how to turn ‘buckets of data’ into sound, well-supported business decisions, create stunning charts to communicate these business decisions and make you one the most valuable people in your business. Understand your business better with analysis.  - Learn through analysis on how your business is faring  - Understand how analysis and your business work hand in hand  - Discover the advantages of using analysis  - Learn how to churn out useful analysis from your data  This course is Skillsfuture Credit Eligible.

    Read more...


Content

Marketing Analytics

+
Learn how to use SQL for better marketing analytics
  • Section 1: Introduction
    • Unit 1.1 - Introducing the Course
  • Section 2: What is SQL?
    • Unit 2.1 - Introduction
    • Unit 2.2 - What, Why and How
    • Unit 2.3 - Marketing and SQL
  • Section 3: Writing SQL Queries
    • Unit 3.1 - Preparing to Write a Query
    • Unit 3.2 - SQL vs. Excel?
    • Unit 3.3 - Writing Queries
  • Section 4: Using SQL
    • Unit 4.1 - Querying Databases
    • Unit 4.2 - Exercises
    • Unit 4.3 - SQL Scripting and Reporting
    • Unit 4.4 - Course Conclusion
  • Section 5: Bonus Content
    • Unit 5.1 - Chartio for Data Analysis
    • Unit 5.2 - Google Query Creator
SkillsFuture Credit Eligible
SGD $79.60
(Price excludes GST)
GET ACCESS NOW
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.