SQL for Developers and Analysts with MS SQL Server (Udemy.com)

Guide for beginners to intermediate using real life examples

( 59 Reviews )

Created by: Biz Nigatu

Produced in 2021

What you will 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

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 76 / 100

Course 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 ServerAnyone preparing for a SQL developer or reporting analysist job interviewsAnyone who is has a desire to learn new skills in SQLThis course doesn't assume any prior knowledge of SQL or databases, and it will be perfect for beginners and intermediate SQL developers and analysts

Time: 3.5h

Instructor Details

Biz Nigatu

3.8 Rating
59 Reviews

Bizuayehu Nigatu is a founder of Reckoned Force an IT consulting. He is a Microsoft Certified Solution Expert for Business Intelligence. He is currently a Ph.D. student on specializing in big data analytics and working his dissertation research is on AI and deep neural networks. His former educational background includes Statistics, Economics, Computer Science and Database System Engineering. He has fourteen years of experience working in the technology industry. When he is not working he love to spend as much time as possible with his family, reading, painting and building small robots.

SQL Server - zapytania. Querying. Exam 70-761

SQL Server - zapytania. Querying. Exam 70-761 (2021)
4.8 (99 Reviews)

- Provider: Udemy
- Time: 5h

$11.99

Oracle Database 12c SQL Certified Associate 1Z0-071

Oracle Database 12c SQL Certified Associate 1Z0-071 (2021)
4.7 (336 Reviews)

- Provider: Udemy
- Time: 20h

$11.99

Introduction to Structured Query Language (SQL)

Introduction to Structured Query Language (SQL) (2017)
4.7 (313 Reviews)

- Provider: Coursera
- Time: 3h

Free

Learn C# With Windows Forms and SQL Server

Learn C# With Windows Forms and SQL Server (2021)
4.7 (269 Reviews)

- Provider: Udemy
- Time: 12.5h

$11.99

Microsoft Access SQL: SQL for Non-Programmers

Microsoft Access SQL: SQL for Non-Programmers (2021)
4.7 (240 Reviews)

- Provider: Udemy
- Time: 3.5h

$11.99

The Ultimate Oracle SQL Course (2021)
4.7 (237 Reviews)

- Provider: Udemy
- Time: 11.5h

$11.99

All sql courses

Reviews

3.8

59 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By sharad borde on 9/20/2020

The concepts are mostly explained superficially, and most of the things are not explained.

By Mae Lu on 9/9/2020

Basic SQL topics are covered for beginners, advanced topics are interesting. But almost all of the videos are blurry...

By Abdul Malik on 8/12/2020

yes,but need a brief explanation on stored procedures,triggers,dynamic sql,functions.

By Jorge Mena Sauterel on 8/2/2020

Really good course for Starting to learn the basics of SSMS and also to get into SQL.
The concepts are really clear for the short time of the sections.

By Indu Singh on 7/25/2020

Video quality is poor.
Voice and demonstration of by Mr Biz could be better.

By Jamaine Earnest on 6/25/2020

Exceeded expectations on the topics that were covered. The resource downloads were a great help with following the course. Especially learning SQL, it can be a challenge trying to watch and take notes. I really appreciate the time and effort in the prep work. I did however see some grammar errors but in comparison to other training modules, this is by far the best in organization, content and information.

By Frank Romero on 5/17/2020

1. Poor quality audio; 2. Not for beginners, 3.Not thorough when explaining just a quick review; 4.When talking it looks like a text to speech machine reading a script

By Reshma A on 5/13/2020

I recommend this course to all , who want to strengthen the important features/logic/topics/basics of SQL. Biz Nigatu has given very good examples for each and every topic taken. Appreciate your efforts for making us understand all the concepts. Thank you very much Biz Nigatu.

By Tsinu Taye on 5/12/2020