Introduction to SQL

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

Learn SQL from scratch and master practical database querying, including using Generative AI tools. Whether you need SQL for data analysis, software development, or better business insights, we'll cover all the fundamentals of real-world SQL skills.

1. Introduction

1. Introduction

2. Before You Write Any SQL

3. Sidebar - SQL vs. [Sequel]

02. Database Fundamentals

01. The Reason Databases Exist

02. The Evolution of Relational Database Management Systems

03. The Point of Every Database

04. Entities and Tables

05. Rows and Columns

06. The Importance of Data Types

07. Dealing with NULL Values

08. Primary Keys

09. Foreign Keys and Relationships

10. Database Naming Conventions

3. Writing SQL Queries

1. The SQL SELECT Statement

2. Sidebar - Where Do You Write SQL

3. Filtering Data Using WHERE

4. Creating More Complex WHERE Conditions

5. Searching Multiple Values with BETWEEN and IN

6. Sidebar - Is SQL Case Sensitive

7. Sidebar - SQL and Whitespace

8. Using LIKE to Match Patterns

9. Using NULL in a SELECT Statement

4. Ordering, Grouping, and Aggregate Functions

1. Sorting Results with ORDER BY

2. The Power of Aggregate Functions

3. Summarizing Data with GROUP BY

4. Using GROUP BY and HAVING

5. Ignoring Duplicate Values with DISTINCT

6. Improving Your SQL Thinking

5. How to JOIN Tables

1. How to JOIN Tables in a Query

2. Using OUTER JOINs LEFT, RIGHT, and FULL

3. Using NATURAL JOIN

4. Table Aliases in SQL

6. Subqueries and Sets

1. Creating a Subquery

2. Using Column Aliases with AS

3. Combining Data with UNION and UNION ALL

4. Sidebar - UNION vs. JOIN

7. Adding, Updating, and Deleting Data

1. How to INSERT New Data

2. How to UPDATE Data

3. How to Delete Rows from a Table

8. Additional Topics

1. Understanding DML, DDL, and DCL

2. SQL and Generative AI

3. Where to Go from Here

235,000 تومان

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

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

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

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