Udemy - SQL Query Training For SAP Business One

[dkmdkm]

Free Download Udemy - SQL Query Training For SAP Business One
Last updated 1/2023
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.63 GB | Duration: 3h 9m
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.
SAP Business One users and consultants who want to learn how to build SQL queries.

Homepage

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

No Password - Links are Interchangeable

 

[0dayddl]

Sql Query Training For Sap Business One
Last updated 7/2018
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
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.

DDownload

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

RapidGator

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

NitroFlare

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!