Database Systems Oracle 11g

Relational Database Systems (Oracle)

SQL, PL/SQL and Real - Life Project with APEX

Data is at the center of today's applications; today's organizations simply cannot operate without data. In many ways, business today is data. Without data, businesses would not have the ability to manage finances, conduct transactions, or contact their customers. Databases are created to store and organize this data. The better the design and utility of the database, the better the organization will be positioned to compete for business.

 

 

each and every business or organization

Don't worry!

This complete beginner to advanced Database System Oracle 11g course track will teach you everything you need to know specially SQL and PL/SQL in order to become Developer or Administrator.

This course is designed to be practical and project-based. It is therefore ideal for Computer Science students who understand the concepts and fundamentals of computer programming and some database concepts but want to gain practical and real experience and learn the industry standards and approaches to become database developer or administrator.

However, we don’t leave the theoretical concepts either and provide students with a solid understanding of the fundamentals, which makes it ideal also for professionals who want to refresh their memory, or we will shortly indicate that every programmer should have knowledge of databases who want to make career in the software development industry.

This is an introductory class and does not require any prior knowledge or experience.

  • Ability to read in English
  • Ability to dedicate 1.5 to 2 hourse daily
  • Familiarity in using computer
  • The 3 P's: Passion, Patience, and Perseverance. Please note it is not a crash course!!

At Milestone Institute we believe that the best way to learn programming is by doing. Therefore, there will be practical coding sessions in almost every class, coding assignments, projects, code reading assignments, debugging and challenge assignments and research and reading assignments. In addition to covering the content of the subject course students will learn about industry approaches and use state of the art tools and technologies.

The duration of this course is two and half months. There are three sessions weekly. Each session is 1.5 hour long.

Students: $80

Non-students: $100

Note: the above fee is for the whole duration of the course and not monthly.

By the end of this course students should learn:

  • DBMS Concepts

  • RDBMS Fundamentals

  • SQL (Structured Query Languague)

  • Objects of Database (Table,View,Index,Functions,Triggers,Packages...)

  • PL/SQL Fundamentals

  • Procedures and Programming Language used in PL/SQL

  • Set yourself up to become an Oracle Certified Associate.

  • Master Databases concepts by using a real-world application as a case study.

  • Create or maintain Databases for small and medium organizations.

The Learning Management System (LMS):

Milestone Institute is equipped with a comprehensive learning management system, which is designed to make learning easy and efficient for students. Through the LMS students can track class progress, see important announcements and events from class instructors and the administration, access and download course related material, submit assignments, check their scores on assignments and exams, interact with class instructors and other students through the discussion forum and more.

Access to Instructors:

At Milestone Institute access to the instructors is not limited to the class only:

  • All instructors have daily office hours during which students can talk to the instructors on a one-to-one basis and solve their problems.
  • All instructors will actively respond to questions posed from students in the discussion forum of the LMS.
  • All instructors will be available to students beyond office hours through appointment.

Free WiFi:

Students can use free WiFi on their laptops or mobile devices within the vicinity of the Institute. (See terms of use)

Library:

The Milestone Institute library is small at the moment but will be rich soon.

Free refreshments:

Free tea, coffee and snacks are available to students.