Certificate in SQL Server Administration and Support

From the YOOBEE SCHOOL OF TECHNOLOGY

  • CAMPUSES:

    START DATES:

  • Auckland Queen Street

    Feb 24 - Jun 26, 2020

    • Credits:

      60

    • Method:

      Full-time

    16

    weeks

    5

    NZQA

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).

What you'll learn

Scripting for Systems Administrators

Learn to make simple web pages using CSS, HTML and JavaScript.

Administering Database Servers

In the administration of databases, learn how to work with security and permissions granted to database roles and users.

Developing Databases

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.

What you should know

Software

Microsoft SQL Server Management Studio

Fees

Domestic students

$3,264 + $170 Student Services Levy

(Eligible for 'fees-free' study)

International students

$6,500 + $750 course fee

Entry Requirements

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.

  • 32

    weeks

  • 5

    Nzqa

Learn to design, develop and test responsive websites and apps using common programming languages (SQL, HTML5, CSS3, JavaScript, C++), and develop custom...

Starting at NZ$95 per hour (Source: Absolute IT)

  • 32

    weeks

  • 6

    Nzqa

In this hands-on, practical course, gain a grounding in network architecture, move on to routing and switching essentials and learn how to scale networks for...

  • 32

    weeks

  • 5

    Nzqa

Learn to design, develop and test responsive websites and apps using common programming languages (SQL, HTML5, CSS3, JavaScript, C++), and develop custom...

  • 16

    weeks

  • 5

    Nzqa

In this 16-week all-rounder course, you will learn technical skills in networking and configuring operating systems, understand hardware and basic scripting,...

Qualifications are issued by Yoobee Colleges. Yoobee Colleges is a Category 1 Provider, the highest rating a school can be awarded by the Government.


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.

Interested in kicking off your career?

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.