Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 8 Minute(s)
Language
English
Taught by
Michael Taylor
Rating
Course Overview
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.
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.
Course Content
- 7 section(s)
- 37 lecture(s)
- Section 1 Introduction
- Section 2 SQL Query Design
- Section 3 SQL Query Basics
- Section 4 SQL Query Intermediate Topics
- Section 5 SQL Query Advanced Topics
- Section 6 Downloadable Resources
- Section 7 Common Query Examples with Documentation
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
Skills covered in this course
Reviews
-
AAjay Abraham
Thanks!! and it was awesome to take up this course, it has provided a light in the field of SQL SAP Business one.
-
MMa Christine Cape
Very Helpful for a beginner
-
NNiranjan Jayasanka
This was an amazing course. It covered all the topics I was hoping to learn about.
-
İİsmail Aydın
For now I like this course.
