Skedmia

SQL - Introduction to SQL with MySQL

30

Exam questions

70%

Pass mark

QR-verifiable Certificate of Training

Self-paced online, start today

About this course

Introduction: 

SQL with MySQL is a comprehensive course that teaches the basics of Structured Query Language (SQL) using MySQL, one of the most popular relational database management systems. This course covers everything from database design and management to querying and analyzing data. Students will learn how to create and manipulate databases, tables, and data using SQL commands, as well as how to retrieve, sort, filter, and aggregate data from multiple tables using JOINs, GROUP BY, and other advanced SQL features. The course includes hands-on exercises and projects that allow students to apply their knowledge in real-world scenarios. Upon completion of this course, students will have a solid foundation in SQL with MySQL and be well-equipped to work with relational databases in various roles, including database developers, data analysts, software developers, and business intelligence professionals.

Objectives: 

  1. Understanding the fundamentals of SQL: Learning SQL with MySQL helps you learn the basics of Structured Query Language (SQL), which is a widely used database programming language.
  2. Familiarizing with MySQL: MySQL is an open-source relational database management system that is widely used in web applications. Learning SQL with MySQL helps you get hands-on experience with MySQL and its features.
  3. Creating and manipulating databases: SQL is used for creating and managing databases. With MySQL, you will learn how to create and manage databases, tables, and columns.
  4. Retrieving data: SQL is primarily used for retrieving data from databases. You will learn how to write SQL queries to retrieve data from MySQL databases.
  5. Sorting and filtering data: You will learn how to sort and filter data using SQL queries.
  6. Aggregating data: You will learn how to group and aggregate data using SQL functions.
  7. Joining tables: You will learn how to join multiple tables to retrieve data from related tables.
  8. Modifying data: You will learn how to modify data in a MySQL database using SQL statements.
  9. Managing database security: You will learn how to manage user accounts and database security using MySQL.
  10. Preparing for data analytics: SQL is a fundamental skill required for data analytics. Learning SQL with MySQL will prepare you for data analytics and other data-related roles.

 

Course Outlines:

  1. Introduction to Relational Database Design
  2. Why MySQL
  3. Getting Up and Running with MySQL
  4. Installing MySQL on Windows
  5. Introduction to MySQL Interface
  6. Setting Up the MySQL Course Database
  7. Introduction to Course Database
  8. Working with SQL SELECT Statement
  9. Identify which Database by the USE statement
  10. SQL SELECT Statement Syntax
  11. Using the SELECT Statement to Retrieve Columns from a Table
  12. Using a Column Name Alias
  13. Removing Duplicate Values by Using the DISTINCT Statement
  14. Filtering SQL Data
  15. SQL WHERE Clause Syntax
  16. Filter Records based on Single Criteria using the WHERE Clause
  17. Filtering Text vs. Numeric Data
  18. Filtering with SQL AND Operator
  19. Filtering Date Values with the Between Operator
  20. Filtering with SQL OR Operator
  21. Sorting SQL Data
  22. SQL ORDER BY Keyword Syntax
  23. Sort SQL Data Ascending/Descending using the ORDER BY Keyword
  24. Sort SQL Data by Multiple Columns
  25. Grouping SQL Data
  26. SQL GROUP BY Syntax
  27. Grouping SQL Data by a Column Value
  28. QUICK TIP - DISTINCT VS. GROUP BY
  29. Performing Calculations within the Grouped Data
  30. Filtering Grouped Data with the SQL Having Clause
  31. Creating a MySQL Database
  32. Create a New Database in MySQL
  33. Using the DROP Statement to Delete a Database
  34. Adding Tables to the Database using the CREATE TABLE Statement
  35. Using the DROP Statement to Delete a Table
  36. SQL NOT NULL Constraint
  37. SQL AUTO_INCREMENT Column
  38. SQL PRIMARY KEY Constraint
  39. SQL FOREIGN KEY Constraint
  40. Inserting Records into SQL Database Tables
  41. SQL INSERT INTO Statement Syntax
  42. Inserting Data into Specific Columns of a Table
  43. Inserting Data into Every Column of a Table
  44. Querying Multiple Tables with a Relationship
  45. SQL Table JOIN Syntax
  46. SQL INNER JOIN
  47. SQL LEFT and RIGHT JOIN
  48. SQL IS NULL Value

 

