SQL for Developers and Analysts with MS SQL Server
3.8 (264 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
9,070 students enrolled

SQL for Developers and Analysts with MS SQL Server

Guide for beginners to intermediate using real life examples
3.8 (264 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
9,070 students enrolled
Created by Biz Nigatu
Last updated 4/2020
English
English [Auto-generated]
Current price: $16.99 Original price: $24.99 Discount: 32% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 19 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Hands-on learning of SQL and databases using Microsoft SQL Server
  • Download a free copy of SQL Server 2017 Edition and setting up a working environment
  • A basic structure of a SQL query structure
  • Different SQL clauses in a way that will make more sense for you to follow
  • Create various objects in SQL Server including tables, views, functions, and stored procedures
  • Manage data in SQL Server and protect it
  • Query data, sort, restrict the output and build sub-queries
  • Manipulate data insert, delete and update works
  • Group and summarize your data
  • Advanced concepts in SQL and how you can be able to build reports using Excel, SSRS, and Tableau
  • Where to get help when you face errors and some career advice to work as a SQL developer or analyst
Course content
Expand all 71 lectures 03:41:52
+ Introduction
8 lectures 27:39
Section 1 - Introduction
00:44
What is a database?
00:58
What is the difference between different Editions of SQL Server?
01:33
How to Installing MS SQL Server and SSMS?
03:33
What an SSMS environment looks like? Important Short cuts
08:57
How/ Why comments in SQL?
03:39
Basic SQL query structure
02:35

This quiz measures how much you have learned from this section about what a database is and the basics of SQL

Quiz 1: Databases and SQL Basics
5 questions
+ SELECT and ORDER BY clauses
11 lectures 25:14
Section 2 - Introduction
00:37
How to use a basic SELECT clause?
01:46
How to select all columns ?
00:54
How to select some columns using column name and display only the top n values?
01:17
How to change column headings and perform mathematical operations in SELECT?
02:48
How to use other built in functions in SELECT clause?
01:24
Conditional evaluations in SELECT clause
02:50
How to filter duplicate in SELECT clause?
01:07
How to use a basic ORDER BY clause?
02:36
Section 2 - Exercise
01:24
Section 2 - Exercise solution
08:31

This quiz measures how much you have learned from this section about SELECT and ORDER BY clauses

Quiz 2: SELECT and ORDER BY Clauses in SQL
5 questions
+ WHERE Clause
9 lectures 28:39
How to use the basic WHERE clause?
01:32
How to handle different conditions in WHERE clause?
00:47
How to use Boolean operators AND, OR, NOT?
01:53
How to use LIKE operator to filter rows that match a certain pattern?
01:18
How to use IN operator in WHERE clause?
01:38
How to use BETWEEN operator in WHERE clause?
01:32
How to handle NULL in WHERE clause?
01:42

This quiz measures how much you have learned from this section about the WHERE clause

Quiz 3: WHERE Clause in SQL
5 questions
+ GROUP BY and HAVING Clauses
5 lectures 32:35
How to use a basic GROUP BY clause?
01:27
How to write sub queries combined with in GROUP BY clause? How to use aggregat
02:39
How to use aggregate functions in ORDER BY?
00:45
How to use a basic HAVING clause?
00:45

This quiz measures how much you have learned from this section about HAVING and GROUP BY clauses

Quiz 4: GROUP BY and HAVING Clauses in SQL
5 questions
+ FROM Clause
4 lectures 04:02
How to use a basic FROM clause?
00:55
How to use "AS" or table alias in FROM clause
00:36
Using simple JOIN
01:16
Execution order in SQL Server
01:15

This quiz measures how much you have learned from this section about the FROM clause

Quiz 5: FROM Clause in SQL
5 questions
+ Create Tables, Relationships and Views
8 lectures 35:01
CREATE TABLE
05:38
ALTER tables: add columns and change table name and DROP tables
02:36
How to Create Table Relationships and How to Creating a Database Diagram?
05:19
Constraints in SQL Server
03:36
Indexes in SQL Server
02:12
How to Create Views?
01:48

This quiz measures how much you have learned from this section about creating tables, views, relationships, SQL Server permissions.

Create Tables and Relationships
5 questions
+ Joins
7 lectures 18:31
How to use INNER JOIN or simply JOIN?
01:29
How to use LEFT OUTER JOIN and RIGHT OUTER JOIN?
02:14
What is FULL OUTER JOIN and CROSS JOIN?
02:02
How to use CROSS APPLY in FROM clause?
01:58
How to Use Set Operations UNION, INTERSECT and EXCEPT?
02:28
Type Casting
04:08

This quiz measures how much you have learned from this section about SQL joins.

Joins in SQL
5 questions
+ INSERT, UPDATE, and DELETE Data
5 lectures 11:35
Using a basic INSERT INTO, INSERT SELECT, and SELECT INTO to Create a New Table
03:42
Import data from external file
02:03
Using a basic UPDATE clause and UPDATE with WHERE clause
01:59
Using a basic DELETE clause and DELETE with WHERE clause
01:52

This quiz measures how much you have learned from this section about data manipulation in SQL.

Quiz 8: INSERT, UPDATE & DELETE data in SQL
5 questions
+ Advanced Topics
12 lectures 33:13
What is the purpose of using WITH(NOLOCK) in SQL Server?
03:17
What is a difference B/N UNION and UNION ALL in SQL Server?
01:21
How to use Variables and Table Variables in SQL Server?
02:38
How to use CURSORS in SQL Server?
03:19
How to use Transaction and safe DELETE in SQL Server?
02:44
How to create Functions in SQL Server?
02:27
How to create Stored Procedures in SQL Server?
03:18
Working with some of SQL Server built-in Functions
02:42
How to create Reports in Excel from data in SQL Server?
01:33
How to create SSRS Reports from data in SQL Server?
02:43
Requirements
  • A free Developer Edition of SQL Server 2017. (How to download and setup will be discussed in course)
  • A free copy of SQL Server Management Studio 2017. (How to download and setup will be discussed in course)
  • A computer running Windows Desktop or Windows Server:
  • - Operating System Requirements: Windows 8,8.1,10 or Windows Server 2012, 2016
  • - Memory: Minimum: 1 GB, Recommended: At least 4 GB
  • - Hard Disk: requires a minimum of 6 GB of available hard-disk space.
Description

This course will give you hands-on learning of SQL using Microsoft SQL Server. The course will teach you how you could download a free copy of SQL Server 2017 Edition from Microsoft website and set up your working environment. It will teach you various objects in SQL Server including tables, views, stored procedures. After providing you a basic structure of a SQL query structure, it will show different SQL clauses in a way that will make more sense for students to follow. It will give you a basic understanding of how you can manage your data and protect it. The course will show you how you can be able to query data, sort, restrict the output and build sub-queries. You will also understand how you can manipulate data insert, delete and update works. The course will teach how you can group and summarize your data. The course will briefly touch some advanced concepts and how you can be able to build reports using Excel, SQL Server Reporting Service, and Tableau. Finally, the course will show you can get help when while working as a SQL developer and some career advice to work as a SQL developer or analyst.

 

Who this course is for:
  • Any student who want to learn the basics of SQL and databases using SQL Server
  • Anyone preparing for a SQL developer or reporting analysist job interviews
  • Anyone who is has a desire to learn new skills in SQL
  • This course doesn't assume any prior knowledge of SQL or databases, and it will be perfect for beginners and intermediate SQL developers and analysts