#SQL).

[megmahoneyart]

Like I said, I don't have the bandwidth to do a daily art challenge this October, but that I'd do /some/ mxtxtober. And I HAD to do prompt 4: Wine Bottle 👀

[futurebird]

Do not help them to build any more of this machine.

If you work with a database and are asked to alter the table structure to comply in advance for citizenship or gender categorizations it's really important to NOT do it.

"The governor is concerned about all this stuff they want us to update our record keeping so we store both gender AND biological sex."

"We need fields to store the country of origin of people's parents."

If you don't have the power to rebuff this yourself, ask for help. At minimum ask for help online anonymously.

Depending on your job you probably have in the past made compromises. Maybe to keep your job. Maybe to survive. This is a bright line. If you are asked to be the one to update the table don't let it be your fingers typing those changes.

If you can't just say "No I won't do that." Stall, run away, feign incompetence. Just don't let it happen.

I suspect this might be where the rubber hits the road first for us around here.

Nothing has changed. You do not have to do it. It is not even ordained.

I know someone who rebuffed such a request. Boss was apologetic "it's what the higher ups want, oh *I* think it's a lot of nonsense, but I don't want us to be out of step ... blah blah"

It was proposed to them in sheepish way. They said it would be a lot of work, not add anything of value, and most important they would not do it. It didn't come up again.

Fascism can be the work of zealots, but there are also many sheepish middle management helping hands who "don't even believe in this really"

There is a lively discussion of this on mastodon. (Mastodon is a very active social network where many people who left twitter have gone over the past few years to escape many problems of big centralized socail media. I like it a lot.) Posting a response to this post over there could be a way to get lots of help and ideas from tech people all over the world with similar values. If you do need help. Please say something.

Also, if you respond to this post I can pass what you say along if that would help too. People will respond and give you ideas to NOT do this should you be asked.

[coffee-dad-studies]

Good morning. ☕ Last night, I took and passed my Database Management Applications exam, which was the last exam in my degree program. Here's a pic of some of my notes (which I intended to post the other night while I was actually studying).

I have until April 30 to complete my capstone project if I'm going to finish by the end of the term. (I do qualify for a one-month extension, though. I went ahead and requested it just in case I need a few extra days.)

Lots of research and writing will be happening over the next week. 📚

[lithiumdoll]

Enough of the gif/jif discourse

[onlytiktoks]

[akvamarinka-art]

Очень зацепила эта фраза в новелле

[systemdeez]

This faggot just got a B in their SQL class :3

[nerdymemes]

[nixcraft]

Wait what... ? this is dangerous knowledge.

[welele]

Viendo las webs gubernamentales y la de tráfico que tenemos, esa inyección SQL seguro que colaría.

[imall4frogs]

The “genius” of Elon Musk becomes more suspect with each passing day. Hypothetical question: If the source is too stupid to know that his information is wrong, would he be still be spreading disinformation?

[crackaddict55]

🤩Are you a CS Student !?!???? 🥳🤩😎CHECK OUT THESE-

No. No I’m not. I study at home.

[raptorstudiesstuff]

Life update -

Hi, sorry for being MIA for a while and I'll try to update here more frequently. Here's a general update of what I've been up to.

Changed my Tumblr name from studywithmeblr to raptorstudiesstuff. Changed my blog name as well. I don't feel comfortable putting my real name on my social media platforms so I'm going by 'Raptor' now.

💻 Finished the Machine Learning-2 and Unsupervised Learning module along with projects. Got a pretty good grade in both of them and my overall grade went up a bit.

📝 Started applying for data science internships and jobs but got rejected from most of the companies I applied to... 😬

I'll start applying again in a week or two with a new resume. Let me know any tips I can use to not get rejected. 😅

💻 Started SQL last week and really enjoying it. I did get a bad grade on an assignment though. Hope I can make up for it in the final quiz. 🤞

🏥 Work has been alright. We're a little less staffed than usual this week but I'm trying not to stress too much about it.

📖 Currently reading Discworld #1 - The Color of Magic. More than halfway through.

📺 Re-watched the Lord of The Rings movies and now I'm compelled to read the books or rewatch the Hobbit movies.

"There's good in this world, Mr Frodo, and it's worth fighting for." This scene had me in tears and I really needed to hear that..

