Introduction to SQL

Introduction to SQL Courseware (SQL101)

Microsoft SQL ServerMicrosoftDataSQL

The Introduction to SQL course offers a comprehensive exploration of the fundamentals of SQL, a powerful query language used to interact with relational databases. Students will learn about the history of SQL, relational databases, popular database systems, and basic SQL statements. The course guides learners through simple SELECT statements, advanced SELECT queries, and the use of subqueries, joins, and unions. Additionally, students will explore conditional processing with CASE and learn how to insert, update, and delete records. Throughout the course, practical examples and hands-on exercises are used to reinforce learning and help students apply their knowledge to real-world scenarios.

Publisher: Webucator

Benefits

  1. 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.
  2. Practical examples: The course uses real-world examples and scenarios to help students understand how to apply SQL concepts in practice.
  3. Hands-on learning: Students will engage in hands-on exercises and activities to reinforce their learning and gain practical experience in working with SQL.
  4. Engaging content: The course is designed to be engaging and easy to follow, ensuring that students remain interested and focused throughout their learning experience.
  5. Experienced authors: This courseware is authored by experts in the field of SQL, ensuring that the content is both accurate and up-to-date.

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.

Skillable Lab

Outline

  1. Relational Database Basics
    1. Brief History of SQL
    2. Relational Databases
    3. Popular Databases
    4. SQL Statements
  2. Simple SELECTs
    1. Introduction to the Northwind Database
    2. Some Basics
    3. SELECTing All Columns in All Rows
    4. Exploring the Tables (Exercise)
    5. SELECTing Specific Columns
    6. SELECTing Specific Columns (Exercise)
    7. Sorting Records
    8. Sorting Results (Exercise)
    9. The WHERE Clause and Operator Symbols
    10. Using the WHERE Clause to Check for Equality or Inequality (Exercise)
    11. Checking for Greater or Less Than
    12. Using the WHERE Clause to Check for Greater or Less Than (Exercise)
    13. Checking for NULL
    14. Checking for NULL (Exercise)
    15. WHERE and ORDER BY
    16. Using WHERE and ORDER BY Together (Exercise)
    17. Checking Multiple Conditions with Boolean Operators
    18. Writing SELECTs with Multiple Conditions (Exercise)
    19. The WHERE Clause and Logical Operator Keywords
    20. More SELECTs with WHERE (Exercise)
  3. Advanced SELECTs
    1. Calculated Fields
    2. Calculating Fields (Exercise)
    3. Aggregate Functions and Grouping
    4. Working with Aggregate Functions (Exercise)
    5. Selecting Distinct Records
    6. Built-in Data Manipulation Functions
    7. Data Manipulation Functions (Exercise)
  4. Subqueries, Joins and Unions
    1. Subqueries
    2. Subqueries (Exercise)
    3. Joins
    4. Using Joins (Exercise)
    5. Outer Joins
    6. Unions
    7. Working with Unions (Exercise)
  5. Conditional Processing with CASE
    1. Using CASE
    2. Working with CASE (Exercise)
  6. Inserting, Updating and Deleting Records
    1. INSERT
    2. Inserting Records (Exercise)
    3. UPDATE
    4. DELETE
    5. Updating and Deleting Records (Exercise)

Required Prerequisites

None

License

Length: 2 days | $70.00 per copy
Labs: Add-on available | $35.46 per lab
View Lab Details

LicenseRequest More InformationDownload Sample CopyRequest Trainer Evaluation Copy
What is Included?
  • Student Manual
  • Student Class Files
  • PowerPoint Presentation
  • Labs (optional add-on)
    Courseware Tracks

    This course is included in the following tracks: