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.

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

LicenseRequest More InformationDownload Sample CopyRequest Trainer Evaluation Copy
What is Included?
  • Student Manual
  • Student Class Files
  • PowerPoint Presentation
    Courseware Tracks

    This course is included in the following tracks: