SQL CREATE INDEX Statement
SQL CREATE INDEX Statement The CREATE INDEX statement is used to create indexes in tables. Indexes are used to retrieve data from the database very fast. The users cannot see the indexes, they are just used to speed up searches/queries. Note: Updating a table with indexes takes more time than updating a table without (because the indexes also need an update). So, only create indexes on columns that will be frequently searched against.
SQL DEFAULT Constraint
SQL DEFAULT Constraint The DEFAULT constraint is used to provide a default value for a column. The default value will be added to all new records IF no other value is specified. SQL DEFAULT on CREATE TABLE The following SQL sets a DEFAULT value for the "City" column when the "Persons" table is created:
SQL FOREIGN KEY Constraint
SQL FOREIGN KEY Constraint A FOREIGN KEY is a key used to link two tables together. A FOREIGN KEY is a field (or collection of fields) in one table that refers to the PRIMARY KEY in another table. The table containing the foreign key is called the child table, and the table containing the candidate key is called the referenced or parent table.
SQL JOIN
SQL JOIN A JOIN clause is used to combine rows from two or more tables, based on a related column between them. Let's look at a selection from the "Orders" table: Then, look at a selection from the "Customers" table: Notice that the "CustomerID" column in the "Orders" table refers to the "CustomerID" in the "Customers" table. The relationship between the two tables above is the "CustomerID" column
MySQL Functions
MySQL Functions MySQL has many built-in functions. This reference contains string, numeric, date, and some advanced functions in MySQL. ________________________________________
SQL Keywords Reference
SQL Keywords Reference This SQL keywords reference contains the reserved words in SQL. ________________________________________
BCA-Software Engineering-Waterfall Model
Software Engineering: An Overview Aim: Waterfall Model Advantages of using Waterfall model 1. Easy reviewing of the progress after every phase 2. Simple, efficient and easily manageable code 3. Every phase is taken up and processed one at a time 4. Works well for small projects where requirements are clearly understood Disadvantages of using Waterfall model 1. Real projects rarely follow the sequential flow as given in the waterfall model. 2. It is difficult for the customer to state all of the requirements explicitly. 3. The software is not available until the end of the life cycle. This requires patience from the side of the customer. V Model Iterative Model and much more
Software Engineering- Software Product and Process
Here we learn about some important concepts of Software engineering: Software Product and Process Software Engineering Paradigm Software Development Lifecycle Waterfall model and more
Computer Graphics-Polygon Rendering Methods
Here we learn about some of the concepts of Computer Graphics: Polygon Rendering Methods Contents we will start to look at rendering methods used in computer graphics Flat surface rendering Gouraud surface rendering Phong surface rendering No Surface Rendering Flat Surface Rendering No Surface Rendering Vs Flat Surface Rendering Gouraud Surface Rendering and many more
Computer Graphics-Illumination Models & Surface-Rendering Methods
Here we learn about some of the concepts of Computer Graphics: Illumination Models & Surface-Rendering Methods Light Sources Point Light Source Distributed Light Source Materials Diffuse reflection and more
Computer Graphics-Two Main Approaches
Here we learn about some of the concepts of Computer Graphics: Two Main Approaches Visible surface detection algorithms are broadly classified as: Object Space Methods: Compares objects and parts of objects to each other within the scene definition to determine which surfaces are visible Image Space Methods: Visibility is decided point-by-point at each pixel position on the projection plane Image space methods are by far the more common *Back-Face Detection *Depth-Buffer Method *Depth-Buffer Algorithm and more
Computer Graphics-Classical Viewing
Here we learn about some of the concepts of Computer Graphics: Objectives Classical Viewing Planar Geometric Projections Parallel Projections Classical Projections Perspective vs Parallel Taxonomy of Planar Geometric Projections Perspective Projection and many more,,,