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

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 ]
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 ]
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 ]
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 ]
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 ]

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