Skip to content
Online Education & Certification

Online Education & Certification

  • Basics of Computer
  • Microsoft Windows
  • Microsoft Office
  • Tally
  • Java
  • SQL
  • Hardware
  • Networking
  • MySQL
  • Python
  • Digital Marketing
  • C Language
  • C ++
  • Visual Basic
  • Html 5 & CSS
Online Education & Certification

Tag: SQL PRIMARY KEY Constraint : SQL PRIMARY KEY Constraint uniquely identifies each record in a database table.

SQL PRIMARY KEY Constraint

November 9, 2017 selva SQL

SQL PRIMARY KEY Constraint : SQL PRIMARY KEY Constraint uniquely identifies each record in a database table. Primary keys must contain UNIQUE values, and cannot contain

Read more

Blog Categories

open all | close all
Answer these questions
C Language
Chapter 1: Introduction to ‘C’ and ‘C’ Fundamentals
Chapter 2: Data Input/Output and ‘C’ Operators
Chapter 3: Control Statement
Chapter 4: Arrays
Chapter 5: Functions
Chapter 6: Pointers
Chapter 7: Structures
Chapter 8: More On Pointers
Chapter 9: File Handling
Chapter 10: Introduction to Data Structure
Chapter 11: Linear List
Chapter 12: Introduction to Graphics
C++
Chapter 1: Introduction to OOPS
Chapter 2: Introduction to C++
Chapter 3: Programming Constructs
Chapter 4: Arrays & Pointers
Chapter 5: Functions
Chapter 6: Class & Objects
Chapter 7: Friend Function
Chapter 8: Constructors & Destructors
Chapter 9: Operator Overloading
Chapter 10: Inheritance
Chapter 11: Virtual Functions & Polymorphism
Chapter 12: Files
Chapter 13: Templates
Chapter 14: Introduction to Graphics
MS Excel
Chapter 1: Introduction to MS Excel
Chapter 2: Working With Excel Sheet
Chapter 3: Advanced Formula and Functions
Chapter 4: Creating Charts in Excel
Chapter 5: Analyzing Data With Excel
MS PowerPoint
PowerPoint
MS Word
Chapter 1: Introduction to Word 2007
Chapter 2: Creating a New Document
Chapter 3: Insert Tab
Chapter 4: Page Layout Tab
Chapter 5: Text Basics
Chapter 6: Text Formatting
Chapter 7: Creating Tables
Chapter 8: Formatting a Table
Chapter 9: References Tab
Chapter 10: Mailings Tab
Chapter 11: Review Tab
Chapter 12: View Tab
Python
Chapter 1: Introduction To Python
Chapter 2: Variable Declarations
Chapter 3: Condition Execution
Chapter 4: Python Functions
Chapter 5: Python Modules
Chapter 6: Sequences
Chapter 7: Python Strings
Chapter 8: Python File I/O
Chapter 9: Python Errors and Built-In Exceptions
Chapter 10: Python Namespace And Scope
Chapter 11: Python Objects and Class
Chapter 12: Python Inheritance
Chapter 13: Python – Network Programming
Chapter 14: Multithreaded Programming
Chapter 15: Python MySql Database Access
Chapter 16: Python – GUI Programming[TKinter]
Chapter 17: Image Processing In Python With Pillow
Tally Prime QA
Chapter 2: Getting Started
Chapter 3: Company Info & Features
Chapter 4: Accounts Info
Chapter 5: Inventory Info
Chapter 6: Voucher Entry
Chapter 7: Display & Configuration
Chapter 8: Printing
Chapter 9: Banking
Chapter 10: Voucher Type & Class
Chapter 11: Bill Wise Details
Chapter 12: Cost Centre & Category
Chapter 13: Job Costing
Chapter 14: Multi-Currency
Chapter 15: Interest Calculation
Chapter 16: Budget & Credit Limit
Chapter 17: Scenario Management
Chapter 18: Order Processing & Tracking System
Chapter 19: Reorder Level & Status
Chapter 20: Batch wise Details
Chapter 21: Bill Of Material (BoM)
Chapter 22: Price Level & List
Chapter 23: Different Actual & Billed Quantity
Chapter 24: Consolidation Of Books
Chapter 25: Split Company Data
Chapter 26: Backup & Restore
Chapter 27: Security Control & Tally Audit
Chapter 28: Tally Vault
Chapter 29: Export & Import
Chapter 30: Open Database Connectivity(ODBC)
Chapter 31: Concurrent Multilingual Support
Chapter 32: Point of Sales(POS)
Chapter 33: Tally.Net
Chapter 34: Payroll
Chapter 35: Goods and Service Tax(GST)
Chapter 36: Tax Deducted at Source
Chapter 37: Tax Collected at Sources
Visual Basic
Chapter 9: Files & Graphics
Chapter 10: Database, DAO & RDO
Chapter 11: ADO
Chapter 12: Objects
Chapter 13: OLE Object Linking And Embedding
Chapter 14: ActiveX
Chapter 15: Internet Applications & DHTML
Windows & Internet
Chapter 1: Introduction to Computer Part A
Chapter 1: Introduction to Computer Part B
Chapter 2: Computer Virus
Chapter 3: Introduction to Windows
Chapter 4: Accessing Information
Chapter 5: Managing Files & Folders
Chapter 6: Customising
Chapter 7: Accessories
Chapter 8: Introduction to the Internet
Chapter 9: World Wide Web
Chapter 10: Multimedia on the Web
Chapter 11: Search the Web
Chapter 12: Electronic Mail
Chapter 13: Web Glossary
ebooks
Hardware – ebook
FairSpin
Fairspin Portugal
Fairspin Portugal
Fairspin Portugal
Online Exams
Tally Prime
Autocad
DTP
HTML
ASP & XML
MySql
Python
C Language
MS Word
Hardware
C++
Java
Visual Basic
MS Excel
Windows & Internet
Tutorials
Basics of Computer
Basics of Computers
Computer Fundamentals
Digital Marketing
Digital Marketing Introduction
Traditional vs Digital Marketing
Organic vs Inorganic Marketing
Content Creation
Graphic Designing
Social Media Marketing
HARDWARE
Hardware Abbreviations
Introduction to computer
System familiarisation
Software classification
DOS commands
Overview of processor
PC mother board
BIOS CMOS – Setup
Hard disk drive
Optical devices
Floppy disk drive
Parts of HDD FDD CDD
Hard disk preparation
PC Memory Classification
AT & ATX Processor
Interface cards
OS installation
Serial and parallel ports
Modem installation
Input devices
Printer
Printer parts identification
Monitor
Power supply
Virus & antivirus
Antivirus installation
System assembling
Intel & AMD mother board
Processor
Mother board Intel & AMD
Trouble shooting tips
Html
Run html code live
Html5 & CSS
HTML5 and CSS3 Examples
HTML5 AND CSS3 SAMPLE SCRIPT FOR PRACTICE
Internet
Internet
Java
Unit-21 Networking (URL,SOCKETS (TCP/IP),DATAGRAMS) – II
Unit-20 Networking (URL,SOCKETS (TCP/IP),DATAGRAMS) – I
Unit-19 Multithreading
Unit-18 Java Astract Window Toolkit-II
Unit-17 Java Astract Window Toolkit-I
Unit-16 Event Handling
Unit-15 Java Applet Basics
Unit-14 Stream and Files-II
Unit-13 Streams and Files-I
Unit-12 Exception Handling
Unit-11 Java.Util Package
Unit-10 Interfaces and Packages
Unit-9 Inheritance in java
Unit-8 Constructors in java
Unit-7 Methods in Java
Unit-6 Introduction to Object Oriented Programming in Java
Unit-5 String Class in Java
Unit-4 Arrays in Java
Unit-3 Programming Constructs
Unit-2 Data Types In Java
Unit-1 Java Introduction
Microsoft Office
Microsoft Office
Microsoft Windows
Microsoft Windows
MySQL
Using Various Operators Using WHERE Clause
ALTER TABLE
LIMIT Clause
DISTINCT CLAUSE
Creating a table as an existing table
More On MySQL WHERE Clause
EXERCISE
WHERE clause with Multiple Conditions
MySQL ORDER BY Clause
Exercise No.1
Select Statement
Create a table with auto increment and default option
How To Update The Details In A Table
Deletion of Rows of the Table
Insertion of Data Into a Table
How To Create New Tables
Creation Of Database
Server Activation
MySQL SQL
MySQL Functions – References
MySQL Data Types – References
MySQL RDBMS
Introduction to MySQL
MySQL Tutorial – MySQL HOME
Networking
Introduction to networks
Network Essential
Network Topology
UTP Network Cable Connections with RJ45 connector
Network devices
OSI MODEL
PROTOCOL
TCP/IP
Operating System
Windows XP features
Windows Vista features
Microsoft Windows installation
Installation of windows NT Server & Work station
Connectivity and sharing
File system
Windows xp / vista tools utilities
User administration os components
Windows 2003 server installation
Demo on network
LAN settings in Windows 10 systems (Peer to Peer)
Installing configuring active directory service
Connectivity & Sharing
User Management
Networking Reference Guide
Python
Chapter-6 Python Maths Part-2
Chapter-6 Python Maths Part-1
Chapter-5 Python Module
Chapter-4 Functions-Built in Functions
Chapter-4 Functions-User Defined (UDF)
Chapter-3 Statements
Chapter-2 Python Data types & Operators
Chapter-1 Introduction to Python
Python e-book
RMI
Unicast Remote Object Interface
SQL
Introduction to SQL
SQL Syntax
SQL Statements
SQL SELECT Statement
SQL SELECT DISTINCT Statement
SQL WHERE Clause
SQL AND, OR and NOT Operators
SQL ORDER BY Keyword
SQL INSERT INTO Statement
SQL NULL Values
SQL UPDATE Statement
SQL DELETE Statement
SQL TOP, LIMIT or ROWNUM Clause
SQL MIN() and MAX() Functions
SQL COUNT(), AVG() and SUM()Functions
SQL LIKE Operator
SQL Wildcards
SQL IN Operator
SQL BETWEEN Operator
SQL Aliases
SQL Self JOIN
SQL UNION Operator
SQL GROUP BY Statement
SQL HAVING Clause
SQL EXISTS Operator
SQL ANY and ALL Operators
SQL SELECT INTO Statement
SQL INSERT INTO SELECT Statement
SQL NULL Functions
SQL Comments
SQL CREATE DATABASE Statement
SQL DROP DATABASE Statement
SQL CREATE TABLE Statement
SQL DROP TABLE Statement
SQL ALTER TABLE Statement
SQL Constraints
SQL NOT NULL Constraint
SQL UNIQUE Constraint
SQL PRIMARY KEY Constraint
SQL FOREIGN KEY Constraint
SQL CHECK Constraint
SQL DEFAULT Constraint
SQL CREATE INDEX Statement
SQL AUTO INCREMENT Field
SQL Working With Dates
SQL Data Types MySQL, SQL Server, MS Access
SQL Views
SQL Injection
SQL Hosting
MySQL Functions
SQL Server Functions
MS Access Functions
Oracle Functions
SQL Operators
Tally Prime
Chapter-3 Getting Started
Tally Prime Features
Tally Prime Shortcut keys
Chapter – 1 Introduction to Accounting & Tally
Chapter – 5 Accounts Info:
Chapter – 6 Inventory Info:
Chapter-7 Voucher Entry
Chapter-5 Bill wise Details
Chapter – 6 Cost Centre
Chapter-7 Job Costing
Chapter-8 Multi currency
Chapter-9 Interest Calculation
Chapter-10 Budget and Credit Limit
Chapter-11 Scenario Management
Chapter-12 Order Processing And Tracking System
Chapter-13 Reorder Level
Chapter-14 Batch wise Detail
Chapter-15 Bill of Material
Chapter-16 Price level and list
Chapter-17 Different Actual And billed Quantity
Chapter-18 point of sales (Pos):
Chapter-19 Pay Roll
Chapter-20 Goods And Service And Tax
Chapter-22 Tax collected Source
XML
Introducing Schemas
XML Schema Complex Types
XML Namespaces
XML Transformation

