Databases And SQL

by Intersect Claim Listing

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.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Intersect Logo

img Duration

Half Day

Course Details

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

  • The course has no prerequisites
  • Sydney Branch

    Ground Floor, 320 Pitt Street, Sydney
  • Melbourne Branch

    WeWork, 120 Spencer St, Melbourne
  • Adelaide Branch

    Spot Co-Working, 12 Pirie St, Adelaide

Check out more SQL Server courses in Australia

NobleProg (Australia) Logo

HBase For Developers Training Course

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.

by NobleProg (Australia) [Claim Listing ]
Nexacu Software Skill Training Logo

SQL Beginner Course

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

by Nexacu Software Skill Training [Claim Listing ]
Computer Information System Lab Logo

SQL Server

Our CISLAB hands-on-Lab Training Programs and Job Oriented Training programs are very popular among individual customers.

by Computer Information System Lab [Claim Listing ]
InterSkill Australia Logo

MySQL Database Development

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.

by InterSkill Australia [Claim Listing ]
StreamTech Knowledge Logo

Designing Business Intelligence Solutions with Microsoft SQL Server

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

by StreamTech Knowledge [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy