FreeTutorials Eu UDEMY SQLite for beginners - FTU

1. 1. Getting Started/1. Introduction.mp49.04MB
2. 1. Getting Started/2. What is SQLite .mp421.98MB
3. 1. Getting Started/3. Download and Install SQLite.mp445.56MB
4. 1. Getting Started/4. What is SQLite Studio .mp426.14MB
5. 1. Getting Started/5. Attaching Sample Database to SQLite.mp444.32MB
6. 1. Getting Started/6. How to connect to SQLite Database.mp425.76MB
7. 1. Getting Started/7. Database Concepts.mp46.27MB
8. 2. Some Basic SQLite3 Commands/1. What is sqlite3 tool.mp49.9MB
9. 2. Some Basic SQLite3 Commands/2. Some commonly used sqlite3 commands.mp439.11MB
10. 2. Some Basic SQLite3 Commands/3. SQLite Dump command.mp447.96MB
11. 3. Retrieving Data and Manipulating Data/1. SQLite SELECT statement.mp420.99MB
12. 3. Retrieving Data and Manipulating Data/2. Querying data from all columns in a table.mp422.05MB
13. 3. Retrieving Data and Manipulating Data/3. Querying data from specific columns in a table.mp425.48MB
14. 3. Retrieving Data and Manipulating Data/4. Sorting data using ORDER BY clause.mp435.87MB
15. 3. Retrieving Data and Manipulating Data/5. Removing duplicate records using DISTINCT clause.mp426.24MB
16. 3. Retrieving Data and Manipulating Data/6. Filtering data with WHERE clause.mp435MB
17. 3. Retrieving Data and Manipulating Data/7. Identifying NULL values.mp419.6MB
18. 3. Retrieving Data and Manipulating Data/8. SQLite Data Types.mp426.48MB
19. 3. Retrieving Data and Manipulating Data/9. SQLite ALiases.mp432.1MB
20. 4. Creating Database Tables Updating Data Deleting Records/1. SQLite Constraints.mp419.73MB
21. 4. Creating Database Tables Updating Data Deleting Records/2. SQLite Create Table Statement - Part 1.mp429.67MB
22. 4. Creating Database Tables Updating Data Deleting Records/3. SQLite Create Table Statement - Part 2.mp448.72MB
23. 4. Creating Database Tables Updating Data Deleting Records/4. SQLite INSERT INTO Table Statement.mp444.64MB
24. 4. Creating Database Tables Updating Data Deleting Records/5. SQLite UPDATE Statement.mp418.29MB
25. 4. Creating Database Tables Updating Data Deleting Records/6. SQLite DELETE Statement.mp413.72MB
26. 4. Creating Database Tables Updating Data Deleting Records/7. SQLite DROP Table Statement.mp47.46MB
27. 5. Some SQLite Operators/1. SQLite BETWEEN Operator.mp423.16MB
28. 5. Some SQLite Operators/2. SQLite IN Operator.mp428.51MB
29. 5. Some SQLite Operators/3. SQLite LIKE operator.mp434.7MB
30. 5. Some SQLite Operators/4. SQLite GLOB Operator.mp429.13MB
31. 5. Some SQLite Operators/5. SQLite LIMIT clause.mp431.52MB
32. 6. SQLite Subquery/1. What is a subquery.mp412.52MB
33. 6. SQLite Subquery/2. Building a subquery in a WHERE clause using IN operator.mp422.78MB
34. 6. SQLite Subquery/3. Building a subquery in a WHERE clause using IN operator.mp417.39MB
35. 6. SQLite Subquery/4. Building a subquery in FROM clause.mp414.55MB
36. 7. SQLITE Table Joins/1. SQLite LEFT Join.mp429.22MB
37. 7. SQLITE Table Joins/2. SQLite INNER Join.mp431.79MB
38. 7. SQLITE Table Joins/3. SQLite CROSS Join.mp427.35MB
39. 7. SQLITE Table Joins/4. SQLite SELF Join.mp445.03MB
40. 8. SQLite Aggregate Functions/1. Introduction to SQLite Aggregate Functions.mp413.97MB
41. 8. SQLite Aggregate Functions/2. SQLite AVG Function.mp422.48MB
42. 8. SQLite Aggregate Functions/3. SQLite COUNT Function.mp428.65MB
43. 8. SQLite Aggregate Functions/4. SQLIte SUM Function.mp413.99MB
44. 8. SQLite Aggregate Functions/5. SQLite MAX Function.mp46.43MB
45. 8. SQLite Aggregate Functions/6. SQLite MIN Function.mp418.22MB
46. 8. SQLite Aggregate Functions/7. SQLite GROUP CONCAT Function.mp49.23MB
47. 8. SQLite Aggregate Functions/8. SQLite GROUP BY Clause.mp419.68MB
48. 8. SQLite Aggregate Functions/9. SQLite HAVING Clause.mp434.89MB