SQL for Beginners: A Complete Course

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

Master the Fundamentals of SQL, Learn to Manage Data, Create Databases, and Generate Reports

1. Introduction

1. Introduction of the Instructor

2. Introduction to SQL Programming

1. Introduction to SQL Programming

3. How to Install MS SQL Server

1. How to Install MS SQL Server and Management Studio

4. How to Log In to SQL Management Studio

1. How to log in to SQL Management Studio

5. Database Transactions

1. How to create a database

2. How to delete a database

3. How to use an external database

6. Table Transactions

1. How to create a table by writing a query

2. How to create a table by using management console interface

7. Main SQL Commands

1. SELECT Command

2. INSERT Command

3. UPDATE Command

4. DELETE Command

5. WHERE Command

6. AND Command

7. OR Command

8. AS Command

9. IN Command

10. LIKE Command

11. BETWEEN Command

12. DISTINCT Command

13. ORDER BY Command

8. Mathematical Functions

1. MAX, MIN, AVG and SUM Functions

2. COUNT Function

9. String Functions

1. UPPER Function

2. LOWER Function

3. SUBSTRING Function

10. Constraints

1. NOT NULL Constraint

2. UNIQUE Constraint

3. CHECK Constraint

4. DEFAULT Constraint

5. PRIMARY KEY Constraint

6. FOREIGN KEY Constraint

11. Stored Procedures

1. How to create a Stored Procedure

2. How to INSERT data by using Stored Procedure

3. How to UPDATE data by using Stored Procedure

4. How to DELETE data by using Stored Procedure

5. How to use PARAMETER in Dynamic Stored Procedures

6. How to INSERT data with DYNAMIC STORED PROCEDURE

7. How to UPDATE data with DYNAMIC STORED PROCEDURE

8. How to DELETE a data from a table by using a DYNAMIC STORED PROCEDURE

12. Triggers

1. How to use TRIGGERS

2. Trigger Example Tables Preparation

3. Trigger Example 1

4. Trigger Example 2

13. Joins

1. How to use JOINS

14. Group By

1. How to use Group By

15. Closing Notes and Professional Advices

1. Closing Notes And Professional Advice

189,000 تومان

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

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

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

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