Course Summary
Data Specialty - MySQL is intended help you learn the basics of SQL and introduce MySQL relational databases to create and administer your own databases.
Skills Gained
This course teaches you how to:
- Learn the basics of SQL
 - Create relational databases using MySQL
 - Administer your own databases with MySQL
 
Pre-Requisite
- Strong desire to learn
 - Ambition to grow professionally
 - Laptop
 - Familiarity or experience in IT is a plus but NOT a requirement
 
Schedule
Virtual Class Live - Starting April 1, 2025
Daily -Â Monday - Friday
Class 1: 6:30 PM - 9:30 PM EDT (New York/ Washington)
Class 2: 6:30 PM - 9:30 PM PST (California/Seattle)
Class 3: 10:30 AM - 1:30 PM EDT (New York/ Washington) or 6:30 PM - 9.30 PM Kampala
Class 4: 10:30 AM - 1:30 PM PST (California/Seattle) 6:30 PM - 9.30 PM London
        
      Instructor:
Mussie Berhane
Professional Experience: Highly technical, detailed oriented and experienced Senior Solution Architect/Designer and Engineer with over 20 years of experience; proficient in designing, deploying, managing and troubleshooting IP based enterprise and cloud solutions: Unified Communications / VoIP, Cyber Security, Cloud, Data Center, Virtualization, Storage, IP Routing and IP Switching, SD-WAN, Data Analytics, Database and Big Data. Currently, Mussie is working as Senior Cloud Security/ Engineer Consultant.
Research & Development: Mussie is actively working to provide tangible solutions to today's complex challenges to the underserved, with focus in Energy, Technology and Knowledge Transfer.
Training/Teaching: Mr. Berhane is passionate about knowledge transfer, teaching and mentoring. Over the past 15 years, Mussie has taught more than 3,000 students in different IT sectors, always adapting and focusing on emerging technologies to meet current and future job market demands.
Education and Certifications:
BS: Computer Information Systems
AWS:
Advance Networking Specialty, Security Specialty, Database Specialty, Big Data Specialty, and all Associate certifications.
Mr. Berhane, also holds other vendor certifications from Cisco, Microsoft, CheckPoint, Silver Peak and others.
Hobbies and Interests:Â Reading, Traveling, Basketball, Mentoring and Transferring Knowledge and Skills.
Course Curriculum
- MySQL Client Server Architecture
 - Installing MySQL
 - Lab 2.1 - Installing MySQL 8.0
 - Connecting to and Disconnecting from the Server
 - Lab 2.2 - Accessing MySQL Server
 - Importing and Installing Datasets I
 - Lab 2.3 - Importing and Installing Datasets
 - Getting information about databases and tables
 - Lab 2.4 - Collecting database and tables information
 - MySQL Commands
 - Entering Queries
 - Lab 2.5 Basic Querying and Syntax