Introduction to SQL

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

The vast majority of applications that use data, are backed by a good relational database system. This course will help to establish a base to those who want to begin learning Structured Query Language (SQL).

1. Course Overview

1. Course Overview

2. Introduction

1. Introduction

2. The Relational Model

3. Summary

3. Understanding Basic SQL Syntax

1. Introduction

2. Basic SQL Commands - SELECT

3. Basic SQL Commands - INSERT

4. Basic SQL Commands - UPDATE

5. Basic SQL Commands - DELETE

6. Course Housekeeping

7. Summary

4. Querying Data with the SELECT Statement

01. Introduction

02. Demo - SELECT

03. The SELECT List

04. SELECT List Wildcard (-)

05. The FROM Clause

06. Demo - FROM Clause

07. How to Constrain the Result Set

08. DISTINCT and NOT DISTINCT

09. Demo - Distinct

10. Summary

5. Filtering Results with the WHERE Clause

01. The WHERE Clause

02. Demo - WHERE Clause

03. Boolean Operators

04. The AND Keyword

05. Demo - AND

06. The OR Keyword

07. Demo - OR

08. Other Boolean Operators

09. BETWEEN

10. Demo - BETWEEN

11. LIKE

12. Demo - LIKE

13. IN

14. Demo - IN

15. IS

16. IS NOT

17. Demo - IS AND IS NOT

18. Summary

6. Shaping Results with ORDER BY and GROUP BY

01. Introduction

02. ORDER BY

03. Demo - ORDER BY

04. Set Functions

05. Demo - Set Functions

06. Set Function And Qualifiers

07. Demo - Set Function And Qualifiers

08. GROUP BY

09. Demo - GROUP BY

10. HAVING

11. Demo - HAVING

12. Summary

7. Matching Different Data Tables with JOINs

01. Introduction

02. CROSS JOIN

03. Demo - CROSS JOIN

04. INNER JOIN

05. Demo - INNER JOIN

06. OUTER JOINs

07. LEFT OUTER JOIN

08. Demo - LEFT OUTER JOIN

09. RIGHT OUTER JOIN

10. Demo - RIGHT OUTER JOIN

11. FULL OUTER JOIN

12. Demo - FULL OUTER JOIN

13. SELF JOIN

14. Summary

8. Adding, Changing, and Removing Data

01. Introduction

02. INSERT

03. Demo - INSERT

04. BULK INSERT

05. Demo - BULK INSERT

06. UPDATE

07. Demo - UPDATE

08. DELETE

09. Demo - DELETE

10. Summary

9. Creating Database Tables

01. Introduction

02. CREATE DATABASE

03. Demo - CREATE DATABASE

04. CREATE TABLE

05. Demo - CREATE TABLE

06. NULL Values

07. PRIMARY KEY

08. CONSTRAINT

09. ALTER TABLE

10. DROP TABLE

11. Demo - CREATE TABLE

12. Summary

139,000 تومان

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

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

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

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