Who should attend?

 

  1. Database developers: This course is essential for database developers who design, create, and maintain databases using MySQL.
  2. Data analysts: If you work with data, SQL with MySQL is a critical course for understanding how to retrieve, analyze, and transform data from MySQL databases.
  3. Software developers: SQL with MySQL is a valuable course for software developers who develop applications that interact with MySQL databases.
  4. Business intelligence professionals: SQL with MySQL is an essential course for business intelligence professionals who need to create reports and dashboards that require data from MySQL databases.
  5. System administrators: System administrators responsible for managing MySQL databases can benefit from learning SQL with MySQL.
  6. IT professionals: IT professionals who work with databases, including MySQL, can benefit from this course to advance their database skills.
  7. Students: Students pursuing computer science or data-related degrees can gain valuable knowledge of SQL with MySQL to support their academic and career aspirations.

 

 

Learning Outcomes:

 

  1. Understanding the fundamentals of SQL: Learning SQL with MySQL helps you learn the basics of Structured Query Language (SQL), which is a widely used database programming language.
  2. Familiarizing with MySQL: MySQL is an open-source relational database management system that is widely used in web applications. Learning SQL with MySQL helps you get hands-on experience with MySQL and its features.
  3. Creating and manipulating databases: SQL is used for creating and managing databases. With MySQL, you will learn how to create and manage databases, tables, and columns.
  4. Retrieving data: SQL is primarily used for retrieving data from databases. You will learn how to write SQL queries to retrieve data from MySQL databases.
  5. Sorting and filtering data: You will learn how to sort and filter data using SQL queries.
  6. Aggregating data: You will learn how to group and aggregate data using SQL functions.
  7. Joining tables: You will learn how to join multiple tables to retrieve data from related tables.
  8. Modifying data: You will learn how to modify data in a MySQL database using SQL statements.
  9. Managing database security: You will learn how to manage user accounts and database security using MySQL.
  10. Preparing for data analytics: SQL is a fundamental skill required for data analytics. Learning SQL with MySQL will prepare you for data analytics and other data-related roles.

 

End of Course

After completion of the course students must undertake the exam. Once the exam is passed, it is considered as end of the course.

 

Format
Self-paced online — the lessons open as soon as you enrol
Assessment
Final Exam: 30 questions, 70% pass mark, 45 minutes
Exam attempts
5
Certificate
Skedmia Certificate of Training, valid for 1 year and verifiable at skedmia.com/verify
Access
Lifetime access with a one-time payment

Course content

Final Exam30 questions · pass mark 70% · 45 min
CertificateOF TRAINING

What you earn

A certificate anyone can verify in seconds

Score 70% or better on the final exam and Skedmia issues your Certificate of Training with a unique certificate number. Every certificate carries a QR code that resolves to our public register, so an employer or auditor can confirm it is genuine without contacting anyone. Certificates state a validity of 1 year from issue and can be renewed.

Verified at skedmia.com/verify

Certified byExemplar Global

Before you enrol

How is the course delivered?

Entirely online and self-paced. Once you enrol, the lessons open immediately in your Skedmia account on any device, and you can stop and resume whenever you like.

How do I earn the certificate?

Complete the lessons, then sit the 30-question final exam. Score 70% or more and your Certificate of Training is issued straight away with a unique certificate number and QR code. The PDF downloads from your account.

What happens if I don't pass?

You have 5 attempts at the exam. Review the lessons between attempts; each one is marked immediately.

How does an employer verify my certificate?

Every certificate carries a QR code and a certificate number. Scanning the code, or entering the number on our verification page, returns the holder’s name, the course and the issue date. No account is needed.

How can I pay?

By card through our secure Stripe checkout, with access opening instantly. Or by bank transfer: we show our account details and an order reference, you send the receipt, and the course opens once the payment is verified.

Can I enrol a team?

Yes. Organisations enrol staff as a cohort, follow progress on a manager dashboard and receive completion reports formatted for an audit file. See corporate training or send an enquiry.

For organisations

Training a whole team on this course?

Enrol staff as a cohort, follow progress from one dashboard and receive completion reports ready for your audit file.