Auckland Queen Street
Jul 22 - Nov 22, 2019
Auckland Queen Street
Feb 24 - Jun 26, 2020
Business today is digital, digital means data, data means databases, and to access those databases you need Microsoft SQL Server.
Knowing SQL (Structured Query Language) is an incredibly valuable skill that’s virtually guaranteed to get you hired. This specialist course teaches you how to use SQL for relational database systems.
SQL is not a programming language, it's a query language. Anyone who can use English at a basic level can learn to write SQL. It is the standard query language for relational database management systems, and SQL statements are used to perform tasks such as updating and retrieving data.
In this hands-on programme, you’ll not only learn to communicate with databases but also with each other as you collaborate on team projects that help you become familiar with SQL Server.
You’ll also learn backup/restore strategies and security control. From practical exercises, you’ll get familiar with developing database solutions with SQL.
On successful completion of the course, you will be awarded a New Zealand Certificate in Information Technology (Level 5).
Scripting for Systems Administrators
Administering Database Servers
In the administration of databases, learn how to work with security and permissions granted to database roles and users.
Learn how to develop a database structure to store meaningful information.
Structured Query Language
Learn how to query the data already stored in a database.
Microsoft SQL Server Management Studio
$3,264 + $170 Student Services Levy
(Eligible for 'fees-free' study)
$6,500 + $750 course fee
Applicants need 48 NCEA Level 2 credits in four subjects, or show completion of an appropriate qualification at an NCEA Level 3 equivalent, or suitable industry/computing experience. If the above requirements cannot be met, an interview may be required.
Once you have successfully completed this course, develop your skills further with the Diploma in Web and Application Development.
In this 16-week all-rounder course, you will learn technical skills in networking and configuring operating systems, understand hardware and basic scripting,...
Term dates are subject to change, pending enrolment numbers, availability and any unforeseen funding fluctuations. Yoobee Colleges reserves the right to modify schedules to make sure the College runs well and student are offered the best learning experience.
Our brochure explores everything you need to know including an outline of study options, key information about enrolment, and all our campuses spread around New Zealand.