SQL - Introduction to SQL with MySQL

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.