S.S.S DHYUTHIDHARsudheendra.hashnode.dev·Nov 14, 2024Introduction to Exploratory Data Analysis (EDA) in SQLHello everyone! I’m Dhyuthidhar Saraswathula. If you’re new here, I write blogs on Data Science and Computer Science topics. So, buckle up! Today, we’re diving into an essential data science concept: Exploratory Data Analysis (EDA). In SQL, EDA means...DiscussData Science
Pentest_Testing_CorpforSQL Injection Prevention in Wordpresssql-injection-prevention-in-wordpress.hashnode.dev·Nov 10, 2024Secure Your WordPress Site: SQL Injection (SQLi) Explained and PreventedSQL Injection (SQLi) in WordPress: How to Protect Your Site from Database Attacks With WordPress being one of the most widely used platforms, it’s also a target for many cybersecurity threats, including SQL Injection (SQLi) attacks. These attacks exp...Discuss#cybersecurity
Workspace Ronniedeveloper-ronnie.hashnode.dev·Nov 5, 2024PART-2 : Mastering Data Retrieval with SELECT StatementsDefining the Learners, Courses Table 💡 NOTE: Carefully follow the instructions when creating the tables. COURSE TABLE -- Create a table by the name of courses having field named "CourseID", "CourseName", "Course_duration_months", "Course_Fee" ...Discuss·38 readsSQL MasteryDatabases
Rajat Srivastavastackup.hashnode.dev·Oct 27, 2024Understanding SQL Server Isolation LevelsDatabase transactions are essential for keeping data accurate in systems where many processes run at the same time. SQL Server offers several isolation levels to balance consistency, concurrency, and performance. In this comprehensive guide, we’ll ex...DiscussDatabases
Mark Pelfmarkpelf.hashnode.dev·Oct 24, 2024.NET8/EF8 - Exception: Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '$NET8/EF8 Breaking Change. Old servers/databases might not understand queries from EF8. Abstract: In .NET8/EF8 when working with SQL Server, EF might create newer version SQL queries that old SQL servers/databases will not understand and will con...DiscussC#ef8
OBULIPURUSOTHAMAN Kobulipurusothaman.hashnode.dev·Oct 24, 2024Database IndexesDatabase Indexes :Consider a large Book of 1000 pages.Suppose you’re trying to find the page which contains information related to a certain word.Without an index page, you would have to go through every page, which could take hours or even days.But ...DiscussSQL
OBULIPURUSOTHAMAN Kobulipurusothaman.hashnode.dev·Oct 22, 2024Sql (vs) NosqlSQL (VS) NOSQL :One of the biggest decisions we make while designing a system is choosing between a Relational (SQL) or Non-Relational (NoSQL) database. Both have their strengths and use cases, but they differ significantly in their approach to data ...DiscussSQL
Data Senseisihan.hashnode.dev·Oct 21, 2024Azure DevOps Automated CICD pipeline with SQL Server Git IntegrationRecently I realised working with quite a few data teams across UK and US that many of these data teams still using VM hosted SQL Server and manually merging into main. To be honest, I helped the teams to get started with simple azure CICD build and r...DiscussSQL Server
Shreyansh Guptashreyanshgupta.hashnode.dev·Oct 17, 2024Types of database locksI recommend reading this article to understand the issues introduced by concurrency in databases, if you haven’t already. So the tradeoffs between concurrent and sequential access are - Either we keep sequential access to the database. Sacrifice sca...DiscussDatabases
S.S.S DHYUTHIDHARsudheendra.hashnode.dev·Oct 13, 2024Mastering SQL Commands: A Complete GuideHey Everyone! 👋 Today, I will break down the types of SQL commands. If you don’t know me yet, I’m Dhyuthidhar Saraswathula, and I love writing about Computer Science topics. Today, we’re diving into the backbone of SQL operations – SQL Commands. Let...Discuss·28 readsSQL
