Processing...

Home > Database Development And Administration With Oracle, Microsoft Sql Server And Azure Certification

Database Development and Administration with Oracle, Microsoft SQL Server and Azure Certification

SAQA ID: 48872, 131 Credits

As Big Data | Data Science are emerging – Database professionals will have great demand provided they are able to cope with developing, querying, and managing data and database systems. 

The programme provides a grounding in the roles of both Database Developer (Part 1), responsible for working on database technologies, as well as the role of Database Administrator (Part 2), focused on routine maintenance and support. Emphasis is placed on incorporating the industry leading database and cloud platforms, Oracle, Microsoft SQL Server and Microsoft Azure.  

 
     
 

Features and Benefits

  • This certification path has been designed to provide the student with multiple certifications, both locally and internationally recognized by industry for maximum employability. 
  • Get internationally certified to increase job readiness on Oracle Database Foundations (exam 1Z0-006), Database Design & Programming with SQL (exam 1Z0-071), Microsoft Database Fundamentals (exam 98-364), Microsoft Azure Fundamentals (exam AZ-900), and Administering Relational Databases on Microsoft Azure (exam DP-300). On successful completion of your international exams, you will be certified as an Oracle Certified Associate (OCA), a Microsoft Technology Associate (MTA) and Microsoft Certified Associate (MCA).
         
  • Through our myWay Hybrid Full Time Learning method, classes can be attended on campus, virtually or both. This method gives each student the ultimate flexibility to combine on campus and virtual lecturers based on their individual preferences.  
  • Through our myWay Online, Virtual Only students, we ensure that you are supported by technology and people throughout your academic journey. We focus on a blended learning approach, combining online Virtual Classrooms, at home exercises, activities and project-based assignments bundled with fully developed video lectures, all managed by our student learning platform.
  • Get a free Office 365 Education A1 license, valid for the duration of your studies.  
     
       
  • Job placement assistance through our industry network and online recruitment portal, exclusively available to AIE graduates. Visit www.recruitgraduates.co.za for more.  

Admission Requirements

Hardware Requirements

Please note that you are required to have your own computer for this qualification. AIE, in partnership with Dell and TripleH committed to supplying every student with a Dell laptop to support our DigitalCampus initiative. Available exclusively to AIE students, devices can now be financed with your tuition fees. We provide three models:

 

 

  • MEDIUMMedium Spec, Dell Latitude 3510, i7, 8GB
  • HIGHHigh Spec, Dell Latitude 3510, i7, 16GB

R18 000.00Learn More

The foundation for intense graphic and processor heavy tasks.

10th Generation Intel Core i7-10510U (4 Core, 8M cache, base 1.8GHz, to 4.9GHz), 15.6-inch FHD (1920 x 1080) Anti-Glare LED-Backlit Non-touch, Camera & Microphone, Power Button with Touch Fingerprint Reader, 8GB,1x8GB, DDR4 Non-ECC, DDR4, M.2 256GB PCIe NVMe Class 35 Solid State Drive, 1Nvidia GeForce MX230 w/2GB GDDR5 Graphics Memory, 4 Cell 53Whr Express Charge Capable Battery, Windows 10 Pro (64 Bit), 1Y Collect and Return Service

R19 500.00 Learn More

Same foundation, more memory...for those who want to get a little more serious.

