Luca Liu articles - 74 total
Data Security in SQL: Encryption, Roles, and Permissions
Master data security in sql: encryption, roles, and permissions with SQL examples. Learn Introduction and Encrypting Sensitive Columns through practical exercises.
Stuck in a Version Trap - How I Used Azure ML to Deploy an Azure Function
Learn stuck in a version trap - how i used azure ml to deploy an azure function with comprehensive examples and best practices.
10 Essential Data Science Algorithms & Techniques
Introduction The world of data science can seem intimidating, filled with complex equations and advanced statistical concepts.
English Speaking Companies in Germany
This article serves as a comprehensive guide for job seekers looking for English-speaking opportunities in Germany. It highlights several prominent companies, including SAP, ALDI Süd, Kaufland E-commerce, Freenow, Allianz Global Investors, HolidayCheck, and Uniper, all of which operate primarily in English. The author shares personal experiences from interviews and interactions within these organizations, emphasizing the accessibility of the job market for non-German speakers. The guide aims to support international job seekers navigating the challenges of finding employment in Germany, encouraging readers to contribute additional company names to enhance the resource.
Markdown Code Blocks Breaking HTML Rendering: How to Fix Line Break Issues
Fix markdown code blocks that break HTML rendering with missing line breaks. Learn how to solve the common issue where code blocks get wrapped in paragraph tags instead of pre tags.
Draw a Fish and Watch it Swim - Crazy Idea Create Viral Website
Discover the viral sensation of drawafish.com, a simple yet engaging website where users can draw a fish and watch it swim in a virtual pond alongside creations from around the world. This article explores how the platform's intuitive interface fosters community, emphasizes the power of fun in web development, and highlights the importance of user experience. Learn valuable lessons for aspiring web developers about focusing on creativity and simplicity, while embracing the whimsical side of web experiences. Join the collective joy and creativity that makes this site a standout in a digital landscape dominated by productivity apps.
The Opportunity Card Germany - My First-Hand Experience and Complete Guide
Discover the Opportunity Card (Chancenkarte), Germany's innovative immigration policy aimed at attracting skilled workers from non-EU countries. This guide outlines its eligibility requirements, including education, financial stability, and language proficiency, as well as a points-based system to help you qualify. Learn how to apply, prepare for job hunting, and navigate your move to Germany with practical tips. With personal insights and experiences, this article provides valuable resources for newcomers, ensuring a smoother transition into the German job market. Don't miss additional recommendations for essential services to aid in your relocation!
Python + AI - The Essential Skill Combination for Modern Workers Without Coding Backgrounds
This article discusses the essential combination of Python and AI for modern workers without coding backgrounds, focusing on how Python, particularly the Pandas library, can automate repetitive tasks in Excel, handle large datasets, and simplify complex calculations. It provides a beginner-friendly introduction to using online platforms like Deepnote and Google Colab to get started with Python, leveraging AI to assist in writing code. The article emphasizes the importance of learning through experimentation and includes a real-world example demonstrating how Python can analyze sales data efficiently, ultimately encouraging users to embrace Python to enhance productivity and skills.
NotionNext - The Ultimate Solution for Notion-Based Website Building
Are you looking for a seamless way to create a personal blog website? Look no further than...
Do You Really Need a “Second Brain”?
Do You Really Need a “Second Brain”? In a world overflowing with information, tools, and...
SQL Advanced Functions - CASE, COALESCE, and NULLIF Explained
Introduction SQL provides advanced functions like CASE, COALESCE, and NULLIF that are...
Database Design Principles - Normalization and Denormalization
Introduction Database design is a critical step in creating efficient, scalable, and...
Implementing Triggers in SQL - Automating Database Actions
Introdution Triggers are special stored procedures in SQL that are automatically executed...
Handling Dates and Times in Oracle Database
Working with date and time data is a crucial aspect of database operations. Oracle provides a rich...
SQL Transactions - COMMIT, ROLLBACK, and Savepoints with Python
In modern database development, tools like DataGrip make transaction handling easier by providing...
SQL Recursive Queries - Understanding Common Table Expressions (CTEs)
Recursive queries in SQL, enabled by Common Table Expressions (CTEs), allow us to work with...
SQL Performance Tuning: Best Practices for Faster Queries
Introduction Efficient SQL queries are essential for optimal performance in Oracle...
Mastering SQL Joins - Inner, Outer, Cross, and Self-Joins with Examples
Introdution SQL joins are a fundamental feature for combining data from multiple tables...
A Guide to Manage Access in SQL - GRANT, REVOKE, and Access Control
Introduction In SQL, controlling access to database objects is crucial for ensuring data...
A Quick Guide to SQL Data Modification Commands with Examples
Introduction SQL is not just about querying data—it also includes powerful commands to...
How to chat with Local LLM in Obsidian
Introduction In Why You Should Try a Local LLM Model—and How to Get Started, I introduced...
Getting Responses from Local LLM Models with Python
Introduction After setting up your local LLM model with LM Studio (as covered in my...
Local LLM Models and Game Changing Use Cases for Life Hackers
This is a submission for the 2025 New Year Writing challenge: Predicting 2025. ...
Why You Should Try a Local LLM Model—and How to Get Started
Introduction In recent years, Large Language Models (LLMs) have revolutionized the way we...
A Quick Review of SQL Window Functions with Examples
Introduction Window functions are a powerful feature in SQL used to perform calculations...
How to Publish an Article to DEV Using Python
Introduction As a regular Obsidian user for writing articles, I found manually publishing...
How to Schedule Python Scripts on a Mac Using Crontab
Introduction If you’re a Mac user and have ever wanted to run a Python script...
How to Publish an Article to Medium Using Python and the Medium API
Introduction As someone who uses Obsidian to write articles, I often find myself needing...
What Does a -2 Reaction Mean? Is It a Bug?
Hey DEV community! I recently noticed something odd on one of my articles—it received -2...
Obsidian - How to create Daily note every day, even if I don't open it
Problem The Daily Note plugin is a fundamental feature in Obsidian, essential for many...