Databases and SQL at UON Online

Intersect is a pivotal part of Australian research landscapeWe provide robust, innovative services and collaborative technology to support world-class research at our member organisations and in the wider research communityIntersect delivers data storage, compute and analysis platforms, custom engineering, expert consulting and training programs to thousands of researchers every yearIntersect works closely with the ARDC (Australian Research Data Commons) built from ANDS, Nectar, and RDSIntersect is a member of the Software Carpentry Foundation, the NCI (National Computational Infrastructure) and the AAF (Australian Access Federation)

Intersect Australia

<h2>Why do this course?</h2>








<p>A relational database is an extremely efficient, fast and widespread means of storing structured data, and Structured Query Language (SQL) is the standard means for reading from and writing to databases. Databases use multiple tables, linked by well-defined relationships, to store large amounts of data without needless repetition while maintaining the integrity of your data.</p>
<p>Moving from spreadsheets and text documents to a structured relational database can be a steep learning curve, but one that will reward you many times over in speed, efficiency and power.</p>
<p>Developed using the researcher-focused training modules from the highly regarded Software Carpentry Foundation (software-carpentry.org).</p>








<h2>You’ll learn how to:</h2>
<ul>
<li>
<p>Understand and compose a query using SQL</p>
</li>
<li>
<p>Use the SQL syntax to select, sort and filter data</p>
</li>
<li>
<p>Calculate new values from existing data</p>
</li>
<li>
<p>Aggregate data into sums, averages, and other operations</p>
</li>
<li>
<p>Combine data from multiple tables</p>
</li>
<li>
<p>Design and build your own relational databases</p>
</li>
</ul>
<h2>The Intersect approach to training</h2>
<p>At Intersect, we work closely with our member universities to develop and deliver training that targets the day-to-day software and technology problems that researchers face. We deliver hands-on courses in a relaxed setting with knowledgeable, helpful trainers who are themselves researchers and who know how researchers work. </p>
<p>For more information about <a href="https://inter.fyi/course/sql101" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">this course</a> and others, see our <a href="https://intersect.org.au/training/courses" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">course catalogue</a>, or visit <strong><a href="http://learn.intersect.org.au" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">Learn.intersect.org.au</a></strong></p>
<p></p>

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Databases and SQL at UON Online

More events from Intersect Australia

Follow organisers to get events picked for you

Databases and SQL at UON Online

More events from Intersect Australia

Follow organisers to get events picked for you

You might also like...

Sign in for personalised recommendations