Microsoft SQL Server Essentials

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

Learn the fundamentals of Microsoft SQL Server Database - No prior knowledge of SQL is required!

1. Introduction

1. Introduction

2. What to expect from this course

3. Defining a relational database

2. Getting Started

1. Installing the required tools

2. Creating your first database

3. Setting up the Adventure Works database

3. Data Definition Language Basics

1. Introduction to Data Definition Language (DDL)

2. Creating a table using SSMS

3. Creating a table using T-SQL

4. Table Constraints In SQL Server

1. Intro to table constraints in SQL Server

2. Creating a primary key using SSMS GUI & T-SQL

3. Creating a foreign key using T-SQL

4. Creating a foreign key using SSMS

5. Data Manipulation Language Basics

1. Intro to Data Manipulation Language (DML)

2.1 dml examples.zip

2. Data Manipulation Language Examples

6. Filtering Queries In SQL Server

1.1 filter options.zip

1. Filtering queries using the WHERE clause

2. Filtering queries using other conditions (Part 1)

3. Filtering queries using other conditions (Part 2)

7. All about the JOIN command

1. Introducing the JOIN command

2.1 employee script.zip

2. Using the JOIN command (Part 1)

3.1 join examples.zip

3. Using the JOIN command (Part 2)

4. Using the JOIN command (Part 3)

8. Aggregate & Conditional Expressions In SQL Server

1.1 aggregate functions.zip

1. Introducing Aggregate functions in SQL Server

2.1 group by + having command.zip

2. Using GROUP BY and HAVING commands

3.1 conditional statements.zip

3. Using the IF...ELSE conditional statements

4. Using the CASE conditional statement in SQL Server

9. Built-In Functions In SQL Server

1.1 date functions.zip

1. Using the DATE functions in SQL Server

2.1 string functions.zip

2. Using the STRING functions in SQL Server

10. Subqueries, Views & Stored Procedures

1.1 subquery sample.zip

1. Writing your first subquery

2.1 stored procedures.zip

2. Working with Stored Procedures (Part 1)

3. Working with Stored Procedures (Part 2)

4.1 view example.zip

4. Creating, using and modifying Views in SQL Server

11. Advanced SQL Server Concepts

1. Introducing TRIGGERS in SQL Server

2.1 after insert trigger.zip

2.2 after update trigger.zip

2. AFTER INSERT and AFTER UPDATE Trigger Examples

3. Automating Jobs with SQL Server Agent

4. Optimizing Query performance in SQL Server

12. Conclusion

1. Conclusion

45,900 تومان

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

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

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

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