Master SQL Basics in 7 Days! | Learn SQL Server (SSMS)

سرفصل های دوره

A One Week Comprehensive Introduction to SQL and Microsoft SQL Server Management Studio!

1 - Day One Getting Started

1 -Video Course Introduction

2 -Video What is a Server

2 - READ ME Welcome!.html

3 -1.pdf

3 -Video What is a Database

3 - Article Cloud Based vs. On-Premises Servers.html

4 -2.pdf

4 -Video Introduction to SQL

4 - Article Database Management Systems.html

5 -3.pdf

5 -E.pdf

5 -Video Downloading Microsoft SQL Server

5 - Article Understanding SQL Command Categories.html

5 - Link Downloading Microsoft SQL Server.html

5 - Optional Article E.F. Codd - A Relational Model of Data for Large Shared Data.html

6 -Video Connecting to server in SSMS

7 -Video SSMS Feature Demonstration

8 -Video SQL Cheat Sheet

9 -00.pdf

9 - Article SQL Cheat Sheet.html

2 - Day Two Databases & Tables

1 -Video Day Two Introduction

2 -Video Create Database

3 -Video Drop Database

3 - Code Create Database.html

4 -Video Use Database

4 - Code Drop Database.html

5 -Video Data Types

5 - Code Use Database.html

6 -4.pdf

6 -Video Create Table

6 - Article Data Types.html

7 -Video Drop Table

7 - Code Create Table.html

8 -Video Insert Data

8 - Code Drop Table.html

9 -Video Not NULL

9 - Code Insert Data.html

10 -Video Unique Values

10 - Code Not NULL.html

11 -Video Primary Keys

11 - Code Unique Values.html

12 -Video Default Values

12 - Code Primary Keys.html

13 - Code Default Values.html

3 - Day Three Retrieving Data

1 -Video Day Three Introduction

2 -Video Select & Top n

2 - Code Syntax used in Day Three.html

3 -Video Select Distinct

3 - Code Select & Top n.html

4 -Video Arithmetic Operators

4 - Code Select Distinct.html

5 -Video Alias Names

5 - Code Arithmetic Operators.html

6 -Video Where Clause (=, , , =, =, )

6 - Code Alias Names.html

7 -Video Where Clause (And, Or, Not in, Between)

7 - Code Where Clause (=, , , =, =, ).html

8 -Video Where Clause (Like, Null, Not Null)

8 - Code Where Clause (And, Or, Not in, Between).html

9 -Video Order by

9 - Code Where Clause (Like, Null, Not Null).html

10 -Video Aggregate Function Count

10 - Code Order by.html

11 -Video Group by

11 - Code Aggregate Function Count.html

12 -Video Aggregate Functions Sum, Min, Max, Avg

12 - Code Group by.html

13 -Video Having

13 - Code Aggregate Functions Sum, Min, Max, Avg.html

14 -Video Case Statements

14 - Code Having.html

15 -5.pdf

15 - Article SQL Order of Operations.html

15 - Code Case Statements.html

4 - Day Four Modifying Data

1 -Video Day Four Introduction

2 -Video Updating Data

2 - Code Syntax used in Day Four.html

3 -Video Truncating Data

3 - Code Updating Data.html

4 -Video Deleting Data

4 - Code Truncating Data.html

5 -Video Alter Table

5 - Code Deleting Data.html

6 -Video Select Into

6 - Code Alter Table.html

7 -Video Inner Queries

7 - Code Select Into.html

8 -Video Temporary Tables

8 - Code Inner Queries.html

9 -Video Common Table Expressions (CTEs)

9 - Code Temporary Tables.html

10 -6.pdf

10 - Article Inner Queries, Temp Tables, and CTEs.html

10 - Code Common Table Expressions (CTEs).html

5 - Day Five Building a Sample Database

1 -Video Day Five Introduction

2 -Video Introduction to Summit Database

3 -Summit Sporting Goods Data Dictionary v2.pdf

3 -Video Summit Sporting Goods Data Dictionary

4 -Video Relational Databases

5 -7.pdf

5 -Summit Sporting Goods Data Dictionary v2.pdf

5 -Video Creating Summit Database Dimension Tables

5 -creating relationships.zip

5 -dimcustomer.zip

5 -dimdate.zip

5 -dimemployee.zip

5 -dimproduct.zip

5 -dimstore.zip

5 -facttransaction.zip

5 -summitsportinggoods.zip

5 - Article Understanding Relational Databases.html

5 - Code Summit Sporting Goods Database.html

6 -Video Creating Summit Database Fact Table

7 -Video Foreign Keys

8 -8.pdf

8 -Video Creating Summit Database Relationships

8 - Article Primary & Foreign Keys.html

9 -Troubleshooting Loading Summit Database via Backup File

10 -Video Joining Data Tables in SQL

11 -9.pdf

11 -Video Inner Joins

11 - Article Joining Data Tables in SQL.html

12 -Video Left Joins

12 - Code Inner Joins.html

13 -Video Right Joins

13 - Code Left Joins.html

14 -Video Full Outer Joins

14 - Code Right Joins.html

15 - Code Full Outer Joins.html

6 - Day Six Other Functions

1 -Video Day Six Introduction

2 -Video Concatenation

3 -Video Replace

3 - Code Concatenation.html

4 -Video IsNull

4 - Code Replace.html

5 -Video Coalesce

5 - Code IsNull.html

6 -Video NullIf

6 - Code Coalesce.html

7 -Video Round

7 - Code NullIf.html

8 -Video Cast and Convert

8 - Code Round.html

9 -Video Format

9 - Code Cast and Convert.html

10 -Video Upper and Lower

10 - Code Format.html

11 -Video Left and Right

11 - Code Upper and Lower.html

12 -Video Trim

12 - Code Left and Right.html

13 -Video Len

13 - Code Trim.html

14 -Video DateAdd

14 - Code Len.html

15 -Video DateDiff

15 - Code DateAdd.html

16 -Video Rollup

16 - Code DateDiff.html

17 - Code Rollup.html

7 - Practice and Beyond!

1 -Video Day Seven Introduction - Whats Next

2 -Video Question 1 Explanation

2 -practice questions (no answers).zip

2 - Article Questions 1 - 10 (without answers).html

2 - Code Question 1.html

3 -Video Question 2 Explanation

3 - Code Question 1 Answer.html

3 - Code Question 2.html

4 -Video Question 3 Explanation

4 - Code Question 2 Answer.html

4 - Code Question 3.html

5 -Video Question 4 Explanation

5 - Code Question 3 Answer.html

5 - Code Question 4.html

6 -Video Question 5 Explanation

6 - Code Question 4 Answer.html

6 - Code Question 5.html

7 -Video Question 6 Explanation

7 - Code Question 5 Answer.html

7 - Code Question 6.html

8 -Video Question 7 Explanation

8 - Code Question 6 Answer.html

8 - Code Question 7.html

9 -Video Question 8 Explanation

9 - Code Question 7 Answer.html

9 - Code Question 8.html

10 -Video Question 9 Explanation

10 - Code Question 8 Answer.html

10 - Code Question 9.html

11 -Video Question 10 Explanation

11 - Code Question 9 Answer.html

11 - Code Question 10.html

12 - Article Whats Next.html

12 - Code Question 10 Answer.html

179,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy