SQL Query Training for SAP Business One
- 2.5 hours on-demand video
- 15 articles
- 72 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- 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.
- SAP Business One users and consultants who want to learn how to build SQL queries.
Where to start building a query, how I design queries and how to scope a query.
How to find data in SAP Business One. Using "System Information" to identify tables and columns and using Query Generator to track down table joins. I also describe my process for planning and show a simple example of a query map.
Be a more efficient "Script Kitty" by taking queries from the SAP Business One forum. Learn how to understand them for yourself, adapt them and make them work for your purposes. Tips and tricks for getting started learning from more advanced queries.
Everyone occasionally needs a raw list of their items. I include the most important fields, you could always add to it but it should give you 90% of the likely needed columns including prices for up to two price lists (just duplicate the subqueries for more price lists, includes a price list code finder query).