Course Details

SQL - The Language of Data

SQL - The Language of Data

15-25 hours

You'll be given your own personal database to use through both Lumivate's web portal, and the industry-standard SSMS editor. We'll guide you through creating virtually any data query in SQL Server, all without any prior knowledge.

Modules

  • What is SQL?
  • Setting Up SSMS and Lumivate Tooling
  • Querying Data with SELECT
  • Filtering, Sorting, and Limiting Results
  • Data Types and Modifying Data
  • Creating Tables and Constraints
  • Aggregates and GROUP BY
  • Joining Tables
  • Table Relationships
  • Views
  • Stored Procedures
  • Indexes
  • Exercise Review
  • Wrap-up and Next Steps