I learned how to use Python version management tool, pyenv, with various virtual environments like pipenv, pyenv-virtualenv , venv, and virtualwrapper. My preference goes to use pyenv with pipenv.
I decided to finally make a complete move to the Linux distribution, Ubuntu 22.04, indeed the ecosystem for programming is much more convenient there. Also, most courses that I take are geared toward using Mac or Linux. Now, I am doing all my projects in the Linux system. I found it useful to configure in Ubuntu: • Timeshift for imaging the system • Déjà Dup which is a simple backup tool for file • PuTTY to be able to access the Ubuntu terminal when on Windows • WinSCP app which is file transfer between a Windows and Ubuntu
I completed the mini-tutorial “Python: write to sqlite database from pandas dataframe” taught by Mark Keith on YouTube. The length of the tutorial is 0.16 total video hours. In this tutorial I learned: • Pandas dataframe to SQLite and SQLite to pandas dataframe • Read and modify data using pandas and add new changes to SQLite database You can find this course at https://www.youtube.com/watch?v=YyUknBHcZB8&ab_channel=MarkKeith
I earned a Certificate of Completion that verifies that I successfully completed “SQLite Fundamentals - Comprehensive SQL course on SQLite” beginner course on 17/9/2022 as taught by Saad Qureshi 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 DB Browser for SQLite. The length of the course is 5.0 total video hours. In this course I learned: • DDL, DML commands • String manipulation • Operators in SQLite • Aggregate Functions in SQL • Joins in SQL • Sub-query in SQL • Statement with join and sub-query • Analytical functions • Triggers in SQL • Advanced topics(Case statement,Views,Index,etc) For this course, I used SQLite Studio and SQLite DBSchema. You can find this course at https://www.udemy.com/course/sqlite-sql-beginners
I fully completed SQLite tutorial on https://www.sqlitetutorial.net/. In this tutorial, I learned SQLite step by step through extensive hands-on practices. This SQLite tutorial is designed for developers who want to use SQLite as the back-end database or to use SQLite to manage structured data in applications including desktop, web, and mobile apps. In this tutorial I learned: • How to build relationships between tables e.g. (1:1), (1:N), (N:N) based on Crow's foot notations. Primary Key and Foreign Key concepts • Joins, group by, having, subquery, case, replace, distinct, in, between, where, offset, like, glob, translate, union, full-text search (FTX), dump, vacuum, import, and export • Windows(Analytical), Aggregate, Data, and String functions • Indexes(performance, in WHERE clause, columns with a lot of data), Triggers(logging, audit, effect other tables and database), and Views • SQL Commands: DDL, DML, TLC, and DQL • API SQLite Python • Using SQLite command line and in_memory database • Pragma foreign_key, pragma user_version (tracking version of database) During this tutorial, I used DBeaver, SQLiteStudio, DbSchema for SQLite, DB Browser, and CMD.
You can put any information here you'd like.