All Courses - Page 7 of 9 - Dade Institute Of Technology and Health

$15,000.00

SQL Server Database Specialist

$15,000.00

0 Available
seats

SQL Server Database Specialist Program Length Total Contact Hours Program Cost Clock Hours 450 Theory Hours 150 Tuition $ 12,500 Credit Hours Lab Hours 300 Registration Fees $ 100 Externship Hours Books & Supplies $ 1000 Material Cost $ 500 Exam Cost $ 900 Total Hours 450 Total Program Cost $ 15,000 Course Number Course Title Clock Hours Lab Hours COMP-70-761 Querying Data with Transact-SQL 70-761 30 COMP-70-762 Developing SQL Databases 70-762 30 COMP-70-764 Administering a SQL Database Infrastructure 70-764 30 COMP-70-765 Provisioning SQL Databases 70-765 30 COMP-70-467 Designing Business Intelligence Solutions with Microsoft SQL Server 70-467 30 Total of Theory Hours 150 COMP-70-761 Querying Data with Transact-SQL 70-761 60 COMP-70-762 Developing SQL Databases 70-762 60 COMP-70-764 Administering a SQL Database Infrastructure 70-764 60 COMP-70-765 Provisioning SQL Databases 70-765 60 COMP-70-467 Designing Business Intelligence Solutions with Microsoft SQL Server 70-467 60 Total Lab Hours 300 Total Hours Theory and Labs 450 Program Objective In the training, the student will acquire skills in Database Development, Database Administration and Business Intelligence. These courses will prepare the students to be able to design, Install, Program, Manage and troubleshoot Microsoft SQL Server 2016 Databases Program Description Querying Data with Transact-SQL 70-761 Developing SQL Databases 70-762 Administering a SQL Database Infrastructure 70-764 Provisioning SQL Databases 70-765 Designing Business Intelligence Solutions with Microsoft SQL Server 70-467 1- Querying Data with Transact-SQL 70-761 Introduction to Microsoft SQL Server 2016 Introduction to T-SQL Querying Writing SELECT Queries Querying Multiple Tables Sorting and Filtering Data Working with SQL Server 2016 Data Types Using DML to Modify Data Using Built-In Functions Grouping and Aggregating Data Using Subqueries Using Table Expressions Using Set Operators Using Windows Ranking, Offset, and Aggregate Functions Pivoting and Grouping Sets Executing Stored Procedures Programming with T-SQL Implementing Error Handling Implementing Transactions 2- Developing SQL Databases 70-762 Introduction to Database Development Designing and Implementing Tables Advanced Table Designs Ensuring Data Integrity through Constraints Introduction to Indexes Designing Optimized Index Strategies Column store Indexes Designing and Implementing Views Designing and Implementing Stored Procedures Designing and Implementing User-Defined Functions Responding to Data Manipulation via Triggers Using In-Memory Tables Implementing Managed Code in SQL Server Storing and Querying XML Data in SQL Server Storing and Querying Spatial Data in SQL Server Storing and Querying BLOBs and Text Documents in SQL Server SQL Server Concurrency Performance and Monitoring 3- Administering a SQL Database Infrastructure 70-764 SQL Server Security Assigning Server and Database Roles Authorizing Users to Access Resources Protecting Data with Encryption and Auditing Recovery Models and Backup Strategies Backing Up SQL Server Databases Restoring SQL Server 2016 Databases Automating SQL Server Management Configuring Security for SQL Server Agent Monitoring SQL Server with Alerts and Notifications Introduction to Managing SQL Server by using PowerShell Tracing Access to SQL Server with Extended events Monitoring SQL Server Troubleshooting SQL Server Importing and Exporting Data 4- Provisioning SQL Databases 70-765 SQL Server 2016 Components Installing SQL Server 2016 Upgrading SQL Server to SQL Server 2016 Working with Databases Performing Database Maintenance Database Storage Options Planning to Deploy SQL Server on Microsoft Azure Migrating Databases to Azure SQL Database Deploying SQL Server on a Microsoft Azure Virtual Machine Managing databases in the Cloud 5- Designing Business Intelligence Solutions with Microsoft SQL Server 70-467 Plan business intelligence infrastructure Plan for performance Plan for scalability Plan and manage upgrades Maintain server health Design BI Infrastructure Design a security strategy Design a SQL partitioning strategy Design a high availability and disaster recovery strategy Design a logging and auditing strategy Design a reporting Solution Design a Reporting Services dataset Manage Excel Services/reporting for SharePoint Design a data acquisition strategy Plan and manage reporting services configuration Design BI reporting solution architecture Design BI data models Design the data warehouse Design a schema Design cube architecture Design fact tables Design BI semantic models Design and create MDX calculations Design an ETL solution Design SSIS package execution Plan to deploy SSIS solutions Design package configurations for SSIS packages

