IT Academy - Computer Database Courses

Introduction to SQL - Basics

Students will be introduced to the concepts involved in designing and using a database management system. The student will learn key concepts - the basic structures of relational databases, how to read and write simple and complex SQL statements, and advanced data manipulation techniques.

Prerequisite: Students need to have basic computer knowledge. Database design knowledge is helpful as well.

Hours: 48
Tuition: $599 (includes books/materials/lab fees)
Course: WITAC 2500

View Our Current Schedule of Classes Here!

Course I: Microsoft Certified Technology Specialists in SQL Server 2005

Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 (MCTS: SQL Server 2005) implement and maintain databases using specific instructions and specifications. You will have thorough knowledge of the product, understand how to use the tools and Transact-SQL language, and know how to explore the user interface. Technology Specialists typically pursue careers as database administrators, database developers, or business intelligence developers.

Exam 70-431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance

Prerequisites: You must have prior networking experience in Microsoft Windows and database design. SQL - Database Basics (WITAC 2500) would be an excellent prerequisite for this course.

Hours: 48
Tuition: $725 (includes books/materials/lab fees)
Course: WITAC 2510

View Our Current Schedule of Classes Here!

Course II: Microsoft Certified IT Professional: Database Administrator

Microsoft Certified IT Professional: Database Administrator (MCITP: Database Administrator) is the premier certification for database server administrators. Database administrators install or configure Microsoft SQL Server and manage or maintain databases or multidimensional databases, user accounts, database availability, recovery, and reporting. They also design or implement security or server automation and monitor and troubleshoot SQL Server activity.

Exam 70-443: PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
Exam 70-444: PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005

Prerequisites: WITAC 2510 Microsoft Certified Technology Specialists in SQL Server 2005

Hours: 80
Tuition: $1,250 (includes books/materials/lab fees)
Course: WITAC 2511

View Our Current Schedule of Classes Here!

Creating a Dynamic Websites with PHP and MySQL

To be competitive in today's marketplace, establishing a dynamic presence on the Internet is more important than ever.  And thanks to the trend of open-source software, it doesn't have to cost a lot to do so.  With the skills you learn in this course, you will be able to showcase your skills and products yourself, without requiring expensive consulting services.
You will learn how to organize and store your information in a database; how to retrieve and display that information based on varying conditions; how to let your visitors customize their experience; and techniques to keep your data safe from attack.  The skills gained in this course also apply to other types of programming and business management.
Experience with HTML and CSS are strongly recommended prerequisites for this course.

Hours: 36
Tuition: $550 (includes books/materials/lab fees)
Course:WITAC 3000

Microsoft SQL Server 2005 Business Intelligence

The following are some of the topics covered.

• Managing SSAS
• Developing SSAS Solutions by Using BIDS
• Implementing data mining by Using BIDs
• Managing SSRS
• Developing Reporting Solutions by Using SSRS
• Developing Business Intelligence Solutions by Using SSIS
• Administering SSIS Packages

Exam 70-445: Implementation and Maintenance

Hours: 40
Tuition: $650 (includes books/materials/lab fees)
Course: WITAC 2504

View Our Current Schedule of Classes Here!

Bi-Weekly Info Sessions
Sign Up Now!

Request More Info
Submit our short form and we'll get right back to you