Introduction to SQL Courseware (SQL101)

This course is intended for individuals who want to develop foundational knowledge and practical skills in the subject, whether for professional development or career advancement.

In this course participants will learn:

• Comprehensive coverage: The course covers all essential aspects of SQL, from basic concepts to advanced techniques, ensuring students gain a strong foundation in SQL and relational databases.
• Practical examples: The course uses real-world examples and scenarios to help students understand how to apply SQL concepts in practice.
• Hands-on learning: Students will engage in hands-on exercises and activities to reinforce their learning and gain practical experience in working with SQL.
• Engaging content: The course is designed to be engaging and easy to follow, ensuring that students remain interested and focused throughout their learning experience.
• Experienced authors: This courseware is authored by experts in the field of SQL, ensuring that the content is both accurate and up-to-date.

1- Relational Database Basics

• Brief History of SQL
• Relational Databases
• Popular Databases
• SQL Statements

2- Simple SELECTs

• Introduction to the Northwind Database
• Some Basics
• SELECTing All Columns in All Rows
• Exploring the Tables (Exercise)
• SELECTing Specific Columns
• SELECTing Specific Columns (Exercise)
• Sorting Records
• Sorting Results (Exercise)
• The WHERE Clause and Operator Symbols
• Using the WHERE Clause to Check for Equality or Inequality (Exercise)
• Checking for Greater or Less Than
• Using the WHERE Clause to Check for Greater or Less Than (Exercise)
• Checking for NULL
• Checking for NULL (Exercise)
• WHERE and ORDER BY
• Using WHERE and ORDER BY Together (Exercise)
• Checking Multiple Conditions with Boolean Operators
• Writing SELECTs with Multiple Conditions (Exercise)
• The WHERE Clause and Logical Operator Keywords
• More SELECTs with WHERE (Exercise)

3- Advanced SELECTs

• Calculated Fields
• Calculating Fields (Exercise)
• Aggregate Functions and Grouping
• Working with Aggregate Functions (Exercise)
• Selecting Distinct Records
• Built-in Data Manipulation Functions
• Data Manipulation Functions (Exercise)

4- Subqueries, Joins and Unions

• Subqueries
• Subqueries (Exercise)
• Joins
• Using Joins (Exercise)
• Outer Joins
• Unions
• Working with Unions (Exercise)

5- Conditional Processing with CASE

• Using CASE
• Working with CASE (Exercise)

6- Inserting, Updating and Deleting Records

• INSERT
• Inserting Records (Exercise)
• UPDATE
• DELETE
• Updating and Deleting Records (Exercise)

No prior experience is required; however, a basic understanding of databases and data concepts is recommended.

Full Lab Environment Add-On:

Enhance and simplify your classes by providing an unparalleled learning platform that requires no setup. Your trainers and students can dive straight into a fully-prepared lab environment with just a click. This seamless integration means no time wasted on installations or configurations, allowing trainers and students to focus solely on the task at hand. The lab comes pre-loaded with all the necessary tools and resources, ensuring a smooth, hassle-free learning experience.