تفاصيل الدورة

In this course you will learn:

  • Start from scratch by installing Microsoft SQL Server Express edition
  • Requirements for installing Microsoft SQL Server
  • Core concepts of RDBMS
  • Comparison of MS SQL Server with Oracle, IBM etc.
  • Getting around SQL Server Management Studio
  • Details of System databases
  • Constructing SELECT statement starting with literals
  • Using FROM clause
  • Working with columns specified in the SELECT LIST
  • Using WHERE clause
  • Using ORDER BY clause
  • Using BETWEEN / NOT BETWEEN operator
  • Using IN / NOT IN operator
  • Pattern matching using LIKE operator and wild card characters
  • Working with NULL
  • Using string functions including concatenation
  • Using Date functions
  • SQL Server System functions
  • Working with JOINS - INNER / LEFT OUTER / RIGHT OUTER / FULL OUTER / CROSS JOIN
  • Working with UNION / UNION ALL
  • A look at sub queries
  • Duplicate rows - DISTINCT / ALL predicates
  • Aggregate functions
  • Using GROUP BY clause 
  • Using HAVING clause
تحديث بتاريخ 31 December, 2017
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على SQL Server ابتداءً من الآن. See all courses

قيِم هذه الصفحة