Program Outcome and Occupational Profiles


 Occupational Profile:

Database Administrators (DBAs) are responsible for the evaluation of database software purchases and supervise the modification of any existing database software to meet the needs of their employer. They are responsible for maintaining the integrity and performance of company databases and guarantee that data is stored securely and optimally. DBAs inform end users of changes in databases and train them to utilize systems. Through control access, DBAs ensure the security of company data. Their skills and technical expertise are desirable to many organizations, with the highest demand being in data-intensive organizations like insurance, finance, and content providers.


Database Developer: 

  • Understand the groundwork for building and working with relational databases including Oracle,
  • SQL Server, and MySQL.
  • Know how to optimize the accessibility and maintenance of data with the SQL programming
  • language.
  • Know the foundation for building, querying and manipulating databases.
  • Know how to write SELECT statements for data retrieval.
  • Know the foundation of database concepts, SQL, and PL/SQL
  • Know how to maintain your organization¿s data and ensure the availability of your data by deploying
  • backup, recovery and flashback operations
  • Know how to tune a server using both manual and automated techniques, as well as providing
  • disaster recovery for Oracle 12c databases
  • Know how to write PL/SQL programs, build stored procedures, and increase the efficiency of data
  • movement.
  • Know how to solve business problems efficiently with SQL codes
  • Know how to perform complex operations with very little code and formulate complex queries.
  • Know how to administer and manage the Microsoft SQL server system



Core Learning objectives and competencies of the successful student.

  • Extract core business data requirements from source documents
  • Design both conceptual and logical data models using requirements
  •  Develop, test and deploy intermediate and advanced data processing solutions using existing SQL
  • Server knowledge
  • Build robust and scalable Oracle Database 12c applications
  • Write efficient data manipulation statements using SQL Developer
  • Create databases, external tables, sequences, and synonyms
  • Write SQL SELECT statements based on ANSI/ISO standards to retrieve data from relational databases
  • Design, build and test SQL Server index management procedures, follow procedures for server
  • installation and configuration
  • Design, build and test best practices procedures for database backup and recovery
  • Develop efficient PL/SQL programs to access Oracle databases
  • Create stored procedures and functions for reuse and maintenance
  • Maximize the potential of SQL to formulate complex queries
  • Thoroughly test SQL queries and avoid common errors
  • Deploy backup and recovery strategies to protect Oracle 12c data
  • Recognize and accurately model complex data relationships
  • Design, develop and implement advanced SQL programming techniques including XML and the
  • Common Language Runtime
  • Ensure data integrity, establish security, and enhance performance
  • Improve cursor processing with FOR LOOPs and parameters
  • Identify the fundamental database building blocks
  • Implement automated backup and recovery techniques with Recovery Manager (RMAN) and Oracle
  • Enterprise Manager (OEM)​


Required For Enrollment: All applicants must have a high school diploma or equivalent prior to enrollment.

For any questions about eligibility, please call 1- 905-499-3631 Ext-103 or 102 to speak with a knowledgeable Admissions Advisor or send an email.

Paying For College Tuition: L.A.P.E.C. team can Help Turn Your Career Goals to Reality


The friendly and experienced Financial Aid experts at L.A.P.E.C. will work with you to explore your personal options and help you find a finance program

that's right for you.


L.A.P.E.C.  is Registered as a private career college under the Private Career Colleges Act, 2005
This program has been “Approved as a vocational program under the Private Career Colleges Act, 2005”


Program Name/Title: (Diploma)

Database Development & Administration Diploma




-Delivery Format and Language:

-Internship-Placement: Not Req.
-Regulatory Licensing:

-In Class or

-No Licensing or regulatory approval/accreditation required

Language;

English


-Live interactive LMS

Regular In Class Schedule:

-Morning:

9.00 AM EST or

-Evening:

4.00 PM EST

Program Duration and Fees
Program Options Full Time

Campus: Vaughan Ontario


  • Weeks 45  (Week Days, Morning or Evening)
  • No Class on Friday.
  • Online access to all resources 


Hours 900

Tuition**

CAD 12600.00

In-class 

Easy fee payment options

Status-Semester-Program Start Schedule


Click here to apply online 

Foreign Nationals AdmissionYes 
No Admission/Reg. Appl. Fee
Free Registration

National Occupation

Classification Code:  

2172   Database Managers


Career Development SupportAdmission policy
Average Salary/Wage Range in Canada 

CAD 20 - CAD 38 plus benefits  Per Hour (Entry Level Positions) 


 

LAPEC

Refund Policy

Minimum

Education Required

For Enrollment 

High school diploma or equivalent 

Call  1- 905-499-3631 
EXT 103,102 

LAPEC

Support policy

Past Learning Credit / Transfer

N/A



Program Assessment:


-End of each module/subject online multiple choice exam and assignments


Pass Marks

60%

Attendance:

-In-Class 75%


Course Material and Books

Free online access to course notes-material where available

Books not included in Tuition


-LAPEC LMS - Definition


-What is LAPEC's Live Interactive

Learning (Online Education)


**

Textbooks not included


Database Development & Administration Diploma

​It's Never Too  Late to Learn

L.A.P.E.  College

Higher Standard In Professional Education

List of Subject Taught in the Program

  1. Introduction to Oracle Database
  2. The business of Database Administration
  3. Database Fundamentals, design, tools and techniques
  4. Writing Oracle SQL Concepts and Queries
  5. Backup, Recovery, and Server Tuning for Oracle Databases
  6. SQL Queries for Oracle Databases Development
  7. Microsoft SQL Administration Server
  8. SQL Language and Programming
  9. Oracle PL/SQL Programming
  10. Lab Work
  11. Privacy Law and Conflict Assessment
  12. Career Development


 

Career and jobs , Citizenship and Immigration Officer in Canada

​immigration enforcement officer , 

website security