Notice : You are now accessing LOOP SIT SERVER. This is not meant for public access. For the actual LOOP Website please visit www.LOOP.sg instead


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

  • QuickBooks 2012

    QuickBooks 2012

    SGD $40.00

    Course Description

    Acquire the skills that are in high demand by learning to use the popular QuickBooks accounting software for small and mid-sized businesses. In this VTC course, Lauri Matson shares tips and examples from her extensive experience with QuickBooks. Learn how QuickBooks can help manage your business through tracking of purchase orders, inventory, invoices, receipts, and statements. Discover how easy it is to reconcile your checking account, track your payables, and generate reports. As you master the basics, you'll also learn how to deal with tricky situations and troubleshoot complicated entries. 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...

  • Business & Everyday Math Course

    Business & Everyday Math Course

    SGD $49.60

    Course Description

    Get comfortable with numbers in business and life. The business world is founded on numbers and math. Mathematical mindfulness can help eliminate costly errors, drive profit and generally lead to a greater confidence in business (and everyday) discussions. It’s therefore vital for business people to be comfortable with the most important and frequently-occurring features of the discipline. We can help you with that. Understand how math and business are linked in more ways than one.  - Learn how math does not stop just after your school curriculum  - Understand the importance of good math skill in a business - Discover how math can be a fun and interesting topic in our daily life  - Take your math skills to a whole new level with this course

    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.