10th Generation Intel Core i7-10510U (4 Core, 5.6" FHD WVA (1920 x 1080) Anti-Glare Non-Touch, Camera & Microphone, Power Button with Touch Fingerprint Reader, 16GB,2x8GB, DDR4 Non-ECC, 15.6" LCD Display Back Cover, WLAN, M.2 256GB PCIe NVMe Class 35 Solid State Drive, Nvidia GeForce MX230 w/2GB GDDR5 Graphics Memory, Windows 10 Pro (64 Bit), 1Y Collect and Return Service

Salaries & Skills

 

* All statistics are derived from www.payscale.com

  • Pricing & Payment Options

    NEW SECTION
  • Duration

    Full Time

    • Full Time, Contact (Hybrid) Learning, 10 Months
    • Full Time, Online Learning, 10 Months
    • Classes conducted from Monday to Friday 2-3 times per week

    Part-Time

    • Part Time, Flexi Online Learning, 10 Months
    • Classes conducted after hours over 2-3 sessions/week (on selected Saturdays)

    * Class structures are subject to change without notification. 

    Learn More

  • Career Options

    • Database Developer
    • Database Application Developer 
    • Database Administrator
  • Study Kit

    Your study kit is included in your fees and will contain:

     

    • Free WIFI (Unlimited, On-Campus only).
    • USB 64GB
    • Stationery kit that includes:  
      • AIE Pen
      • AIE Ruler
      • AIE Pencil Case (15cm)
      • AIE Notepad
      • 13 Piece Toolkit
    • Textbook: OCA Oracle Database SQL Exam Guide (Exam 1Z0-071)
    • Orientation kit including: Student Card, Welcome Letter and Getting Started Guide.
    • Access to our myAIE student portal and student support team via phone, email and tickets. 
  • Enrol Now

What you get

  • Oracle Database Foundations (Oracle Certified Junior Associate)
  • Database Design & Programming with SQL (Oracle Certified Associate)
  • Database Fundamentals (Microsoft Technology Associate) 
  • Microsoft Azure Fundamentals (Microsoft Certified: Fundamentals) 
  • Administering Relational Databases on Microsoft Azure (Microsoft Certified: Associate). 

Our Learning Methods

Our learning methods is a technology mediated delivery model, focused on flexibility, accessibility, and academic support to provide the ultimate learning experience without compromising teaching time and quality.

#Flexibility

#AnywhereAnytime

#Accessibility

#StudentSupport

Full Time, Contact
(Hybrid) Learning

A modern twist on traditional face-to-face, full-time learning. Our contact classes are delivered via Hybrid learning, providing students with the flexibility to attend on campus, virtually, or both.

Full Time, Online
Learning

Extending our reach with online only, full time learning. Our progressive technology platform and people-supported academic journey giving students access to our classes from anywhere in the world.

Part Time, Flexi Online
Learning

Designed for the working professional, our part time programmes provide you with the flexibility to manger your own schedule and pace of learning. Sessions are conducted after hours on selected weekdays, and on alternate Saturdays.

Career Video

Watch this video to understand a day in the life of a Database Developer. 

Term 1

Digital Literacy 

  • Demonstrate knowledge, understand key terms and apply the principles of MS Word 
  • Demonstrate knowledge, understand key terms and apply the principles of MS Excel 
  • Demonstrate knowledge, understand key terms and apply the principles of MS Powerpoint 
 

Oracle Database Foundations

  • Demonstrating your understanding of the different types of database models and components 
  • Knowledgeable of database components, concepts and design, implementation of business roles, SQL language and queries, and ERD modeling and languages to manage data and transactions. 

Database Design and Programming with SQL

 


Term 2 

Database Programming with SQ (Continue) 
Database Fundamentals 
  • Describe the core concepts of relational databases. 
  • Create and manipulate database objects and data using Microsoft SQL Server. 
  • Explain the use of basic database administration tools. 
 
Azure Fundamentals 
  • Describe cloud concepts 
  • Describe Core Azure Services 
  • Describe core solutions and management tools on Azure 
  • Describe general security and network security features 
  • Describe identity, governance, privacy, and compliance features 
  • Describe Azure cost management and Service Level Agreements 
 

 

Term 3 

Administering Databases on MS Azure 
  • Plan and implement data platform resources 
  • Implement a secure environment 
  • Monitor and optimize operational resources 
  • Optimize query performance 
  • Perform automation of tasks 
  • Plan and implement a High Availability and Disaster Recovery (HADR) environment 
  • Perform administration by using T-SQL 
 

 

Term 4 
 
Deploying Oracle Solutions on Azure 
  • Deploying Oracle Solutions on Microsoft Azure Case Study and Integrated Projec

  • Campus
    Registration Close Date
    Start Date
    Type
  • 07 February 2022
    14 February 2022
    Full Time, Contact
  • 07 February 2022
    14 February 2022
    Full Time, Contact
  • 07 February 2022
    14 February 2022
    Full Time, Online
  • 07 February 2022
    14 February 2022
    Part Time, Online

Delivery Method: 
Include a Laptop? Yes No   Read more