This module covers how to design, build and program databases according to user information needs using Logical Data Models and SQL. Learners will incorporate these databases into software solutions. Learners have the opportunity to prepare for the Oracle Database SQL Expert exam.
|Study Type:||Part Time|
Course is 2.5 hours per week for 15 weeks from October to February.
IT Academies Short Courses: Dates - CLICK HERE
Students analyse case studies to identify patterns and connections between information not obviously related and develop solutions to make a business effective. The programme teaches inductive reasoning to solve problems and think conceptually, systematically, and critically. Students become proficient business analysts, technical experts in structured query language (SQL), and develop essential "professional skills" including teamwork, project management etc.
• Transform business requirements into an operational database.
• Create physical relational database tables to implement a database design.
• Manage a business project that delivers a database design and model for a potential client.
• Create, maintain, and manipulate database objects.
• Prepare for Introduction to Oracle 11g - SQL Certification exam.
By studying at NESCOT you can:
• Learn at your own pace
• Fit study around family life and work
• Develop practical skills
Oracle Database SQL Certified Experts demonstrate the complete set of skills required for working with the powerful SQL programming language and have mastered the key concepts of a relational database. SQL Experts understand how to use the advanced features of SQL in order to query and manipulate data within the database, control privileges at the object and system level, and use advanced querying and reporting techniques. They are able to manipulate large data sets and understand storing and retrieving dates according to different time zones.
An Interview is required to join this course. The Oracle Database SQL Certified Experts certifications provide the foundation for Oracle Database 10g Administrator Certified Associate Certification. These certifications are designed to validate your skills on the features and functionality of key Oracle technologies. Course schedules, content, supporting materials, availability and centre opening times may be subject to change.
This Nescot College website describes the facilities and courses which the College intends to offer during the academic year commencing Autumn 2017. The web pages are prepared in advance of the academic year to which they relate and every effort has been made to ensure that the information contained in these pages is helpful, fair and accurate at the time of printing. However, this information is subject to change over time.
Nescot will take reasonable steps to provide the courses and services as described, however, the College cannot guarantee the provision of any course or facility. Some circumstances, such as staff changes, resource limitations and other factors over which the College has no control, such as industrial action or a change in the law or the level of demand for a particular programme or module (please note that this list is non-exhaustive), may result in the College having to withdraw or change aspects of the programmes, modules and/or student services detailed on the website. This could include, but not necessarily be limited to, programme/module content, staffing, the location where the programme/module is taught or the manner of teaching delivery, and the facilities provided to deliver or support the programme. Where circumstances demand an unavoidable change or where it is necessary for the College to discontinue a programme of study, Nescot will take all reasonable steps to minimise the effect and all proposed changes will be notified to potential applicants who have registered an interest in the relevant programme at the earliest possible opportunity as well as being reflected on the College’s website. In addition, any changes between the website and the proposed course and services will be notified to applicants at the time of making an offer.
All prices quoted may be subject to change and you will be notified of any such change when any offer of a place is made to you by Nescot.
Should you become a student of the College, this notice shall be a term of any contract between you and Nescot. Any offer of a place at the College shall be subject to the student enrolment conditions and the College’s rules and regulations as amended from time to time. A copy of the Nescot’s current terms and conditions can be obtained in writing from Nescot, Quality Office, Reigate Road, Ewell, Epsom, Surrey, KT17 3DS.
Last updated: 27/02/18