#my sql database

[demo-ness]

my old advisor was """restructured""" a while ago and my new one can be SO frustrating. they spent several emails working on the assumption that i had veteran benefits, for some reason, and in our most recent interaction they just full on ignored my question about whether a class i wanted to take would be viable or not. WHAT DO YOU THINK WE'RE HERE TO DO, MAN

[borealing]

"learn to code" as advice is such bullshit. i have learned and used four and a half different coding languages through my career (html/css, java, python+sql, c++) and when i say used i mean I've built things in every one but the things that i actually used these languages for??? these earn zero money (with the caveat of until you have seniority in, e.g. front end web dev) what people really mean when they say learn coding is "learn to code. go into investment banking or finance startups." coding does not inherently have money in it. my absolute favourite part of coding? my peak enjoyment? was when i was developing for a visual coding language (you put it together like a flowchart, so say youre using a temperature sensor and you want it to log the temperature once every four hours, you can put the blocks together to make it do that. i was writing the code behind the blocks for new sensors) and i was earning £24k a year and that wasn't even part of my main role. it was an extra voluntary thing i was doing (i was working as a research assistant in biosensors - sort of - at a university, and was developing the visual code for students who didnt want to learn c++) like. i want people to learn to code, i want people to know how their electrical equipment works and how coding works, but dont believe the myth that there is inherently money in coding. the valuable things, the things people are passionate about are still vulnerable to the passion tax (if you want to do it you dont have to be paid for it). skills arent where the money is, money is where the money is.

[attitudetallyacademy]

Web Development Roadmap for Students to Get Hired Fast

Introduction

In today’s digital era, web development is a career with vast opportunities and rapid growth. If you're a student eager to build a strong foundation and get hired quickly in this competitive industry, having a clear roadmap is crucial. This guide will walk you through essential steps and skills to master, helping you transition from a beginner to a confident web developer ready for the job market.

Step 1: Learn the Basics of Web Designing and Development

Before diving into coding, it's important to understand the fundamentals of web designing and development. Enroll in a web designing course or web designing coaching institute to gain hands-on experience with HTML, CSS, and JavaScript. These core technologies are the building blocks of any website and are crucial to becoming a skilled web developer.

Many students prefer web designing classes or web designing training institute to get structured learning with expert guidance. This foundational knowledge will help you understand how websites are built and styled.

Step 2: Master Frontend and Backend Development

Once comfortable with the basics, focus on frontend development, where you create the visible parts of a website users interact with. Skills like responsive design and working with frameworks such as React or Angular are highly valued.

Simultaneously, learning backend development — which deals with servers, databases, and application logic — is important. Consider joining a web development course or web development training institute to explore server-side languages like Node.js, PHP, or Python.

For a more comprehensive skill set, look into a full stack web development course in Yamuna Vihar or full stack web development training. Full stack developers, who handle both frontend and backend tasks, are in high demand.

Step 3: Explore UI/UX Design Fundamentals

Understanding user interface (UI) and user experience (UX) design can set you apart from other developers. This knowledge helps you build websites that are not only functional but also user-friendly and visually appealing.

Enroll in ui/ux courses with certificate in Yamuna Vihar or user interface design course to get started. These courses cover UX design fundamentals and offer certifications that add value to your portfolio.

You can also find ui ux design certification and ui ux designing coaching centre in Yamuna Vihar to deepen your skills in this area.

Step 4: Gain Practical Experience and Build a Portfolio

Theory is important, but practical experience is key to getting hired fast. Work on real projects, either through internships or freelance gigs, to apply your knowledge.

Look for web development coaching centre or web development classes that emphasize project work and portfolio development. A strong portfolio showcasing websites or applications you’ve built will impress potential employers.

Step 5: Learn Programming Languages like Python and Java

For backend and full stack roles, programming languages like Python and Java are essential. Join a python programming course or java full stack developer course to build proficiency.

These courses often offer python certification course or full stack developer certification , which help validate your skills to recruiters.

Step 6: Prepare for Interviews and Stay Updated

Landing your first job requires interview preparation. Practice coding problems, understand common interview questions, and be ready to explain your projects.

Stay updated with the latest technologies by attending workshops or joining web designing coaching centre in Uttam Nagarand full stack web development coaching institute.

Final Thoughts

Starting your journey with the right training at reputed institutes, such as web designing coaching in Yamuna Vihar or full stack developer training , is vital. Combining technical skills with UI/UX knowledge and real-world experience dramatically increases your chances to get hired quickly.

