Si95015 Oracle´s Database MAnagement Systems Fundamentals

(3-0-8.Requisites: None)

Equivalencies: None

Relational database fundamentals and how are they handled in Oracle’s DBMS.  Oracle’s instance and database, concepts and internal architecture.  Data structures employed within Oracle.  Oracle’s SQL, particular features and use.  Database administrator’s management tasks.  Looking after performance and good use of database resources.  Security aspects.  Oracle´s handling of concurrency.

CAMPUS: CDJ
ACADEMIC PERIOD: SPRING & FALL
LANGUAGE OF INSTRUCTION: SPANISH
MAJORS: ISI, ISC

COURSE TEXT

• Greenwald, R.y Stackowiak, R. Oracle Essentials: Oracle9i, Oracle8i & Oracle8, 2^nd edition.  O’Reilly, 2001, NY.

REFERENCE TEXT

• Loney, K. y Theriault, M.  Oracle8i: DBA Handbook. Oracle Press (Osborne/McGraw-Hill), 1999, NY.
• Kreines, D. Oracle SQL: The Essential Reference.  O’Reilly, 2001, NY.

TEACHER’S PROFILE

Professor with master’s and/or doctorate degree on Computer Science or Information Systems, with a bachelor’s degree on Systems Engineering or with a similar degree.

Si95016 . Creating Web Sites for e-commerce

Objectives:
· Discuss the varios types of applications that are being created today
· Explain what distributed applications are and explain the advantages of using them
· Explain the functionality of the distributed application
· Can be create components COM · Understand the purposes of electronic commerce
· Install a commerce server · Operate a commerce server site in a secure environment.
CAMPUS: LEON
ACAD. PERIOD: SPRING
LANGUAGE OF INSTRUCTION: SPANISH

Si95020. ERP Technology Adoption Seminar: Manufacturing Pro (MFG/PRO)

Academic department: Information Systems
Units:3-0-8
Requirement:Advanced knowledge about programming and databases
Semester and career:7th to 9th semesters for ISC and LSCA programs
Equivalence:none
General aim of the course:Getting to the student the knowledge about the most important and latest techniques in the ERP market for manufacturers

Campus:Cd. México
Bibliography: QAD’s ERP training materials, QAD White Papers
Instructor's profile: PhD and master degree on Information Systems or Computer Science program. Expert in: ERP technologies, manufacturing processes, manufacturing techniques, MFG/PRO Consultant

Language of Instruction:spanish

Si95070. Information Technology Regulations

Academic department:SI
Units:3-0-4
Requirement:NT
Semester and career:6 ISC, 4 ISE, LSC, IEC
Equivalence:D00859 LSCA

General aim of the course:The student will become familiar and understand the importance of the Information Technology Regulation. The student will analyze the legal and normative needs involved with the constant use of new technologies, since the point of view of computer security, e-commerce and cyber rights.
Campus:Edo. México

Bibliography:Azari, Rasool.
Current security management & ethical issues of information technology
Hershey, PA : IRM Press, 2003.

Lessig, Lawrence
Code and other laws of cyberspace
New York, N.Y.] : Basic Books, c1999

Stallings, William.
Network security essentials : applications and standards
Upper Saddle River, NJ: Pearson Education, 2003.
2nd ed.

Instructor's profile:Bachelor’s degree in law, with a profile oriented to the knowledge of Information Technology and Information Security Management.
Language of Instruction:Spanish

Si 95 092 Tecnology information and financial audit / accountant

(3-0- 8)
Requirement:Si00865
Semester and career:7, CPF, LAE, LIN, LAF
Equivalence:NT

Have an integral vision of the internal control from a company when integrating the aspects that have to do with the technology of information that supports the business processes typically evaluated in a financial audit / accountant To Identify situations in a financial audit / accountant where to use technical of audit supported by the computer or for technology they represent opportunities of more security and efficiency in the emission of the auditor's opinion

Bibliography:No specific book

Instructor's profile:Professor with a master degree in information systems.

Language of Instruction:Spanish

Campus:Monterrey

Si95093 Digital Design Applications

(3-0- 8)
Academic department:Academic Department of Engineering, Architecture and Systems
Requirement:None
Semester and career:Semesters 7, 8 or 9 of Business Administration Undergraduate Program
Equivalence:None
General aim of the course:To know, learn and use vanguard applications for digital audio, video and image design and edition, for its use on multimedia projects or websites.

Bibliography:
Corel Draw 10 Iniciación y Referencia. Juan Izquierdo Cortes. Mc Graw Hill Interamericana Editores S.A de C.V ISBN: 8448132602 / 2001
Manual de Photoshop 6. Adele Droblas Greenberg/Seth Greenberg. Mc Graw Hill Interamericana Editores S.A de C. V. ISBN: 8448131703 / 2002
Director Demystified. Jason Roberts/Phil Gross Macromedia Press. ISBN: 0-201-35445-4.
Macromedia Director 8 Visual QuickStart Guide. Andre Persidsky. Macromedia Press. ISBN: 0201702584 / 2000
Adobe Premiere 6.5 Classroom in a Book. D. Adobe. ISBN: 0321158857 / 2002
Macromedia Flash MX: Visual QuickStart, Katherine Ulrich/Russell Chun. Macromedia Press ISBN: 0201794810 /2002
Instructor's profile:Bachelor on Information Systems with Master´s Degree on Information Technologies Management or similar area, with practical experience and Knowledge on Digital Design Applications.
Language of Instruction:Spanish

Campus: Sonora Norte