Computer Science AA Degree Certificate

Revised 7.21.09 ADDITIONAL INFORMATION ON REVERSE. SUBJECT TO CHANGE WITHOUT NOTICE. A Course of Study for a Major in Computer Science A.A. Degree, Certificate of Achievement Programs & Department Certificate Programs The field of computer science leads to a variety of careers that all require core computer science skills. These skills include theory classes such as Computer Hardware, Data Structures, Databases, and Networks, as well as programming in different computer languages. Thereafter, within the field, areas of specialty lead into

careers including software development, project management, system analysis, and maintenance among other areas. With the Internet being an integral part of everyday life, Web page authoring and Web application development have been other areas of high demand in the job market. This major may also lead to many other careers. For additional possibilities, visit the Career Services Center on campus to utilize computerized career information systems and other valuable career resources. ASSOCIATE IN ARTS DEGREE - 60 UNITS Students must complete major requirements in effect at the time enrollment begins or major requirements in effect at graduation as long as continuous enrollment is maintained. See Santa Monica College catalog for definition of continuous enrollment. At least 50% of the major units must be completed at Santa Monica College. All coursework for the major must be completed with a grade of C (2.0) or higher. Please note: Certificates of Achievement may be expanded into Associate in Arts degrees by completing a total of 60 semester units that include the general education requirements and recommended courses from the certificate areas. Additional general education requirements for Associate in Arts degree can be found online at www.smc.edu/articulation or listed on a separate sheet available...

Website: www.smc.edu | Filesize: 67kb
No of Page(s): 6
Download computer_science_aa - Computer Science AA Degree, Certificate of ....pdf

Eitesal - Oracle Initiative

Eitesal - Oracle Initiative Dear Eitesal members Eitesal, following its role of serving the members’ needs for developing their current staff and to build capacity with new high caliber resources in order to help in increasing the export opportunities and to open new lines of business to be able to face the global financial crisis, Eitesal is launching the first Initiative in 2009 in co- operation with Oracle and supported and funded by ITIDA to invest in training of 360

candidates in different ERP Applications and Technology tracks The Participation in this initiative should go under the following terms: • Beneficiary companies should be Eitesal Members • Training will be covered by Oracle through its certified partners who are members in Eitesal as well • The Beneficiary Companies will be responsible for the attendance of their employees • 30% of the attendees should be new graduates and the beneficiary company is committed to hire them after being trained. ex: if the company wants to nominate 10 attendees, then 7 of them can be from its current staff and the rest 3 should be new graduates hired by the company. • ITIDA will fund 95% of the training cost for individuals and 90% for companies. The Beneficiary Company/Individual will cover the balance in cash. • The training will be held in Cairo, Alexandria, Mansoura and Upper Egypt Dear Member kindly find attached • Training tracks and courses • Company registration form • Pledge for commitment • Training schedule plan Your kind prompt response (within 5 working days) will be highly appreciated and please note that the number of trainees is limited, So, hurry up FIRST COME FIRST SERVE Financial Applications Duration...

Website: www.eitesal.org | Filesize: 311kb
No of Page(s): 9
Download Eitesal - Oracle Initiative.pdf

Oracle Database 11g: Advanced PL/SQL Programming & Tuning

CompuWorks Class Information Oracle Database 11g: Advanced PL/SQL Programming & Tuning Description: The objective of this course is to allow experienced PL/SQL developers to write efficient programs. Advanced techniques which not only improve execution speed but also enhance the functionality of the programs are also discussed. Days: 5 Prerequisites: Oracle Database 11g: Introduction to SQL and Oracle Database 11g: Program With PL/SQL Audience: The target audience for this course is senior application developers. Developers who will be building, debugging and

