SQL Server 101 : Microsoft SQL Server for Absolute Beginners
- 3.1
4 hours on-demand video
$
12.99
Brief Introduction
A *** MUST HAVE *** to get you quickly started with SQL Server regardless of the version you are working with !Description
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
Requirements
- Requirements
- NO PRIOR DATABASE OR SQL experience is required.
- You need High speed Internet connection with a PC.