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!
This course introduces HBase – a NoSQL store on top of Hadoop.  The course is intended for developers who will be using HBase to develop applications,  and administrators who will manage HBase clusters.
Use SQL to access and query your data. A crucial skill for anyone working with data is the ability to access and analyse that data. Structured Query Language (SQL) enables users to access data from databases, combine data from multiple
Our CISLAB hands-on-Lab Training Programs and Job Oriented Training programs are very popular among individual customers.
This 3-day MySQL Database Development training course encourages students to explore general database fundamentals, as well as MySQL features. Students learn the basics of MySQL use and the programming of stored routines and triggers.
This training course teaches database and business intelligence (BI) professionals how to plan and design a BI solution that is based on Microsoft SQL Server 2014 and other Microsoft BI technologies
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy