SQL Development with MS SQL Server Beginner to Master

Other

Size

8.6 GB

Seeders

Leechers

Files

Category

Other

Added

05/07/23 at 3:27pm GMT+1

Status

Verified by VeriPLUS

Infohash

3930d8780f2dcb382d715acec2c7003441384134

Direct link Torrent file Download now

Description

Description

Learn how to understand and effectively write SQL Queries to interact with databases and build powerful datasets.

The whole course also only uses resources that are available to all operating systems so that you can follow along from Windows, Linux or MacOS.

Learning Path:

There are 3 different levels you will go through in your journey to becoming a SQL Expert.

The learning objectives below outline what you will learn and be able to do and understand at the end of each section.

Basics
Create resources
View, add and delete data stored in database tables
Filter, sort, summarize and aggregate data from tables
Intermediate
Combine data from different tables
Affect the way data is stored and accessed with indexes
Use built in SQL Functions to transform and format data
Advanced
Create indexes and understand how they work
Use window functions to access data from other rows in the dataset
Store query logic inside of stored procedures and access then with dynamic filters
Improve query performance with temporary tables and nested queries

If you are new to programming, or just new to SQL you will get a floor up explanation of everything you need to know to write clean and powerful SQL Queries and Datasets for Applications, Reporting, or Data Analysis.

If you already know some SQL, you will get a great reference for anything that is new to you!

By the end of the course your SQL toolbox will be full of great tools to transform, manage, and read data using Structured Query Language.
Who this course is for:

Anyone who want to learn about SQL (Structured Query Language)
Anyone interested in building datasets for Data Analysis, Reporting, or DataWarehouse management
Anyone Interested in persistent data storage for application development

Requirements

Must have basic computer skills, and a desire to learn SQL
Must have a computer to follow the course on

Last Updated 4/2023

File list

