20  SQL introduction

20.1 Lesson contents

  • introduction SQL
  • introduction to SQL dialects like Transact-SQL
  • SELECT : querying one table
  • Data Modification Language (Insert,Update,Delete)
  • Using JOINs to query two or more tables
  • SET Operations
  • Functions
  • Group By
  • Subqueries
  • APPLY
  • Virtual Tables (Views,WITH,Temp Tables)
  • Grouping Sets and Pivot Tables

20.2 SQL knowledge among developers

SQL knowledge among developers

20.3 Database Schema Object Names

  • [Server Name].[Database Name].[Schema Name].Object Name
  • [Database Name].[Schema Name].Object Name
  • [Schema Name].Object Name
  • Object Name

20.3.1 Schema Object names 2

  • The best practice is to use the schema name by appending it. Example Sales.SalesPerson
  • I recommend not giving the same name to the schema and the objects. (Although Microsoft has not followed this)

Schema Example SQL Server