#MySQL

[code-es]

The women who laid the foundation of tech

EDIT: I noticed that this post ended up being reblogged by terfs. If you're transphobic this post is not for you to reblog. I want to celebrate everyone who is not a cis man in this industry, including trans women and nonbinary people in tech, and it was my mistake to only include cis women in this post when there are so many trans women and nonbinary people who have done great things in tech as well. Trans women are women and just as important.

Here you can read about trans ppl in tech, and please do:

https://www.thecodingspace.com/blog/2022-03-01-six-trans-programmers-who-shattered-the-lavender-ceiling/

https://abcnews.go.com/Business/transgender-tech-visibility-obstacles-remain/story?id=76374628

The morning of women's day i attended a super inspiring seminar about being a woman in tech at a large tech company in my city, and now I'm inspired to share what I learned with all of you!

I didn't have time to finish this post on women's day, but it's not too late to post now: every day is a day to celebrate women!

Women actually laid the foundation for a lot of the tech industry.

For example, the first computer, ENIAC, was programmed completely by women! While men were the behind the scenes engineers, it was women who did all the actual programming of ENIAC.

The women who made up the team responsible for programming it were called Jean Bartik, Kay McNulty, Betty Holberton, Marlyn Wescoff, Frances V. Spence and Ruth Teitelbaum.

I think one woman who is finally getting her overdue recognition is Ada Lovelace. She was a mathematician (also often referred to as the first programmer) who created the first algorithm in 1842, which wasn't recognized until 1953! However, since none of her machines were ever completed it was never tested in practice during her time.

She has since been celebrated by giants such as google, and she has given name to a programming language (Ada). She was also the first person to write about what is today known as AI. Back when she was practicing, computers were simply thought of as calculators. But she had an idea that if computers can understand numbers, then that can be translated to letters, and in turn that can lead to computers being able to handle words, and eventually even write, draw and create music.

Hedy Lamarr was a famous Hollywood actress in the 40's, but she was also an inventor who laid ground for what we use today for Wi-Fi, Bluetooth and GPS services.

During WW2 she wanted to contribute positviely to the military efforts against the Nazis, and she tried to figure out how to radio control torpedoes. In 1942 she patented her technology "Secret Communications System", also known as frequency hopping, which laid the foundation for the technology we use today for Wi-Fi, GPS and Bluetooth. It wasn't until 1962 that it was first used for its intended purpose, during the cuban missile crisis.

Grace Hopper invented the first compiler, called A-0, in 1955, and was also part of the Univac team, which was the company also responsible for building ENIAC. She also initiated work on the COBOL programming language.

She was also the one to coin the term "bug" in 1947. Computers back then had lights to visualize their working process (which was also a womans idea to implement btw) and bugs would be attracted to the lights, but usually that was no issue - until a bug made its way into a tube which caused the computer to stop working. Hopper taped the bug to a piece of paper and logged what caused the crash - a bug.

Dorothy Vaughan (left), alongside colleagues such as Katherine Johnson (middle) and Mary Jackson (right), was a mathematician at NASA (called NACA when she started) who worked on the orbit for the first ever manned spaceflight and later also on Apollo 11 that would take humanity to the moon!

When Vaughan started at what was then called NACA, segregation was still prevalent in the US and she was not allowed in the same areas in the office as her white colleagues. Another department was formed for the black staff, and when the director of said department unexpectedly died, she was appointed as the new director and thus became the first ever black woman at that position at NACA/NASA. In 1958 when NACA becomes NASA segregation is forbidden, and that is when Vaughan and her colleagues Johnson and Jackson started working on programming the orbit and later also Apollo 11.

Continuing on the same track of NASA and space, Margaret Hamilton was the Apollo project's first actual programmer. Hamilton became the director of software engineering at NASA in 1965, and she was also the person to first coin the term !

