MS in Information Technology - Database Design

What will this cost?
 

See Graduate Program Costs

or Use our Net price calculator to see how affordable a degree at SNHU really is.

The Database as a Finely Tuned Machine

Databases are the backbone of almost every business. Using them to their full potential takes a skilled Database Administrator, or DBA. DBAs are experts in the science of administering, managing and handling the tasks involved in database management systems, such as the creation of databases, data warehousing, and database performance and tuning.

SNHU's Master’s in Information Technology database design degree focuses on the design and development of database applications, client/server systems and data warehouses within the context of a business environment. Learn to develop multi-user database applications and manipulate data in a shared database environment. Explore principles of design, development and implementation of Data Warehouse DBMS based on the dimensional modeling architecture.

In the working world, a junior DBA will likely focus on administration, while senior-level DBAs work at the data architecture, strategy and design level.

Concentration Outcomes

In addition to the skills you’ll gain as an SNHU MS IT graduate, our Database Design concentration helps you:

  • Develop advanced, multi-user database applications using large commercial database systems
  • Design and build client applications that manipulate data in a shared database environment on a network
  • Utilize principles of design to plan the development and implementation of Data Warehouse DBMS based on the dimensional modeling architecture

MS IT Database Design Concentration - Curriculum

Total Credits Required: 36 minimum

To complete your Master’s in IT degree, you will take 12 courses (36 credits), including nine core MS in Information Technology courses and three IT concentration courses.

Database Design Courses

IT-655: Database Application Development
This course focuses on how to develop advanced, multi-user database applications using ORACLE. Hands-on project work is stressed. Students will learn advanced administration techniques and ways to handle run-time errors and optimize database processing by manipulating system parameters.
Prerequisites:
IT-500 or IT-510 or permission of instructor
IT-665: Client/Server Systems
This course focuses on the elements and methodologies used in the development of client server applications. Students design and build client applications that manipulate data in a shared database environment on a network. Topics include user interface design, object- oriented design, data management and data security. Theoretical concepts are reinforced with applications. The course is project- oriented, with students implementing projects using a front-end application development language.
Prerequisites:
IT-500 or IT-510 or permission of instructor
IT-675: Data Warehouse Concepts and Design
This course presents the principles of design, development, and recommended implementation strategies of a Data Warehouse DBMS based on the dimensional modeling architecture. Data warehouse management issues will also be examined, along with an introduction to data mining as a tool for analytical decision support. Students will design and recommend implementation strategies of a data warehouse architecture.
Prerequisites:
CIS-650 or IT-650

MS in Information Technology Core Courses

IT-510: Advanced Information Technology
This course focuses on the principles and practices underlying the analysis, design, implementation and management of information technology systems. Topics include information system development methodologies, systems planning, requirements analysis, systems implementation, software engineering, project management, and interface, database and process design.
Prerequisites:
Take IT-505
IT-511: Object Oriented Application Development
This course provides a comprehensive introduction to the principles and practices of object- oriented software development and provides a foundation for developing quality software. Students develop skills in applying object- oriented concepts to solve software problems and implement solutions. The course also teaches the concepts and design of algorithms for problem solving and includes the topics of data structures as they are related to the algorithms that use them. The course provides the technical foundation necessary to handle the material covered in the subsequent IT courses.
IT-515: Innovations in Information Technology
In this course, students strengthen their understanding of leadership theory and ethical frameworks in the context of a technology enterprise. Students will apply this understanding to business cases that reflect the need for innovative technology solutions in today's workplace in order to transform the thinking of an organization when change is required or to develop ideas that enable new business strategies.
IT-520: Technical Communication
The course focuses on the essential oral and written technical communication skills needed for producing technical documentation and presentations in many different forms for varying business situations. The course enables students to understand the needs of stakeholders in order to develop different technical documents such as white papers, design specifications, project plans, test plans, user manuals, etc. The ability to communicate research findings using appropriate academic formatting will also be addressed.
IT-600: Operating Systems
This course focuses on computer architecture and the operating systems of digital computers. Students learn about the operational methods of hardware; the services provided by operating systems' software; acquisition, processing, storage and output data; and the interaction between computers. Topics include widely used operating systems such as DOS, Windows, and UNIX.
Prerequisites:
IT-511 and IT-510
IT-625: Information Technology Project and Team Management
This course introduces the students to the principles and practices necessary to be an effective IT project manager. The course covers project scope, time, cost, quality and human resource management techniques as applied to the kinds of project management problems and issues unique to the IT environment. Students learn how to design an actual IT project structure and will obtain hands-on experience using project management software. Emphasis is on the techniques of project management, leadership, teamwork and project risk management as applied to the IT environment. Case work is an important part of this course.
IT-640: Telecommunications and Networking
Telecommunications is a business resource that must be well managed. This includes the technical aspects and the application of telecommunications technology to solve specific business problems and enhance the strategic position of a business enterprise. Topics include the importance of telecommunication in today's business environment, the analysis, design and implementation of telecommunications systems, the scope of the telecommunications industry and current trends; telecommunications hardware, the OSI network model, networking technologies and telecommunications software, protocols and standards.
Prerequisites:
IT-600
IT-650: Principles of Database Design
This course is a study of the design, development and implementation of database management systems (DBMS) that emphasizes relational DBMS architecture using SQL. Students will design and implement projects and complete case exercises as they are introduced to new developments in data- base design.
Prerequisites:
IT-511 and IT-510

Foundation Course

IT-505: Core Technologies
This course familiarizes students with the basic concepts of information systems to strengthen their knowledge of hardware and software systems, including supporting information technology infrastructures. Students will gain an understanding of the application of fundamental information technology competencies related to computer networks, software and delivery systems for delivering products and service within an enterprise to customers, suppliers and clients. Additionally, students examine the skills and dispositions that shape their professional identities.

Capstone Course

IT-700: Information Technology Strategy & Policy
This is the capstone course of the IT master's degree program and is designed to provide in-depth understanding of the central role of information technology in the contemporary business environment. Students develop an understanding of the strategic uses of information technology from a business perspective at the enterprise level. Students also learn how to manage the introduction of new information technologies in the firm. They learn how to harness the power of these new technologies, enabling them to make better decisions and more effectively manage their organizations. Students conduct an extensive research project on the business impact of emerging technologies.
Prerequisites:
IT-510, IT-600, IT-610, IT-625, IT-630, IT-640 and IT-650 or permission of instructor

Admission Requirements

Acceptance decisions are made on a rolling basis throughout the year for our five graduate terms. You can apply at any time and get a decision within days of submitting all required materials. To apply, simply contact an admission counselor, who can help you explore financial options.  Your counselor can also walk you through the application process, which involves completing a graduate application ($40 fee) and providing undergraduate transcripts.

Candidates are also required to submit a resume.

Contact Us
 
Admissions

Phone: 888.387.0861
Email: enroll@snhu.edu