Beginners Guide to Developing SQL Queries for SQL Server

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 4 Hours | Lec: 34 | 638 MB

Genre: eLearning | Language: English

Learn to Summarise data using aggregation and Query multiple tables

Microsoft SQL Server is robust relational database management system used by so many

organizations of various sizes including top fortune 100 companies.

SQL -Structural Query language is the language used to interrogate and manipulate

Microsoft SQL Server Databases.

This course is a beginners course that will walk you through how to develop queries

to execute on and SQL Server Database.

We will start by developing queries to :

Retrieve data with SELECT

Use Aliases

Use Case Expressions

Retrieve data from a view

Eliminate duplicates

Filter data with equality filters

Filter data with basic comparisons

Filter data with string comparisons

Filter data with logical comparisons

Filter data with NULL comparisons

Use order by clause

Sort data by ascending order

Sort data by multiple columns

Add new records

Update existing records

Delete records

There may be times when want to retrieve data from multiple tables and in course

we will do that using:

Inner joins

Left outer joins

Right Outer joins

We will also be Summarising data with aggregate functions such as:

COUNT

SUM

AVG

MIN

MAX

Grouping data

ORDER BY Clause

SQL forms the cornerstone of all relational database operations. Taking full advantage of its power requires an in-depth understanding of the language. In this course, you learn to use the full potential of SQL to write simple queries for SQL Server databases. You will gain the practical skills to choose the best query method to ensure accuracy and avoid common errors or pitfalls.