Welcome to SQL Saturday in Albany, NY: July 28, 2018
SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server and related technologies. This is our 5th SQL Saturday in Albany, and will take place on the beautiful campus at the University of Albany. The event is free, plus a $10 fee for those who will enjoy a delicious breakfast and lunch with us. Vegetarian options are available for all meals.
Please register soon and let your friends and colleagues know about the great time to be had at our event! In addition to educational sessions by leading industry experts, you can meet colleagues from around the country and maybe win some sweet raffle prizes!
The street address for UAlbany is 1400 Washington Ave, Albany, NY 12222. The following is a map indicating the location of the campus and is centered on the State Purple parking lot. Signs will direct you from there to the lecture centers & fountain area, where all events will be taking place.
Google Map: State Purple Parking Lot
All events will be held in the Lecture Centers, which are located at the center of campus encircling the large tower & fountain. A Google map of SUNY Albany's campus can be found here, as well as a printable PDF version, as well.
The State Purple lot is the closest and most convenient place to park on campus, with easy access to the center of campus. All lots allow for free parking on the weekend, so you may park elsewhere, if desired. We will be using Lecture Centers (LCs) 20 - 25 for all sessions, and the concourse area outside of them for sponsors & registration.
Need a Place to Stay?
The Hilton Garden Inn @ SUNY Albany has reserved a block of rooms for attendees at the discounted rate of $139/night. The hotel is located at:
1389 Washington Ave, Albany, NY 12206 and you can reserve a room online or by calling them at (518) 453-1300. The block is reserved under Professional Association of SQL Server.
We are pleased to be offering 2 precon session on Friday, July 27th at the Hilton Garden Inn at UAlbany, in Albany, NY. These are all-day sessions that offers in-depth training that complements our SQL Saturday Albany event.
Introduction to Data Science With Python
John Miner is a Data Architect at Blue Metal, helping corporations solve their business needs with various data platform solutions.
He has over twenty five years of data processing experience, and his architecture expertise encompasses all phases of the software project life cycle, including design, development, implementation, and maintenance of systems.
His credentials include undergraduate and graduate degrees in Computer Science from the University of Rhode Island. He has also earned certificates from Microsoft for Database Administration (MCDBA), System Administration (MCSA) and Data Management & Analytics (MCSE).
Before joining Blue Metal, John won the Data Platform MVP award in 2014 and 2015 for his outstanding contributions to the SQL Server community.
When he is not busy talking to local user groups or writing blog entries on new technology, he spends time with his wife and daughter enjoying outdoor activities. Some of John’s hobbies include wood working projects, crafting a good beer and playing a game of chess.
“Python” and “R” are two well-known data science languages being used today. Both of these languages are part of the open source community and have many free modules available for your use.
Which one of the languages do you choose as an enterprise standard?
My money is on the “Python” language, due to the fact it can be used to solve business problems other than ones related to data science.
Python is a general purpose programming language created by Guido van Rossum in 1991. It was designed for readability and easy syntax by using significant whitespace. The main goal was to allow programmers to solve problems using fewer lines of code.
During this one day pre-conference course, we will be covering the following topics.
Python Programming Basics
- Defining and working with variables.
- Handling user input and output.
- Controlling the program flow.
- Structuring data with tuples, lists and dictionaries.
- Defining and using functions.
- Modeling objects with classes.
- Reading and writing files.
- Handling exceptions with try except blocks.
- Some interesting community packages.
Introduction to Data Science with Python
- Identifying the problems that can be solved.
- Leveraging numpy package for N dimensional arrays.
- Applying the scipy package for scientific computing.
- Using pandas package to create data frames.
- Plotting data with the matplotlib package.
- Sharing research with Jupyter notebooks.
- Machine learning using the skikit-learn package.
This course is meant for beginners who want to learn Python. At the end of the day, you will have a solid understanding of the language and an introduction to the data science libraries.
SQL Server in Azure
For the past 2.5 years, TR has worked at Microsoft as a Cloud Data Solution Architect, helping Enterprises leverage Microsoft Data and AI solutions to draw insight and maximize business impact.
Prior to Microsoft, he had played key role in successfully landing large scale distributed systems using SOA, SQL, NoSQL, Advanced Analytics tools with Java and Python, at Sophos, Verizon, Nokia and other organizations.
In this Precon event, we will present the many different Microsoft Azure Cloud, Data and AI Services. Starting with a high level view of the different services, the sessions will drill down deeper into some of the more frequently used Azure Services in any Data & AI project.
Demonstrations, as well as hands-on exercises will be provided during the sessions. Topics to be covered include:
- Overview of Azure Services: Infrastructure/App, Data & AI
- Azure Data Lake Store & Data Lake Analytics
- Azure Data Factory & Data Catalog
- Azure SQL Data Warehouse, DB, and Managed Instance
- Azure Machine Learning
- Azure Cognitive Services