Beginners Guide to Developing SQL Queries for SQL Server
4.6 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,111 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Beginners Guide to Developing SQL Queries for SQL Server to your Wishlist.

Add to Wishlist

Beginners Guide to Developing SQL Queries for SQL Server

Learn to Summarise data using aggregation and Query multiple tables
4.6 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,111 students enrolled
Last updated 4/2017
English
Current price: $10 Original price: $155 Discount: 94% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Retrieve data from multiple tables
  • Filter data
  • Remove Duplicate Data
  • Update Data
  • Add Data
  • Delete Data
View Curriculum
Requirements
  • You should have an understanding of database concepts
  • You should be comfortable using a computer
Description

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.

 

Who is the target audience?
  • Beginner Database Administrators
  • Data Analyst
  • Data Scientist
  • Students new to SQL and SQL Server
Students Who Viewed This Course Also Viewed
Curriculum For This Course
34 Lectures
04:07:10
+
Setting Up Your Test Environment
6 Lectures 25:29




Download adventureworks 2014 database
05:06

Install adventureworks 2014 database
04:14
+
SQL Fundamentals
16 Lectures 02:18:29
Retrieving data with SELECT
12:53

Using Aliases
07:12

Using Case Expressions
12:15

Retrieving data from a view
09:10

Eliminate duplicates
06:42

Filtering data with equality filters
13:35

Filtering data with basic comparisons
06:07

Filtering data with string comparisons
11:22

Filtering data with logical comparisons
14:08

Filtering data with NULL comparisons
04:35

Using order by clause
03:02

Sorting data by acending order
04:34

Sorting data by multiple columns
05:09

Adding new records
10:34

Updating existing records
09:18

Deleting records
07:53
+
Implementing various types of joins
5 Lectures 33:48
Introduction
00:27

Why Join tables
00:49

Inner joins
10:36

Left outer joins
12:26

Right Outer joins
09:30
+
Summarising data with aggregate functions
7 Lectures 49:24
COUNT
09:24

SUM
07:17

AVG
07:52

MIN
06:50

MAX
06:49

Grouping data
08:10

ORDER BY Clause
03:02
About the Instructor
Bluelime Learning Solutions
4.0 Average rating
1,559 Reviews
35,114 Students
85 Courses
Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.