Querying Data with Transact-SQL

Querying Data with Transact-SQL, available at $39.99, has an average rating of 4.2, with 25 lectures, based on 56 reviews, and has 16189 subscribers.

You will learn about Query and filter data Query and sort data Query data with Aggregate Functions Install SQL Server Install Sample Database This course is ideal for individuals who are Beginners to Microsoft SQL Server or Beginners to T-SQL It is particularly useful for Beginners to Microsoft SQL Server or Beginners to T-SQL.

Enroll now: Querying Data with Transact-SQL

Summary

Title: Querying Data with Transact-SQL

Price: $39.99

Average Rating: 4.2

Number of Lectures: 25

Number of Published Lectures: 25

Number of Curriculum Items: 25

Number of Published Curriculum Objects: 25

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Query and filter data

Query and sort data

Query data with Aggregate Functions

Install SQL Server

Install Sample Database

Who Should Attend

Beginners to Microsoft SQL Server

Beginners to T-SQL

Target Audiences

Beginners to Microsoft SQL Server

Beginners to T-SQL

SQL Server is a relational database management system, or RDBMS, developed and marketed by Microsoft.

Similar to other RDBMS software, SQL Server is built on top of SQL, a standard programming language for interacting with the relational databases. SQL server is tied to Transact-SQL, or T-SQL, the Microsoft’s implementation of SQL that adds a set of proprietary programming constructs.

What is SQL?

SQL stands for Structured Query Language

SQL lets you access and manipulate databases

SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987

SQL is a standard language for accessing and manipulating databases.

What is SQL?

SQL stands for Structured Query Language

SQL lets you access and manipulate databases

SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987

What Can SQL do?

SQL can execute queries against a database

SQL can retrieve data from a database

SQL can insert records in a database

SQL can update records in a database

SQL can delete records from a database

SQL can create new databases

SQL can create new tables in a database

SQL can create stored procedures in a database

SQL can create views in a database

SQL can set permissions on tables, procedures, and views

In this course we are going to query data from a sample database installed inside Microsoft SQL Server  using T-SQL

Topics Covered include:

Filtering Data

Sorting Data

Aggregate Functions

Course Curriculum

Chapter 1: Installing Microsoft SQL Server

Lecture 1: Overview of Querying Data with Transact-SQL

Lecture 2: Introduction

Lecture 3: What is T-SQL

Lecture 4: What is SQL Server

Lecture 5: Hardware and Software Requirements

Lecture 6: Download Microsoft SQL Server Developer Edition

Lecture 7: Installing Microsoft SQL Server Developer Edition

Lecture 8: Installing SSMS

Lecture 9: Connecting to Microsoft SQL Server with SSMS

Lecture 10: Install Sample Database

Chapter 2: Filtering Data

Lecture 1: Introduction

Lecture 2: Filtering with comparison operators

Lecture 3: Filtering with logical operators

Lecture 4: Filtering NULL Values

Chapter 3: Sorting Data

Lecture 1: Introduction

Lecture 2: ORDER BY Clause

Lecture 3: Sorting in ascending order

Lecture 4: Sorting in descending order

Lecture 5: Sorting multiple columns

Chapter 4: Aggregate Functions

Lecture 1: Introduction

Lecture 2: Max Function

Lecture 3: Min Function

Lecture 4: SUM Function

Lecture 5: Count Function

Lecture 6: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 0 votes

2 stars: 1 votes

3 stars: 11 votes

4 stars: 22 votes

5 stars: 22 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!