Preferred: Some knowledge or prior experience with programming or web development.
No class Oct 31, Nov 21
Prepare for Certification as Oracle Certified Administrator (OCA).
1. Oracle Database 11g: Introduction to SQL
2. Oracle Database 11g: Administration
Who Should Attend
• Business and Data Analyst/IS Management
• Network/Systems Engineers and Integrators
• Support and Implementation Specialist
Oracle Database 11g: Introduction to SQL
No prior knowledge of SQL or database is required.
Introduction to the Oracle 11g relational database and SQL programming language. This course provides beginners with essential SQL database querying and report building skills. Students will learn to install the Oracle software (client and server), learn basic entity relationship diagrams (ERD) and data modeling techniques. Students will create database objects such as views, tables and indexes. This course will also introduce standard database permissions and security practices. Course is designed for business analysts, information managers or anyone looking to become better acquainted with an industry standard relational database used in a variety of analytical applications. Successful completion of this course will allow the student to take the Oracle 11g SQL
Fundamentals exam (1Z0-051) which is the first exam towards Oracle OCA certification. Textbook will be distributed in class.
|12||M, W||6:00-9:00pm||Richard Vanderbilt|
No class Nov 21
Basic knowledge of AC/DC circuits, digital electronics and industrial controls is required.
Comfort utilizing Microsoft Windows operating system recommended.
Who Should Attend?
• Industrial maintenance mechanics
• Automation technicians
• Energy management system operators in training
To be competitive in the global economy, manufacturing, and service companies are examining ways to improve existing processes to become more efficient and reduce costs. PLC controlled equipment enables an organization to precisely fine-tune their operations by fully automating manufacturing processes that are currently performed manually. PLC controllers are used in energy management and monitoring systems (SCADA) to reduce electrical consumption and to network stand-alone industrial controls. Students will be introduced to basic system concepts of operation, industry terminology, dominant manufacturer brands and general product practical applications and uses. Students in this innovative training program will have the opportunity to use
PLC workstations that will simulate real world tasks. Book and materials are included.
1 hour lunch