Dec 31, 2022Daily ThoughtSocrates — “ The unexamined life is not worth living for a human being” The quote “The unexamined life is not worth living for a human being” is often attributed to Socrates, and it expresses his belief that self-examination and critical thinking are essential to leading a meaningful and fulfilling life. To…1 min read1 min read
Aug 22, 2022Alembic MigrationsRUN MIGRATIONS & ROLL BACKS — Step 1: Make sure virtual env is activated Step 2: Confirm alembic installation3 min read3 min readAlembic MigrationsRUN MIGRATIONS & ROLL BACKSStep 1: Make sure virtual env is activatedStep 2: Confirm alembic installation----
Aug 19, 2022Multi-Table Queries: Coding Challenge1 min read1 min readMulti-Table Queries: Coding Challenge----
Aug 19, 2022Multi-Table Queries: ExerciseEXAMPLE 1 — Problem: How can we find duplicate last names, in the combined list of last names from both the students and students tables? Approach: We must get the count of each last name. Then we will know that any last name with a count > 1 is a duplicate. Begin by…3 min read3 min read
Aug 19, 2022Multi-Table QueriesSubqueries, WITH Queries: Common Table Expressions — What are subqueries? EXIST3 min read3 min readMulti-Table QueriesSubqueries, WITH Queries: Common Table ExpressionsWhat are subqueries?EXIST----
Aug 18, 2022(NuC) Multi-Table QueriesSet Operations & Joins, Union, Intersect, INNER JOIN, LEFT, RIGHT, FULL JOIN — Set Operations Allow us to query from more than one table at a time Sample Data: UNION5 min read5 min read
Aug 17, 2022Coding Challenge: Data QueriesThese prompts were difficult. But it made me aware that i needed to brush up on aliases. The video I watched: Will revisit.1 min read1 min readCoding Challenge: Data QueriesThese prompts were difficult. But it made me aware that i needed to brush up on aliases. The video I watched:Will revisit.----
Aug 16, 2022Database QueriesAggregations, GROUP BY, HAVING — Aggregate functions Aggregations3 min read3 min read
Aug 16, 2022Wildcard Characters in SQL Server1 min read1 min readWildcard Characters in SQL Server----