Answer these questions

open all | close all
C Language
Chapter 1: Introduction to ‘C’ and ‘C’ Fundamentals
Chapter 2: Data Input/Output and ‘C’ Operators
Chapter 3: Control Statement
Chapter 4: Arrays
Chapter 5: Functions
Chapter 6: Pointers
Chapter 7: Structures
Chapter 8: More On Pointers
Chapter 9: File Handling
Chapter 10: Introduction to Data Structure
Chapter 11: Linear List
Chapter 12: Introduction to Graphics
C++
Chapter 1: Introduction to OOPS
Chapter 2: Introduction to C++
Chapter 3: Programming Constructs
Chapter 4: Arrays & Pointers
Chapter 5: Functions
Chapter 6: Class & Objects
Chapter 7: Friend Function
Chapter 8: Constructors & Destructors
Chapter 9: Operator Overloading
Chapter 10: Inheritance
Chapter 11: Virtual Functions & Polymorphism
Chapter 12: Files
Chapter 13: Templates
Chapter 14: Introduction to Graphics
MS Excel
Chapter 1: Introduction to MS Excel
Chapter 2: Working With Excel Sheet
Chapter 3: Advanced Formula and Functions
Chapter 4: Creating Charts in Excel
Chapter 5: Analyzing Data With Excel
MS PowerPoint
PowerPoint
MS Word
Chapter 1: Introduction to Word 2007
Chapter 2: Creating a New Document
Chapter 3: Insert Tab
Chapter 4: Page Layout Tab
Chapter 5: Text Basics
Chapter 6: Text Formatting
Chapter 7: Creating Tables
Chapter 8: Formatting a Table
Chapter 9: References Tab
Chapter 10: Mailings Tab
Chapter 11: Review Tab
Chapter 12: View Tab
Python
Chapter 1: Introduction To Python
Chapter 2: Variable Declarations
Chapter 3: Condition Execution
Chapter 4: Python Functions
Chapter 5: Python Modules
Chapter 6: Sequences
Chapter 7: Python Strings
Chapter 8: Python File I/O
Chapter 9: Python Errors and Built-In Exceptions
Chapter 10: Python Namespace And Scope
Chapter 11: Python Objects and Class
Chapter 12: Python Inheritance
Chapter 13: Python – Network Programming
Chapter 14: Multithreaded Programming
Chapter 15: Python MySql Database Access
Chapter 16: Python – GUI Programming[TKinter]
Chapter 17: Image Processing In Python With Pillow
Tally Prime QA
Chapter 2: Getting Started
Chapter 3: Company Info & Features
Chapter 4: Accounts Info
Chapter 5: Inventory Info
Chapter 6: Voucher Entry
Chapter 7: Display & Configuration
Chapter 8: Printing
Chapter 9: Banking
Chapter 10: Voucher Type & Class
Chapter 11: Bill Wise Details
Chapter 12: Cost Centre & Category
Chapter 13: Job Costing
Chapter 14: Multi-Currency
Chapter 15: Interest Calculation
Chapter 16: Budget & Credit Limit
Chapter 17: Scenario Management
Chapter 18: Order Processing & Tracking System
Chapter 19: Reorder Level & Status
Chapter 20: Batch wise Details
Chapter 21: Bill Of Material (BoM)
Chapter 22: Price Level & List
Chapter 23: Different Actual & Billed Quantity
Chapter 24: Consolidation Of Books
Chapter 25: Split Company Data
Chapter 26: Backup & Restore
Chapter 27: Security Control & Tally Audit
Chapter 28: Tally Vault
Chapter 29: Export & Import
Chapter 30: Open Database Connectivity(ODBC)
Chapter 31: Concurrent Multilingual Support
Chapter 32: Point of Sales(POS)
Chapter 33: Tally.Net
Chapter 34: Payroll
Chapter 35: Goods and Service Tax(GST)
Chapter 36: Tax Deducted at Source
Chapter 37: Tax Collected at Sources
Visual Basic
Chapter 9: Files & Graphics
Chapter 10: Database, DAO & RDO
Chapter 11: ADO
Chapter 12: Objects
Chapter 13: OLE Object Linking And Embedding
Chapter 14: ActiveX
Chapter 15: Internet Applications & DHTML
Windows & Internet
Chapter 1: Introduction to Computer Part A
Chapter 1: Introduction to Computer Part B
Chapter 2: Computer Virus
Chapter 3: Introduction to Windows
Chapter 4: Accessing Information
Chapter 5: Managing Files & Folders
Chapter 6: Customising
Chapter 7: Accessories
Chapter 8: Introduction to the Internet
Chapter 9: World Wide Web
Chapter 10: Multimedia on the Web
Chapter 11: Search the Web
Chapter 12: Electronic Mail
Chapter 13: Web Glossary

Online Exams

  • ASP & XML
  • Autocad
  • C Language
  • C++
  • DTP
  • Hardware
  • HTML
  • Java
  • MS Excel
  • MS Word
  • MySql
  • Python
  • Visual Basic
  • Tally Prime
WordPress Theme: Gambit by ThemeZee.