SQL Intermediate Course

Meet your Developer

Tamara Shatar holds a PhD in Agricultural Data Science. She has extensive experience, including many years working as a research scientist focused on data analysis, modelling using machine learning, simulation, and other techniques. While working in both academia and at the CSIRO, part of her role included teaching a variety of data analysis skills.

What is Remote Training?

Remote training at Nexacu means our experienced trainers will deliver your training virtually. With remote learning, students can access our usual classroom training courses via video conferencing, ask questions, participate in the discussion, and share their screen with the trainer if they need help at any point in the course. Students have the same level of participation and access to the trainer as they would in classroom training sessions.

Who should attend this SQL Intermediate course?

This course is designed for those who have completed our SQL Beginner course or have equivalent experience writing basic SQL queries. It's ideal for professionals who want to enhance their skills with T-SQL and more complex querying techniques.

What will I learn in this intermediate SQL training?

You’ll learn to write more advanced SQL queries using T-SQL, work with built-in functions, create subqueries and views, and build your own user-defined functions. This course helps deepen your SQL skills for real-world data analysis and reporting tasks.

Do I need to know T-SQL before attending?

No prior T-SQL experience is required, but you should be comfortable writing basic SQL queries. The course introduces key T-SQL functions and syntax progressively, building on foundational SQL concepts.

What tools will I use during this SQL training course?

You will work with Azure SQL Database and write queries using Transact-SQL (T-SQL) in Azure Data Studio. These tools are industry-standard and widely used across data and analytics roles.

Is this course hands-on?

Yes, the course includes practical exercises throughout. You'll write queries, apply functions, and solve real-world problems as part of your learning experience.