Remember, consistency and continuous learning are key in the fast-evolving web development industry. Follow this roadmap, practice regularly, and soon you’ll be ready to take on exciting opportunities in web development.

If you're looking for quality web development training or web designing course in Uttam Nagar, focus on institutes that offer practical projects, updated curriculum, and placement assistance to boost your career growth effectively.

Suggested Links: –

Oracle Database Administration

MY SQL Training

PHP Development

[yappacadaver]

LETS GO PLAY VALORANT IM ABT TO EARN MY VERY FIRST KNIFE SKIN :DDDDDDDDDDDDDDD

[tipswithalam]

How To Find My Sql Database Host Name

[sybaritick]

the inevitable tension between:

In an effort to demystify programming, which many people still think of as a skill that requires some sort of exceptional intelligence or training, I will always emphasize that basically anyone can do simple programming tasks like creating their own browser extension or simple website, using SQL to query a database, making data visualizations with matplotlib, etc. You can learn to do this in a week. If you're not sure you can for real just ask me (dm here or on Discord). it IS easy and anyone CAN do it! This isn't me saying "learn to code to get a job," which used to be decent advice 5 years ago but isn't any more because of AI and market saturation. More just "if there is something you want to do, at work or as a personal thing, that requires programming skills you think you might not have, I bet you can do it anyway. Do it!"

Okay maybe the reason I think this way is because my dad was teaching me Java when I was literally 8 years old

[komaedalovemail]

komaedas have you tried straw.page?

