| 1 - Database Overview English.srt | 3.2 KB | ||
| 1 - Database Overview.mp4 | 18.4 MB | ||
| 1 - Database.pptx | 20.2 MB | ||
| 1 - SQL Test.html | 102.4 B | ||
| 10 - Alter Command in SQL English.srt | 3.6 KB | ||
| 10 - Alter Command in SQL.mp4 | 21.2 MB | ||
| 11 - Update command in SQL English.srt | 4.2 KB | ||
| 11 - Update command in SQL.mp4 | 29.7 MB | ||
| 12 - Union and Union All English.srt | 4.6 KB | ||
| 12 - Union and Union All.mp4 | 25.6 MB | ||
| 13 - SQLQuestions1.pptx | 71.6 KB | ||
| 13 - Substring Function in SQL English.srt | 6.9 KB | ||
| 13 - Substring Function in SQL.mp4 | 38.6 MB | ||
| 14 - INSTR Function in SQL English.srt | 5.8 KB | ||
| 14 - INSTR Function in SQL.mp4 | 35.6 MB | ||
| 15 - CONCAT FunctionUPPER and LOWER Functions English.srt | 5.3 KB | ||
| 15 - CONCAT FunctionUPPER and LOWER Functions.mp4 | 35.5 MB | ||
| 16 - TRIM LTRIM and RTRIM English.srt | 4.4 KB | ||
| 16 - TRIM LTRIM and RTRIM.mp4 | 19.5 MB | ||
| 17 - Replace Function in SQL English.srt | 2.9 KB | ||
| 17 - Replace Function in SQL.mp4 | 15.3 MB | ||
| 18 - Brief Overview of Operators English.srt | 1.9 KB | ||
| 18 - Brief Overview of Operators.mp4 | 8.8 MB | ||
| 18 - Operators.pptx | 94.5 KB | ||
| 19 - AND Operator English.srt | 7.4 KB | ||
| 19 - AND Operator.mp4 | 44 MB | ||
| 2 - SQLite.pptx | 71.6 KB | ||
| 2 - What is SQLite Database English.srt | 3 KB | ||
| 2 - What is SQLite Database.mp4 | 11.6 MB | ||
| 20 - OR Operator English.srt | 8.5 KB | ||
| 20 - OR Operator.mp4 | 51.9 MB | ||
| 21 - IN Operator English.srt | 5.7 KB | ||
| 21 - IN Operator.mp4 | 37.6 MB | ||
| 22 - Between Operator English.srt | 7.4 KB | ||
| 22 - Between Operator.mp4 | 59.6 MB | ||
| 23 - Like Operator English.srt | 6.8 KB | ||
| 23 - Like Operator.mp4 | 47.1 MB | ||
| 24 - GLOB Operator English.srt | 4.9 KB | ||
| 24 - GLOB Operator.mp4 | 30.2 MB | ||
| 24 - GLOBOperator.pptx | 73.6 KB | ||
| 25 - Limit Clause English.srt | 3.8 KB | ||
| 25 - Limit Clause.mp4 | 22.6 MB | ||
| 26 - Aggregate-Functions.pptx | 98.4 KB | ||
| 26 - Overview of Aggregate Functions English.srt | 3.7 KB | ||
| 26 - Overview of Aggregate Functions.mp4 | 16.3 MB | ||
| 27 - Group by Statement Explanation English.srt | 4.5 KB | ||
| 27 - Group by Statement Explanation.mp4 | 17.9 MB | ||
| 28 - Having Clause English.srt | 5.6 KB | ||
| 28 - Having Clause.mp4 | 33.4 MB | ||
| 29 - AggregateFunctionPractice.pptx | 68.9 KB | ||
| 29 - Examples of Aggregate Functions English.srt | 10.3 KB | ||
| 29 - Examples of Aggregate Functions.mp4 | 80.9 MB | ||
| 3 - SQLite Installation English.srt | 7.5 KB | ||
| 3 - SQLite Installation.mp4 | 70.3 MB | ||
| 30 - CreateTable.txt | 1.7 KB | ||
| 30 - Inner Join English.srt | 3.9 KB | ||
| 30 - Inner Join.mp4 | 16.5 MB | ||
| 30 - Joins.pptx | 211.8 KB | ||
| 31 - Examples of Inner Join Part01 English.srt | 8.6 KB | ||
| 31 - Examples of Inner Join Part01.mp4 | 85.4 MB | ||
| 32 - Examples of Inner Join Part02 English.srt | 3.5 KB | ||
| 32 - Examples of Inner Join Part02.mp4 | 28.6 MB | ||
| 33 - Left OuterRight Outer and Full Outer Join English.srt | 9.1 KB | ||
| 33 - Left OuterRight Outer and Full Outer Join.mp4 | 45 MB | ||
| 34 - Examples of Outer Joins English.srt | 7.9 KB | ||
| 34 - Examples of Outer Joins.mp4 | 60.9 MB | ||
| 34 - OuterJoinPractice.pptx | 73.1 KB | ||
| 35 - Self Join English.srt | 5.1 KB | ||
| 35 - Self Join.mp4 | 22 MB | ||
| 36 - Cartesian Product English.srt | 2.8 KB | ||
| 36 - Cartesian Product.mp4 | 9.2 MB | ||
| 37 - Subquery with SELECT statement English.srt | 9.7 KB | ||
| 37 - Subquery with SELECT statement.mp4 | 66.4 MB | ||
| 37 - Subquery.pptx | 72.1 KB | ||
| 38 - Subquery Example Part02 English.srt | 3.1 KB | ||
| 38 - Subquery Example Part02.mp4 | 25.2 MB | ||
| 39 - Insert-Subquery.pptx | 69.8 KB | ||
| 39 - Subquery with INSERT UPDATE and DELETE English.srt | 6.8 KB | ||
| 39 - Subquery with INSERT UPDATE and DELETE.mp4 | 54.6 MB | ||
| 4 - Introduction to SQlite Studio English.srt | 4.9 KB | ||
| 4 - Introduction to SQlite Studio.mp4 | 34.4 MB | ||
| 4 - SQLiteStudio.txt | 102.4 B | ||
| 40 - Correlated Subquery English.srt | 6.3 KB | ||
| 40 - Correlated Subquery.mp4 | 32.5 MB | ||
| 40 - Correlated-Subquery.pptx | 73.4 KB | ||
| 41 - Row Number English.srt | 10.8 KB | ||
| 41 - Row Number.mp4 | 58 MB | ||
| 41 - RowNumber.pptx | 90.2 KB | ||
| 42 - Rank and Dense Rank Functions English.srt | 9 KB | ||
| 42 - Rank and Dense Rank Functions.mp4 | 40.6 MB | ||
| 42 - Rank-and-Dense-Functions.pptx | 71.4 KB | ||
| 43 - Partition By Clause with Rank and Dense Rank Functions English.srt | 5 KB | ||
| 43 - Partition By Clause with Rank and Dense Rank Functions.mp4 | 40.1 MB | ||
| 44 - Rank and Dense Rank Example English.srt | 5.1 KB | ||
| 44 - Rank and Dense Rank Example.mp4 | 25.2 MB | ||
| 45 - Cumulative SumMoving Average and Moving Count English.srt | 13.2 KB | ||
| 45 - Cumulative SumMoving Average and Moving Count.mp4 | 89.2 MB | ||
| 46 - Examples Cumulative SumMoving Average and Moving Count English.srt | 9.6 KB | ||
| 46 - Examples Cumulative SumMoving Average and Moving Count.mp4 | 64.9 MB | ||
| 46 - SQLQuestions13.pptx | 89 KB | ||
| 47 - Overview of Triggers English.srt | 2.9 KB | ||
| 47 - Overview of Triggers.mp4 | 11.8 MB | ||
| 47 - Triggers.pptx | 70.4 KB | ||
| 48 - After and Before Insert Trigger Part01 English.srt | 8.5 KB | ||
| 48 - After and Before Insert Trigger Part01.mp4 | 65.3 MB | ||
| 49 - Before Insert Trigger Part02 English.srt | 5.4 KB | ||
| 49 - Before Insert Trigger Part02.mp4 | 38.7 MB | ||
| 49 - Triggers.txt | 819.2 B | ||
| 5 - Introduction to DB Browser SQLite English.srt | 5 KB | ||
| 5 - Introduction to DB Browser SQLite.mp4 | 31.1 MB | ||
| 50 - Update Trigger English.srt | 7.8 KB | ||
| 50 - Update Trigger.mp4 | 53 MB | ||
| 50 - UpdateTrigger.txt | 512 B | ||
| 51 - Delete Trigger English.srt | 5.1 KB | ||
| 51 - Delete Trigger.mp4 | 31.3 MB | ||
| 52 - Case statement English.srt | 7.5 KB | ||
| 52 - Case statement.mp4 | 53.3 MB | ||
| 52 - CaseStatement.txt | 614.4 B | ||
| 53 - COALESCE.pptx | 73.9 KB | ||
| 53 - Coalesce Function English.srt | 5 KB | ||
| 53 - Coalesce Function.mp4 | 29.7 MB | ||
| 53 - CreateTableCoalesce.txt | 409.6 B | ||
| 54 - Views in SQL English.srt | 4 KB | ||
| 54 - Views in SQL.mp4 | 25 MB | ||
| 55 - NullIf Function English.srt | 3 KB | ||
| 55 - NullIf Function.mp4 | 16.7 MB | ||
| 56 - Indexes.pptx | 76.4 KB | ||
| 56 - SQLite Indexes Part01 English.srt | 6.4 KB | ||
| 56 - SQLite Indexes Part01.mp4 | 28.6 MB | ||
| 57 - SQLite Indexes Part02 English.srt | 4.9 KB | ||
| 57 - SQLite Indexes Part02.mp4 | 37.2 MB | ||
| 6 - Keys.pptx | 72 KB | ||
| 6 - Primary Key and Foreign Key Database English.srt | 4.1 KB | ||
| 6 - Primary Key and Foreign Key Database.mp4 | 19.6 MB | ||
| 7 - SQLite Constraints English.srt | 6.7 KB | ||
| 7 - SQLite Constraints.mp4 | 37.9 MB | ||
| 7 - SQLiteConstraint.pptx | 70.3 KB | ||
| 8 - CREATE-Table.docx | 13.1 KB | ||
| 8 - CreateInsert and Select in SQL English.srt | 4.7 KB | ||
| 8 - CreateInsert and Select in SQL.mp4 | 25.2 MB | ||
| 8 - DDL-Commands.pptx | 87.6 KB | ||
| 8 - Database.docx | 17.8 KB | ||
| 9 - Delete and Drop Command English.srt | 2.3 KB | ||
| 9 - Delete and Drop Command.mp4 | 12.4 MB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 146 total files | |||
Sqlite Fundamentals - Comprehensive Sql Course On Sqlite
https://DevCourseWeb.com
Last updated 8/2019
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.06 GB | Duration: 4h 53m
A comprehensive course on SQLite Fundamentals and SQL
What you'll learn
Learn to write SQL queries in SQLite database
Hands on experience of all the major concepts.
Answer variety of database problems through SQL
At the end of this course, You will be able to use SQL statements in any database management system.
Requirements
No Experience of SQL and database are required
All you need a Computer machine; windows, Mac, and Linux users are all welcome
Tools:SQLite Studio/ SQLite Db Browser
Description
Unlike MySQL, Oracle, PostgreSQL, or SQL Server SQLite database is a server less database that serves the different purpose altogether. SQLite emphasizes economy, efficiency, reliability, independence, and simplicity.Use of SQLite:SQLite database requires no administration so it is best suited for embedded devices and the internet of things.Why to Learn SQL:SQL aka Structured Query Language is the most popular database language so it's use is everywhere whether we talk about Database,Data warehousing,Data Science or BI.Many big companies like Deloitte,Amazon,Netflix etc using this language to retrieve data from database.Important thing needs to understand that,the basic syntax of SQL for all databases is the same, so, if you have mastered SQL on SQLite database , the use of SQL on other databases would not be a problem for you.SQLite Major Topics:Introduction to SQLite DatabaseOperators in SQLAggregate Functions in SQLJoins in SQLSub-query in SQLAnalytical functionsTriggers in SQLAdvanced topics(Case statement,Views,Index,etc)Another aspect of this course is that not only I am going through all the concepts but also give the practical nstration by writing SQL queries.The pace of this course is very slow,means,I will emphasize ample time on the subject and will try to cover everything that I can.After this Course:Once your are done with the course,you will have maximum knowledge of SQL and you will be ready to apply all these concepts.Cheers..!!Have a Great Learning..!!!
Overview
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
|
Udemy - Build a RESTful API with Node.js, Express, and SQLite Database Posted by
freecoursewb in Other
|
1.4 GB | freecoursewb | 10 months | 0 | 0 |
| 401.4 MB | xHOBBiTx | 1 year | 34 | 3 | |
|
Udemy - Database and Query - Let's Talk SQL (SQL Server, SQLite etc.) Posted by
freecoursewb in Other
|
2.2 GB | freecoursewb | 2 years | 0 | 0 |
|
Udemy - Develop Complete Billing Software in Python, PyQt5 and SQLite Posted by
freecoursewb in Other
|
2.9 GB | freecoursewb | 3 years | 0 | 0 |
| 2.5 GB | freecoursewb | 3 years | 0 | 0 |
All Comments