SQL Server 101 : Microsoft SQL Server for Absolute Beginners
Udemy
Course Summary
An absolute beginner’s tutorial to quickly learn Microsoft SQL Server from scratch using Management Studio and T SQL.
-
+
Course Description
- 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 JOINS
- Working with UNION / UNION ALL
- A look at sub queries
- Duplicate rows – DISTINCT / ALL predicates
- Aggregate functions
- Using GROUP BY clauseÂ
- Using HAVING clause
This course is listed under
Data & Information Management
Community
Related Posts: