Mastering SQLite: From Fundamentals to Advanced Techniques
Become a SQLite Expert: Practical Skills for Real-World Applications
1.00 (1 reviews)
5
students
4.5 hours
content
Jul 2024
last update
$19.99
regular price
What you will learn
Understand the fundamental concepts and architecture of SQLite.
Install and configure SQLite on different operating systems.
Execute and optimize SQLite SELECT statements for data retrieval.
Filter and sort data using WHERE and ORDER BY clauses.
Eliminate duplicate records using the DISTINCT clause.
Understand and apply various SQLite data types.
Use SQLite aliases for improving query readability.
Define and enforce constraints in SQLite tables.
Create, update, and delete database tables using SQL statements.
Perform data manipulation tasks such as inserting, updating, and deleting records.
Drop tables and manage database schema changes.
Utilize SQLite operators like BETWEEN, IN, LIKE, and GLOB for advanced querying.
Construct and execute subqueries in different parts of SQL statements.
Implement various types of joins (LEFT, INNER, CROSS, SELF) to combine data from multiple tables.
Leverage aggregate functions and clauses to summarize data (AVG, COUNT, SUM, MAX, MIN, GROUP BY, HAVING).
Apply string, numeric, and date/time functions to manipulate and format data.
Create and use indexes to improve query performance and implement optimization techniques for efficient database operations.
6095159
udemy ID
7/26/2024
course created date
7/29/2024
course indexed date
Bot
course submited by