In the image above, she stands next to all the handwritten code that was used to send humanity to the moon. During the early stages of the project when she would speak of "sofware engineering", software development was not taken as seriously as other forms of engineering, and it wasn't regarded as a science, either. She wanted to legitimize software development as an engineering discipline, and overtime the term "software engineering" gained the same respect as any other technical discipline.

And lastly, if you're a woman in STEM, I want to highlight and celebrate you! Being a woman in a male dominated industry is not easy, we often suffer from sterotype threat and are not seen as our own individuals, but rather "the woman" in a room full of men. But just as these women, I'm sure you will achieve greatness!!

Here are some additional resources if you'd like to learn more:

https://www.history.com/news/coding-used-to-be-a-womans-job-so-it-was-paid-less-and-undervalued

https://digitalfuturesociety.com/programming-when-did-womens-work-become-a-mans-world/

And this was mainly my source for this post, but it's unfortunately only available in Swedish:

Thank you for reading ✨

[nixcraft]

Wait what... ? this is dangerous knowledge.

[codingquill]

SQL Fundamentals #2: SQL Data Manipulation

In our previous database exploration journey, SQL Fundamentals #1: SQL Data Definition, we set the stage by introducing the "books" table nestled within our bookstore database. Currently, our table is empty, Looking like :

books

| title | author | genre | publishedYear | price |

Data manipulation

Now, let's embark on database interaction—data manipulation. This is where the magic happens, where our "books" table comes to life, and we finish our mission of data storage.

Inserting Data

Our initial task revolves around adding a collection of books into our "books" table. we want to add the book "The Great Gatsby" to our collection, authored F. Scott Fitzgerald. Here's how we express this in SQL:

INSERT INTO books(title, author, genre, publishedYear, price) VALUES('The Great Gatsby', 'F. Scott Fitzgerald', 'Classic', 1925, 10.99);

Alternatively, you can use a shorter form for inserting values, but be cautious as it relies on the order of columns in your table:

INSERT INTO books VALUES('The Great Gatsby', 'F. Scott Fitzgerald', 'Classic', 1925, 10.99);

Updating data

As time goes on, you might find the need to modify existing data in our "books" table. To accomplish this, we use the UPDATE command.For example :

UPDATE books SET price = 12.99 WHERE title = 'The Great Gatsby';

This SQL statement will locate the row with the title "The Great Gatsby" and modify its price to $12.99.

We'll discuss the where clause in (SQL fundamentals #3)

Deleting data

Sometimes, data becomes obsolete or irrelevant, and it's essential to remove it from our table. The DELETE FROM command allows us to delete entire rows from our table.For example :

DELETE FROM books WHERE title = 'Moby-Dick';

This SQL statement will find the row with the title "Moby-Dick" and remove it entirely from your "books" table.

To maintain a reader-friendly and approachable tone, I'll save the discussion on the third part of SQL, which focuses on data querying, for the upcoming post. Stay tuned ...

[skull-shore]

03.july23,mon ; internship

i had my first work-day today at my internship and my brain started melting alreadyyy D: i knew they were using PHP for their websites so i started off with learning HTML and CSS so far. Why does PHP seem so complicated compared to those two?:,)

I also didn't understand the connection between PHP and MySQL yet? can someone explain?

i decided to use my free night to begin the codecademy tutorial about PHP and just do that until i fall asleep, hopefully it will open my eyes a bit more than the website they provided me with. wish me luck(pls)<3

[playstationvii]

[amparol12]

Breaking Homework Barriers: Journey to Database Brilliance

In the fast-paced world of academia, students often find themselves grappling with the intricacies of database management and SQL homework. The challenges posed by these assignments can be daunting, leaving many seeking a guiding light to navigate the complexities of database design, queries, and optimization. If you're one of those students desperately searching for "help with mySQL homework," you've come to the right place. This blog will serve as your roadmap, guiding you through the journey to unlock the secrets of database brilliance.

Unraveling the Mysteries of mySQL Homework

