Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 41 Minute(s)
Language
English
Taught by
Biz Nigatu
Rating
Course Overview
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.
Course Content
- 11 section(s)
- 72 lecture(s)
- Section 1 Welcome!
- Section 2 Introduction
- Section 3 SELECT and ORDER BY clauses
- Section 4 WHERE Clause
- Section 5 GROUP BY and HAVING Clauses
- Section 6 FROM Clause
- Section 7 Create Tables, Relationships and Views
- Section 8 Joins
- Section 9 INSERT, UPDATE, and DELETE Data
- Section 10 Advanced Topics
- Section 11 What is Next?
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
Skills covered in this course
Reviews
-
JJyotirmayee Mallick
The course was very nice and I have learnt a lot and will explore more from these topics.
-
MMae Lu
Basic SQL topics are covered for beginners, advanced topics are interesting. But almost all of the videos are blurry...
-
ssharad borde
The concepts are mostly explained superficially, and most of the things are not explained.
-
JJamaine Earnest
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.
