Mastering SQLite: From Fundamentals to Advanced Techniques

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

Become a SQLite Expert: Practical Skills for Real-World Applications

1. Introduction to SQLite

1. Introduction.html

2. What is SQLite .html

3. Why Use SQLite.html

2. Setting Up Your Environment

1. Download and Install SQLite

2. Tools and Interfaces for SQLite.html

3. What is SQLite Studio

4.1 chinook.zip

4.2 db+schema.zip

4. Attaching Sample Database to SQLite

5. How to connect to SQLite Database

6. Database Concepts

7. What is sqlite3 tool

8. Some Basic SQLite3 Commands

9. SQLite Dump command

3. Basic Concepts and Terminology

1. Databases, Tables, and Records.html

2. SQL Basics.html

4. Data Manipulation

1. SQLite SELECT statement

2. Querying data from all columns in a table

3. Querying data from specific columns in a table

4. Sorting data using ORDER BY clause

5. Removing duplicate records using DISTINCT clause

6. Filtering data with WHERE clause

7. Identifying NULL values

8. SQLite Data Types

9. SQLite ALiases

5. Creating Database Tables Updating Data Deleting Records

1. SQLite Constraints

2. SQLite Create Table Statement - Part 1

3. SQLite Create Table Statement - Part 2

4. SQLite INSERT INTO Table Statement

5. SQLite UPDATE Statement

6. SQLite DELETE Statement

7. SQLite DROP Table Statement

6. SQLite Operators

1. SQLite BETWEEN Operator

2. SQLite IN Operator

3. SQLite LIKE operator

4. SQLite GLOB Operator

5. SQLite LIMIT clause

7. Working with Subqueries

1. What is a subquery

2. Building a subquery in a WHERE clause

3. Building a subquery in a WHERE clause using IN operator

4. Building a subquery in FROM clause

8. Joining Tables

1. SQLite LEFT Join

2. SQLite INNER Join

3. SQLite CROSS Join

4. SQLite SELF Join

9. Aggregating Data

1. Introduction to SQLite Aggregate Functions

2. SQLite AVG Function

3. SQLite COUNT Function

4. SQLIte SUM Function

5. SQLite MAX Function

6. SQLite MIN Function

7. SQLite GROUP CONCAT Function

8. SQLite GROUP BY Clause

9. SQLite HAVING Clause

10. SQLite Functions

1. String Functions.html

2. Numeric Functions.html

3. Date and Time Functions.html

11. Indexes and Optimization

1. Creating and Using Indexes.html

2. Analyzing Query Performance.html

3. Optimization Techniques.html

139,000 تومان

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

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

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

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