Mastering SQL Query With SQL Server

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

Querying Microsoft SQL Server , Azure SQL DB & Cosmos DB

1. Introduction

1. Course Topics

2. How to use udemy

2. Basics Of DBMS

1. Introduction To This Module

2. What is Data

3. What is Database & How To Design A Simple Database

4. Why We Need A DBMS Software

5. What Is The Use SQL Scripting Language

6. Summary Of This Module

3. How To Install SQL Server (Laptop)

1. Different SQL Server Installation Options (Cloud and On Premise)

2. Install SQL Server

3. Install SQL Server Management Studio

4. Connect To SQL Server by Using SQL Server management Studio

4. How To Use Azure SQL For SQL Server

1. Create Free Azure Account

2. SQL Server In Cloud (Azure)

3. Create Azure SQL Server DB

4. Connect To Azure SQL Server DB From SSMS

5. Delete Azure SQL Data Base

5. Design Your First Database

1. Introduction To Designing A Database

2. Create A Databse

3. Create Tables Inside A Database

4. Insert Data Into A Tables

5. Insert Data Into A Tables Part 2

6. Retrieve Saved Data From A Database

7. Retrieve Saved Data From A Database Part 2

8. Update Records Saved in A Table

9. Remove Data From A Table

10. Remove Tables From A Database

11. Summary Of This Module

6. Task 1 Check Your Understanding

1. Task 1

2. Solution For Task 1 Part 1

3. Solution For Task 1 Part 2

4. Solution For Task 1 Part 3

5. Solution For Task 1 Part 4

6. Solution For Task 1 Part 5

7. Solution For Task 1 Part 6

8. Solution For Task 1 Part 7

9. Solution For Task 1 Part 8

7. Types OF SQL Statements

1. Interview Question Different Types Of SQL Statements

8. Fundamentals Of DQL Statements

1.1 SQL_Fund_1.zip

1. Basics Of SQL Select Statement & Derive New Data

2. Literal Select Statement

3. Select Distinct Data From A Table

4. Select Specific Data With Where Conditions

5. How To Use In Operate In SQL Where Condition

6. How To Use Between Operator In SQL Where Condition

7. How To Retrieve Null Values Using SQL Where Conditions

8.1 SQL_Fund_2.zip

8. How To Select Values From A Table That Are Not Equal To Some Values

9.1 SQL_Fund_3.zip

9. How To Use Like Operator In Where Clause

10. Sort Data By Using Order By

11. How To Use The SQL Server OFFSET FETCH Clauses To Limit The Number Of Rows

9. Introduction To SQL Constrains

1.1 SQL_Constrains.zip

1. What Is Constrain How To Use It When We Need SQL Constrains

2.1 SQL_Constrains_Null.zip

2. Use Of Not Null Constrains

3.1 SQL_Constrains_unique.zip

3. How To Use Unique Constrains Part 1

4.1 SQL_Constrains_unique.zip

4. How To Use Unique Constrains Part 2

5.1 SQL_Constrains_Check.zip

5. How To Use Check Constraint In SQL Server

6.1 SQL_Constrains_Default.zip

6. How To Use Default Constrains In SQL Server

7.1 PK.zip

7. Use Of Primary Key In SQL Server

8.1 FK.zip

8. Use IDENTITY Keyword To Perform An Auto-Increment Feature With Primary Key

9.1 FK.zip

9. SQL FOREIGN KEY Constraint (Used To Link Two Tables Together)

10. Aggregate Function In SQL Server

1.1 Agg_Functions.zip

1. Aggregate Functions Like Min, Max, Sum, Avg and Count in Select With Group By

11. Join In SQL

1. What Is SQL Join and Different Types Of Join

2.1 Join.zip

2. Inner Join

3.1 Join.zip

3. Outer Joins (Full Left & Right Joins in SQL)

12. Union and Union All

1. How To Use Union to Combine Data from Multiple Tables

13. Introduction To Stored Procedure In SQL Server

1. Use Stored Procedure To Save Your Code And Reuse Old code

2. Use Single and Multiple Parameters With Stored Procedure

14. String Functions In SQL Server

1. SQL Server String Functions

2.1 String_functions.zip

2. Ascii Vs Char String Functions

3. Lower & Upper String Functions

4. Left & Right String Functions In SQL

5. Ltrim & Rtrim String Functions

6. Replace and Reverse String Functions

7. Substring & Charindex Functions

15. Building Globally Distributed Databases with Cosmos DB

1. Introduction

2.1 sample_data.zip

2. Create an Azure Cosmos DB database & Save Data Using Json

3.1 sample_data.zip

3. Query Data in Your Azure Cosmos DB Database Using SQL

16. Interview Questions Short Answer

1. Question 1 and Answer

2. Question 2 and Answer

3. Question 3 and Answer

17. Common SQL Interview Questions And Answers

1. First Set of Questions And Answers

2.1 in_between.zip

2. Question 1 and Answer

3. Question 2 and Answer

4. Question 3 and Answer

5. Question 4 and Answer

6. Question 5 and Answer

7. Question 6 and Answer

8. Question 7 and Answer

9. Question 8 and Answer

10. Question 9 and Answer

11. Question 10 and Answer

12. Question 11 and Answer

13. Question 12 and Answer

14. Question 14 Filters In SQL Select

18. Work With ASP . NET & SQL Server

1. Video Disclaimer

2.1 URL.html

2. Features in Visual Studio 2019

3.1 URL.html

3.2 Video.html

3. Install Visual Studio 2019

4.1 URL.html

4. Getting Started with Visual Studio 2019

5.1 URL.html

5.2 Video.html

5. Build Your First Web Application with Visual Studio 2019

6.1 URL.html

6.2 Video.html

6. Adding Data to a Web Application with Visual Studio 2019

7.1 URL.html

7.2 Video.html

7. Building Web APIs with Visual Studio 2019

8.1 URL.html

8.2 Video.html

8. Publishing Web Apps to Azure with Visual Studio 2019

9.1 URL.html

9. Increase your .NET Productivity with Visual Studio 2019

10.1 URL.html

10. Visual Studio Productivity Tips

11.1 URL.html

11. Introduction To Entity Framework Core

12.1 URL.html

12. Entity Framework Core Part 2

13.1 URL.html

13. Entity Framework Core Part 3

14.1 URL.html

14. Entity Framework Core Part 4

15.1 URL.html

15. Entity Framework Core Part 5

16. Check Your Knowledge.html

19. Bonus Part

1. Rate This Course

67,300 تومان

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

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

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

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