(i hope you don't mind if i make a big ollllle webdev post off this!)

i have never tried straw.page but it looks similar to carrd and other WYSIWYG editors (which is unappealing to me, since i know html/css/js and want full control of the code. and can't hide secrets in code comments.....)

my 2 cents as a web designer is if you're looking to learn web design or host long-term web projects, WYSIWYG editors suck doodooass. you don't learn the basics of coding, someone else does it for you! however, if you're just looking to quickly host images, links to your other social medias, write text entries/blogposts, WYSIWYG can be nice.

toyhouse, tumblr, deviantart, a lot of sites implement WYSIWYG for their post editors as well, but then you can run into issues relying on their main site features for things like the search system, user profiles, comments, etc. but it can be nice to just login to your account and host your information in one place, especially on a platform that's geared towards that specific type of information. (toyhouse is a better example of this, since you have a lot of control of how your profile/character pages look, even without a premium account) carrd can be nice if you just want to say "here's where to find me on other sites," for example. but sometimes you want a full website!

---------------------------------------

neocities hosting

currently, i host my website on neocities, but i would say the web2.0sphere has sucked some doodooass right now and i'm fiending for something better than it. it's a static web host, e.g. you can upload text, image, audio, and client-side (mostly javascript and css) files, and html pages. for the past few years, neocities' servers have gotten slower and slower and had total blackouts with no notices about why it's happening... and i'm realizing they host a lot of crypto sites that have crypto miners that eat up a ton of server resources. i don't think they're doing anything to limit bot or crypto mining activity and regular users are taking a hit.

↑ page 1 on neocitie's most viewed sites we find this site. this site has a crypto miner on it, just so i'm not making up claims without proof here. there is also a very populated #crypto tag on neocities (has porn in it tho so be warned...).

---------------------------------------

dynamic/server-side web hosting

$5/mo for neocities premium seems cheap until you realize... The Beautiful World of Server-side Web Hosting!

client-side AKA static web hosting (neocities, geocities) means you can upload images, audio, video, and other files that do not interact with the server where the website is hosted, like html, css, and javascript. the user reading your webpage does not send any information to the server like a username, password, their favourite colour, etc. - any variables handled by scripts like javascript will be forgotten when the page is reloaded, since there's no way to save it to the web server. server-side AKA dynamic web hosting can utilize any script like php, ruby, python, or perl, and has an SQL database to store variables like the aforementioned that would have previously had nowhere to be stored.

there are many places in 2024 you can host a website for free, including: infinityfree (i use this for my test websites :B has tons of subdomains to choose from) [unlimited sites, 5gb/unlimited storage], googiehost [1 site, 1gb/1mb storage], freehostia [5 sites/1 database, 250mb storage], freehosting [1 site, 10gb/unlimited storage]

if you want more features like extra websites, more storage, a dedicated e-mail, PHP configuration, etc, you can look into paying a lil shmoney for web hosting: there's hostinger (this is my promocode so i get. shmoney. if you. um. 🗿🗿🗿) [$2.40-3.99+/mo, 100 sites/300 databases, 100gb storage, 25k visits/mo], a2hosting [$1.75-12.99+/mo, 1 site/5 databases, 10gb/1gb storage], and cloudways [$10-11+/mo, 25gb/1gb]. i'm seeing people say to stay away from godaddy and hostgator. before you purchase a plan, look up coupons, too! (i usually renew my plan ahead of time when hostinger runs good sales/coupons LOL)

here's a big webhost comparison chart from r/HostingHostel circa jan 2024.

---------------------------------------

domain names

most of the free website hosts will give you a subdomain like yoursite.has-a-cool-website-69.org, and usually paid hosts expect you to bring your own domain name. i got my domain on namecheap (enticing registration prices, mid renewal prices), there's also porkbun, cloudflare, namesilo, and amazon route 53. don't use godaddy or squarespace. make sure you double check the promo price vs. the actual renewal price and don't get charged $120/mo when you thought it was $4/mo during a promo, certain TLDs (endings like .com, .org, .cool, etc) cost more and have a base price (.car costs $2,300?!?). look up coupons before you purchase these as well!

namecheap and porkbun offer something called "handshake domains," DO NOT BUY THESE. 🤣🤣🤣 they're usually cheaper and offer more appealing, hyper-specific endings like .iloveu, .8888, .catgirl, .dookie, .gethigh, .♥, .❣, and .✟. I WISH WE COULD HAVE THEM but they're literally unusable. in order to access a page using a handshake domain, you need to download a handshake resolver. every time the user connects to the site, they have to provide proof of work. aside from it being incredibly wasteful, you LITERALLY cannot just type in the URL and go to your own website, you need to download a handshake resolver, meaning everyday internet users cannot access your site.

---------------------------------------

hosting a static site on a dynamic webhost

you can host a static (html/css/js only) website on a dynamic web server without having to learn PHP and SQL! if you're coming from somewhere like neocities, the only thing you need to do is configure your website's properties. your hosting service will probably have tutorials to follow for this, and possibly already did some steps for you. you need to point the nameserver to your domain, install an SSL certificate, and connect to your site using FTP for future uploads. FTP is a faster, alternative way to upload files to your website instead of your webhost's file upload system; programs like WinSCP or FileZilla can upload using FTP for you.

if you wanna learn PHP and SQL and really get into webdev, i wrote a forum post at Mysidia Adoptables here, tho it's sorted geared at the mysidia script library itself (Mysidia Adoptables is a free virtual pet site script, tiny community. go check it out!)

---------------------------------------

file storage & backups

a problem i have run into a lot in my past like, 20 years of internet usage (/OLD) is that a site that is free, has a small community, and maybe sounds too good/cheap to be true, has a higher chance of going under. sometimes this happens to bigger sites like tinypic, photobucket, and imageshack, but for every site like that, there's like a million of baby sites that died with people's files. host your files/websites on a well-known site, or at least back it up and expect it to go under!

i used to host my images on something called "imgjoe" during the tinypic/imageshack era, it lasted about 3 years, and i lost everything hosted on there. more recently, komaedalovemail had its webpages hosted here on tumblr, and tumblr changed its UI so custom pages don't allow javascript, which prevented any new pages from being edited/added. another test site i made a couple years ago on hostinger's site called 000webhost went under/became a part of hostinger's paid-only plans, so i had to look very quickly for a new host or i'd lose my test site.

if you're broke like me, looking into physical file storage can be expensive. anything related to computers has gone through baaaaad inflation due to crypto, which again, I Freaquing Hate, and is killing mother nature. STOP MINING CRYPTO this is gonna be you in 1 year

...um i digress. ANYWAYS, you can archive your websites, which'll save your static assets on The Internet Archive (which could use your lovely donations right now btw), and/or archive.today (also taking donations). having a webhost service with lots of storage and automatic backups can be nice if you're worried about file loss or corruption, or just don't have enough storage on your computer at home!

if you're buying physical storage, be it hard drive, solid state drive, USB stick, whatever... get an actual brand like Western Digital or Seagate and don't fall for those cheap ones on Amazon that claim to have 8,000GB for $40 or you're going to spend 13 days in windows command prompt trying to repair the disk and thenthe power is gong to go out in your shit ass neighvborhood and you have to run it tagain and then Windows 10 tryes to update and itresets the /chkdsk agin while you're awayfrom town nad you're goig to start crytypting and kts just hnot going tot br the same aever agai nikt jus not ggiog to be the saeme

---------------------------------------

further webhosting options

there are other Advanced options when it comes to web hosting. for example, you can physically own and run your own webserver, e.g. with a computer or a raspberry pi. r/selfhosted might be a good place if you're looking into that!

if you know or are learning PHP, SQL, and other server-side languages, you can host a webserver on your computer using something like XAMPP (Apache, MariaDB, PHP, & Perl) with minimal storage space (the latest version takes up a little under 1gb on my computer rn). then, you can test your website without needing an internet connection or worrying about finding a hosting plan that can support your project until you've set everything up!

there's also many PHP frameworks which can be useful for beginners and wizards of the web alike. WordPress is one which you're no doubt familiar with for creating blog posts, and Bluehost is a decent hosting service tailored to WordPress specifically. there's full frameworks like Laravel, CakePHP, and Slim, which will usually handle security, user authentication, web routing, and database interactions that you can build off of. Laravel in particular is noob-friendly imo, and is used by a large populace, and it has many tutorials, example sites built with it, and specific app frameworks.

---------------------------------------

addendum: storing sensitive data

if you decide to host a server-side website, you'll most likely have a login/out functionality (user authentication), and have to store things like usernames, passwords, and e-mails. PLEASE don't launch your website until you're sure your site security is up to snuff!

when trying to check if your data is hackable... It's time to get into the Mind of a Hacker. OWASP has some good cheat sheets that list some of the bigger security concerns and how to mitigate them as a site owner, and you can look up filtered security issues on the Exploit Database.

this is kind of its own topic if you're coding a PHP website from scratch; most frameworks securely store sensitive data for you already. if you're writing your own PHP framework, refer to php.net's security articles and this guide on writing an .htaccess file.

---------------------------------------

but. i be on that phone... :(

ok one thing i see about straw.page that seems nice is that it advertises the ability to make webpages from your phone. WYSIWYG editors in general are more capable of this. i only started looking into this yesterday, but there ARE source code editor apps for mobile devices! if you have a webhosting plan, you can download/upload assets/code from your phone and whatnot and code on the go. i downloaded Runecode for iphone. it might suck ass to keep typing those brackets.... we'll see..... but sometimes you're stuck in the car and you're like damn i wanna code my site GRRRR I WANNA CODE MY SITE!!!

↑ code written in Runecode, then uploaded to Hostinger. Runecode didn't tell me i forgot a semicolon but Hostinger did... i guess you can code from your webhost's file uploader on mobile but i don't trust them since they tend not to autosave or prompt you before closing, and if the wifi dies idk what happens to your code.

---------------------------------------

ANYWAYS! HAPPY WEBSITE BUILDING~! HOPE THIS HELPS~!~!~!

-Mod 12 @eeyes

[willalraand]

Hear me out

A The Beholding ritual but it’s just some guy given some enormous spooky database and they have to come up with as many useful sql views for it

(Doing my databases homework for hours and listening to TMA at the same time does interesting things to my mind and it full on feels like some ritual)

[lazeecomet]

The Story of KLogs: What happens when an Mechanical Engineer codes

Since i no longer work at Wearhouse Automation Startup (WAS for short) and havnt for many years i feel as though i should recount the tale of the most bonkers program i ever wrote, but we need to establish some background

WAS has its HQ very far away from the big customer site and i worked as a Field Service Engineer (FSE) on site. so i learned early on that if a problem needed to be solved fast, WE had to do it. we never got many updates on what was coming down the pipeline for us or what issues were being worked on. this made us very independent

As such, we got good at reading the robot logs ourselves. it took too much time to send the logs off to HQ for analysis and get back what the problem was. we can read. now GETTING the logs is another thing.

the early robots we cut our teeth on used 2.4 gHz wifi to communicate with FSE's so dumping the logs was as simple as pushing a button in a little application and it would spit out a txt file

later on our robots were upgraded to use a 2.4 mHz xbee radio to communicate with us. which was FUCKING SLOW. and log dumping became a much more tedious process. you had to connect, go to logging mode, and then the robot would vomit all the logs in the past 2 min OR the entirety of its memory bank (only 2 options) into a terminal window. you would then save the terminal window and open it in a text editor to read them. it could take up to 5 min to dump the entire log file and if you didnt dump fast enough, the ACK messages from the control server would fill up the logs and erase the error as the memory overwrote itself.

this missing logs problem was a Big Deal for software who now weren't getting every log from every error so a NEW method of saving logs was devised: the robot would just vomit the log data in real time over a DIFFERENT radio and we would save it to a KQL server. Thanks Daddy Microsoft.

now whats KQL you may be asking. why, its Microsofts very own SQL clone! its Kusto Query Language. never mind that the system uses a SQL database for daily operations. lets use this proprietary Microsoft thing because they are paying us

so yay, problem solved. we now never miss the logs. so how do we read them if they are split up line by line in a database? why with a query of course!

select * from tbLogs where RobotUID = [64CharLongString] and timestamp > [UnixTimeCode]

if this makes no sense to you, CONGRATULATIONS! you found the problem with this setup. Most FSE's were BAD at SQL which meant they didnt read logs anymore. If you do understand what the query is, CONGRATULATIONS! you see why this is Very Stupid.

You could not search by robot name. each robot had some arbitrarily assigned 64 character long string as an identifier and the timestamps were not set to local time. so you had run a lookup query to find the right name and do some time zone math to figure out what part of the logs to read. oh yeah and you had to download KQL to view them. so now we had both SQL and KQL on our computers

NOBODY in the field like this.

But Daddy Microsoft comes to the rescue

see we didnt JUST get KQL with part of that deal. we got the entire Microsoft cloud suite. and some people (like me) had been automating emails and stuff with Power Automate

This is Microsoft Power Automate. its Microsoft's version of Scratch but it has hooks into everything Microsoft. SharePoint, Teams, Outlook, Excel, it can integrate with all of it. i had been using it to send an email once a day with a list of all the robots in maintenance.

this gave me an idea

and i checked

and Power Automate had hooks for KQL

KLogs is actually short for Kusto Logs

I did not know how to program in Power Automate but damn it anything is better then writing KQL queries. so i got to work. and about 2 months later i had a BEHEMOTH of a Power Automate program. it lagged the webpage and many times when i tried to edit something my changes wouldn't take and i would have to click in very specific ways to ensure none of my variables were getting nuked. i dont think this was the intended purpose of Power Automate but this is what it did

the KLogger would watch a list of Teams chats and when someone typed "klogs" or pasted a copy of an ERROR mesage, it would spring into action.

it extracted the robot name from the message and timestamp from teams

it would lookup the name in the database to find the 64 long string UID and the location that robot was assigned too

it would reply to the message in teams saying it found a robot name and was getting logs

it would run a KQL query for the database and get the control system logs then export then into a CSV

it would save the CSV with the a .xls extension into a folder in ShairPoint (it would make a new folder for each day and location if it didnt have one already)

it would send ANOTHER message in teams with a LINK to the file in SharePoint

it would then enter a loop and scour the robot logs looking for the keyword ESTOP to find the error. (it did this because Kusto was SLOWER then the xbee radio and had up to a 10 min delay on syncing)

if it found the error, it would adjust its start and end timestamps to capture it and export the robot logs book-ended from the event by ~ 1 min. if it didnt, it would use the timestamp from when it was triggered +/- 5 min

it saved THOSE logs to SharePoint the same way as before

it would send ANOTHER message in teams with a link to the files

it would then check if the error was 1 of 3 very specific type of error with the camera. if it was it extracted the base64 jpg image saved in KQL as a byte array, do the math to convert it, and save that as a jpg in SharePoint (and link it of course)

and then it would terminate. and if it encountered an error anywhere in all of this, i had logic where it would spit back an error message in Teams as plaintext explaining what step failed and the program would close gracefully

I deployed it without asking anyone at one of the sites that was struggling. i just pointed it at their chat and turned it on. it had a bit of a rocky start (spammed chat) but man did the FSE's LOVE IT.

about 6 months later software deployed their answer to reading the logs: a webpage that acted as a nice GUI to the KQL database. much better then an CSV file

it still needed you to scroll though a big drop-down of robot names and enter a timestamp, but i noticed something. all that did was just change part of the URL and refresh the webpage

SO I MADE KLOGS 2 AND HAD IT GENERATE THE URL FOR YOU AND REPLY TO YOUR MESSAGE WITH IT. (it also still did the control server and jpg stuff). Theres a non-zero chance that klogs was still in use long after i left that job

now i dont recommend anyone use power automate like this. its clunky and weird. i had to make a variable called "Carrage Return" which was a blank text box that i pressed enter one time in because it was incapable of understanding /n or generating a new line in any capacity OTHER then this (thanks support forum).

im also sure this probably is giving the actual programmer people anxiety. imagine working at a company and then some rando you've never seen but only heard about as "the FSE whos really good at root causing stuff", in a department that does not do any coding, managed to, in their spare time, build and release and entire workflow piggybacking on your work without any oversight, code review, or permission.....and everyone liked it

[mckencodes]

8-18-24

I am starting SQL on Codecademy today! I know nothing about databases, despite taking a class on in 2020 (😅). My sister has a bunch of photos from when she made a baking instagram and I want to make a website using them. I'm thinking a recipe that you can search based on ingredients. I'm taking a break from JavaScript, so the backend will be using Flask. I love JavaScript, but I'm a bit bored of it right now tbh. I'll try to update about this project, but this blog is kind of a mess (oops).

🎧: Join the Club by Tilly Louise

P.s. the coffee is cookie butter caramel latte with almond milk, from local coffee shop 🧡

[veliseraptor]

figured out how to export a database, convert it into a readable file, and run a sql query for a very specific formatting quirk all by myself from the very basic sql knowledge I've managed to scrape together on my own. i'm so smart

[hazellight11]

Exam went well 👍

It was all multiple choice that i could reason through pretty well. A few questions about specific things I don't usually use but i think i reasoned through those okay too

I have an exam this morning (9:30) that I haven't studied for at all because instead of giving us a study guide or a list of topics, the professor told us (two days before the exam) to ask chatgpt for study problems (fuck chatgpt all the homies hate chatgpt)

[attitudetallyacademy]

Build a Strong Backend: Why Web Developers Should Focus on MySQL Early

Introduction

When it comes to web development, most beginners are fascinated by the visual aspects of websites—the buttons, layouts, and animations. But behind every great website lies a powerful backend, and one of the most essential components of this backend is the database. Among the many database management systems out there, MySQL stands out as the most widely used and beginner-friendly option. If you're planning to enroll in a web development course in Yamuna Vihar or web development training in Uttam Nagar, it’s important to understand why you should prioritize learning MySQL early in your journey.

What is MySQL and Why is it So Important?

MySQL is an open-source relational database management system. It is used to store, organize, and retrieve data for web applications. It powers some of the world’s biggest platforms including Facebook, Twitter, and YouTube. For any student taking web designing classes in Yamuna Vihar or web development coaching in Uttam Nagar, learning MySQL is a non-negotiable step.

Why? Because it’s the heart of how web apps interact with data. Whether it’s a login system, product catalog, or a content management system—MySQL is what makes these features function.

Early MySQL Skills = Long-Term Benefits

Students who start learning MySQL early gain a significant advantage:

Better understanding of backend logic

You’ll start understanding how data flows between the front-end and backend, giving you a complete picture of web development.

Stronger foundation for full-stack development

If you're aiming to become a full-stack developer, learning MySQL early prepares you for advanced backend frameworks like Node.js, Django, or Laravel.

Boost your job-readiness

Recruiters and companies look for developers who can handle the full development cycle—especially those with MySQL and database management experience.

If you’re taking a full stack web development course in Yamuna Vihar or searching for the best full stack developer course with placement in Uttam Nagar, you’ll notice MySQL is an integral part of the curriculum.

How MySQL Complements Front-End Skills

Even if your primary interest lies in UI/UX or front-end design, having a grip on MySQL sets you apart. For example:

UI elements like dropdowns or search bars often fetch real-time data from the backend via SQL queries.

Dynamic websites that display user data or product recommendations rely heavily on MySQL databases.

If you're already exploring UI UX free online courses with certificates in Yamuna Vihar or a user interface design course in Uttam Nagar, pairing that with MySQL will make your portfolio completer and more impressive.

Key Concepts You Should Learn in MySQL

Here are some essential MySQL concepts every web developer should master:

Database creation and table structures

SQL queries: SELECT, INSERT, UPDATE, DELETE

Joins and relationships

Data normalization

Indexing for performance optimization

These concepts are often covered thoroughly in a web development training institute in Yamuna Vihar or web development coaching center in Uttam Nagar.

Real-World Applications of MySQL

Whether you're developing an e-commerce website, a social media platform, or a blog, MySQL will help you:

Store user credentials securely

Handle product inventories

Maintain order history

Run analytics on user behavior

Students attending web designing coaching in Yamuna Vihar or web development classes in Uttam Nagar often work on real-time projects that require database connectivity, making MySQL a practical tool rather than just theoretical knowledge.

Conclusion: Start with MySQL to Stay Ahead

Web development is not just about what users see—it's also about how websites work behind the scenes. MySQL teaches you the logic and structure that bring data-driven websites to life. So, if you’re currently enrolled in or planning to join a web designing course in Yamuna Vihar or a web development course in Uttam Nagar, make sure MySQL is at the top of your learning list.

Whether your goal is to become a full stack developer, build your own website, or master UI/UX design, understanding databases like MySQL will take your skills to the next level.

Suggested Links:

Oracle Database Administration

MY SQL Training

PHP Development

[liquidcrystalsky]

im not entirely done btw, i do eventually want to make gamefiles.ranid.space an actual website, i'm tempted to even have little 3d viewers included (so i might actually have to make that gltf exporter. groans)

I'll be posting about it here when it's done (it'll take months at LEAST) and also i have an rss feed now lol

i've just manually written it out but i want to get my website blog into a sort of database (hence why i was interested in mysql) so it can automatically update the feed, but right now it's just a post filled with a bunch of outdated info about cool brower stuff and a post about how im quitting social media so nothing cool yet but i'll talk on there much less frequently because it sucks to manually do all of this.

shout out people on the internet in like the 80s this is just how they did shit. actually i lied they had SQL back then as well. how old is SQL. damn 1974 lmao okay.

i just remembered that Fortran is still being used, what the hell do you mean the best way to make something is with a programming language made in the 50s. what do you mean it's used in supercomputers.

[akaicodes]

update to my roadmap of learning https://www.tumblr.com/akaicodes/744920785897111552/roadmap-of-learning-curriculum-related-so-far - 4 months later ♡

• C# - spent ~1 year so far practicing, more comfortable, can build whole sites/programs with little help

• HTML & CSS - started ~5 months ago, confident in both, can style a site without help online, still much to learn

• JavaScript + Vue - Axios - can build “full stack” applications where i do both backend & frontend and host online (love JS!!)

• REST - experienced for 5 months! can build my own REST API, use someone elses with axios & test it thoughoutly with Postman (+Javascript code)

• Unit testing & UI testing - learned so many better ways to unit test & UI test more indeph

• Started leaning Git more with commands

• SQL - can manipulate simple databases and more one from scratch

& huge thanks to my sister @niyacodes for being on this journey with me 💓

++++ I went to a 5 hour exam for all these subjects (+- more) and got the highest grade possible 🥹 (i failed my first programming exam in 1st sem!!!!) ((pic is my favorite after study-snack))

[argumate]

Hi Argumate! I just read about your chinese language learning method, and you inspired me to get back to studying chinese too. I want to do things with big datasets like you did, and I am wondering if that means I should learn to code? Or maybe I just need to know databases or something? I want to structure my deck similar to yours, but instead of taking the most common individual characters and phrases, I want to start with the most common components of characters. The kangxi radicals are a good start, but I guess I want a more evidence-based and continuous approach. I've found a dataset that breaks each hanzi into two principle components, but now I want to use it determine the components of those components so that I have a list of all the meaningful parts of each hanzi. So the dataset I found has 嘲 as composed of 口 and 朝, but not as 口𠦝月, or 口十曰月. So I want to make that full list, then combine it with data about hanzi frequency to determine the most commonly used components of the most commonly used hanzi, and order my memorization that way. I just don't know if what I'm describing is super complicated and unrealistic for a beginner, or too simple to even bother with actual coding. I'm also not far enough into mandarin to know if this is actually a dumb way to order my learning. Should I learn a little python? or sql? or maybe just get super into excel? Is this something I ought to be able to do with bash? Or should I bag the idea and just do something normal? I would really appreciate your advice

I think that's probably a terrible way to learn to read Chinese, but it sounds like a fun coding exercise! one of the dictionaries that comes with Pleco includes this information and you could probably scrape it out of a text file somewhere, but it's going to be a dirty grimy task suited to Python text hacking, not something you would willingly undertake unless you specifically enjoy being Sisyphus as I do.

if you want to actually learn Chinese or learn coding there are probably better ways! but I struggle to turn down the romance of a doomed venture myself.