Vind een opleiding

SQL Server 101 : Microsoft SQL Server for Absolute Beginners - Udemy

Doelgroep: Beginner
Duur: 45 colleges - 4 uur
Richtprijs: € 49,99
Taal: Engels
Aanbieder: Udemy

>> proefles

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


>> Meer info