tuning PL/SQL program units will benefit from this course. USING SQL DEVELOPER · PREPARING THE EXECUTION ENVIRONMENT · INSTALLING SQL DEVELOPER · BASIC CONNECTION TYPE · TNS CONNECTION TYPE · ADVANCED CONNECTION TYPE · MANAGING CONNECTIONS · EXECUTING EXTERNAL SCRIPTS · USING BIND VARIABLES FROM SQL DEVELOPER USING THE DATABASE RESULT CACHE · CONFIGURING THE RESULT CACHE · USING THE RESULT CACHE 1 / 5 CompuWorks Class Information · MANAGING & MONITORING THE RESULT CACHE ORACLE BASICFILES & SECUREFILES · LOB CONCEPTS & TERMINOLOGY · BASICFILES LOB · TABLE DDL WITH LOBS · CONTROLLING LOB PHYSICAL STORAGE · INITIALIZE INTERNAL LOBS · INITIALIZE EXTERNAL LOBS · LOB COLUMNS & SQL · SECUREFILES LOBS · MIGRATING BASICFILES TO SECUREFILES · MONITORING SECUREFILES PERFORMANCE DATABASE-RESIDENT PROGRAM UNIT ENHANCEMENTS · MIXED NOTATION PROCEDURE REFERENCES · CREATING DISABLED TRIGGERS · CONTROLLING THE ORDER OF TRIGGER EXECUTION · DEVELOPING COMPOUND TRIGGERS · EXPLOITING & MANAGING CURSOR SHARING · ABOUT CURSOR SHARING · BIND VARIABLES & CURSOR PEEKING · USING THE CURSOR_SHARING PARAMETER · DYNAMIC SQL · NATIVE DYNAMIC SQL USING COLLECTIONS · ABOUT COLLECTIONS · BULK BIND USING COLLECTIONS · COLLECTION METHODS RETRIEVING DDL WITH DBMS_METADATA() 2 / 5 CompuWorks Class Information · WHY RETRIEVE...

Website: www.compuworks.com | Filesize: 587kb
No of Page(s): 5
Download Oracle Database 11g: Advanced PL/SQL Programming & Tuning.pdf

SQL Programming

CS145 Lecture Notes #10 SQL Programming Example schema: CREATE TABLE Student (SID INTEGER PRIMARY KEY, name CHAR(30), age INTEGER, GPA FLOAT); CREATE TABLE Take (SID INTEGER, CID CHAR(10), PRIMARY KEY(SID, CID)); CREATE TABLE Course (CID CHAR(10) PRIMARY KEY, title VARCHAR(100) UNIQUE); Motivation Pros and cons of SQL: Very high-level, possible to optimize Not tuned to support general-purpose computation Oracle as a calculator? SELECT 142857*3 FROM DUAL; Strictly less expressive than general-purpose languages SQL2 has no recursion and cannot even compute

factorial! Solutions: Augment SQL: Oracle’s PL/SQL Use SQL together with a general-purpose programming language: embedded SQL, dynamic SQL Oracle PL/SQL Basics Rough form of a PL/SQL program: DECLARE BEGIN END; . RUN; DECLARE section is optional . and RUN end the program and execute it Jun Yang 1 CS145 Spring 1999 Example: go through students 142–857 and set all GPA’s under 4.0 to 4.0 DECLARE thisSID Student.SID%TYPE; thisGPA Student.GPA%TYPE; BEGIN thisSID := 142; LOOP EXIT WHEN (thisSID > 857); SELECT GPA INTO thisGPA FROM Student WHERE SID = thisSID; IF (thisGPA < 4.0) THEN UPDATE Student SET GPA = 4.0 WHERE SID = thisSID; END IF; thisSID := thisSID + 1; END LOOP; END; . RUN; Basic features: Local variable: Use %TYPE to match its type to a column in the schema Use := for assignment; = for comparison Branch: IF (...) THEN ... ELSE ... END IF; Loop: LOOP ... EXIT WHEN (...); ... END LOOP; The usual data modification statements: INSERT, DELETE, UPDATE Single-row SELECT: SELECT ... INTO ... FROM ...; Oracle raises an exception if SELECT returns no rows or more than one row Cursors Inside a PL/SQL program, the result of a SELECT must go somewhere:...

Website: infolab.stanford.edu | Filesize: 96kb
No of Page(s): 5
Download SQL Programming.pdf

The Flexible Alternative for Oracle Bar Code

Introduction The information accuracy and labor efficiency that bar codes and radio frequency identification (RFID) ta gs provide are essential for activities managed with Oracle® Warehouse Management (WMS) and Mobile Supply Chain Applications (MSCA). However, printing bar code and RFID labels with data from Oracle WMS and MSCA has traditionally been challenging because thermal label printers have proprietary printer control languages (PCLs). Label printer incompatibility and limited bar code and RFID support features within the software have forced users to

add new servers or PCs to their print systems, or to implement custom programming to enable bar code and RFID output from Oracle applications. Now there is an Oracle-certified software alternative to traditional Oracle WMS and MSCA label printing methods that provides superior flexibility and lower total cost of ownership. Oracle WMS and MSCA users previously had three options for enabling bar code and RFID smart label output from the applications: • Custom software development; • Installation of a print server and associated middleware and design software to support label printers, or; • Implementation of PC-based labeling software, which require operator intervention and adds a hardware layer to the print system architecture. Oracle recently certified two new methods for bar code and RFID output from WMS and MSCA: • XML-enabled label printers preconfigured for Oracle connectivity; • BARCODE 2000 XML labeling software from Unibar, Inc., which resides on the Oracle host and provides enterprise-wide bar code and smart label printing, without print servers or printer- dedicated PCs. (See Fig. 1). Figure 1: Unibar BARCODE 2000 XML processes Oracle’s XML print commands. No other software or processor is required between the Oracle application and the printer. Each method has advantages, limitations...

