Laserfiche WebLink
122 <br />D401: Database <br />Database Administration Fundamentals <br />Administration <br />Fundamentals/SQL <br />Students who are beginning studies in technology need a strong foundation in the basics <br />before moving on to more advanced technology courses. Database Administration <br />Fundamentals covers introductory knowledge and skills including: relational databases; <br />core database concepts; relational database concepts; security requirements for databases <br />and the data stored in them; database objects — such as tables and views; graphical tools <br />and T-SQL scripts; database queries; and stored procedures. <br />The course focuses on teaching individuals how to use SQL Server 2012 product features <br />and tools related to maintaining a database. All the Assignments for this course can be <br />performed using the provided virtual machines. At the end of this course, students will be <br />able to: <br />• Understand Core database concepts <br />• Manage Relational database concepts <br />• Handle Security requirements for databases and the data stored in them <br />• Manipulate Database objects, such as tables and views <br />• Create Graphical tools and Transact -Structured Query Language (T-SQL) scripts <br />• Administer Database queries <br />• Manipulate Database Definition Language (DDL) <br />• Administer Data Manipulation Language (DIAL) <br />• Understand Stored procedures <br />• Make Plan and install SQL Server <br />• Describe the system databases, the physical structure of databases and the most <br />common configuration options related to them <br />Prerequisite: None <br />R501: Intro to Router Routing Technology <br />This course is designed specifically to prepare students for authenticating the ability to <br />install, configure, operate, and troubleshoot medium -size route and switched networks. <br />With this course, networking professionals will make connections to remote sites via a <br />WAN, mitigate basic security threats, and understand the requirements for wireless <br />network access. <br />Install, configure, and troubleshoot fully operational routers, as you build a multiprotocol <br />network. In this informative course, you will learn internetworking LAN and WAN concepts <br />and master the router operations. This course covers the basic techniques to configure the <br />routers for LANs and provides the foundation on routers, switches and firewalls. Additional <br />topics include: <br />• Describe the benefits of a layered model <br />• Describe the main benefit of the OSI reference model <br />• Understand each of the seven layers of the OSI reference model <br />• Describe flow control and how it is used within an internetwork <br />• Understand how the Transport layer flow control mechanism works <br />• Describe how the OSI's Network layer provides routing in an internetwork <br />environment <br />• List the five conversion steps of data encapsulation <br />Prerequisite: None <br />Revision Date on <br />