protim

Hasura’s SQL Server Course for Frontend Developers

Protim's photo
Protim
·

2 min read

Hasura gives you instant GraphQL and REST APIs on your data. These data sources can be databases like Postgres, MySQL, SQL Server, and BigQuery.

But Hasura realized that a lot of frontend developers were not exactly fluent in the databases that Hasura worked with. The feedback from the Hasura community was that courses on these databases would be most welcome.

Hasura now has a course on Microsoft SQL Server that will help one understand the key features of MSSQL server, learn how to use them and when to use them, while laying the foundation for learning more advanced concepts in the future.

Here's the list of contents; please use it to go directly to the section that you need:

  1. Introduction to SQL Server
  2. What is MSSQL Server?
  3. Installation
  4. Installing SQL Server on Windows
  5. Installing SQL Server on Linux
  6. Installing SQL Server on Mac
  7. Setting up SQL Server on Azure SQL
  8. Core Concepts
  9. Database Concepts
  10. SQL Types
  11. MSSQL Constraints
  12. T-SQL Statements
  13. Transact-SQL Data Types
  14. T-SQL Database
  15. T-SQL Table
  16. T-SQL SELECT
  17. T-SQL UPDATE
  18. T-SQL DELETE
  19. T-SQL Alter Table
  20. Restore Database
  21. JOINS (MS SQL Server)
  22. Views
  23. Entity Relationship Model(ER model)
  24. Functions - SQL Server
  25. Create user-defined function (T-SQL)
  26. SQL Server database backup
  27. SQL Server Performance Tuning
  28. MS SQL Limitations
  29. Azure SQL Database limitations
  30. SQL Server Indexes
SQL ServercourseFrontend DevelopmentTutorial