Free

VMWare Certifications

0 Available
seats

VMWare Certified Associate VMWare Certified Professional

Free

Citrix Certified Administrator for Citrix XenApp 6

$0.00

Sarah Johnson

Teacher

20 Available
seats

$4,550.00

CompTIA A+ Objectives Hardware 220-801

$4,550.00

0 Available
seats

CompTIA A+ Certification Exam Objectives  Exam Number: 220-801 Introduction In order to receive CompTIA A+ certification a candidate must pass two exams. The first exam is CompTIA A+ 220-801 Certification Exam. The CompTIA A+ 220-801 examination measures necessary competencies for an entry-level IT professional with the equivalent knowledge of at least 12 months of hands-on experience in the lab or field. Successful candidates will have the knowledge required to assemble components based on customer requirements, install, configure and maintain devices, PCs and software for end users, understand the basics of networking and security/forensics, properly and safely diagnose, resolve and document common hardware and software issues while applying troubleshooting skills. Successful candidates will also provide appropriate customer support; understand the basics of virtualization, desktop imaging, and deployment. 1.0 PC Hardware 1.1 Configure and apply BIOS settings. 1.2 Differentiate between motherboard components, their purposes, and properties. 1.3 Compare and contrast RAM types and features. 1.4 Install and configure expansion cards. 1.5 Install and configure storage devices and use appropriate media. 1.6 Differentiate among various CPU types and features and select the appropriate cooling method. 1.7 Compare and contrast various connection interfaces and explain their purpose. 1.8 Install an appropriate power supply based on a given scenario. 1.9 Evaluate and select appropriate components for a custom configuration, to meet customer specifications or needs. 1.10 Given a scenario, evaluate types and features of display devices. 1.11 Identify connector types and associated cables. 1.12 Install and configure various peripheral devices. 2.0 Networking 2.1 Identify types of network cables and connectors. 2.2 Categorize characteristics of connectors and cabling. 2.3 Explain properties and characteristics of TCP/IP. 2.4 Explain common TCP and UDP ports, protocols, and their purpose. 2.5 Compare and contrast wireless networking standards and encryption types. 2.6 Install, configure, and deploy a SOHO wireless/wired router using appropriate settings. 2.7 Compare and contrast Internet connection types and features. 2.8 Identify various types of networks. 2.9 Compare and contrast network devices their functions and features. 2.10 Given a scenario, use appropriate networking tools. 3.0 Laptops 3.1 Install and configure laptop hardware and components. 3.2 Compare and contrast the components within the display of a laptop. 3.3 Compare and contrast laptop features. 4.0 Printers 4.1 Explain the differences between the various printer types and summarize the associated imaging process. 4.2 Given a scenario, install, and configure printers. 4.3 Given a scenario, perform printer maintenance. 5.0 Operational Procedures 5.1 Given a scenario, use appropriate safety procedures. 5.2 Explain environmental impacts and the purpose of environmental controls. 5.3 Given a scenario, demonstrate proper communication and professionalism. 5.4 Explain the fundamentals of dealing with prohibited content/activity.

$2,995.00

Interconnecting Cisco Networking Devices Part 1 (100-105)

$2,995.00

0 Available
seats

