Posts

Showing posts from October, 2018

Different types of Cables and CPU parts

Image
HDMI(High-Definition Multimedia Interface) It is a type of cable or connector  which carries audio/video signal from source device to the connected device.  The information sent over HDMI is uncompressed digital data. Which carries high definition audio,video signals from source device to the sync device. VGA(  V ideo Graphics Array)  cable It is a type of cable which carries visual display data from the CPU to the monitor. One end of the VGA cable is attached to the port in the graphics card on the computer motherboard, and the other to the port in the display device. It only carries analog signals. DVI ( Digital Visual Interface ) It also carries video signals from source to display device. It carries both analog and digital signals. Video quality is better than the VGA . SMPS(Switch Mode Power Supply) The main function of SMPS is to convert AC current to DC and supply it to motherboard. The power supply convert...
Image
group by category of movie group by two fields i.e. category + year_released Having condition Select into To create a structure of existing table we use select into. To insert date from existing table to new table. Student _details table Isnull() function: Replaces the column name with given value if the column is null. isnull(column_name,replaced_value) Case Updating  table using case movies2 table: After updating movies2 table insert into select used to insert data from one table to the other which is already created. date types should be match in both the tables. the following query gives error because movies3 table is not there in the database. After creating the movies3 table.

Breathing space

Image
Breathing space is the space between letters,words and lines or any design that  provides visual breathing for the eye. The exact space we need to give  to  design something. Without breathing space anything looks awkward. Anything looks good with breathing space. It improves readability. Examples: Without breathing space White space helps to give importance to the main element of the design.

Multiplication table and Calendar

Image
1.multiplication table with specified number of rows and columns. 2.Multiplication table with required rows and columns entering at a time. Calendar  1. Creating a table with 5 rows and 7 columns 2. Adding table header to the table . 3. creating select box with months. 4. Changing the text of extra days in the calendar.    5. Adding two buttons with up and down. When clicking up the previous month calendar will be displayed. 6. When clicking down the next month calendar will be displayed.  7. Highlighting today's date in calendar. 8. Adding current time to the calendar .

SQL Training

Image
Data: Data is collection of information. It is any sort of information which is stored in computer memory. It may be personal information, banking information, address information. Database: database is organised and it has a specific structure. Eg: phone book which is sorted in the order of their last names.        Online television streaming service which stores a list of movies and TV shows.       Healthcare stores patients data in their database.       All weather data is stored in a database and retrieved, analysed from that database. DBMS Data Base Management System. It is a software which is used to perform different operations like addition,deleting and updation of data in the database. DBMS VS RDBMS DBMS RDBMS Data is stored in the form of files. Data is stored in the form of tables. The data may consists tables. The data only consists tables. Relation is not defined in DBMS. It consists relation between...