Certificate of completion - SQLite for beginners
I earned a Certificate of Completion that verifies that I successfully completed “SQLite for beginners” course on 12/9/2022 as taught by Bluelime Learning Solutions at Udemy Academy. The certificate indicates the entire course was completed as validated by the student. The course duration represents the course's total video hours at the most recent completion. The course is using SQLite Studio. Length 4.0 total hours. In this course I learned: • SQLite tools, commands, Show and Describe Tables, Dump command • Querying data from all columns in a table • Querying data from specific columns in a table • Sorting data using ORDER BY clause • Removing duplicate records using DISTINCT clause • Filtering data with WHERE clause • Identifying NULL values • Data Types • Constraints • Performing CRUD and INSERT INTO Table Statement operations • DROP Table Statement • BETWEEN, IN, LIMIT, LIKE, GLOB Operators • Building a subquery in a WHERE clause • Building a subquery in a WHERE clause using IN operator • Building a subquery in FROM clause • Table Joins: LEFT Join, INNER Join, CROSS Join, SELF Join • ALiases • Aggregate Functions: AVG, COUNT, SUM, MAX, MIN • GROUP_ CONCAT Function • SQLite GROUP BY Clause • SQLite HAVING Clause For this course, I used SQLite Studio and SQLite DBSchema. You can find this course at https://www.udemy.com/course/sqlite-for-beginners/