SQL for Newcomers – The Full Mastery Course

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

A course to make you an SQL genius!

1. Introduction

1. Introduction

2. Tools Used in This Course

2. Setting Up Course Tools

1. Download PostgreSQL

2. Install PostgreSQL

3. Download SQLectron

4. Install SQLectron

5. Connect to PostgreSQL - Credentials

6. Connect to PostgreSQL Using SQLectron

7.1 emp dept.zip

7. Import Course Data Using SQLectron

8. FOR WINDOWS 32-BIT USERS SQL Alternative - DBeaver.html

9.1 emp dept.zip

9. FOR WINDOWS 32-BIT USERS Download, Install, Configure & Import Data

3. Browsing & Filtering Data

1. Check Imported Data

2. So.. What is a Database

3. SQL Data Types

4. Finally Some Fun! Extracting Data Based on Requirements

5. Filtering Data using WHERE Keyword

6. Filter Data by Range Using BETWEEN

7. Filter Data by Set of Values Using IN

8. Filter Data by Date

9. More Filtering by Date

10. Another Query Filtering by Date

11. Filter Data by Strings (Names, Addresses, ...)

12. More Filtering by Strings

13. More Filtering by Strings 2

14. More Filtering by Strings 3

15. How to Ignore Caps when Filtering by String

4. Filter Data with AND, OR, NOT Operators

1. AND Operator

2. OR Operator

3. NOT Operator

4. AND, OR & NOT Operators Which Has The Highest Priority

5. Math Operations

1. Basic Math Operations

2. Modulo Operator

3. Its Payday! Calculate The Net Salary for Employees

4. Filter Data with Math Equations

6. String Concatenation

1. Concatenate Strings with Operator

2. Concatenate Strings with Numbers

7. Tidy Up Your Results Sorting, Alias Names, Limit Records

1. Give Your Report Fields A Cool Name

2. A Report for Payroll

3. Order Records by Column

4. Order Records by Multiple Columns

5. How Alias Names Cannot Be Used with WHERE

6. LIMIT Record Count Fetched by Your Query

8. NULL, DISTINCT & CASE Statements

1. Fetch A Fields Unique Values Using DISTINCT

2. Using DISTINCT Keyword with Multiple Columns

3. What is a NULL Value Anyway

4. Build More Sophisticated Queries with CASE Statements

5. Your Knowledge So Far Under A Great Test

9. Functions in SQL Multiple-Row Functions

1. Let Me Introduce You to Functions

2. SUM Function

3. AVG (Average) Function

4. COUNT Function

5. MIN & MAX Functions

6. How To Count Your Fields Unique Values

7. GROUP BY Clause Use Functions with Dimensions

8. GROUP BY More Than One Dimension

9. Now For Some Tough Workout

10. Filter By Aggregate Functions with HAVING Clause

10. Functions in SQL Single-Row Functions

1. Character Functions - UPPER, LOWER & INITCAP

2. Character Functions - CONCAT & LENGTH

3. Character Functions - LPAD & RPAD

4. Character Functions - TRIM

5. Character Functions - REPLACE

6. Character Functions - SUBSTR

7. Number Functions - MOD & ROUND

8. Number Functions - TRUNC

11. Nested Queries

1. Selectception A Select Query Inside Another Select Query!

12. Casting & Data Conversion

1. Auto Data Conversion in SQL

2. Cast Date to Character

3. Cast Number to Character

4. Cast Timestamp to Character

5. Cast Character to Number

6. Cast Character to Date & Timestamp

13. Combination Relationships

1. UNION

2. UNION ALL

3. Important Note about Combining Queries

4. INTERSECT

5. EXCEPT

14. Joins in SQL

1. Employees & Departments Tables Revised

2. Entity Relationship Diagram (ERD)

3. Cartesian Join

4. Table Aliases with Joins

5. Why I Dont Recommend Cartesian Joins

6. Inner Join

7. In-Depth Look into Join Types in SQL

8.1 employees fl.zip

8. Outer Join - Right, Left & Full

15. Data Manipulation (DML)

1. INSERT a New Record to a Table

2. Insert Without Specifying Column Names

3. UPDATE a Records Field Values

4.1 emp dept.zip

4. CAUTION! How an UPDATE Query Can Go Wrong

5. Update a Record Using Single-Row Functions

6. A Good Exercise Extract Employees Email Address

7. Hints on How to Extract Employees Email Address.html

8. Solution Extract Employees Email Address

9.1 emp dept.zip

9. DELETE a Tables Record

10. Insert Records with Nested Select Queries

16. SQL Data Definition Language (DDL)

1. SQL Data Types Revised

2. Bookstore Data Set Lets Move It to Database

3. Create Your First Table!

4. Insert Data to Your New Table

5. Change Column Data Type

6. Rename Column

7. Add a New Column to Table

8. Constraints in SQL

9. Primary Keys

10. NOT NULL Constraint

11. UNIQUE Constraint

12. DEFAULT Constraint

13. Foreign Keys

14. Use Foreign Keys with Joins - Books & Publishers

15. Foreign Keys - Properties

16. Drop Column

17. DROP Table

18. Create a New Table with Select Statement

19. A Trick to Create an Empty Table with Select Statement

20. Insert New Records Using Select Statement

21. Views

22. Schemas

23. Create & Use Schemas

17. Access Control

1. Introduction to Access Control

2. Create User

3. Grant SELECT to User

4. Grant Insert & Update to User

5. Revoke Privilege from User

6. User Groups

139,000 تومان

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

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

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

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