Welcome to Mobilarian Forum - Official Symbianize forum.

Join us now to get access to all our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, and so, so much more. It's also quick and totally free, so what are you waiting for?

SQL Query Training For Sap Business One

TOP 110


Alpha and Omega
Jan 21, 2021
Reaction score
3 years of service

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.37 GB | Duration: 2h 52m
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
You should be familiar with SAP Business One and want to build queries / reports
A working SAP Business One environment (SQL or HANA)
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.
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 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.

Please, Log in or Register to view codes content!

Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live
Links are Interchangeable - No Password - Single Extraction
K 0

KatzSec DevOps

Alpha and Omega
Jan 17, 2022
Reaction score
2 years of service
TOP salamat sa pag contribute. Next time always upload your files sa
Please, Log in or Register to view URLs content!
para siguradong di ma dedeadlink. Let's keep on sharing to keep our community running for good. This community is built for you and everyone to share freely. Let's invite more contributors para mabalik natin sigla ng Mobilarian at tuloy ang puyatan. :)
Top Bottom