Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA CompTIA Security+ Amazon AWS Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Freelancing Online Business Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Business Business Analytics & Intelligence SAP Business One

SQL Query Training for SAP Business One

No jargon course on queries by a friendly SAP Business One consultant
Rating: 4.0 out of 54.0 (204 ratings)
912 students
Created by Michael Taylor
Last updated 7/2018
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Design SQL queries for data or export
  • Build basic and advanced SQL queries
  • Find data and create quick ad-hoc reports for managers
  • Create SQL views and stored procedures for use a Crystal Report datasources

Requirements

  • You should be familiar with SAP Business One and want to build queries / reports
  • A working SAP Business One environment (SQL or HANA)

Description

My goal is to take any user and make them into an SQL query expert.  Without overly technical jargon and unnecessary complexity.

I include real-world experience and examples of queries written for actual customers for reference.  I show you exactly how I build queries, find tables and how to get your information out of SAP quickly to generate ad-hoc reports.

We will also be covering more advanced topics including SQL views, stored procedures and how to use SQL datasources in Crystal Reports.

If you have already done my Crystal Reports course, this course is a logical next step and a great way to improve your skills.  Do reports yourself, save money and be in control of your data.

This course includes the ability to ask me questions and get real answers.  I monitor the Q&A section constantly and will reply generally within 24 hours with guidance.

Who this course is for:

  • SAP Business One users and consultants who want to learn how to build SQL queries.

Course content

7 sections • 36 lectures • 2h 52m total length

  • Preview02:19

  • Preview02:51
  • Preview08:29
  • My Process & Tools
    07:28
  • Activity: Getting Your Tools Together
    02:50
  • Find and Identify Fields
    4 questions
  • Article: Advanced Tips & Tricks
    02:12

  • Basic SQL Syntax
    06:45
  • SQL Table Joins
    02:42
  • SQL Query Filtering
    06:12
  • SQL Query Filtering with Dates
    06:20
  • SAP Business One Parameters
    06:56
  • Deploy Your Queries to SAP
    06:04
  • Exporting Your Data to Excel
    02:01
  • RATE AND REVIEW PLEASE
    00:27
  • Activity: Write and Deploy Your First Query
    02:06
  • SQL Query Basics
    5 questions

  • Alert Queries
    05:47
  • Formatted Searches
    14:19
  • CASE Satements
    07:12
  • Aggregate Functions and Grouping
    08:14
  • Article: Aggregate Functions in Detail
    01:08
  • Article: Understanding and Adapting Queries from SAP Forums
    02:26
  • Coalesce Will Save the Day
    05:53
  • Activity: Create a Customer Statistics Query
    06:17
  • SQL Query Intermediate
    5 questions

  • Subqueries and Derived Tables
    09:52
  • SQL Views
    09:58
  • Declaring SQL Variables
    05:04
  • Stored Procedures
    10:20
  • Views and Stored Procedures for Crystal Reports
    11:29
  • Article: B1 Usability Package Query Advantages
    02:06
  • Article: HANA Differences + 130 Examples
    00:20
  • SQL Query Advanced
    5 questions

  • Document Resources
    00:06

  • Business Partner Master Data Raw Export v1.0
    01:56
  • Item Master Data + Price Lists Raw Export v1.0
    00:53
  • Sales Analysis by Date Range Export v1.0
    02:06
  • Inventory Audit Report Export v1.0
    00:31
  • Current Stock in Warehouse v1.0
    00:29

Instructor

Michael Taylor
BBA, Business Management Consultant
Michael Taylor
  • 4.3 Instructor Rating
  • 1,532 Reviews
  • 16,461 Students
  • 3 Courses

Summary: Active SAP software consultant working with SAP Business One in the SME space. Developing business intelligence and business processes for my clients. Working for Forgestik in Western Canada.


History

My focus has always been on business and technology.

Started in web design and development while attending school, finished my BBA and began implementing business management software. I was quickly recruited into the SAP ecosystem and began working with SAP Business One.

Using information technology is critical to operational efficiency. Your use of technology means the difference between good and great.

With my eye for design and mind for process, I have been designing business systems be it in ERP form or web site form since the start of my career.

My current focus is SAP Business One implementation with a specialty in Crystal Reports and business intelligence.

But I have not lost my love for design and internet technologies as I still work on web development projects on the side.


Interests

I am an enthusiastic martial artist (Pankration / MMA), reader and artist. Amateur handyman, technology nerd, video game connoisseur and sushi lover.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.