Course Outline
Module 1: Introduction to Databases and MySQL
- Overview of databases and their importance
- Introduction to MySQL as a relational database management system
- Understanding the role of MySQL in data storage and retrieval
- Installation and setup of MySQL on various platforms
Module 2: Getting Started with MySQL Workbench
- Introduction to MySQL Workbench as a graphical user interface for MySQL
- Navigating the MySQL Workbench environment
- Creating connections to MySQL servers
- Executing basic SQL commands using MySQL Workbench
Module 3: Understanding Data and Tables
- Concept of data and its representation in MySQL
- Introduction to tables as the fundamental structure for organizing data
- Exploring different data types supported by MySQL
- Creating and managing tables in MySQL
Module 4: Inserting and Retrieving Data
- Inserting data into MySQL tables using INSERT statements
- Retrieving data from tables using SELECT statements
- Filtering and sorting retrieved data
- Limiting the number of rows returned by SELECT statements
Module 5: Updating and Deleting Data
- Updating existing data in MySQL tables using UPDATE statements
- Deleting data from tables using DELETE statements
- Truncating tables to remove all data
- Understanding the importance of data manipulation operations
Module 6: Introduction to Constraints
- Understanding constraints and their role in maintaining data integrity
- Introduction to primary keys, foreign keys, unique constraints, and nullability
- Applying constraints to table columns in MySQL
Module 7: Querying Multiple Tables with Joins
- Introduction to relational databases and table relationships
- Understanding the concept of joins in MySQL
- Performing inner joins, left joins, and right joins to query data from multiple tables
- Using aliases to simplify join queries
Module 8: Aggregating Data with Functions
- Introduction to aggregate functions in MySQL (COUNT, SUM, AVG, MIN, MAX)
- Grouping data using GROUP BY clause
- Filtering grouped data using HAVING clause
- Performing basic data analysis using aggregate functions
Module 9: Introduction to Transactions
- Understanding the concept of transactions in MySQL
- Initiating and committing transactions
- Rolling back transactions to maintain data consistency
- Importance of transactions in database management
Module 10: Conclusion and Next Steps
- Recap of key concepts covered in the course
- Guidance on further resources and advanced topics in MySQL
- Encouragement for continued learning and practice in MySQL
Requirements
No prior experience with MySQL is required. Basic familiarity with computer systems and software interfaces is recommended.
Testimonials (12)
Lot of content and exactly the requested one.
Pascal - Diehl
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
I like this training because it was interactive
Amalia - Banca Transilvania
Course - SQL Fundamentals
i really liked the pace of the training, and the exercises given inbetween the explanations
Trana
Course - SQL in SQL Server
the practices and the trainer notes
Hamda AlMahri - Dubai Courts
Course - ORACLE PL/SQL Fundamentals
Luka is an excellent, patient teacher with a sense of humor. His relaxed style made the stressful experience of "be called to the blackboard" more pleasant. Also one student explaining or guiding the other was a very good idea. I will use the motto "KISS methodology" he shared with us in both my SQL exercises , private and professional life since I like to overcomplicate things. Luka also kept the good pace considering how much material was there for him to show and for us to learn.
IWONA KLIMASZEWSKA - GP Strategies Poland sp. z o.o.
Course - ORACLE SQL Fundamentals
I enjoyed the balance of lectures and exercises. When I was stuck Luke was very good at helping me to understand the problem and work towards solutions which made a really positive impact on my understanding.
Tom - Welsh Revenue Authority
Course - Transact SQL Basic
Really enjoyed compression data components
James - Medtech Limited
Course - Transact SQL Advanced
The course built lesson to lesson, and the pacing was a big deal for me.
Bradford Moore - Regis College
Course - SQL in MySQL
Luke was opened to answer any question and explain multiple times until everyone understood the exercises.
Alexandra Popa - OTP BANK ROMANIA S.A.
Course - Oracle SQL Language
I liked the way the trainer explained the information about the topics and the fact that he paid attention to the details so that the lessons were very practical and logical.
Andreea
Course - Oracle SQL for beginners
Exercises are entertaining and the topics were nicely introduced.
Adrian-Madalin Chirita - DB Global Technology SRL
Course - Oracle SQL Advanced
I appreciated Folio's wide breadth of knowledge. Not only was he familiar with the course content, but he also knew of constructs in languages we were familiar with to make examples more meaningful to us. During intervals he shared his knowledge of technologies and solutions outside the training scope to provide insights into other solutions we could use in future (and future training).