Smart Content Search

Find the exact content you need

Search across courses, articles, programs, MCQs, and descriptive questions from your knowledge platform in one clean workspace.

1248

Results Found

3

Current Page

63

Total Pages

Article Result 41

Assignment Solution: MySQL Functions

Assignment Solution 11.7 Assignment Solution: MySQL Functions Review the complete solution for MySQL functions, including string functions, numeric functions, date functions, conversion functions, conditional functions, debugging, and complete student report g...

/article/read/39/5844

Article Result 42

Assignment Solution: MySQL Performance Optimization

Assignment Solution 22.7 Assignment Solution: MySQL Performance Optimization Complete SQL solution for analyzing slow queries, using EXPLAIN, creating indexes, optimizing joins, avoiding common performance mistakes, and improving MySQL query performance. Solut...

/article/read/39/5866

Article Result 43

Assignment Solution: Sorting and Limiting in MySQL

Assignment Solution 10.5 Assignment Solution: Sorting and Limiting in MySQL Review the complete solution for sorting, limiting, pagination, and unique-value selection in MySQL using ORDER BY, ASC, DESC, LIMIT, OFFSET, and DISTINCT. Solution Purpose: This solut...

/article/read/39/5842

Article Result 44

Assignment Solution: Stored Procedures and Functions in MySQL

Assignment Solution 18.6 Assignment Solution: Stored Procedures and Functions in MySQL Review the complete solution for stored procedures and stored functions in MySQL, including procedure creation, parameterized procedures, stored functions, routine managemen...

/article/read/39/5858

Article Result 45

Assignment Solution: Subqueries in MySQL

Assignment Solution 14.6 Assignment Solution: Subqueries in MySQL Review the complete solution for MySQL subqueries, including subqueries in WHERE, SELECT, and FROM clauses, IN, NOT IN, EXISTS, NOT EXISTS, ANY, ALL, correlated subqueries, debugging, and join v...

/article/read/39/5850

Article Result 46

Assignment Solution: Transactions in MySQL

Assignment Solution 17.6 Assignment Solution: Transactions in MySQL Review the complete solution for MySQL transactions, including START TRANSACTION, COMMIT, ROLLBACK, SAVEPOINT, ROLLBACK TO SAVEPOINT, AUTOCOMMIT, InnoDB, ACID properties, and real-world transa...

/article/read/39/5856

Article Result 47

Assignment Solution: Triggers in MySQL

Assignment Solution 19.8 Assignment Solution: Triggers in MySQL Complete SQL solution for creating and testing MySQL triggers for product validation, audit logs, price history, deleted records, and automatic stock updates. Solution Objective In this assignment...

/article/read/39/5860

Article Result 48

Assignment Solution: User Management and Security in MySQL

Assignment Solution 21.6 Assignment Solution: User Management and Security in MySQL Complete SQL solution for creating MySQL users, granting privileges, revoking permissions, verifying access, dropping temporary users, and applying database security best pract...

/article/read/39/5864

Article Result 49

Assignment Solution: Views in MySQL

Assignment Solution 15.6 Assignment Solution: Views in MySQL Review the complete solution for MySQL views, including creating simple views, join-based views, aggregate views, modifying views, dropping views, debugging view queries, and comparing tables with vi...

/article/read/39/5852

Article Result 50

Assignment Solution: Working with Tables

Assignment Solution 4.7 Assignment Solution: Working with Tables Review the complete solution for working with MySQL tables, including creating tables, altering table structure, renaming tables, dropping tables, truncating tables, and understanding basic table...

/article/read/39/5830

Article Result 51

ATS-Friendly Resume

RESUME MASTERY ATS-Friendly Resume A complete beginner-friendly guide to understanding Applicant Tracking Systems, resume keywords, formatting rules, section structure, and practical steps to create a resume that is readable by both software and recruiters. ...

/article/read/132/5685

Article Result 52

Attributes in MySQL

MYSQL DATABASE DESIGN Attributes in MySQL Understand how attributes describe entities, become columns in MySQL tables, and help design meaningful databases. What is an Attribute? An attribute is a property, feature, or detail that describes an entity in a da...

/article/read/39/5755

Article Result 53

audit logs

SYSTEM DESIGN • CHAPTER 13.7 Audit Logs Understand how audit logs establish an accountable record of who did what, when, and to which resource, and how to design them so the evidence survives the incident it was meant to explain. Learning objective: By the end...

/article/read/135/6739

Article Result 54

authentication vs authorization

API DESIGN & SERVICE CONTRACTS Idempotency Learn how to make retried API requests safe by designing operations with repeatable effects, validating idempotency keys, storing execution outcomes, preventing concurrent duplicates, and handling uncertain distribute...

/article/read/135/6673

Article Result 55

AVG() in MySQL

MYSQL • AGGREGATE FUNCTIONS AVG() Function in MySQL Calculate the Average Value With Precision — Find Means, Trends, and Patterns in Your Data Instantly Introduction The AVG() function in MySQL is an aggregate function that calculates the average (mean) value ...

/article/read/39/5598

Article Result 56

Azure Database Services

Azure Database Services Azure provides many Database services to cater to the wide range of needs of enterprises. Few them are: Relational Database Services - Azure provides SQL, MySQL, and PostgreSQL services as PaaS, making it easier to move existing workloa...

/article/read/91/3145

Article Result 57

Azure physical infrastructure

Physical Infrastructure Overview Datacenters: Facilities with resources arranged in racks, with dedicated power, cooling, and networking. Global Presence: Azure has datacenters worldwide, grouped into Azure Regions or Availability Zones. Regions Definition: Ge...

/article/read/91/3264

Article Result 58

B-tree and composite indexes

RELATIONAL DATA MODELING & SQL B-tree and Composite Indexes Learn how B-tree indexes organize searchable keys, how composite indexes support multi-column filters and ordering, why column order matters, how indexes affect reads and writes, and how to design ind...

/article/read/135/6681

Article Result 59

Backend Development Path

Career and Next Steps Backend Development Path Learn the complete backend development path from programming fundamentals, databases, APIs, authentication, security, testing, deployment, and system design to real-world backend projects. Introduction Backend dev...

/article/read/8/6077

Article Result 60

basic data lifecycle

DATA STORAGE & MANAGEMENT Basic Data Lifecycle Learn how data moves from creation and collection through validation, storage, processing, use, sharing, archival, retention, and secure deletion, and how ownership, metadata, quality, security, recovery, and obse...

/article/read/135/6691

1
2
3
4
5
...
63