Scott Stroz
MySQL Developer Advocate
Charles Town, West Virginia, United States
Actions
Scott has been full-stack developer for longer than the term "full-stack developer" has been around. In that time, MySQL was the only constant in his development stack. He is passionate about sharing what he has learned on his coding journey so others may learn from his mistakes.
Area of Expertise
Topics
The Top 10 Things You Didn't Know MySQL Shell Can Do
MySQL Shell is a new command line interface for connecting to and managing MySQL database instances - but you can do much more than run SQL queries. In this session, we will discuss some of the most helpful features of MySQL Shell that you might not know about.
JavaScript & MySQL: Perfect Together - A guide to using JavaScript to Create Stored Functions
Did you know you can use JavaScript to create stored functions and stored procedures in MySQL? Join me in this session where we will discuss the benefits of using JavaScript to create stored functions and procedures, give a high-altitude overview of how JavaScript is converted to a language MySQL can understand, demonstrate multiple examples, and show some debugging techniques.
From Slinging Bodies to Slinging Code - A Paramedic's Journey to Becoming a Developer
Did you come to code writing through another career? Did you know you learned skills in your previous career that can make you a better developer? Come find out how to identify those skills from previous experiences to improve your skills as a developer.
MySQL, Node, & Testcontainers - Testing Done Right
Writing tests for code that interacts with a database can be challenging. Testcontainers can help make it less of a challenge. In this session, we will discuss the advantages of using Testcontainers, how to use a MySQL container to have a clean database every time you run your tests, and how to incorporate each to test your Node.js code effectively and efficiently.
MySQL, Java, & Testcontainers - Testing Done Right
Writing tests for code that interacts with a database can be challenging. Testcontainers can help make it less of a challenge. In this session, we will talk about the advantages of using Testcontainers, how to use a MySQL container to have a clean database every time you run your tests, and how to incorporate each to effectively and efficiently test your Java code.
Using MySQL Document Store with Java
MySQL Document Store offers developers the best features of NoSQL and relational, SQL-based databases. In this session, we will discuss how we can use Java to access a MySQL Document Store, create/remove collections, create/update/remove documents, retrieve, filter, & sort document lists, and leverage raw SQL to retrieve aggregate data for reporting purposes.
My Pi in the Sky - Running MySQL on a Raspberry Pi and Replicating Data to the Cloud
Did you know you can run MySQL on a Raspberry Pi and replicate the data to the cloud?
In this session, we will cover how to install MySQL on a Raspberry Pi, give a brief overview of how to store data on this MySQL instance, demonstrate an application that can visualize that data, and finally, how you can replicate that data to a MySQL instance running in the cloud.
Using MySQL Document Store with SpringBoot
traditional SQL-based database. In this session, we will discuss how we can use SpringBoot to access a MySQL Document Store, create/remove collections, create/update/remove documents, retrieve, filter, & sort document lists, and leverage raw SQL to retrieve aggregate data for reporting purposes.
NoSQL + SQL = MySQL - An Introduction to MySQL Document Store
MySQL Document Store offers developers the best features of both a NoSQL database and a relational database. In this session, we will discuss how we can access a MySQL Document Store, create/remove collections, create/update/remove documents, retrieve, filter, & sort document lists, and leverage raw SQL to retrieve aggregate data for reporting purposes.
Using Window Functions in MySQL
Window functions in MySQL allow you to return aggregate data for a subset of your results in a single query. In this session, we will define what window functions are, and discuss use cases for when window functions might be appropriate. We will also break down the syntax of window functions and talk about the different clauses that can be used and demonstrate the functionality of window functions and how the different clauses can return different results.
Using MySQL Document Store with Node.js
MySQL Document Store offers developers the best features of both a NoSQL database and a traditional SQL based database. In this session we will discuss how we can use Node.js to access a MySQL Document Store, create/remove collections, create/update/remove documents, retrieve, filter, & sort document lists, and leverage raw SQL to retrieve aggregate data for reporting purposes.
MySQL, JSON, & You: Perfect Together
Long before 'NoSQL' databases became all the rage, developers stored JSON in relational database tables. With the advent of the JSON data type, developers now have a powerful set of functions to update, retrieve, and filter data based on values stored in a JSON blob. In this session, we discuss storing JSON in our database and how the tools in MySQL can make that task a bit easier. We will start with a discussion of why you might want to store data as JSON as opposed to other storage methods. We will then talk about the different ways in which MySQL can help us achieve that goal and how we might go about deciding what method is best. We will see examples of using the JSON data type to store data in a 'normal' table and use SQL commands to retrieve filter, and sort that data. We will also show how you can validate your JSON schema.
UtahJS Conf 2023 Sessionize Event
JavaScript & Friends 2023 Sessionize Event
KCDC 2023 Sessionize Event
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top