Querying Microsoft SQL Server 2014 alaptanfolyam
- Overview: Querying Microsoft SQL Server 2014 - Overview
- Overview: Introduction to Microsoft SQL Server 2014
- Lesson 1: The Basic Architecture of SQL Server
- Lesson 2: SQL Server Editions and Versions
- Lesson 3: Getting Started with SQL Server Management Studio
- Lab 1: Working with SQL Server 2014 Tools
- Overview: Introduction to T-SQL Querying
- Lesson 1: Introducing T-SQL
- Lesson 2: Understanding Sets
- Lesson 3: Understanding Predicate Logic
- Lesson 4: Understanding the Logical Order of Operations in SELECT Statements
- Lab 2: Introduction to T-SQL Querying
- Overview: Writing SELECT Queries
- Lesson 1: Writing Simple SELECT Statements
- Lesson 2: Eliminating Duplicates with DISTINCT
- Lesson 3: Using Column and Table Aliases
- Lesson 4: Writing Simple CASE Expressions
- Lab 3: Writing Basic SELECT Statements
- Overview: Querying Multiple Tables
- Lesson 1: Understanding Joins
- Lesson 2: Querying with Inner Joins
- Lesson 3: Querying with Outer Joins
- Lesson 4: Querying with Cross Joins and Self Joins
- Lab 4: Querying Multiple Tables
- Overview: Sorting and Filtering Data
- Lesson 1: Sorting Data
- Lesson 2: Filtering Data with Predicates
- Lesson 3: Filtering Data with TOP and OFFSET-FETCH
- Lesson 4: Working with Unknown Values
- Lab 5: Sorting and Filtering Data
- Overview: Working with SQL Server 2014 Data Types
- Lesson 2: Working with Character Data
- Lesson 1: Introducing SQL Server 2014 Data Types
- Lesson 3: Working with Date and Time Data
- Lab 6: Working with SQL Server 2014 Data Types
- Overview: Using DML to Modify Data
- Lesson 1: Adding Data to Tables
- Lesson 2: Modifying and Removing Data
- Lesson 3: Generating Numbers
- Lab 7: Using DML to Modify Data
- Overview: Using Built-In Functions
- Lesson 4: Using Functions to Work with NULL
- Lesson 3: Using Logical Functions
- Lesson 2: Using Conversion Functions
- Lesson 1: Writing Queries with Built-In Functions
- Lab 8: Using Built-In Functions
- Overview: Grouping and Aggregating Data
- Lesson 1: Using Aggregate Functions
- Lesson 2: Using the GROUP BY Clause
- Lesson 3: Filtering Groups with HAVING
- Lab 9: Grouping and Aggregating Data
- Overview: Using Subqueries
- Lesson 1: Writing Self-Contained Subqueries
- Lesson 2: Writing Correlated Subqueries
- Lesson 3: Using the EXISTS Predicate with Subqueries
- Lab 10: Using Subqueries
Az oktatóról
