Course Overview
The MySQL Fundamentals training is the mastering MySQL, the world`s most popular open source database. Develop solid understand and practical experience using relational databases, SQL and the MySQL Server and tools.
Learn to:
- Explain the relational database model.
- Describe the features and benefits of MySQL
- Install and configure the MySQL Server and Clients.
- Design efficient databases.
- Use Structured Query Language (SQL) to build your database and query data.
- Employ appropriate MySQL tools.
Benefits to the Participants:
This course will teach you everything you need to know to start using the incredibly popular MySQL database in your Web, Cloud and embedded applications. In learning about MySQL you will also gain an understanding of relational databases. In general, learning how to design your database so it`s robust and efficient. Furthermore, you will harness that power by learning SQL and using it to build databases. Populate them with data and query that data though extensive hands-on practices.
Manages Your MySQL Database
In addition to covering core concepts, this course introduces you to more advanced tools and techniques to help you manage your MySQL database and put your new skills to work.
Who Should Attend?
Application Developers, Database Administrators, Database Designers, Developer.
Pre-requisite
Basic knowledge in MySQL and any programming language.
Course Outlines
Lab Outlines
- Get Started with Cisco Command-Line Interface (CLI)
- Observe How a Switch Operates
- Perform Basic Switch Configuration
- Implement the Initial Switch Configuration
- Inspect TCP/IP Applications
- Configure an Interface on a Cisco Router
- Configure and Verify Layer 2 Discovery Protocols
- Implement an Initial Router Configuration
- Configure Default Gateway
- Explore Packet Forwarding
- Troubleshoot Switch Media and Port Issues
- Troubleshoot Port Duplex Issues
- Configure Basic IPv6 Connectivity
- Configure and Verify IPv4 Static Routes
- Configure IPv6 Static Routes
- Implement IPv4 Static Routing
- Implement IPv6 Static Routing
- Configure VLAN and Trunk
- Troubleshoot VLANs and Trunk
- Configure a Router on a Stick
- Implement Multiple VLANs and Basic Routing Between the VLANs
- Configure and Verify Single-Area OSPF
- Configure and Verify EtherChannel
- Improve Redundant Switched Topologies with EtherChannel
- Configure and Verify IPv4 ACLs
- Implement Numbered and Named IPv4 ACLs
- Configure a Provider-Assigned IPv4 Address
- Configure Static NAT
- Configure Dynamic NAT and Port Address Translation (PAT)
- Implement PAT
- Log into the WLC
- Monitor the WLC
- Configure a Dynamic (VLAN) Interface
- Configure a DHCP Scope
- Configure a WLAN
- Define a Remote Access Dial-In User Service (RADIUS) Server
- Explore Management Options
- Explore the Cisco DNA™ Center
- Configure and Verify NTP
- Configure System Message Logging
- Create the Cisco IOS Image Backup
- Upgrade Cisco IOS Image
- Configure WLAN Using Wi-Fi Protected Access 2 (WPA2) Pre-Shared Key (PSK) Using the GUI
- Secure Console and Remote Access
- Enable and Limit Remote Access Connectivity
- Secure Device Administrative Access
- Configure and Verify Port Security
- Implement Device Hardening