Exam Description The 640-822 Interconnecting Cisco Networking Devices Part 1 (ICND1) is the exam associated with the Cisco Certified Entry Network Technician certification and a tangible first step in achieving the Cisco Certified Network Associate certification. Candidates can prepare for this exam by taking the Interconnecting Cisco Networking Devices Part 1 (ICND1) v1.1 course. This exam tests a candidate’s knowledge and skills required to successfully install, operate, and troubleshoot a small branch office network. The exam includes topics on networking fundamentals; connecting to a WAN; basic security and wireless concepts; routing and switching fundamentals; the TCP/IP and OSI models; IP addressing; WAN technologies; operating and configuring IOS devices; configuring RIPv2, static and default routing; implementing NAT and DHCP; and configuring simple networks. Exam Topics The following topics are general guidelines for the content likely to be included on the Interconnecting Cisco Networking Devices Part 1 exam. However, other related topics may also appear on any specific delivery of the exam. In order to better reflect the contents of the exam and for clarity purposes, the guidelines below may change at any time without notice. Describe the operation of data networks Describe the purpose and functions of various network devices Select the components required to meet a given network specification Use the OSI and TCP/IP models and their associated protocols to explain how data flows in a network Describe common networking applications including web applications Describe the purpose and basic operation of the protocols in the OSI and TCP models Describe the impact of applications such as Voice Over IP on a network Interpret network diagrams Determine the path between two hosts across a network Describe the components required for network and Internet communications Identify and correct common network problems at layers 1, 2, 3 and 7 using a layered model approach Differentiate between LAN/WAN operation and features Implement a small switched network Select the appropriate media, cables, ports, and connectors to connect switches to other network devices and hosts Explain the technology and media access control method for Ethernet technologies Explain network segmentation and basic traffic management concepts Explain the operation of Cisco switches and basic switching concepts Perform, save and verify initial switch configuration tasks including remote access management Verify network status and switch operation using basic utilities (including: ping, traceroute, telnet, SSH, arp, ipconfig), SHOW & DEBUG commands Implement and verify basic security for a switch (port security, deactivate ports) Identify, prescribe, and resolve common switched network media issues, configuration issues, autonegotiation, and switch hardware failures Implement an IP addressing scheme and IP services to meet network requirements for a small branch office Describe the need and role of addressing in a network Create and apply an addressing scheme to a network Assign and verify valid IP addresses to hosts, servers, and networking devices in a LAN environment Explain the basic uses and operation of NAT in a small network connecting to one ISP Describe and verify DNS operation Describe the operation and benefits of using private and public IP addressing Enable NAT for a small network with a single ISP and connection using SDM and verify operation using CLI and ping Configure, verify and troubleshoot DHCP and DNS operation on a router (using both CLI and SDM) Implement static and dynamic addressing services for hosts in a LAN environment Identify and correct IP addressing issues Implement a small routed network Describe basic routing concepts (including: packet forwarding, router lookup process) Describe the operation of Cisco routers (including: router bootup process, POST, router components) Select the appropriate media, cables, ports, and connectors to connect routers to other network devices and hosts Configure, verify, and troubleshoot RIPv2 Access and utilize the router CLI to set basic parameters Connect, configure, and verify the operational status of a device interface Verify device configuration and network connectivity using ping, traceroute, telnet, SSH or other utilities Perform and verify routing configuration tasks for a static or default route given specific routing requirements Manage IOS configuration files (including: save, edit, upgrade, restore) Manage Cisco IOS Implement password and physical security Verify network status and router operation using basic utilities (including: ping, traceroute, telnet, SSH, arp, ipconfig), SHOW & DEBUG commands Explain and select the appropriate administrative tasks required for a WLAN Describe standards associated with wireless media (including: IEEE WI-FI Alliance, ITU/FCC) Identify and describe the purpose of the components in a small wireless network. (including: SSID, BSS, ESS) Identify the basic parameters to configure on a wireless network to ensure that devices connect to the correct access point Compare and contrast wireless security features and capabilities of WPA security (including: open, WEP, WPA-1/2) Identify common issues with implementing wireless networks Identify security threats to a network and describe general methods to mitigate those threats Explain today’s increasing network security threats and the need to implement a comprehensive security policy to mitigate the threats Explain general methods to mitigate common security threats to network devices, hosts, and applications Describe the functions of common security appliances and applications Describe security recommended practices including initial steps to secure network devices Implement and verify WAN links Describe different methods for connecting to a WAN Configure and verify a basic WAN serial connection

$7,995.00

MCSA Windows Server 2012

$7,995.00

0 Available
seats

