Certificate in SQL Server Administration and Support

From the YOOBEE SCHOOL OF TECHNOLOGY

  • CAMPUSES:

    START DATES:

  • Auckland Queen Street

    Feb 22 - Jun 25, 2021

  • Yoobee Online

    Aug 31, 2020 - Mar 21, 2021

    • Credits:

      60

    • Method:

      Full-time / Part-time Evening

    16

    weeks

    5

    NZQA

Gain your SQL qualification with Yoobee.

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

*Yoobee online intake date is part-time/evening only.

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,329.28 + $170 Student Services Levy

(Eligible for 'fees-free' study)

International students

$6,500 + $850 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.

International students need to be at least 18 years old.

Once you have successfully completed this course, develop your skills further with the Diploma in Web and Application Development.

With additional practical experience, graduates can sit the following exams: Microsoft Certified Professional (MCP) in 20761-SQL 2016 Querying databases, Microsoft Certified Professional (MCP) 20762-SQL 2016 Database Development, Microsoft Certified Professional (MCP) 20764-SQL 2016 Administer databases.

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

  • 16

    weeks

  • 5

    Nzqa

Gain the skills to become an entry-level IT helpdesk support technician with this short programme. You’ll learn how to configure operating systems, understand...

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.

Following the Government announcement, Auckland is moving to Alert Level 3 in response to COVID-19 and the rest of the New Zealand is moving to Alert Level 2. Our Auckland campuses will be shut to students from midday Wednesday, 12 August 2020 for three days and we will be taking steps to move to delivery of streamed online classes in the Auckland region. Other campuses around New Zealand remain open to students. Please talk to your campus manager if you have questions.