SQL (Intro)

by NDA Tasmania Claim Listing

On completion of this course, attendees will be able to use SQL to develop complete computer reporting systems without writing a line of programming code. You should come to this course if your work involves the storage and retrieval of lists of information capable of being queried.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

NDA Tasmania Logo

img Duration

1 Day

Course Details

On completion of this course, attendees will be able to use SQL to develop complete computer reporting systems without writing a line of programming code. You should come to this course if your work involves the storage and retrieval of lists of information capable of being queried through an SQL interface.

 

Learning Outcomes:

  • Understand fundamental database concepts, relational tables, primary and foreign keys
  • Describe the history of SQL
  • Understand basic SQL structure and syntax
  • Select simple record sets from tables
  • Utilise SQL conditional operators
  • Use statistical and grouping functions
  • Create advanced multiple table queries involving both inner and outer joins.

 

Prerequisites:

Those attending this course require a basic understanding of relational databases and skills equivalent to those presented in NDA’s Access Introductory course. They should also be able to type text efficiently using a text editor.
 

  • Hobart CBD Branch

    Trafalgar Centre, 110 Collins St, Hobart CBD, Hobart

Check out more SQL Server courses in Australia

Logitrain Logo

Oracle Database Administration I

The Oracle Database Administration I certification training course focuses on Oracle Database Architecture, Managing Users, Roles and Privileges, Moving Data, Managing Tablespaces and Datafiles, Restricting and Sorting Data and more.

by Logitrain
NobleProg Australia Logo

A Practical Introduction To NoSQL Databases Training Course

NoSQL databases also scale better than relational databases, due to their ability to efficiently partition data across many servers (cluster) and load balance the access to this data. NoSQL databases integrate particularly well with applications that support real-time analytics, site personalizatio...

by NobleProg Australia [Claim Listing ]
General Assembly Melbourne Logo

Intro To SQL

In this free, two-hour livestream, you’ll get a foundational understanding of SQL. We’ll cover the basics of SQL structure, querying databases, filtering and aggregating data, and JOINing tables. All in real time, taught by an industry professional.

by General Assembly Melbourne [Claim Listing ]
NextTech Learning Logo

Updating Your Skills To SQL Server 2017

This two-day instructor-led course is aimed at database professionals looking to update their skills to cover SQL Server 2017.

by NextTech Learning [Claim Listing ]
Skill Finder Logo

Advanced Database Administration

Develop queries in SQL to create databases, tables and indexesDevelop queries in SQL that create views.Develop queries in SQL that create stored proceduresUnderstand concurrent database processing through the use of transactions and locking.Develop queries in SQL that create functions

by Skill Finder [Claim Listing ]

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