No jargon course on queries by a friendly SAP Business One consultant
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.
Overview
Section 1: Introduction
Lecture 1 What is SQL? What is a Query?
Section 2: SQL Query Design
Lecture 2 Where to Start / Query Design
Lecture 3 Finding Data in SAP Business One: Basic
Lecture 4 My Process & Tools
Lecture 5 Activity: Getting Your Tools Together
Lecture 6 Article: Advanced Tips & Tricks
Section 3: SQL Query Basics
Lecture 7 Basic SQL Syntax
Lecture 8 SQL Table Joins
Lecture 9 SQL Query Filtering
Lecture 10 SQL Query Filtering with Dates
Lecture 11 SAP Business One Parameters
Lecture 12 Deploy Your Queries to SAP
Lecture 13 Exporting Your Data to Excel
Lecture 14 RATE AND REVIEW PLEASE
Lecture 15 Activity: Write and Deploy Your First Query
Section 4: SQL Query Intermediate Topics
Lecture 16 Alert Queries
Lecture 17 Formatted Searches
Lecture 18 CASE Satements
Lecture 19 Aggregate Functions and Grouping
Lecture 20 Article: Aggregate Functions in Detail
Lecture 21 Article: Understanding and Adapting Queries from SAP Forums
Lecture 22 Coalesce Will Save the Day
Lecture 23 Activity: Create a Customer Statistics Query
Section 5: SQL Query Advanced Topics
Lecture 24 Subqueries and Derived Tables
Lecture 25 SQL Views
Lecture 26 Declaring SQL Variables
Lecture 27 Stored Procedures
Lecture 28 Views and Stored Procedures for Crystal Reports
Lecture 29 Article: B1 Usability Package Query Advantages
Lecture 30 Article: HANA Differences + 130 Examples
Section 6: Downloadable Resources
Lecture 31 Document Resources
Section 7: Common Query Examples with Documentation
Lecture 32 Business Partner Master Data Raw Export v1.0
Lecture 33 Item Master Data + Price Lists Raw Export v1.0
Lecture 34 Sales Analysis by Date Range Export v1.0
Lecture 35 Inventory Audit Report Export v1.0
Lecture 36 Current Stock in Warehouse v1.0
SAP Business One users and consultants who want to learn how to build SQL queries.
Download Links
