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

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

  • An Essential Online Course: Accounting & Bookkeeping Intermediate Course

    An Essential Online Course: Accounting & Bookkeeping Intermediate Course

    SGD $79.60

    Course Description

    Transform the accounting process from a necessary evil into an opportunity to protect, improve, expand and optimize your business. All business people know that accounting sits importantly at the heart of the business world. But fewer business people fully understand that accounting represents so much more than the necessary evil of recording profit and loss. Accounting presents business owners and staff with an enormously powerful set of information and tools with which to make critical decisions that protect, improve, expand and even revolutionize the business. Be accountable for all the proceeds in your organization.  - Know how you can keep an account for your business - Learn ways to reduce and eliminate the potential losses  - Discover how you can further your business with proper accounting - Know the benefits of handling your accounts in a constructive manner  This course is eligible for SkillsFuture Credit and UTAP funding.

    Read more...

  • Essential Online Course - Quickbooks Premier 2014

    Essential Online Course - Quickbooks Premier 2014

    SGD $299.00

    Course Description

    This course is training for accounting software that combines a variety of accounting processes into one user-friendly system. The software's primary function is to alleviate the use of multiple tables, spreadsheets, and tracking sheets necessary to document and maintain accounting tasks at a company. Accounting figures are also easily reconciled for tax purposes with Quickbooks. The software was developed by Intuit and can be customized based on the needs of the business utilizing the software. 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: Facebook Marketing for Small Businesses Course

    An Essential Online Course: Facebook Marketing for Small Businesses Course

    SGD $49.60

    Course Description

    Facebook is utterly ubiquitous, and is expanding as we speak. And with no start-up costs, Facebook’s potential as a marketing, branding and networking tool is truly enormous. Utilizing Facebook is indispensable as a business; to ignore it is to be left behind. But whilst many businesspeople know this, most fail to maximize Facebook’s marketing potential.  This course - written by people with extensive Facebook-marketing experience, including soaring highs and crippling lows - will teach you, in just a few hours, how to transform Facebook from a chore into a tool that gives you the freedom and ability to launch and manage tailored marketing campaigns that utilize the power of real-time marketing to deliver hot leads, clients and professional growth immediately. Make full use of Facebook for your business! - Learn how to leverage the power of real-time marketing - Discover how you can market your business on Facebook  - Learn the tools of trade using Facebook to promote your business - Kill two birds with one stone by sharing your business at one stop  This course is eligible for SkillsFuture Credit and UTAP funding.

    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.