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!
Oracle Purchasing Fundamentals R12.x course is designed to give learners an overview of Oracle e-Business Suite Purchasing, including the basic functionality for requisitioning and purchasing.
This course will teach the basics of Microsoft’s dialect of the standard SQL language
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.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy