SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Course details

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