SQL Development with MS SQL Server Beginner to Master

Focused View

Dominic Tripodi

9:21:54

125 View

1. Introduction

1. Introduction.mp4

01:40

2. Install List.html

3. Install.mp4

11:13

4. MacOSLinux SQL Server Install - Notes.html

5. MacOSLinux SQL Server Install.mp4

13:40

6. Hotkeys and Macros.html

2. SQL Basics Part 1

1. Basics Part 1 Theory.mp4

06:01

2. Windows Connect to the Database.mp4

04:20

3. CREATE DATABASE.mp4

08:14

4. CREATE SCHEMA.mp4

03:37

5. Scalar Variables notes.html

6. Scalar Variables.mp4

30:10

7. CREATE TABLE.mp4

12:56

8. DEFAULT & NULL.mp4

04:53

9. INSERT.mp4

08:05

10. SELECT.mp4

06:44

11. UPDATE.mp4

02:14

12. ALTER TABLE.mp4

11:41

13. Custom Types.mp4

07:02

3. SQL Basics Part 2

1. Basics Part 2 Theory.mp4

06:28

2. Windows File Location.mp4

02:36

3. Mac Backup Restore.mp4

06:49

4. Windows Backup Restore.mp4

02:35

5. TOP.mp4

03:20

6. WHERE.mp4

15:47

7. DELETE.mp4

06:26

8. UPDATE.mp4

05:56

9. INTO.mp4

03:59

10. TRUNCATE.mp4

04:27

4. SQL Basics Part 3

1. Basics Part 3 Theory.mp4

03:41

2. ORDER BY.mp4

04:18

3. DISTINCT.mp4

03:19

4. GROUP BY.mp4

10:13

5. AS (Aliases).mp4

06:05

6. HAVING.mp4

04:33

7. Basics Quiz.html

5. SQL Intermediate Part 1

1. Intermediate Part 1 Theory.mp4

09:26

2. ISNULL & COALESCE.mp4

11:04

3. NULLIF.mp4

04:23

4. CAST.mp4

07:20

5. Convert Code.html

6. CONVERT.mp4

06:44

7. GETDATE.mp4

01:31

8. DATEADD.mp4

04:18

9. DATEDIFF.mp4

04:29

10. CASE.mp4

10:39

11. STRING AGG.mp4

04:33

12. FOR XML PATH & STUFF.mp4

12:16

6. SQL Intermediate Part 2

1. Intermediate Part 2 Theory.mp4

06:31

2. INNER JOIN.mp4

12:26

3. LEFT JOIN.mp4

05:38

4. RIGHT JOIN.mp4

05:16

5. FULL JOIN.mp4

04:49

6. OUTER APPLY.mp4

21:18

7. CROSS APPLY.mp4

05:07

8. UNION.mp4

10:21

9. EXCEPT.mp4

04:38

10. Intermediate Quiz.html

7. Indexes

1. Indexes Theory.mp4

08:24

2. Go To Definition.mp4

02:36

3. CLUSTERED INDEX.mp4

07:52

4. NONCLUSTERED INDEX.mp4

08:23

5. UNIQUE.mp4

09:06

6. PRIMARY KEY.mp4

05:50

7. COMPOSITE KEY.mp4

04:19

8. Window Functions

1. Window Function Theory.mp4

08:56

2. ROW NUMBER.mp4

07:11

3. RANK.mp4

04:36

4. DENSE RANK.mp4

03:45

5. NTILE.mp4

05:15

6. LAG.mp4

05:14

7. LEAD.mp4

02:13

8. FIRST VALUE.mp4

01:45

9. LAST VALUE.mp4

08:05

9. SQL Advanced

1. Advanced Theory.mp4

06:44

2. Stored Procedures - CREATE.mp4

12:34

3. Stored Procedures - Parameters Part 1.mp4

09:38

4. Stored Procedures - Parameters Part 2.mp4

05:28

5. OFFSET.mp4

10:02

6. Nested Queries.mp4

15:53

7. Temporary Tables - Creation.mp4

09:09

8. Temporary Tables - Management.mp4

05:58

9. IF & ELSE.mp4

05:07

10. TRANSACTION.mp4

11:21

10. Congratulations!

1. Congratulations!.mp4

00:41

Description

Learn SQL (Structured Query Language) with MS SQL Server and T-SQL from Mac, Linux or Windows!

What You'll Learn?

Understand and write SQL queries to interact with databases
Summarize and analyze data with powerful SQL query techniques
Build stored procedures to create and dynamically access production-level datasets
Understand how SQL Indexes work and what they do to improve query performance

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

What You Need to Know?

Must have basic computer skills, and a desire to learn SQL

Must have a computer to follow the course on

More details

Description
Learn how to understand and effectively write SQLÂ Queries to interact with databases and build powerful datasets.
The whole course 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Â Query Writing 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
Use built in SQLÂ Functions to transform and format data
Combine data from different tables
Return dynamic results with case statements and type casting
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 explanations of how things work that will lead to a strong understanding of complex topics, and 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

User Reviews

Rating

average 0

Total votes0

Focused display

Computers have been very important and interesting to me for my entire life, and I've always loved learning about the way that computers can be used to build tools for business and entertainment.The most interesting thing to me has always been what goes on behind the scenes.I work a lot with data, databases, and I build tools to manage and display data. APIs and Databases are the most important building blocks in modern application development. I build tools for storage, movement, management and transformation of data These types of tools fuel most modern applications.Most modern companies need or have software that uses these types of tools and the skills needed to build these tools are in high demand.Why I teachAs a self-taught developer, I spent a lot of time learning and deciding what to learn about and I wanted to create content and resources to simplify and streamline the process for new developers.

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.