Duration
2 day
Course Overview
SQL training is equips professionals with skills to manage and analyze vast amounts of data. By extracting data from various sources, SQL enables the processing and visualization of information, leading to improved customer experiences, product quality, and energy efficiency. Big data techniques in manufacturing allow for predictive maintenance and proactive decision-making, anticipating product or equipment failures. Mastering SQL is essential for leveraging these data-driven insights and driving the innovations of Industry 4.0.
Course Objectives:
In this course, you will compose SQL queries to retrieve desired information from a database. After the session, you should be able to:
- Demonstrate the ability to connect to the SQL Server database.
- Execute a simple query.
- Apply a search condition in a simple query.
- Apply various functions to perform calculations on data.
- Organise the data obtained from a query before it is displayed on-screen.
- Demonstrate the ability to retrieve data from multiple tables.
- Demonstrate the ability to export the results of a query.
Module 1: SQL - An Overview
Relational Databases
Overview on SQLite
Using SQL Studio
Module 2: Creating Databases
Designing databases
Primary keys
Indexing fields
Columns/Fields data types
Module 3: Queries
Writing queries
Indentation and case
Setting criteria using WHERE
Wildcards
Setting criteria for dates
Dealing with nulls
Module 4: Exporting
Results, text and grid options
Copying and pasting column headings
Exporting using SQL & the menu
Module 5: Calculations
Calculated columns
Aliases
String functions and concatenation
Using Date Function
Module 6: Aggregation and grouping
SUM, AVG, MIN, MAX
Counts
Grouping by fields
Using HAVING to filter results
SUM, AVG, MIN, MAX
Counts
Grouping by fields
Using HAVING to filter results
Module 7: Joins
Inner joins
Table aliases
Left and right outer joins
Cross joins
Full outer joins
Self joins
Module 8: More Advanced Queries
Union and Union All
Using Subqueries
Subquery Best Practices and Considerations
Module 9: SQL Best Practices and Optimizations
What to do and not to do when writing SQL queries?
Using CTEs (Common Table Expressions)
Programme scope, delivery arrangements and suitability are confirmed during enquiry.