The SQL Ultimate Course: from Zero to Hero

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

Unique SQL course - covers everything you need to MASTER SQL and understand how things work behind the scenes in SQL.

1. SQL Basics

1. Course Curriculum Overview

2.1 database-script.zip

2.2 SQL-Cheat-Sheet-DATAwithBARAA.pdf

2.3 SQL-Presentation-DATAwithBARAA.pdf

2. Course Materials.html

3. Introduction to SQL

4. Why Learn SQL

5. The Database Concepts

6. SQL Tables Concepts

7. The Main SQL Commands

8. The Elements of SQL Statements

2. Prepare The Environment

1. Download & Install MySQL

2. Tour in the Interface of MySQL Workbench

3. Install the Course Database

4. Guide to SQL Coding Style

3. Querying Data

1. SELECT Statement

2. DISTINCT

3. ORDER BY

4. Assessment 1 - Querying Data.html

5. Solutions to Assessment 1.html

4. Filtering Data

1. WHERE

2. Comparison Operators =, , , =, =, !=

3. Logical Operators AND, OR, NOT

4. BETWEEN

5. IN

6. LIKE

7. Assessment 2 - Filtering Data.html

8. Solutions to Assessment 2.html

5. Joining Data

1. JOINS Concept

2. AS Statement - Aliases

3. INNER JOIN

4. LEFT JOIN

5. RIGHT JOIN

6. FULL JOIN

7. UNION

8. Assessment 3 - Joining Data.html

9. Solutions to Assessment 3.html

6. SQL Functions

1. Aggregate Functions

2. String Functions

3. Assessment 4 - SQL Functions.html

4. Solutions to Assessment 4.html

7. SQL Advanced Topics

1. GROUP BY

2. HAVING

3. SubQuery EXISTS vs IN

4. Assessment 5 - SQL Advanced Topics.html

5. Solutions to Assessment 5.html

8. Modifying Data

1. INSERT

2. UPDATE

3. DELETE

4. Assessment 6 - Modifying Data.html

5. Solutions to Assessment 6.html

9. Defining Data

1. CREATE Table

2. ALTER Table

3. DROP Table

4. Assessment 7 - Defining Data.html

5. Solutions to Assessment 7.html

10. Next SQL Course & THANK YOU

1. Next SQL Course & THANK YOU

139,000 تومان

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

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

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

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