SQL for Developers and Analysts with MS SQL Server

Focused View

Biz Nigatu

3:36:45

73 View

1. Chapter 1

1. Welcome!.mp4

00:14

2. Introduction

1. Section 1 - Introduction.mp4

00:44

2.1 1-cia-factbook-schema.zip

2.2 2-cia-factbook-data.zip

2. Course resources.html

3. What is a database.mp4

00:58

4. What is the difference between different Editions of SQL Server.mp4

01:33

5. How to Installing MS SQL Server and SSMS.mp4

03:33

6. What an SSMS environment looks like Important Short cuts.mp4

08:57

7.1 1-cia-factbook-schema.zip

7.2 2-cia-factbook-data.zip

7. How to create the course sample database.mp4

05:40

8. How Why comments in SQL.mp4

03:39

9.1 lecture1.zip

9. Basic SQL query structure.mp4

02:35

10. Quiz 1 Databases and SQL Basics.html

3. SELECT and ORDER BY clauses

1. Section 2 - Introduction.mp4

00:37

2.1 lecture2.zip

2. How to use a basic SELECT clause.mp4

01:46

3. How to select all columns .mp4

00:54

4. Select all columns.html

5. How to select some columns using column name and display only the top n values.mp4

01:17

6. Select only some columns.html

7. How to change column headings and perform mathematical operations in SELECT.mp4

02:48

8. How to use other built in functions in SELECT clause.mp4

01:24

9. Conditional evaluations in SELECT clause.mp4

02:50

10. How to filter duplicate in SELECT clause.mp4

01:07

11. How to use a basic ORDER BY clause.mp4

02:37

12. Sort SQL result by a columns.html

13. Section 2 - Exercise.mp4

01:24

14.1 section2-excercise-solution.zip

14. Section 2 - Exercise solution.mp4

08:31

15. Quiz 2 SELECT and ORDER BY Clauses in SQL.html

4. WHERE Clause

1.1 lecture3.zip

1. How to use the basic WHERE clause.mp4

01:32

2. How to handle different conditions in WHERE clause.mp4

00:47

3. How to use Boolean operators AND, OR, NOT.mp4

01:53

4. How to use LIKE operator to filter rows that match a certain pattern.mp4

01:18

5. How to use IN operator in WHERE clause.mp4

01:38

6. How to use EXISTS operator in WHERE clause.mp4

03:38

7. How to use BETWEEN operator in WHERE clause.mp4

01:32

8. How to handle NULL in WHERE clause.mp4

01:42

9. Quiz 3 WHERE Clause in SQL.html

10.1 section3-excercise-solution.zip

10. Section 3 - Exercise solution.mp4

14:39

5. GROUP BY and HAVING Clauses

1.1 lecture4.zip

1. How to use a basic GROUP BY clause.mp4

01:27

2. How to write sub queries combined with in GROUP BY clause How to use aggregat.mp4

02:39

3. How to use aggregate functions in ORDER BY.mp4

00:45

4. How to use a basic HAVING clause.mp4

00:45

5.1 section4-excercise-solution.zip

5. Section 4 - Exercise solution.mp4

26:59

6. Quiz 4 GROUP BY and HAVING Clauses in SQL.html

6. FROM Clause

1.1 lecture5.zip

1. How to use a basic FROM clause.mp4

00:55

2. How to use AS or table alias in FROM clause.mp4

00:36

3. Using simple JOIN.mp4

01:17

4. Execution order in SQL Server.mp4

01:15

5. Quiz 5 FROM Clause in SQL.html

7. Create Tables, Relationships and Views

1.1 lecture6.zip

1. CREATE TABLE.mp4

05:38

2. ALTER tables add columns and change table name and DROP tables.mp4

02:36

3. How to Create Temporary Tables.mp4

04:18

4. How to Create Table Relationships and How to Creating a Database Diagram.mp4

05:19

5. Constraints in SQL Server.mp4

03:36

6. Indexes in SQL Server.mp4

02:12

7. How to Create Views.mp4

01:48

8. How to Grant and Revoke Permissions to Users in SQL Server.mp4

09:34

9. Create Tables and Relationships.html

8. Joins

1.1 lecture7.zip

1. How to use INNER JOIN or simply JOIN.mp4

01:29

2. How to use LEFT OUTER JOIN and RIGHT OUTER JOIN.mp4

02:14

3. What is FULL OUTER JOIN and CROSS JOIN.mp4

02:02

4. How to use Subqueries in FROM clause and join tables using a WHERE clause.mp4

04:12

5. How to use CROSS APPLY in FROM clause.mp4

01:58

6. How to Use Set Operations UNION, INTERSECT and EXCEPT.mp4

02:28

7. Type Casting.mp4

04:08

8. Joins in SQL.html

9. INSERT, UPDATE, and DELETE Data

1.1 lecture8.zip

1. Using a basic INSERT INTO, INSERT SELECT, and SELECT INTO to Create a New Table.mp4

03:42

2.1 Students.csv

2. Import data from external file.mp4

02:03

3. Using a basic UPDATE clause and UPDATE with WHERE clause.mp4

01:59

4. Using a basic DELETE clause and DELETE with WHERE clause.mp4

01:52

5. Using OUTPUT operator to log inserteddeleted data to a different table.mp4

01:59

6. Quiz 8 INSERT, UPDATE & DELETE data in SQL.html

10. Advanced Topics

1.1 lecture9.zip

1. What is the purpose of using WITH(NOLOCK) in SQL Server.mp4

03:17

2. What is a difference BN UNION and UNION ALL in SQL Server.mp4

01:21

3. How to use Variables and Table Variables in SQL Server.mp4

02:38

4. How to use CURSORS in SQL Server.mp4

03:19

5. How to use Transaction and safe DELETE in SQL Server.mp4

02:44

6. How to create Functions in SQL Server.mp4

02:27

7. How to create Stored Procedures in SQL Server.mp4

03:18

8. Working with some of SQL Server built-in Functions.mp4

02:42

9.1 SixthDatabase-bak.zip

9. How to BackupRestore Databases in SQL Server.mp4

02:05

10.1 Country-GDP-xlsx.zip

10. How to create Reports in Excel from data in SQL Server.mp4

01:33

11.1 Country-GDP-SSRS.zip

11. How to create SSRS Reports from data in SQL Server.mp4

02:43

12.1 Country-GDP-twbx.zip

12. How to create Tableau Reports from data in SQL Server.mp4

05:06

Description

Guide for beginners to intermediate using real life examples

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

Who is this 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

What You Need to Know?

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.

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

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.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.