SQL Query Training for SAP Business One

SQL Query Training for SAP Business One, available at $69.99, has an average rating of 4.41, with 37 lectures, based on 487 reviews, and has 2625 subscribers.

You will learn about 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 This course is ideal for individuals who are SAP Business One users and consultants who want to learn how to build SQL queries. It is particularly useful for SAP Business One users and consultants who want to learn how to build SQL queries.

Enroll now: SQL Query Training for SAP Business One

Summary

Title: SQL Query Training for SAP Business One

Price: $69.99

Average Rating: 4.41

Number of Lectures: 37

Number of Published Lectures: 37

Number of Curriculum Items: 41

Number of Published Curriculum Objects: 41

Original Price: $39.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: What is SQL? What is a Query?

Chapter 2: SQL Query Design

Lecture 1: Where to Start / Query Design

Lecture 2: Finding Data in SAP Business One: Basic

Lecture 3: My Process & Tools

Lecture 4: Activity: Getting Your Tools Together

Lecture 5: Article: Advanced Tips & Tricks

Chapter 3: SQL Query Basics

Lecture 1: Basic SQL Syntax

Lecture 2: SQL Table Joins

Lecture 3: SQL Query Filtering

Lecture 4: SQL Query Filtering with Dates

Lecture 5: SAP Business One Parameters

Lecture 6: Deploy Your Queries to SAP

Lecture 7: Exporting Your Data to Excel

Lecture 8: RATE AND REVIEW PLEASE

Lecture 9: Activity: Write and Deploy Your First Query

Chapter 4: SQL Query Intermediate Topics

Lecture 1: Alert Queries

Lecture 2: Formatted Searches

Lecture 3: Formatted Searches (Additional YouTube Video)

Lecture 4: CASE Satements

Lecture 5: Aggregate Functions and Grouping

Lecture 6: Article: Aggregate Functions in Detail

Lecture 7: Article: Understanding and Adapting Queries from SAP Forums

Lecture 8: Coalesce Will Save the Day

Lecture 9: Activity: Create a Customer Statistics Query

Chapter 5: SQL Query Advanced Topics

Lecture 1: Subqueries and Derived Tables

Lecture 2: SQL Views

Lecture 3: Declaring SQL Variables

Lecture 4: Stored Procedures

Lecture 5: Views and Stored Procedures for Crystal Reports

Lecture 6: Article: B1 Usability Package Query Advantages

Lecture 7: Article: HANA Differences + 130 Examples

Chapter 6: Downloadable Resources

Lecture 1: Document Resources

Chapter 7: Common Query Examples with Documentation

Lecture 1: Business Partner Master Data Raw Export v1.0

Lecture 2: Item Master Data + Price Lists Raw Export v1.0

Lecture 3: Sales Analysis by Date Range Export v1.0

Lecture 4: Inventory Audit Report Export v1.0

Lecture 5: Current Stock in Warehouse v1.0

Instructors

Michael Taylor
BBA, Business Management Consultant

Rating Distribution

1 stars: 6 votes
2 stars: 13 votes
3 stars: 64 votes
4 stars: 164 votes
5 stars: 240 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu