Introduction
Disclaimer
We are happy to make our knowledge and materials available to help you apply SQL issues in your organization.
Feel free to use the sheets and apply them in your own work and projects. We also appreciate it when you send us your experiences or improvements. We also like to work a little better every day.
However, it is not the intention to use this material 1-on-1 for giving your own training or to forward the material to other interested parties. We are the intellectual owners of this material.
If you plan to use this material for anything other than your own work, could you please contact us in advance? You can do so via info@datasciencepartners.nl or 020-2443146.
Then we can make arrangements with you on how we can help each other in this.
1. Introduction
-
What is your name and who are you?
-
Why do you want to learn SQL?
-
What do you already know about it?
2. Data Science Partners
-
Training
- SQL
- Python
- R
-
Consultancy
-
Software
3. Schedule
During the 2 training days, we will follow the following schedule:
Day 1
| Time | Topic |
|---|---|
| Morning | Introduction |
| Morning | Data retrieval |
| ~12:00 - 13:00 | Lunch |
| Afternoon | Data retrieval |
| Afternoon | Grouping and aggregating |
Day 2
| Time | Topic |
|---|---|
| Morning | Grouping and aggregating |
| Morning | Making adjustments |
| ~12:00 - 13:00 | Lunch |
| Afternoon | Data models |
| Afternoon | Combining tables |
| Afternoon | Conclusion |
-
There is plenty of room for short breaks in between.
- Also indicate if you need this.
-
In several places, you will find extra material and extra assignments in this training.
-
We do not cover this during the training.
- Are you progressing faster than the group during the assignments?
- Then you can start on the extra assignments.
-
This is so you can continue to practice afterwards.
-
-
It is also completely okay if you don't understand something right away.
- Programming is sometimes very abstract, which can take time to grasp.