SQLBits encompasses everything from in-depth technical immersions to the enhancement of valuable soft skills. The full agenda will be announced in the spring; in the meantime check out the timetable and content we cover below.
2024 Training Days
Presenting 2024’s selection of training days, encompassing a deep dive into a range of subjects with some of the best data trainers in the world.
- 08:00 Registration opens and breakfast served.
- All training days run simultaneously across the venue from 09:00 – 17:00 with co-ordinated breaks.
- All training days include regular refreshment breaks and a lunch stop to rest, recharge, and chat to fellow delegates.
- No evening events planned, but if you’re staying over the night beforehand, why not join us in the Aviator on Monday night to meet the training day speakers for an informal drinks reception.
Python for SQL Server Specialists
Description
Python is a more organized language than R. In last years, many data analytics libraries for Python evolved, and thus Python is catching up with R even in the data science area.
Microsoft added support for Python code in SQL Server in version 2017. Now you can use either R or Python inside the Database Engine for advanced tasks like predictive analytics. Therefore, you can use the language that suits you better. Statisticians and mathematicians might prefer R, while developers tend to be more Python oriented.
Attendees of this seminar learn to program with Python from scratch. Basic Python code is introduced using the Python engine installed with SQL Server 2017 and Visual Studio 2017. The seminar shows some more advanced data manipulations, matrix calculations and statistical analysis together with graphing options. The mathematics behind is briefly explained as well. Then the seminar switches to more advanced data mining and machine learning analyses.
Microsoft added support for Python code in SQL Server in version 2017. Now you can use either R or Python inside the Database Engine for advanced tasks like predictive analytics. Therefore, you can use the language that suits you better. Statisticians and mathematicians might prefer R, while developers tend to be more Python oriented.
Attendees of this seminar learn to program with Python from scratch. Basic Python code is introduced using the Python engine installed with SQL Server 2017 and Visual Studio 2017. The seminar shows some more advanced data manipulations, matrix calculations and statistical analysis together with graphing options. The mathematics behind is briefly explained as well. Then the seminar switches to more advanced data mining and machine learning analyses.
Pre-requisites
Familiarity with the tools - SQL Server Management Studio, Visual Studio
Laptop Required:Optional
- Spec: No special requirements, anything that can host SQL Server 2017. Note: laptop is not obligatory; however, I plan to provide the code used in the seminar at the beginning of the day, so you can join me in exploring and executing it. If you don"t have a laptop then no problem, you can sit back and watch!
- Software: SQL Server 2017 Database Engine Services with Machine Learning Services (In-Database) and both languages, Python and R, SQL Server Management Studio, Visual Studio 2017 setup for Data Science and Analytical Applications
Learning Objectives
Previous Experience
Tech Covered
data mining, Analytics, R