Help with mySQL homework is more than just a search query; it's a plea for assistance in unraveling the mysteries of structured query language and database management systems. As you embark on your academic quest, you'll encounter challenges that test your understanding of data modeling, SQL syntax, and the nuances of optimizing database performance. Fear not, for every hurdle you face is an opportunity to grow and master the art of database design.

Navigating the Database Landscape

To embark on this journey, it's crucial to understand the landscape you're navigating. Databases are the backbone of modern applications, storing and managing vast amounts of information. SQL, or Structured Query Language, serves as the key to interacting with these databases, allowing you to retrieve, insert, update, and delete data seamlessly. However, the road to becoming proficient in SQL can be winding, filled with challenges that demand attention to detail and a deep understanding of database concepts.

The Role of Expert Guidance

In your quest for database brilliance, seeking expert guidance is akin to having a seasoned navigator on your journey. Platforms like DatabaseHomeworkHelp.com are designed to provide comprehensive help with mySQL homework. These services offer a lifeline for students drowning in assignments, providing expert assistance that goes beyond mere completion to ensure understanding and mastery of database principles.

Tailored Solutions for Individual Needs

One size does not fit all, especially when it comes to mastering database concepts. Help with mySQL homework should be tailored to your individual needs and learning style. A reliable service will not only assist with assignment completion but also provide detailed explanations, clarifying doubts and reinforcing your understanding of SQL. This personalized approach is the key to breaking down barriers and fostering true brilliance in database management.

Overcoming Common Challenges

As you delve into the world of databases, you'll likely encounter common challenges that can be stumbling blocks in your academic journey. Whether it's understanding normalization, crafting complex queries, or optimizing database performance, expert assistance can make all the difference. These challenges, when conquered with the right guidance, become stepping stones to a deeper understanding of database management.

Building a Foundation for Future Success

The journey to database brilliance is not just about completing assignments; it's about building a solid foundation for future success. The skills you acquire in navigating SQL and database design will prove invaluable in real-world scenarios. As industries increasingly rely on data-driven decision-making, your proficiency in database management will set you apart in the job market.

Embracing the Learning Process

Every stumble, every challenge, and every "help with mySQL homework" query is an integral part of your learning process. Embrace the journey, knowing that each assignment is an opportunity to enhance your skills. Don't shy away from seeking assistance when needed, as it's a sign of strength to recognize your limitations and actively work towards overcoming them.

Conclusion: Your Path to Database Brilliance

In conclusion, the journey to database brilliance is not a solitary one; it's a collaborative effort that involves seeking guidance, overcoming challenges, and embracing the learning process. When faced with the complexities of SQL homework, remember that help with mySQL homework is readily available. Take advantage of the resources at your disposal, and soon you'll find yourself not just completing assignments but mastering the art of database management. Your path to brilliance starts now.

[shwetaglobereach]

PHP & MySQL Essentials: Online Coding Course

Dive into dynamic web development! Our online course teaches PHP and MySQL for building robust, database-driven websites. Elevate your coding skills today!

[dvpno]

Current status of the database code: Bit fucked lol but i stopped working on it so wc

[koshekdev]

Backend update

Had the most horrible time working with Sequelize today! As I usually do whenever I work with Sequelize! Sequelize is an SQL ORM - instead of writing raw SQL, ORM gives you an option to code it in a way that looks much more like an OOP, which is arguably simpler if you are used to programming that way. So to explain my project a little bit, it's a full stack web app - an online photo editor for dragging and dropping stickers onto canvas/picture. Here is the diagram.

I'm doing it with Next which I've never used before, I only did vanilla js, React and a lil bit of Angular before. The architecture of a next project immediately messed me up so much, it's way different from the ones I've used before and I often got lost in the folders and where to put stuff properly (this is a huge thing to me because I always want it to be organized by the industry standard and I had no reference Next projects from any previous jobs/college so it got really overwhelming really soon :/) . The next problem was setting up my MySQL database with Sequelize because I know from my past experience that Sequelize is very sensitive to where you position certain files/functions and in which order are they. I made all the models (Sequelize equivalent of tables) and when it was time to sync, it would sync only two models out of nine. I figured it was because the other ones weren't called anywhere. Btw a fun fact

