Database Specialist (DS14)  Diploma

Introduces the fundamental concepts terminology and operations necessary to use computers. Emphasis is placed on basic functions and familiarity with computer use. Topics include an introduction to computer terminology the Windows environment Internet and email word processing software spreadsheet software database software and presentation software.

Provides an overview of information systems computers and technology. Topics include: Information Systems and Technology Terminology Computer History Data Representation Data Storage Concepts Fundamentals of Information Processing Fundamentals of Information Security Information Technology Ethics Fundamentals of Hardware Operation Fundamentals of Networking Fundamentals of the Internet Fundamentals of Software Design Concepts Fundamentals of Software (System and Application) System Development Methodology Computer Number Systems conversion (Binary and Hexadecimal) Mobile computing.

An introductory course that provides problem solving and programming concepts for those that develop user applications. An emphasis is placed on developing logic troubleshooting and using tools to develop solutions. Topics include: problem solving and programming concepts structured programming the four logic structures file processing concepts and arrays.

Provides an overview of the skills and knowledge of database application systems which are used in business government and industry. Topics include: history database terminology and concepts database system logical organization data manipulation database design concepts models normalization Entity Relationship diagramming physical database networking and databases and database security.

IT Analysis Design and Project Management will provides a review and application of systems life cycle development methodologies and project management. Topics include: Systems planning systems analysis systems design systems implementation evaluation and project management.

Visual Basic I introduces event-driven programming. Common elements of Windows applications will be discussed created and manipulated using Microsofts Visual Studio development environment. Topics include numeric data types and variables decision making structures arrays validating input with strings and functions repetition and multiple forms test files lists and common dialog controls.

This course is designed to teach the basic concepts and methods of objected-oriented design and C#.Net programming. Use practical problems to illustrate C#.Net application building techniques and concepts. Develop an understanding of C#.Net vocabulary. Create an understanding of where C#.Net fits in the application development landscape. Create an understanding of the C#.Net Development Environment Visual Studio and how to develop debug and run C#.Net applications using the Visual Studio. Continue to develop student*s programming logic skills. Topics include: C#.NET Language History C#.NET Variable Definitions C#.NET Control Structures C#.NET Functions C#.NET Classes C#.NET Objects and C#.NET Graphics.

Provides opportunity to gain a working knowledge of C++ programming. Includes creating editing executing and debugging C++ programs of moderate difficulty. Topics include: basic C++ concepts simple I/O and expressions I/O and control statements arrays pointers structures managing data and developing programs.

This course is designed to teach the basic concepts and methods of objected-oriented design and Java programming. Use practical problems to illustrate Java application building techniques and concepts. Develop an understanding of Java vocabulary. Create an understanding of where Java fits in the application development landscape. Create an understanding of the Java Development Kit and how to develop debug and run Java applications using the JDK. Continue to develop student*s programming logic skills. Topics include: JAVA Language History JAVA Variable Definitions JAVA Control Structures JAVA Methods JAVA Classes JAVA Objects and JAVA Graphics.

This course explores mobile guidelines, standards, and techniques. This course includes design and development techniques for multiple mobile devices, platforms, and operating systems. Students will develop mobile applications using state of practice development tools, languages and devices.

Provides an overview of modern operating systems and their use in home and small business environments. Activities will utilize the graphical user interface (GUI) and command line environment (CLI This will include operating system fundamentals; installing configuring and upgrading operating systems; managing storage file systems hardware and system resources; troubleshooting diagnostics and maintenance of operating systems; and networking.

This course provides an introduction to the Oracle database management system platform and to Structured Query Language (SQL). Topics include database vocabulary normalization Oracle DML and DDL statements SQL Statements views and constraints.

This course enables thedatabase student to implement and administer Oracle databases. Topics include: oracle logical architecture and administration tools Oracle physical architecture and data dictionary views performance monitoring and database security.

This course introduces participants to the critical task of planning and implementing database backup and recovery strategies. Topics include Backup and Recovery Resource Management and Performance tuning Globalization Support and Diagnostic Tools.

This course enables the database student to integrate database content and theory. The student will use Oracle application development tools and utilities to create and manage realistic database development projects. Topics include SQL and PL/SQL Oracle Forms Database Reports and Integrated Database Applications.

This course provides an introduction to the Oracle database management system platform and to Structured Query Language (SQL). Topics include database vocabulary normalization Oracle DML and DDL statements SQL Statements views and constraints.

Provides the ability to implement administrator and troubleshoot Windows Professional Client as a desktop operating system in any network environment.

Provides instruction on how to administer a Microsoft SQL server. Topics include: planning installation and configuration configuring and managing security managing and maintaining data monitoring and optimization and troubleshooting.

Shows how to design and implement a database solution using Microsoft SQL Server. Topics include: developing logical data model and physical design creating data services creating physical database and maintaining a database.

Provides students with knowledge and skills necessary to install configure manage support and administer a Microsoft network infrastructure.