SQL Basics for RAMM

SQL Basics for RAMM is a free ten-part digital boot camp from The Datastack.

SQL, or Structured Query Language, is a way to query and manipulate data stored in databases. Databases just like what RAMM from Thinkproject is built on top of.

This course is designed to help get you up and running with SQL in RAMM, gain familiarity with the new SQL Management application, and understand the fundamentals of this powerful language.

Who is this course for?

Wherever you sit within the industry, be it at a road controlling authority, contractor, consultant, or data supplier, learning SQL can help you make better decisions and gain insights from your data.

With our SQL Basics for RAMM digital boot camp, you'll gain the skills and knowledge to kickstart your journey to becoming a confident and competent SQL user within RAMM.

This course has been designed for those who;

• Have never used SQL before and want to get started

• Are at a beginner level with using SQL in RAMM and want to take their skills to the next level

• Previously used the old RAMM SQL app and now want to get up to speed with the new SQL Management app

• Want to brush up on their SQL basics

All lessons have been designed to be as jargon-free as possible. So if you are new to the world of SQL, you won’t be overwhelmed with technical jargon here.

How do I access the lessons?

Each lesson is delivered via email, with one lesson sent to your inbox every two days. We'll guide you through each topic with clear explanations and examples that are easy to follow.

And throughout the course, you will use real-world SQL code that will run in your RAMM database. This will help reinforce what you've learned and give you practical SQL tools you can use in RAMM today.

What will I learn?

You'll learn the key concepts and techniques of SQL, focusing on how to use it within the RAMM software. Here's just a taste of what you'll get from this course:

• Understand what SQL is used for and what SQL code looks like

• Learn about key features of the RAMM SQL Management application that you need to know when getting started

• Find out how to retrieve data from your RAMM dat abase, using examples like carriageway sections and footpaths.

• Create powerful filters based on specific criteria like material types.

• Summarise and aggregate data to get insights from your datasets.

• And much more!

By the end of the course, you'll have a solid foundation to start using the RAMM SQL Management application, and you will be able to write basic queries to retrieve and get insights from the data in your RAMM database.

How do I get started?

To sign up for this boot camp, simply enter your details in the form below. You'll receive a confirmation email, and the first lesson will be delivered to your inbox shortly thereafter.

Don't miss this opportunity to learn how to use SQL in your RAMM database.

Take your data analysis skills to the next level and sign up for our free ten-part SQL Basics for RAMM email course today!