So I imported them to my index.js file I made in my database folder. It was reporting an db.define() is not a function error now. That was weird because it didn't report that for the first two tables that went through. To make a really long story short - because I was used to an server/client architecture, I didn't properly run the index.js file, but just did an "npm run dev" and was counting on all of the files to run in an order I am used to, that was not the case tho. After about an hour, I figured I just needed to run index.js solo first. The only reasons those first two tables went through in the beginning is because of the test api calls I made to them in a separate file :I I cannot wait to finish this project, it is for my bachelors thesis or whatever it's called...wish me luck to finish this by 1.9. XD

Also if you have any questions about any of the technologies I used here, feel free to message me c: <3 Bye!

[the-real-wholesome-bitch]

There will never be a time that in my coding projects that I don’t put a Percy Jackson name as a place holder

[arshikasingh]

SQL Interview Questions

The following SQL interview questions and answers are designed to familiarize candidates with common interview questions.

[nixcraft]

[hitthebooksposts]

Thinking about trying to get AO3's source code running on my own server.

Just to see what's involved.

Though would love some direction on where to learn a bit about MySQL as it's a big part of getting it to work.

[kittu800]

[amparol12]

Unveiling Expertise: An Interview with Dr. Elon, a Database Homework Help Maestro (+9 Years of Experience)

Welcome to the insightful world of database management! In our exclusive interview today, we bring you face-to-face with Dr. Elon, a seasoned expert in the realm of database homework help, boasting an impressive track record of over nine years. Dr. Elon is not just a name; it's a synonym for proficiency and passion in navigating the intricate landscapes of SQL homework assistance.

Q1: Dr. Elon, could you share a bit about your journey and what inspired you to delve into the world of database homework help?

Dr. Elon: Absolutely. My journey began with a profound interest in database systems during my academic years. As I delved deeper, I realized the challenges students faced in grasping SQL concepts. This realization ignited my passion for aiding them in mastering the art of database management.

Q2: With over nine years of experience, you've witnessed the evolution of database technology. How has this experience shaped your approach to helping students with SQL homework?

Dr. Elon: It's been an exciting ride. Over the years, I've seen technology leap forward. This experience has allowed me to adapt my teaching methods, ensuring students are not just acquainted with the fundamentals but are also well-prepared for the dynamic, real-world applications of SQL.

Q3: "Help with SQL homework" is a common plea from students. What, in your opinion, makes SQL assignments particularly challenging, and how do you assist students in overcoming these challenges?

Dr. Elon: SQL assignments often involve intricate queries and a deep understanding of database design. The challenge lies in translating theoretical knowledge into practical application. I guide students through this process, emphasizing hands-on practice and offering step-by-step assistance tailored to their learning pace.

Q4: Can you share an experience where you witnessed a student's "aha" moment while working on their SQL homework, and what strategies do you employ to foster such breakthroughs?

Dr. Elon: Oh, absolutely. There was a student struggling with a complex JOIN operation. Through patient guidance and breaking down the problem into manageable parts, the student suddenly grasped the concept. It's about building confidence through small victories and celebrating those "aha" moments.

Q5: The field of database management is ever-evolving. How do you ensure your assistance aligns with the latest trends and technologies, keeping students ahead of the curve?

Dr. Elon: Continuous learning is at the core of my approach. I stay abreast of the latest industry trends, incorporating relevant updates into my teaching materials. This ensures that students not only understand the foundational principles but are also prepared for the current demands of the field.

Conclusion:

Our interview with Dr. Elon, a stalwart in database homework help, has unveiled a wealth of experience and insights. From inspiring journeys to overcoming SQL challenges, Dr. Elon's expertise has proven instrumental in guiding students toward mastering the intricacies of database management. If you find yourself uttering the words "help with SQL homework," rest assured, Dr. Elon is the beacon of knowledge you've been seeking on your academic journey.