No jargon course on queries by a friendly SAP Business One consultant
My goal is to take any user and make them into an SQL query expert. Without overly technical jargon and unnecessary complexity.
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.
Course Content
- Introduction –> 1 lecture • 2min.
- SQL Query Design –> 5 lectures • 24min.
- SQL Query Basics –> 9 lectures • 40min.
- SQL Query Intermediate Topics –> 9 lectures • 1hr 8min.
- SQL Query Advanced Topics –> 7 lectures • 49min.
- Downloadable Resources –> 1 lecture • 1min.
- Common Query Examples with Documentation –> 5 lectures • 6min.
Requirements
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.