SQL Query Training for SAP Business One
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.
Who this course is for:
- SAP Business One users and consultants who want to learn how to build SQL queries.
Instructor
Summary: Active SAP software consultant working with SAP Business One in the SME space. Developing business intelligence and business processes for my clients. Working for Forgestik in Western Canada.
History
My focus has always been on business and technology.
Started in web design and development while attending school, finished my BBA and began implementing business management software. I was quickly recruited into the SAP ecosystem and began working with SAP Business One.
Using information technology is critical to operational efficiency. Your use of technology means the difference between good and great.
With my eye for design and mind for process, I have been designing business systems be it in ERP form or web site form since the start of my career.
My current focus is SAP Business One implementation with a specialty in Crystal Reports and business intelligence.
But I have not lost my love for design and internet technologies as I still work on web development projects on the side.
Interests
I am an enthusiastic martial artist (Pankration / MMA), reader and artist. Amateur handyman, technology nerd, video game connoisseur and sushi lover.