- Instructor: admin
- Duration: 31 weeks
PROGRAM DESCRIPTION:
This course covers the knowledge and skills needed to provide an enterprise solution that supports manual and automated server installations in a physical and virtual environment including the supporting file and storage services. You will also learn the skills necessary to provide enterprise-networking solutions such as DHCP, IPAM, VPN, and Direct Access. You will also learn the skills necessary to design and implement a forest and domain infrastructure including multi domains/forest and branch office scenarios.
This program teaches the key skills you need to become a Data Analyst and prepare you for the SQL Server 2012 (70-461, 70-462 & 70-463) and SQL Server 2014 (Data Management Analytics – 70-466, 40-467) official certification exams
PROGRAM PREREQUISITES:
Students taking this course should be familiar with personal computers and the use of a keyboard and a mouse. Furthermore, basic knowledge of Microsoft Windows Operating System and its core functionality is required.:
- Must have: High School Diploma or High School Equivalency
- Must score: 10 or higher in CASAS
After completing this course the student will know how to:
- Describe the basic architecture and concepts of Microsoft SQL Server 2014.
- Understand the similarities and differences between Transact-SQL and other computer languages.
- Write SELECT queries.
- Query multiple tables.
- Describe data warehouse concepts and architecture considerations.
- Select an appropriate hardware platform for a data warehouse.
- Design and implement a data warehouse.
- Implement Data Flow in an SSIS Package.
- Assess an existing enterprise environment.
- Plan and implement Policy-Based Management.
- Implement Dynamic Host Configuration Protocol (DHCP).
- Implement IPv6.
- Implement Domain Name System (DNS).
- Implement and manage IP address management (IPAM).
- Plan server upgrade and migration.
- Plan and implement a server deployment strategy.
- Design and maintain an IP configuration and address management solution.
- Design and implement name resolution.
Ideal Institute of Technology will provide a one-time voucher for student to take:
- Microsoft Certification
Student will have access to all necessary equipment and supplies such as Computers, , Computer Software, Servers, and other applications to work with computers for the duration of the course.
Student will have full access to our Learning Management System (LMS) portal, Google Classroom and Live Webinars. We will be providing resources in the form of PowerPoints, video tutorials, quizzes, assessments and much more.
CAREER READINESS:
After successful completion of the program and obtaining certification(s), A Job Readiness program and a free Resume Building Workshop will be offered to student through Ideal Career Centre, to prepare students for their job search.
CAREER PLACEMENT:
Upon successful completion of the course and certification, student will get 100% job placement assistance through Ideal Career Centre.
CAREER TITLES:
Information Security Analysts could see the best employment prospects through the 2014-2024 decade. Job opportunities in this field were expected to grow 18%, while Network and Computer Systems Administrators could see a job growth of 8%. Database Administrators were expected to experience an employment increase of 11%, and a job growth of 12% was projected for computer support specialists.
IT professionals who have worked their way up to becoming a Microsoft Certified Solutions Expert may find employment in a variety of positions, including Information Security Analyst and Database Administrator. An average or faster-than-average job growth was projected for most of these positions, and individuals could earn anywhere from $62,000 to a little over $90,000.