Website: www.unibar.com | Filesize: 1184kb
No of Page(s): 7
Download The Flexible Alternative for Oracle Bar Code and.pdf

CIS 183 (Oracle SQL Programming) Syllabus

Orange Coast College Business, Computing, & Career Education Division CS/CIS Department CIS A183 (Oracle SQL Programming) Spring 2010 Syllabus Instructor: Martha Malaty CIS A183 Syllabus Page 1 Subject to changes!!! Instructor: Dr. Martha Malaty Office: Computing Center, Room D Office Hours: Check my main homepage Email: (Better use Yahoo Email!) m_malaty@yahoo.com mmalaty@occ.cccd.edu My Main Homepage: http://faculty.orangecoastcollege.edu/mmalaty/index.html Phone: (on-Campus) Ext: 21127 (off-Campus) (714) 432-5616 Units: 4 CRN:31982 Format: On-Campus Class Time: Mondays 6-10:15 pm Location: Computing Center, Room 109 Interesting links

Page Oracle10g Express Installation Video Oracle10g Enterprise Ed. Installation Video General Information CIS A183 is the second course in the series of courses for Oracle Developer Certificates. The first course (CIS 182) covered an introduction to database concepts, main definitions of the relational model and how to represent the model using Entity-Relationship Diagram (ERD). To manipulate the tables in a database system, we use a special language called SQL (Structured Query Language). Details of SQL will be covered in this course. Following this course you can take CIS 184 (PL/SQL Programming, where you will learn PL/SQL (Procedural Language SQL), which is a procedural programming language used as an alternative to issuing multiple SQL statements, that extends the capabilities of SQL. Text  "Joan Casteel, Oracle 11G: SQL, 2nd Edition ", © Course Technology- Cengage Learning, 2010, ISBN: 1439041288 or ISBN13: 9781439041284.  There is also an electronic version of the text book for some discount. Check this link and enter the ISBN of the book: http://www.ichapters.com  The bookstore is renting some of the textbooks (for 45% of new retail price) for the duration of the semester Recommended Preparation CS A111 & CIS A182 OCC Catalog Description An introduction to...

Website: faculty.orangecoastcollege.edu | Filesize: 161kb
No of Page(s): 4
Download CIS 183 (Oracle SQL Programming) Syllabus.pdf

Advanced Oracle Programming for University System Developer

877-489-7745 Advanced Oracle Programming for University System Developers (BAN200) Course Description This 5-day course provides an in-depth look at complex SQL statements and reporting techniques. The course covers a comprehensive set of programming techniques using the PL/SQL language. The course provides both lecture and hands-on lab time with the student spending approximately 50% of the class time practicing the techniques discussed in the lecture. Audience This course is intended for technically oriented end-users, application developers and programmers who will create

or maintain Oracle applications. The prerequisite for this course is SQL100 or a minimum of three months of SQL/SQL*Plus experience. Course Topics Advanced Subqueries Multiple Value Subqueries Nested Subqueries Correlated Subqueries EXISTS Operator ANY Operator ALL Operator Complex Table Joins Multiple Outer Joins Replacing NOT IN With Outer Join Self-Join Tree-Structured Query CONNECT BY Clause Using Multiple Cursors Nested Cursors Cursor Parameters Passing Parameters to Cursors Complex Cursors & Looping While Loop Count Loop While Loop with Cursor Where Current of Clause Cursor Count Loop Cursor For Loop Table & Record Data Types Advanced DML INSERT with Table Join INSERT with Correlated Subquery UPDATE with Table Join UPDATE with Correlated Subquery DELETE with Correlated Subquery Temporary Tables Dynamic SQL Generating SQL Spooling to a File Calling a Second File Using Substitution Variables Matrix Reports Matrix Reports Decode Function Creating a Matrix Report Adding Summary Columns Advanced Functions Creating Bar Charts Creating Graphs TRANSLATE Function Making RTRIM & LTRIM Powerful INSTR Function Introduction to PL/SQL What is PL/SQL? Block Structure Server Output Declaration Section Variable Assignment Select Into Conditional Control Using an Aggregate Cursors & Looping Forever Loop Cursors PL/SQL Record Data Type Defining a Record Data Type Initializing a Record...

Website: www.bosssoftware.com | Filesize: 91kb
No of Page(s): 3
Download Advanced Oracle Programming for University System Developer.pdf