SQL Development with MS SQL Server Beginner to Master
.pad/0 724 B
.pad/1 347 B
.pad/2 949.7 KB
.pad/3 962.5 KB
.pad/4 937.2 KB
.pad/5 992.2 KB
TutsNode.net.txt 63 B
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/1. Introduction/1. Introduction.srt 4.6 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/1. Introduction/2. Install List.html 1.4 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/1. Introduction/3. Install.srt 20.1 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/1. Introduction/4. MacOSLinux SQL Server Install - Notes.html 1.9 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/1. Introduction/5. MacOSLinux SQL Server Install.mp4 212.1 MB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/1. Introduction/5. MacOSLinux SQL Server Install.srt 23.9 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/1. Introduction/6. Hotkeys and Macros.html 1.4 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/10. Congratulations!/1. Congratulations!.srt 2.2 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/2. SQL Basics Part 1/1. Basics Part 1 Theory.srt 9.9 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/2. SQL Basics Part 1/10. SELECT.srt 12 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/2. SQL Basics Part 1/11. UPDATE.srt 3.6 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/2. SQL Basics Part 1/12. ALTER TABLE.srt 19.5 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/2. SQL Basics Part 1/13. Custom Types.srt 10.8 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/2. SQL Basics Part 1/2. Windows Connect to the Database.srt 6.8 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/2. SQL Basics Part 1/3. CREATE DATABASE.srt 13.2 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/2. SQL Basics Part 1/4. CREATE SCHEMA.srt 6.1 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/2. SQL Basics Part 1/5. Scalar Variables notes.html 2.3 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/2. SQL Basics Part 1/6. Scalar Variables.mp4 473.3 MB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/2. SQL Basics Part 1/6. Scalar Variables.srt 50.8 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/2. SQL Basics Part 1/7. CREATE TABLE.mp4 198 MB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/2. SQL Basics Part 1/7. CREATE TABLE.srt 23 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/2. SQL Basics Part 1/8. DEFAULT & NULL.srt 8.4 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/2. SQL Basics Part 1/9. INSERT.srt 13.4 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/3. SQL Basics Part 2/1. Basics Part 2 Theory.srt 11 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/3. SQL Basics Part 2/10. TRUNCATE.srt 10.6 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/3. SQL Basics Part 2/2. Windows File Location.srt 4.3 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/3. SQL Basics Part 2/3. Mac Backup Restore.srt 11.5 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/3. SQL Basics Part 2/4. Windows Backup Restore.srt 4.6 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/3. SQL Basics Part 2/5. TOP.srt 5.9 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/3. SQL Basics Part 2/6. WHERE.mp4 243.1 MB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/3. SQL Basics Part 2/6. WHERE.srt 38.6 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/3. SQL Basics Part 2/7. DELETE.srt 16 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/3. SQL Basics Part 2/8. UPDATE.srt 15.3 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/3. SQL Basics Part 2/9. INTO.srt 10 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/4. SQL Basics Part 3/1. Basics Part 3 Theory.srt 9.2 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/4. SQL Basics Part 3/2. ORDER BY.srt 10.8 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/4. SQL Basics Part 3/3. DISTINCT.srt 8.2 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/4. SQL Basics Part 3/4. GROUP BY.srt 26.2 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/4. SQL Basics Part 3/5. AS (Aliases).srt 14.7 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/4. SQL Basics Part 3/6. HAVING.srt 12.3 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/4. SQL Basics Part 3/7. Basics Quiz.html 180 B
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/5. SQL Intermediate Part 1/1. Intermediate Part 1 Theory.srt 24.7 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/5. SQL Intermediate Part 1/10. CASE.srt 27.4 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/5. SQL Intermediate Part 1/11. STRING_AGG.srt 11.3 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/5. SQL Intermediate Part 1/12. FOR XML PATH & STUFF.srt 30.3 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/5. SQL Intermediate Part 1/2. ISNULL & COALESCE.srt 27.4 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/5. SQL Intermediate Part 1/3. NULLIF.srt 10.9 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/5. SQL Intermediate Part 1/4. CAST.srt 17.2 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/5. SQL Intermediate Part 1/5. Convert Code.html 2.1 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/5. SQL Intermediate Part 1/6. CONVERT.srt 16.9 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/5. SQL Intermediate Part 1/7. GETDATE.srt 4.1 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/5. SQL Intermediate Part 1/8. DATEADD.srt 10.3 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/5. SQL Intermediate Part 1/9. DATEDIFF.srt 11.8 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/6. SQL Intermediate Part 2/1. Intermediate Part 2 Theory.srt 16.2 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/6. SQL Intermediate Part 2/10. Intermediate Quiz.html 180 B
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/6. SQL Intermediate Part 2/2. INNER JOIN.srt 30.3 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/6. SQL Intermediate Part 2/3. LEFT JOIN.srt 14.1 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/6. SQL Intermediate Part 2/4. RIGHT JOIN.srt 13.5 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/6. SQL Intermediate Part 2/5. FULL JOIN.srt 12.2 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/6. SQL Intermediate Part 2/6. OUTER APPLY.mp4 327.5 MB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/6. SQL Intermediate Part 2/6. OUTER APPLY.srt 52.2 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/6. SQL Intermediate Part 2/7. CROSS APPLY.srt 11.8 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/6. SQL Intermediate Part 2/8. UNION.srt 25.2 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/6. SQL Intermediate Part 2/9. EXCEPT.srt 11.1 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/7. Indexes/1. Indexes Theory.srt 20.9 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/7. Indexes/2. Go To Definition.srt 6.5 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/7. Indexes/3. CLUSTERED INDEX.srt 19.7 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/7. Indexes/4. NONCLUSTERED INDEX.srt 21.2 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/7. Indexes/5. UNIQUE.srt 22 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/7. Indexes/6. PRIMARY KEY.srt 15 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/7. Indexes/7. COMPOSITE KEY.srt 11 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/8. Window Functions/1. Window Function Theory.srt 23.3 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/8. Window Functions/2. ROW_NUMBER.srt 18.7 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/8. Window Functions/3. RANK.srt 12.6 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/8. Window Functions/4. DENSE_RANK.srt 9.8 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/8. Window Functions/5. NTILE.srt 14.1 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/8. Window Functions/6. LAG.srt 14.2 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/8. Window Functions/7. LEAD.srt 6 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/8. Window Functions/8. FIRST_VALUE.srt 4.7 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/8. Window Functions/9. LAST_VALUE.srt 20.6 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/9. SQL Advanced/1. Advanced Theory.srt 18.5 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/9. SQL Advanced/10. TRANSACTION.srt 29.3 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/9. SQL Advanced/2. Stored Procedures - CREATE.srt 34.3 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/9. SQL Advanced/3. Stored Procedures - Parameters Part 1.srt 26.6 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/9. SQL Advanced/4. Stored Procedures - Parameters Part 2.srt 14.5 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/9. SQL Advanced/5. OFFSET.srt 27.8 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/9. SQL Advanced/6. Nested Queries.mp4 241.1 MB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/9. SQL Advanced/6. Nested Queries.srt 41 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/9. SQL Advanced/7. Temporary Tables - Creation.srt 24.3 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/9. SQL Advanced/8. Temporary Tables - Management.srt 16.5 KB
[TutsNode.net] - SQL Development with MS SQL Server Beginner to Master/9. SQL Advanced/9. IF & ELSE.srt 13.1 KB

Rating

Not rated yet

Comments

No comments yet.

Similar torrents

Name	Size	Date
SQL The Ultimate Beginners Guide To SQL Server - Start With And Master SQL Programming ... in Other	569 kB	05/26/17	1	0
SQL Beginner to Guru MySQL Edition - Master SQL with MySQL Verified in Other	5.5 GB	03/31/19	0	0
Udemy - Mastering SQL Query With SQL Server Verified in Other	1.3 GB	04/07/20	0	1
Udemy - SQL for Developers and Analysts with MS SQL Server (Updated 9-2019) Verified in Other	1.7 GB	04/07/20	0	1
Udemy - Mastering SQL Query With SQL Server Verified in Other	2.3 GB	05/10/20	0	1
Mastering SQL Query With SQL Server (Updated 5 - 2020) Verified in Other	2.7 GB	05/31/20	0	0
Udemy - T-SQL (Transact-SQL) for beginners with Microsoft SQL Server Verified in Software	560 MB	07/24/20	0	1
Udemy - SQL for Beginners with Microsoft SQL Server Database Verified in Software	1.1 GB	10/28/20	0	3