Menu Bar

Home
Introduction to HTML Tables Elements and Attributes Lists Google Home Page Registration Form Forms_1 Forms_2
Introduction to CSS Three types of css Tables Forms(id,class,psuedo class) Backgrounds Periodic table Border in a table Margins and Padding Height,Width,Overflow
Introduction Basic Script Data types and Operators String methods and Arrays Functions and Objects Events Dialog boxes Conditions Loops Error Handling External JS Simple Calculator
Introduction SQL Installation and User creation SQL:Database and Table Creation SQL:Alter Constraints Select,Insert Delete Operators Functions Joins, Union, GroupBy Missing Items User Defined Functions Views Backup and Restore Company DB, Table and records Queries on Company DB Computer Business DB and Queries
Introduction Variables, Datatypes & Operators Conditional & Looping Statements Functions Pointers & Recursion Array & Files Patterns
Introduction Problems in C++
Configuration SQL server connection Introduction to PHP
Introduction VB.NET VB.NET Compilation & Run VB.NET Problems No link
Design Principles Stone Profit support page MasterLegacy MasterDev Work with Live System

Create Company DB, Tables and Insert values

Create tables for our company database and inset real-time records.


Create a database: SPS

Query: create database SPS










Create Table: Location


Query:



Create table: Department


Query:



Create table: Shift


Query:



Create table: CPU


Query:



Create table: Monitor


Query:



Create table: Employee


Query:




Insert values into table: Location

Query:




Insert values into table: Department

Query:




Insert values into table: Shift

Query:




Insert into table: CPU

Query:




Insert into table: Monitor

Query:




Insert values into table: Employee

Query:







Subscribe to: Posts (Atom)