SQL for Developers and Analysts with MS SQL Server

  • Overview
  • Curriculum
  • Instructor
  • Review

About This Course

Guide for beginners to intermediate using real life examples

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.

  • 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

Course Curriculum

1 Lectures

Instructor

Profile photo of Biz Nigatu
Biz Nigatu

Biz. 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...

Review
4.9 course rating
4K ratings
ui-avatar of Jyotirmayee Mallick
Jyotirmayee M.
4.0
1 year ago

The course was very nice and I have learnt a lot and will explore more from these topics.

  • Helpful
  • Not helpful
ui-avatar of Audrey
Audrey
5.0
1 year ago

It's the best course and the lecture explains very well.

  • Helpful
  • Not helpful
ui-avatar of Ronel Vermaak
Ronel V.
1.0
2 years ago

The English is not spoken in an eloquent way and the speaker's accent is making it difficult to follow.

The Queries from section 35 uses concepts that were not handled yet.. eg. Join etc.

  • Helpful
  • Not helpful
ui-avatar of Harsh Tyagi
Harsh T.
5.0
2 years ago

Easy explanation

  • Helpful
  • Not helpful
ui-avatar of Sufiyan Akhtar
Sufiyan A.
3.0
3 years ago

The subtitles aren't accurate. The practice questions arent in line with the content taught in a particular section. The solutions for the practice questions are much more complicated and dont align with what is taught in a particular module.

  • Helpful
  • Not helpful
ui-avatar of Pantham Satya Srinivas
Pantham S. S.
3.0
3 years ago

the voice is not clear and bit fast

  • Helpful
  • Not helpful
ui-avatar of Desbele
Desbele
4.5
3 years ago

a lot of important topics are covered

  • Helpful
  • Not helpful
ui-avatar of Renganathan K
Renganathan K.
3.0
4 years ago

Some of the sections were covered too fast.

  • Helpful
  • Not helpful
ui-avatar of Traore Amadou
Traore A.
4.5
4 years ago

GREAT COURSE
THANKS TO INSTRUCTOR

  • Helpful
  • Not helpful
ui-avatar of Brian Prosper Chando
Brian P. C.
5.0
4 years ago

The voice projection could be better but yes, this was above what i thought i could learn in a small course

  • Helpful
  • Not helpful
Leave A Reply

Your email address will not be published. Required fields are marked *

Ratings

Courses You May Like

Lorem ipsum dolor sit amet elit
Show More Courses