This one-day badge focused on code and queries teaches you the fundamentals of writing efficient code and how to apply these towards optimizing your SQL queries. This training provides you with three competencies: A performant program, meaning your program runs as fast as possible. A sharable program so others can understand and adapt your code. And finally, a scalable program that can be easily adjusted if the input changes. This course will also teach you to tackle specific version control challenges by working in Git.
Why is this for you?
Do you actually know – on a deep level – if your code is doing the right thing while running on production? Or do you just trust that it works? In this course, our field experts will teach you the best-practice for code writing in teams and optimization.
Who should attend?
This module is ideal for AI Engineers, Data Engineers and Data Scientists looking for hands-on experience to improve their programming skills. Participants must be familiar with the general terminology of programming and statistical tooling such as SQL and Python to get the most out of this course.
What will you learn?
- Writing code as a team using version control, code reviews, and setting shared code standards
- Writing low maintenance code intended for production
- Writing optimal SQL and Python code in terms of performance
- Principles of efficient coding – Being able to write efficient code, i.e. code that uses the right language for the job, that is performant, sharable, and scalable
- Query and code optimization in SQL – Advanced application of SQL code including reading and understanding execution plans, performance optimization, debugging and fixes
- Version control using Git – Being able to use version control systems to share and version your code in a team environment
Theory and practical use
All trainings in the GAIn portfolio combine high-quality standardized training material with theory sessions from experts and hands-on experience where you directly apply the material to real-life cases. Each training is developed by top of the field practitioners which means they are full of industry examples along with practical challenges and know-how, fueling the interactive discussions during training. We believe this multi-level approach creates the ideal learning environment for participants to thrive.
- Version control
- Low maintenance code
- Code optimization
- Code review
- Code standards
Open Course Schedule
MIacademy offers part of its portfolio in an Open Course Schedule Format in our location in the center of Amsterdam. Via the form below you can register your interest to participate. Our team will contact you to finalize the booking and answer any questions you may have.
All of our courses are delivered by our expert trainers.
If no dates are mentioned, the specific course is not scheduled yet in 2020. If this is the case you can use the form to register your interest. In case there is enough demand MIacademy can schedule additional courses and will notify you.
Are you interested in training a larger group of people, looking for specific training or would you like to create a company-wide program? We will be happy to assist!
Whether you have a very specific training need (for example: training your Data Engineers on advanced technical topics, or your Data Scientists on model implementation), or the need for a large transformational program, or something in between, we can help. Over the past 13 years, we have built up extensive experience not only in the implementation of multi-year, multi-population, multi-country programs but also in providing high quality, very specific modules for specific target groups. Both in in-house set-ups and cross-company programs. Not sure what type of program would fit your organization best? We’d be happy to discuss the best approach together.