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. At Ideal Institute of Technology, you will learn the skills necessary to provide enterprise-networking solutions such as DHCP, IPAM, VPN, and DirectAccess. 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) Windows Server Engineer and prepare you for the Windows Server 2016 (70-740, 70-741 & 70-742), Designing and Implementing a Server Infrastructure (70-413, 70-414 – MCSE Server Infrastructure) and SQL Server 2014 (Data Management Analytics – 70-466, 40-467) official certification exams.
What will I learn?
After completing this course 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.
- And more…
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.
Students must be familiar with using a personal computer, mouse, and keyboard. They must be comfortable in a Windows environment, and have the ability to launch and close activities and navigate to information stored on the computer. They must have an ability to manage files and folders.
A day in Network Specialist’s life:
- Sets up desktop computers and peripherals and test network connections
- Installs and tests desktop software applications and internet browsers.
- Tests computers to ensure proper functioning of computer systems.
- Extends computer support for systems’ software and hardware.
- Consults with customers on all aspects of end-user computing and desktop-based systems software; resolves more complex, less defined issues
- Works independently in troubleshooting and providing solutions to unresolved hardware and software problems through trouble-ticket system
- packages; participates in the testing and evaluation of new desktop packages, implements prototypes, and consults with customers on selection of software applications
- Installs LAN software upgrades including planning and scheduling, testing, and coordination, and maintains integrity of the LAN software and hardware
- Performs LAN security procedures including implementing log-in requests; evaluates new products and technologies to determine impact on existing system configurations