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

Koenig Solutions Logo

R12.x Oracle Purchasing Fundamentals

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.

by Koenig Solutions [Claim Listing ]
Academy IT Logo

Querying Data with Microsoft Transact-SQL

This course will teach the basics of Microsoft’s dialect of the standard SQL language

by Academy IT [Claim Listing ]
StreamTech Knowledge Logo

Administering Microsoft® SQL Server

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

by StreamTech Knowledge [Claim Listing ]
Prog360 Logo

MySQL DBA

MySQL Training and Certification focuses on the Core Concepts & Advanced Tools and techniques to manage data and administer the MySQL Database.

by Prog360
IFA Australia - Institute for Financial Analysts Australia Logo

T-SQL Create Select Queries

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.

by IFA Australia - Institute for Financial Analysts Australia [Claim Listing ]

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