Video: .MP4, 1280×720 | Audio: AAC, 44100Hz, 2ch | Duration: 4hGenre: eLearning | Language: English + Sub | Size: 1,18 GBWhat you’ll learnLearn how to attach a sample database to SQLiteHow to connect to SQLite DatabaseLearn how to execute Some commonly used sqlite3 commandsHow to backup entire database and tables using SQLite Dump commandLearn to fetch data from database using SQLite SELECT statementLearn to query and fetch all data from a database tableLearn to query and fetch specific data from a database tableLearn to sort data returned from a database using ORDER BY clauseLearn to filter data returned from a database using WHERE clauseLearn how to remove duplicate records using SQLITE DISTINCTLearn how to identify NULL values in a database tableLearn about various SQLite Data TypesLearn how SQLite Constraints worksLearn how to create new tableLearn how to add new records into a tableLearn how to Update existing records inside a database tableLearn how to Delete existing records in a databaseLearn how to Drop a tableLearn how to use various SQLite operators to manipulate dataLearn how to extract data from multiple tables using table joinsLearn how to use AliasesLearn how to use various types of Aggregate functions to perform calculations on records in a database tableLearn how to group data with GROUP BY clauseLearn how to Filter grouped data using HAVING clauseAre there any course requirements or prerequisites?Basic knowledge of a computerBasic internet navigation skillsBasic understanding of database concepts will help but not mandatoryBasic working knowledge of Standard SQL will help but not mandatoryWho this course is for:Beginner SQL DevelopersBeginner Data AnalystBeginners to SQLiteBeginner DBA’s ( Database Administrators)