In this introductory course you will learn the basics of databases and SQL using the researcher-focused training modules from the highly regarded Software Carpentry Foundation.
In this introductory course you will learn the basics of databases and SQL using the researcher-focused training modules from the highly regarded Software Carpentry Foundation.
About This Course
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.
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.
Developed using the researcher-focused training modules from the highly regarded Software Carpentry Foundation.
Learning Outcomes
Understand and compose a query using SQL
Use the SQL syntax to select, sort and filter data
Calculate new values from existing data
Aggregate data into sums, averages, and other operations
Combine data from multiple tables
Design and build your own relational databases
Prerequisites
Intersect is an important part of Australia’s research infrastructure. We provide robust, innovative and collaborative technology to support world-class research at member and customer universities and other organisations.
We help researchers be more effective by providing them with highly advanced and specialised IT services and solutions.
In The Beginning
25 June 2008, Sydney Australia: A proposal for an “Institute for Trans-disciplinary eResearch Services & Technology” was approved by the DVCsR of the University of Sydney, Macquarie University, the University of NSW, Southern Cross University and the CEO of the Securities Industry Research Centre of Asia-Pacific (SIRCA).
A Board of Directors was appointed with Professor Mark Wainwright as Chair, Paul Martin as Secretary and Dr Michael Briers as interim CEO, and founding directors were John Shipp, John Masters, James Dalziel.
Intersect was incorporated as a not-for-profit company limited-by-guarantee, governed by a Constitution that grants NSW research institutions eligibility as members.
The Department of State and Regional Development (DSRD) approved a Science Leveraging Fund grant, which provided funding to Intersect over three years. Dr. Ian Gibson was appointed CEO and the initial goal of establishing a worldwide viable Intersect by mid-2008 was achieved.
Careers At Intersect
Intersect offers challenging work on a diverse range of projects that support leading edge research across disciplines. We are big on collaboration – sharing ideas and expertise and following the Agile Software Development methodology.
We provide a supportive environment in which you can learn and develop new skills. We work hard, but we also like to have fun!
On completion of this course, attendees will be able to use SQL to develop complete computer reporting systems without writing a line of programming code. You should come to this course if your work involves the storage and retrieval of lists of information capable of being queried.
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database
T-SQL Create Select Queries course is offered by IFA Australia - Institute for Financial Analysts Australia. Our program structure and content has been researched by consultation with industry CFO’s. The courses are written and delivered by experts in their field.
This two-day instructor-led course is aimed at database professionals looking to update their skills to cover SQL Server 2017.
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy