MySQL Cheat Sheet: Essential Commands & Syntax

Posted by on Aug 6, 2024 in Computers | 0 comments

MySQL Cheat Sheet

MySQL Command-Line Client Commands

Connect to MySQL server using the mysql command-line client with a username and password (MySQL will prompt for a password):

mysql -u [username] -p

Connect to MySQL Server with a specified database using a username and password:

mysql -u [username] -p [database]

Exit mysql command-line client:

exit

Export data using mysqldump tool

mysqldump -u [username] -p [database] > data_backup.sql

To clear the MySQL screen console on Linux, use the following command:

Read More

Object-Oriented Modeling and Design

Posted by on Aug 5, 2024 in Computers | 0 comments

MDE

MDE inc level of abs & automates dev process(faster, consistency, reuse)

Descriptive

understand complex systems, communicate, predict.

Prescriptive

specify system (blueprints) & implement systems

Abstraction

Emphasize important things, ignore irrelevant | Accuracy | Prediction | Low Cost | Understandability (Ex: Obj – world, Class – obj, Superclass – class, Op – set of methods)

Usefulness

Understanding, Communicating, Control complexity, Developing

Structural

(Describe concept and their relationship:

Read More

Network Technologies: A Comprehensive Guide to Wired and Wireless Communication

Posted by on Aug 5, 2024 in Computers | 0 comments

1. Twisted Pair

A twisted pair consists of two wires (usually copper), each covered by a plaited insulation. One cable carries the signal, and the other is the ground reference. Braiding cancels electromagnetic interference, and twisting effects are canceled.

Different Types of Copper Twisted Pair

There are two types of twisted pair: UTP (unshielded) and STP (shielded). There are seven categories that depend on the quality of the cable, the thickness, and the speed of data transmission, from CAT 1

Read More

Thread Basics and Synchronization in C

Posted by on Aug 5, 2024 in Computers | 0 comments

Thread Basics:
  • Thread operations include thread creation, termination, synchronization (joins,blocking), scheduling, data management and process interaction.
  • A thread does not maintain a list of created threads, nor does it know the thread that created it.
  • All threads within a process share the same address space.
  • Threads in the same process share:
    • Process instructions
    • Most data
    • open files (descriptors)
    • signals and signal handlers
    • current working directory
    • User and group id
  • Each thread has a unique:
    • Thread
Read More

Understanding Characteristics of Relations and SQL Data Types

Posted by on Aug 5, 2024 in Computers | 0 comments

1) List and briefly explain the Characteristics of Relations:

  • 1. Ordering of Tuples in a Relation: A relation is defined as a set of tuples. Mathematically, elements of a set have no order among them; hence, tuples in a relation do not have any particular order. Similarly, when tuples are represented on a storage device, they must be organized in some fashion, and it may be advantageous, from a performance standpoint, to organize them in a way that depends upon their content.
  • 2. Ordering of Values
Read More

Software Configuration Management: Identification, Version Control, Change Control, Audit, and Reporting

Posted by on Aug 4, 2024 in Computers | 0 comments

Identification of Objects in the Software Configuration

  • To control and manage software configuration items, each should be separately named and then organized using an object-oriented approach.
  • Two types of objects can be identified: Basic objects and aggregate objects
  • A basic object is a unit of information that has been created by a software engineer during analysis, design, code, or test. For example, a basic object might be a section of requirements specification, part of a design model, or a source
Read More