Hero background

SQL Development - Beginner

(DESD-100)

Course overview

We are moving to a data-driven culture, and more than ever, it’s vital that you and your team can search through data to find insights to inform decisions.

 

This one-day course is highly interactive with lots of hands-on activities.

Learning outcomes

 

By the end of this course, participants will be able to:

 

Check List Item Icon
Use SQL to access, create, and update data in a database
Check List Item Icon
Understand SQL query structure and perform queries, utilising essential querywords and functionality
Check List Item Icon
Use basic SQL commands – this includes filtering, sorting, manipulating dataand using case statements for conditional logic
Check List Item Icon
Perform table joins and unions and query multiple tables
Check List Item Icon
Utilise various aggregate functions to support data analytics
Check List Item Icon
Create datasets to answer business questions and problems using SQL
Check List Item Icon
Use their skills and knowledge to read the SQL documentation and applyfunctions not previously taught.
Check List Item Icon
Optimise query performance for faster response time

Intended audience


The one-day SQL course is designed for individuals who want to learn the basics of SQL, including querying and manipulating data in a relational database. The course is suitable for beginners with little or no prior experience in SQL. This includes professionals working in roles such as data analysts, business analysts, database administrators, and developers who want to develop their SQL skills. The course covers fundamental SQL concepts, such as creating and querying databases, filtering, and sorting data, and using functions and expressions to manipulate data. By the end of the course, attendees will have a solid understanding of SQL and be able to write basic SQL queries to retrieve and manipulate data.

 

Delivery

 

This course is offered privately for groups of around 10–12 participants. Delivered either onsite or remotely by our experienced consultants, it can be tailored to meet your organisation’s specific needs.

 

Contact us for a quote

Download the full agenda.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Submit your request to download the agenda

Upcoming public training

For a selection of our most popular courses, we offer public training sessions - perfect for individuals or small teams who don’t have enough participants for a private course.

There is no upcoming public training for this course.

See all upcoming training
Client testimonials

High quality outcomes

"The team at Altis have an exceptional understanding of data analytics and engineering, and I trust them to deliver high quality outcomes"

Don Gooden

Head of Engineering, Mutinex

I can’t recommend Altis enough

The data transformation at Deputy would not have been possible without Altis and their support. I can’t recommend Altis enough to anyone that is about to embark on a transformation.

Huss Afzal

Director of Data, Deputy

A real differentiator for our business

“The [Altis] solution as a whole brings real benefit to our client base, and is a real differentiator for our business in such a busy marketplace.”

Robbie Francis

Managing Director, Eposability

Talk to a trainer

Our expert trainers are here to assist you. We’re just a call or email away.
+61 2 9211 1522
connect@altis.com.au
Connect with us on Linkedin
Personal Information
Contact Information
Job Title and Company Information
Location Information

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Submit your enquiry form to contact Altis Consulting