Support

Thank you from doMore

I'd like to thank you for being involved in the doMore.com.au community and the team and I hope that you've received value from being a part of it.

doMore was our original passion project born out of the desire to help connect people wanting to learn something new with experts that could teach them over 10 years ago.

Over the years we have helped almost 70,000 learners connect with one of over 1,500 courses and providers, across the country. For that, we're very proud and grateful for your contribution.

doMore.com.au also served to teach us about how to help measure and improve business performance and inspired the launch and growth of two other companies as a result, one of which we've decided to dedicate our resources and energy to making great.

We'll be switching the site off on Tuesday 31st of July. If you have any questions or concerns, please contact us directly on [email protected].

Thanks again and good luck with your teaching endeavours in the future.

Warm regards,

The doMore team.

Introduction to SQL Course

7 sessions available starting from $990.00

Subject: Programming

Ages: All ages

Skill level: All difficulty levels

This course trains the participants in using the Structured Query Language (SQL) to retrieve data from a relational database and to make changes to that same data.

This course focuses on data access and manipulation. While the SQL statements to manage the database schema/structure are mentioned, they are not covered in detail.

Intended For

Anyone who needs to be able to access relational data with SQL.

Learning Outcomes

By the end of this course, participants will be able to create SQL SELECT statements that retrieve any required data and create SQL INSERT, UPDATE and DELETE statements to make changes to that same data.

Content

Relational Databases

An overview of relational database schemas: tables; fields; indices; primary and foreign keys; relationships.

Reading...

see more

This course trains the participants in using the Structured Query Language (SQL) to retrieve data from a relational database and to make changes to that same data.

This course focuses on data access and manipulation. While the SQL statements to manage the database schema/structure are mentioned, they are not covered in detail.

Intended For

Anyone who needs to be able to access relational data with SQL.

Learning Outcomes

By the end of this course, participants will be able to create SQL SELECT statements that retrieve any required data and create SQL INSERT, UPDATE and DELETE statements to make changes to that same data.

Content

Relational Databases

An overview of relational database schemas: tables; fields; indices; primary and foreign keys; relationships.

Reading Data

The SQL SELECT statement: reading rows; duplicate values; filtering rows; ordering rows.

Modifying and summarising the data: expressions; aggregate functions; field aliases; grouping values; filtering rows and groups.

Retrieving data from multiple tables: joins; table aliases.

Simplifying queries with nesting: nesting with from; nesting with in; nesting with operators; unions; views.

Adding Data

Inserting new data rows: adding a single record; adding a new table; nested queries.

Changing Data

Modifying existing data: updating all records; updating selected records; updating multiple fields.

Deleting Records

Removing data rows: deleting all records; deleting selected records.

Parameters

Using values picked up at runtime rather than ‘hard-coded’: queries; modifying data.

Database Management

Managing the database schema/structure: managing tables; indices.

Method Used

This is a hands-on course, with participants applying what they learn to access a non-trivial database. Every participant will have dedicated use of a workstation for the database exercises.

see less

Choose from 7 available sessions:

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Melbourne, VIC

Price: $990.00

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Melbourne, VIC 2000

Price: $990.00

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Canberra, ACT

Price: $990.00

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Melbourne, VIC

Price: $990.00

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Brisbane, QLD

Price: $990.00

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Melbourne, VIC 2000

Price: $990.00

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • Canberra, ACT

Price: $990.00




My Other Listings

Taste of Agile Course
Taste of Agile Course
1 session available for $990.00
ISTQB Training Course | Advanced Analyst Core Module
ISTQB Training Course | Advanced Analyst Core Module
2 sessions available starting from $2,970.00
Taste of Agile Course
Taste of Agile Course
1 session available for $990.00

see all listings »


Found In