70-410 / Installing and Configuring Windows Server 2012 Install and Configure Servers (17%) Install servers This objective may include but is not limited to: Plan for a server installation; plan for server roles; plan for a server upgrade; install Server Core; optimize resource utilization by using Features on Demand; migrate roles from previous versions of Windows Server Configure servers This objective may include but is not limited to: Configure Server Core; delegate administration; add and remove features in offline images; deploy roles on remote servers; convert Server Core to/from full GUI; configure services; configure NIC teaming Configure local storage This objective may include but is not limited to: Design storage spaces; configure basic and dynamic disks; configure MBR and GPT disks; manage volumes; create and mount virtual hard disks (VHDs); configure storage pools and disk pools Configure Server Roles and Features (16%) Configure file and share access This objective may include but is not limited to: Create and configure shares; configure share permissions; configure offline files; configure NTFS permissions; configure access-based enumeration (ABE); configure Volume Shadow Copy Service (VSS); configure NTFS quotas Configure print and document services This objective may include but is not limited to: Configure the Easy Print print driver; configure Enterprise Print Management; configure drivers; configure printer pooling; configure print priorities; configure printer permissions Configure servers for remote management This objective may include but is not limited to: Configure WinRM; configure down-level server management; configure servers for day-to-day management tasks; configure multi-server management; configure Server Core; configure Windows Firewall Configure Hyper-V (17%) Create and configure virtual machine settings This objective may include but is not limited to: Configure dynamic memory; configure smart paging; configure Resource Metering; configure guest integration services Create and configure virtual machine storage This objective may include but is not limited to: Create VHDs and VHDX; configure differencing drives; modify VHDs; configure pass-through disks; manage snapshots; implement a virtual Fibre Channel adapter Create and configure virtual networks This objective may include but is not limited to: Implement Hyper-V Network Virtualization; configure Hyper-V virtual switches; optimize network performance; configure MAC addresses; configure network isolation; configure synthetic and legacy virtual network adapters Deploy and Configure Core Network Services (16%) Configure IPv4 and IPv6 addressing This objective may include but is not limited to: Configure IP address options; configure subnetting; configure supernetting; configure interoperability between IPv4 and IPv6; configure ISATAP; configure Teredo Deploy and configure Dynamic Host Configuration Protocol (DHCP) service This objective may include but is not limited to: Create and configure scopes; configure a DHCP reservation; configure DHCP options; configure client and server for PXE boot; configure DHCP relay agent; authorize DHCP server Deploy and configure DNS service This objective may include but is not limited to: Configure Active Directory integration of primary zones; configure forwarders; configure Root Hints; manage DNS cache; create A and PTR resource records Install and Administer Active Directory (18%) Install domain controllers This objective may include but is not limited to: Add or remove a domain controller from a domain; upgrade a domain controller; install Active Directory Domain Services (AD DS) on a Server Core installation; install a domain controller from Install from Media (IFM); resolve DNS SRV record registration issues; configure a global catalog server Create and manage Active Directory users and computers This objective may include but is not limited to: Automate the creation of Active Directory accounts; create, copy, configure, and delete users and computers; configure templates; perform bulk Active Directory operations; configure user rights; offline domain join; manage inactive and disabled accounts Create and manage Active Directory groups and organizational units (OUs) This objective may include but is not limited to: Configure group nesting; convert groups including security, distribution, universal, domain local, and domain global; manage group membership using Group Policy; enumerate group membership; delegate the creation and management of Active Directory objects; manage default Active Directory containers; create, copy, configure, and delete groups and OUs Create and Manage Group Policy (16%) Create Group Policy objects (GPOs) This objective may include but is not limited to: Configure a Central Store; manage starter GPOs; configure GPO links; configure multiple local group policies; configure security filtering Configure security policies This objective may include but is not limited to: Configure User Rights Assignment; configure Security Options settings; configure Security templates; configure Audit Policy; configure Local Users and Groups; configure User Account Control (UAC) Configure application restriction policies This objective may include but is not limited to: Configure rule enforcement; configure Applocker rules; configure Software Restriction Policies Configure Windows Firewall This objective may include but is not limited to: Configure rules for multiple profiles using Group Policy; configure connection security rules; configure Windows Firewall to allow or deny applications, scopes, ports, and users; configure authenticated firewall exceptions; import and export settings 70-411 / Administering Windows Server 2012 Deploy, Manage, and Maintain Servers (17%) Deploy and manage server images. This objective may include but is not limited to: Install the Windows Deployment Services (WDS) role; configure and manage boot, install, and discover images; update images with patches, hotfixes, and drivers; install features for offline images Implement patch management. This objective may include but is not limited to: Install and configure the Windows Server Update Services (WSUS) role; configure group policies for updates; configure client-side targeting; configure WSUS synchronization; configure WSUS groups Monitor servers. This objective may include but is not limited to: Configure Data Collector Sets (DCS); configure alerts; monitor real-time performance; monitor virtual machines (VMs); monitor events; configure event subscriptions; configure network monitoring Configure File and Print Services (15%) Configure Distributed File System (DFS). This objective may include but is not limited to: Install and configure DFS namespaces; configure DFS Replication Targets; configure Replication Scheduling; configure Remote Differential Compression settings; configure staging; configure fault tolerance Configure File Server Resource Manager (FSRM). This objective may include but is not limited to: Install the FSRM role; configure quotas; configure file screens; configure reports Configure file and disk encryption. This objective may include but is not limited to: Configure Bitlocker encryption;

$5,295.00

VMWare Certified Associate hot

$5,295.00

343 Available
seats

German for Beginners online video course is designed as an easy to use, fun and interactive introduction to the German language. It’s ideal for people wanting to travel or live in Germany. This course will teach you the structures and vocabulary necessary in order to communicate in every day situations.

$5,050.00

CCNA Routing and Switching new

$5,050.00

Donard St Jean

Teacher

0 Available
seats

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis vestibulum turpis eu nunc volutpat vestibulum. Donec scelerisque arcu ac ante.

Free

Citrix Certified Administrator for Citrix XenDesktop 5

$0.00

Sarah Johnson

Teacher

20 Available
seats

If you want to build a successful business online, watch the promo video to see why 13,000+ students are using this online entrepreneurship course to learn the 10 steps that work for me every day to build and grow a business online!