📺 Watched the first 4 episodes of First Kill on Netflix and I don't know what I was doing to myself. The writing and dialogue is so cheesy and terrible. The acting is okay-ish. It's so bad that it turned out to be quite hilarious. Laughed the whole time.

🎧 Discovered a new (for me) song that I'm obsessed with right now - Mirrors by Justin Timberlake.

📷 Took some really cool pics on my camera..

Might start the 100 days productivity challenge soon as that is the only way I find myself to be consistent.

Peace ✌️

Raptor

PS. Please don't repost any of my pictures without permission.

[codingquill]

SQL Fundamentals #1: SQL Data Definition

Last year in college , I had the opportunity to dive deep into SQL. The course was made even more exciting by an amazing instructor . Fast forward to today, and I regularly use SQL in my backend development work with PHP. Today, I felt the need to refresh my SQL knowledge a bit, and that's why I've put together three posts aimed at helping beginners grasp the fundamentals of SQL.

Understanding Relational Databases

Let's Begin with the Basics: What Is a Database?

Simply put, a database is like a digital warehouse where you store large amounts of data. When you work on projects that involve data, you need a place to keep that data organized and accessible, and that's where databases come into play.

Exploring Different Types of Databases

When it comes to databases, there are two primary types to consider: relational and non-relational.

Relational Databases: Structured Like Tables

Think of a relational database as a collection of neatly organized tables, somewhat like rows and columns in an Excel spreadsheet. Each table represents a specific type of information, and these tables are interconnected through shared attributes. It's similar to a well-organized library catalog where you can find books by author, title, or genre.

Key Points:

Tables with rows and columns.

Data is neatly structured, much like a library catalog.

You use a structured query language (SQL) to interact with it.

Ideal for handling structured data with complex relationships.

Non-Relational Databases: Flexibility in Containers

Now, imagine a non-relational database as a collection of flexible containers, more like bins or boxes. Each container holds data, but they don't have to adhere to a fixed format. It's like managing a diverse collection of items in various boxes without strict rules. This flexibility is incredibly useful when dealing with unstructured or rapidly changing data, like social media posts or sensor readings.

Key Points:

Data can be stored in diverse formats.

There's no rigid structure; adaptability is the name of the game.

Non-relational databases (often called NoSQL databases) are commonly used.

Ideal for handling unstructured or dynamic data.

Now, Let's Dive into SQL:

SQL is a :

Data Definition language ( what todays post is all about )

Data Manipulation language

Data Query language

Task: Building and Interacting with a Bookstore Database

Setting Up the Database

Our first step in creating a bookstore database is to establish it. You can achieve this with a straightforward SQL command:

CREATE DATABASE bookstoreDB;

SQL Data Definition

As the name suggests, this step is all about defining your tables. By the end of this phase, your database and the tables within it are created and ready for action.

1 - Introducing the 'Books' Table

A bookstore is all about its collection of books, so our 'bookstoreDB' needs a place to store them. We'll call this place the 'books' table. Here's how you create it:

CREATE TABLE books ( -- Don't worry, we'll fill this in soon! );

Now, each book has its own set of unique details, including titles, authors, genres, publication years, and prices. These details will become the columns in our 'books' table, ensuring that every book can be fully described.

Now that we have the plan, let's create our 'books' table with all these attributes:

CREATE TABLE books ( title VARCHAR(40), author VARCHAR(40), genre VARCHAR(40), publishedYear DATE, price INT(10) );

With this structure in place, our bookstore database is ready to house a world of books.

2 - Making Changes to the Table

Sometimes, you might need to modify a table you've created in your database. Whether it's correcting an error during table creation, renaming the table, or adding/removing columns, these changes are made using the 'ALTER TABLE' command.

For instance, if you want to rename your 'books' table:

ALTER TABLE books RENAME TO books_table;

If you want to add a new column:

ALTER TABLE books ADD COLUMN description VARCHAR(100);

Or, if you need to delete a column:

ALTER TABLE books DROP COLUMN title;

3 - Dropping the Table

Finally, if you ever want to remove a table you've created in your database, you can do so using the 'DROP TABLE' command:

DROP TABLE books;

To keep this post concise, our next post will delve into the second step, which involves data manipulation. Once our bookstore database is up and running with its tables, we'll explore how to modify and enrich it with new information and data. Stay tuned ...

Part2

[triandot]