Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Microsoft SQL Server 2019 – Querying SQL Server

Learn the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server.
5.0
5.0/5
(1 reviews)
27 students
Created by

9.7

CourseMarks Score®

9.9

Freshness

9.2

Feedback

9.3

Content

Platform: Udemy
Video: 10h 5m
Language: English
Next start: On Demand

Top Microsoft Certification courses:

Detailed Analysis

CourseMarks Score®

9.7 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness Score

9.9 / 10
This course was last updated on 3/2022.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Student Feedback

9.2 / 10
We analyzed factors such as the rating (5.0/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Content Score

9.3 / 10
Video Score: 9.1 / 10
The course includes 10h 5m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
Detail Score: 9.4 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 9.5 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

0 article.
0 resource.
0 exercise.
1 tests or quizzes.

Table of contents

Description

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server. You will learn how to write queries that return data from tables as well as create, update, or delete data in a database. These queries will allow filtering and sorting and effectively use the various data types provided by SQL Server. This course also covers the use of dynamic tables of various sorts which can allow a more sophisticated SQL user to hide implementation details from other end users accessing data from reporting tools. Finally, the course will provide details on the what and how of error handling and transaction management. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. The primary target audience for this course is: Database Administrators, Database Developers and BI professionals.

In this course, you will learn how to:

•Understand the similarities and differences between Transact-SQL and other computer languages.
•Write SELECT queries
•Query multiple tables
•Sort and filter data
•Describe the use of data types in SQL Server
•Modify data using Transact-SQL
•Use built-in functions
•Group and aggregate data
•Use subqueries
•Use table expressions
•Use set operators
•Use window ranking, offset and aggregate functions
•Implement pivoting and grouping sets
•Execute stored procedures
•Program with T-SQL
•Implement error handling
•Implement transactions

You will learn

✓ provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server.
✓ You will learn how to write queries that return data from tables as well as create, update, or delete data in a database.
✓ These queries will allow filtering and sorting and effectively use the various data types provided by SQL Server.
✓ The course will provide details on the what and how of error handling and transaction management.

Requirements

• None.

This course is for

• Any professional wanting to learn.

How much does the Microsoft SQL Server 2019 - Querying SQL Server course cost? Is it worth it?

The course costs $14.99. And currently there is a 25% discount on the original price of the course, which was $19.99. So you save $5 if you enroll the course now.

Does the Microsoft SQL Server 2019 - Querying SQL Server course have a money back guarantee or refund policy?

YES, Microsoft SQL Server 2019 – Querying SQL Server has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any SCHOLARSHIPS for this course?

Currently we could not find a scholarship for the Microsoft SQL Server 2019 - Querying SQL Server course, but there is a $5 discount from the original price ($19.99). So the current price is just $14.99.

Who is the instructor? Is Vision Training Systems Technology Institute Online dba a SCAM or a TRUSTED instructor?

Vision Training Systems Technology Institute Online dba has created 37 courses that got 58 reviews which are generally positive. Vision Training Systems Technology Institute Online dba has taught 397 students and received a 4.3 average review out of 58 reviews. Depending on the information available, Vision Training Systems Technology Institute Online dba is a TRUSTED instructor.
Creator of Technical and Creative Content
Vision Training Systems is a provider quality online educational products.
Vision focuses on providing corporations a high quality, customizable solution that gives their employees valuable training that can be done on the go, 24/7. Courses are built with a myriad of features, providing any type of learner with the style of training they need to excel.
Vision has become one of the fast growing companies in the IT training space by delivering the highest quality training in the marketplace.

9.7

CourseMarks Score®

9.9

Freshness

9.2

Feedback

9.3

Content

Platform: Udemy
Video: 10h 5m
Language: English
Next start: On Demand

Students are also interested in

Review widget (for course creators):

Microsoft SQL Server 2019 - Querying SQL Server rating
Code for the widget (just copy and paste it to your site):
<a href="https://coursemarks.com/course/microsoft-sql-server-2019-querying-sql-server/" target="_blank" title="Microsoft SQL Server 2019 – Querying SQL Server on Coursemarks.com"><img border="0" src="https://coursemarks.com/widget/97.svg" width="200px" alt="Microsoft SQL Server 2019 – Querying SQL Server rating"/></a>