Beginners Guide to Developing SQL Queries for SQL Server

Beginners Guide to Developing SQL Queries for SQL Server, available at $19.99, has an average rating of 4.25, with 35 lectures, based on 19 reviews, and has 1175 subscribers.

You will learn about Retrieve data from multiple tables Filter data Remove Duplicate Data Update Data Add Data Delete Data This course is ideal for individuals who are Beginner Database Administrators or Data Analyst or Data Scientist or Students new to SQL and SQL Server It is particularly useful for Beginner Database Administrators or Data Analyst or Data Scientist or Students new to SQL and SQL Server.

Enroll now: Beginners Guide to Developing SQL Queries for SQL Server

Summary

Title: Beginners Guide to Developing SQL Queries for SQL Server

Price: $19.99

Average Rating: 4.25

Number of Lectures: 35

Number of Published Lectures: 35

Number of Curriculum Items: 35

Number of Published Curriculum Objects: 35

Original Price: $129.99

Quality Status: approved

Status: Live

What You Will Learn

Retrieve data from multiple tables
Filter data
Remove Duplicate Data
Update Data
Add Data
Delete Data

Who Should Attend

Beginner Database Administrators
Data Analyst
Data Scientist
Students new to SQL and SQL Server

Target Audiences

Beginner Database Administrators
Data Analyst
Data Scientist
Students new to SQL and SQL Server

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.

�

Course Curriculum

Chapter 1: Setting Up Your Test Environment

Lecture 1: Introduction

Lecture 2: Hardware and Software Requirements

Lecture 3: Download SQL Server

Lecture 4: Install SQL Server

Lecture 5: Download adventureworks 2014 database

Lecture 6: Install adventureworks 2014 database

Chapter 2: SQL Fundamentals

Lecture 1: Retrieving data with SELECT

Lecture 2: Using Aliases

Lecture 3: Using Case Expressions

Lecture 4: Retrieving data from a view

Lecture 5: Eliminate duplicates

Lecture 6: Filtering data with equality filters

Lecture 7: Filtering data with basic comparisons

Lecture 8: Filtering data with string comparisons

Lecture 9: Filtering data with logical comparisons

Lecture 10: Filtering data with NULL comparisons

Lecture 11: Using order by clause

Lecture 12: Sorting data by acending order

Lecture 13: Sorting data by multiple columns

Lecture 14: Adding new records

Lecture 15: Updating existing records

Lecture 16: Deleting records

Chapter 3: Implementing various types of joins

Lecture 1: Introduction

Lecture 2: Why Join tables

Lecture 3: Inner joins

Lecture 4: Left outer joins

Lecture 5: Right Outer joins

Chapter 4: Summarising data with aggregate functions

Lecture 1: COUNT

Lecture 2: SUM

Lecture 3: AVG

Lecture 4: MIN

Lecture 5: MAX

Lecture 6: Grouping data

Lecture 7: ORDER BY Clause

Lecture 8: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 0 votes
2 stars: 2 votes
3 stars: 0 votes
4 stars: 8 votes
5 stars: 9 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!

Menu