1000+ Courses for Free

JavaScript
C++
DevOps
Cloud Computing
PHP
Blockchain
Operating System
IOT
Kotlin
WordPress
view all

MS Access

All About The Primary Key

MS Access

What is MS Access? MS Access-RDBMS Understanding the Relational Database Concept Components of MS Access –Objects How to create a Database? MS Access –Data Types MS Access –Create Tables All About The Primary Key Query Data And Query Criterion RELATING DATA WILDCARDS Queries and filters Difference between Access and Excel

All About The Primary Key

< MS Access –Create Tables

Query Data And Query Criterion >

At some point in our lives, all of us have come across this term called the primary key. So what’s the use of a primary key? Let us take an example to understand it in a better way. Suppose I have a firm, my own company, and I want to store the record of each person working in my organization. Then, when I have a few fields like DOB, date of joining, age, salary, and employment ID, there are certainly chances that any two records of two different persons can have almost everything similar. What I mean to say is two people, who have joined the company on the same date, have been offered the same salary package and coincidentally have their birthdays on the same date, and they may even have the same age also. Now, to make the situation worse, there may be one in a hundred cases where even the names of both persons become the same. ( I myself had five students named Ayush in my high school). So, it becomes a matter of confusion for the HR department to keep track of them, which may lead to serious misconceptions. So, in that case, We have to define a particular field, which we call the primary key, which will be unique for each employee. Each employee, here, in our example, can be assigned a unique employment id, which can serve as the primary key. It should be kept in mind that computers, as a device, originated as a military devices whose sole work was to coordinate with the military requirements. So, typically, the databases were created, creating a unique identification number, which would be similar to the unique military id assigned to each machine during the WW2 era. You can also think of it as the aadhar card number. There is a requirement to assign a field as a primary key. You cannot simply assign any field randomly to be the primary key. The main criterion is it should not contain similar data for 2 different entries. And then, no particular cell should be left vacant. If these two conditions are satisfied, then you are all ready to set that field as a primary key.

< MS Access –Create Tables

Query Data And Query Criterion >

JavaScript
Introduction to JavaScript Tutorial JavaScript: Syntax JavaScript: Enabling JavaScript: Placements JavaScript: Variables JavaScript: Operators JavaScript: If…else JavaScript: Switch case JavaScript: While Loops JavaScript: For Loop JavaScript: For…in Loop JavaScript: Loop Control JavaScript: Functions JavaScript: Events JavaScript: Cookies
C++
C++ Introduction C++ environment Setup C++ Syntax C++ Comments C++ Data Types C++ Variable Types C++ Variable Scope C++ Constants and Literals C++ Modifier Types. C++ Storage C++ Operators C++ Loop Types C++ Decision Making C++ Functions C++ Arrays C++ Strings C++ Pointers C++ References C++ Date & Time C++ Input and Output C++ Data Structures
DevOps
What is DevOps? Why DevOps? DevOps Architecture Features DevOps Advantages and Disadvantages DevOps Architecture DevOps Lifecycle DevOps Workflow DevOps Tools DevOps Automation DevOps Automation Tools DevOps Engineers DevOps Engineer Roles and Responsibilities DevOps Pipeline DevOps Methodology AWS DevOps DevOps Training Certification DevOps Institution DevOps vs Agile
Cloud Computing
Cloud Computing Introduction Cloud Computing Planning Cloud Computing Technologies Cloud Computing Architecture Cloud Computing Infrastructure Private Cloud Model Hybrid Cloud Model Community Cloud Model Cloud Service Models Platform as a Service (PaaS) Software as a Service (SaaS) Identity as a Service (IDaaS) Network as a Service (NaaS) Cloud Advanced Concepts Cloud Computing - Data Storage Cloud Computing – Virtualization Cloud Computing – Security Cloud Computing – Operation Cloud Computing – Applications Cloud Computing – Providers Cloud Computing – Challenges Mobile Cloud Computing (MCC)
PHP
PHP Overview Why should you learn PHP? PHP Environment Setup PHP-Syntax Overview PHP-Constants PHP Decision Making PHP Loop Types PHP Arrays PHP Strings PHP WEB CONCEPTS PHP File Inclusion PHP-Files & I/O
Blockchain
Introduction to Blockchain Brief History of Blockchain What is Blockchain? Blockchain Versions Key Concepts in Blockchain What are Smart Contracts? Network, Nodes and Mining What is the Consensus Mechanism? What’s Double Spending? Resolving Conflict Privacy Management Types of Blockchains Blockchain and Cryptocurrency How to Buy Bitcoin Mitigating Attacks on Bitcoin Transaction Blockchain Opportunities Advantages of Blockchain Disadvantages of Blockchain Blockchain Conclusion
Operating System
Operating System Introduction Operating System Types Operating System Services Operating System Properties Operating System Processes Operating System Process Scheduling Operating System Scheduling Algorithms Operating System Multithreading Operating System Memory Management Operating System Virtual Memory Hardware I/O I/O Software File system File Access Methods Os security Linux
IOT
What is IOT? Advantages of IoT Disadvantages of IoT IoT as Hardware Electronics Wearable Devices IoT as Software IoT Technology and Protocols IoT Common Use Media, Marketing & Advertising IoT - Environmental Monitoring IoT Manufacturing Applications IoT Healthcare application IoT Transportation Application Application of IoT technology in transportation IoT Building/Housing Applications
Kotlin
Kotlin - Introduction Kotlin - Environment Setup Kotlin - Architecture Kotlin - Basic Syntax Kotlin - Comments Kotlin - Variables
WordPress
WordPress - Introduction What is Wordpress Installation of WordPress After Installation Wordpress Settings Wordpress General settings WordPress Writing Settings WordPress Reading Settings WordPress Discussion Settings WordPress Media Settings WordPress Permalink Settings WordPress Privacy Settings WordPress Plugin Settings WordPress Categories Wordpress Post WordPress Media WordPress Pages WordPress Tags WordPress Links WordPress Comments Wordpress Plugins
Ajax
AJAX TUTORIAL AJAX - introduction AJAX - What is AJAX? AJAX - Technologies AJAX - Examples AJAX - Action AJAX - Database Operations AJAX - Security AJAX - Issues
Angular 7
Angular 7 Overview Prerequisites to Learn Angular What is TypeScript? Versions of TypeScript How Angular was design or History of Angular? Versions of Angular What is Angular JS? What is Angular (Version2 and above)? Differences between AngularJS (1.0) and Angular Angular Advantages or Why we use Angular Angular Features Browser Compatibility of Angular 2+ versions Angular Architecture and Building blocks of Angular Types of Compilation in Angular Just-In-Time compilation (JIT) Ahead-of-Time compilation (AOT) Introduction of Angular 7 New features of Angular 7
Manual Testing
Manual Testing Introduction Testing Principles Software Development Life Cycle Software Testing Life Cycle Types of Software Testing Levels of Testing Test Maturity Model SDLC Models Types of Testing White Box Techniques Black Box Techniques Types of Black Box Types of Functional Testing Types of Non-Functional Testing
Jenkins
Jenkins Introduction Jenkins – Installation Jenkins Download Jenkins - Tomcat Setup Jenkins - Maven Setup Jenkins – Configuration Jenkins – Management Jenkins - Setup Build Jobs Jenkins - Automated Testing Jenkins – Notification Jenkins – Reporting Jenkins - Code Analysis Jenkins - Distributed Builds Jenkins - Automated Deployment Jenkins - Metrics and Trends Jenkins - Server Maintenance Jenkins - Continuous Deployment Backup Jenkins Home Jenkins - Managing Plugins Jenkins – Security Jenkins - Backup Plugin Jenkins - Remote Testing Conclusion
MS Access
What is MS Access? MS Access-RDBMS Understanding the Relational Database Concept Components of MS Access –Objects How to create a Database? MS Access –Data Types MS Access –Create Tables All About The Primary Key Query Data And Query Criterion RELATING DATA WILDCARDS Queries and filters Difference between Access and Excel
Kafka
Introduction Kafka - Fundamentals What is a messaging system in Kafka? Point to point messaging System Publish-subscribe messaging System What are Events? Kafka and Events Importance of Kafka Kafka - Cluster Architecture Core APIs of Kafka Kafka - Work Flow Zookeeper in Kafka Kafka - Installation Steps Installation of Kafka on Windows Setting Kafka Directory Path Installation of Zookeeper Kafka - Basic Operations Creating a Kafka topic Get a list of Topics Start Producer to Send Messages Start Consumer to receive messages Deleting a Topic in Kafka cluster Modifying a Topic in Kafka cluster Simple Producer Example Producer API ProducerRecord API Consumer Group Example Integration With Storm How to integrate with Storm? KafkaSpout API Integration With Spark How to integrate with Spark? . Real-Time Application (Twitter) Apache Kafka - Tools System tools Replication tool Apache Kafka - Applications LinkedIn Twitter Netflix Oracle Mozilla Uber
Spring
Spring Introduction Spring - Architecture Spring - Environment Setup Spring - Hello World Example Spring - IoC Containers Spring - Bean Definition Spring - Bean Scopes Spring - Bean Life Cycle Spring - Bean Definition Inheritance Spring - Dependency Injection Spring - Injecting Collection Spring - Beans Auto-Wiring Annotation Based Configuration Spring - Java Based Configuration Spring - Event Handling in Spring Spring - Custom Events in Spring Spring - AOP with Spring Framework Spring - JDBC Framework Spring - Transaction Management Method and its Description Spring - Web MVC Framework Spring - Logging with Log4J
ASP.NET
ASP.NET Introduction ASP.NET Environment ASP.NET - LifeCycle ASP.NET - Event Handling ASP.NET - Server-Side ASP.NET - Server Controls ASP.NET - HTML Server ASP.NET – Client-Side ASP.NET - Directives ASP.NET - Managing State ASP.NET – Validators ASP.NET - Database Access ASP.NET - ADO.net ASP.NET - File Uploading ASP.NET – Calendars
JMETER
JMETER Introduction JMETER TEST PLAN TEST PLAN ELEMENTS LOGICAL CONTROLLERS: Listeners TIMERS ASSERTIONS Configuration Nodes: TEST PLAN ELEMENT ORDER OF EXECUTION TEST PLAN JMETER FUNCTIONS JMETER BEST PRACTICES:
Tkinter
Tkinter Introduction What is Python? Tkinter Basic Syntax Python quotations Tkinter Python quotations Python Multiple Statements on a Single Line Python Variable Types Python Decision Making Python Loops Python Strings String formatting in Python Element Removal from the List Python Tuples Python Dictionary Python Functions Function arguments Python Modules Python Exceptions
Informatica
Informatica Tutorial How Informatica performs ETL? Designing Informatica Repository Service Uses of Informatica Informatica Transformations Informatica ODBC Connection Alter existing Database Source in Informatica
JPA
JPA Introduction Mismatches between relational and object models What is JPA? JPA Architecture JPA ORM Components ORM Architecture Persistence Operations JPA Entity Relationships Query Structure Criteria
Magento 2
Magento 2 Tutorial What is Magento 2? Features of Magento 2 Architecture of Magento 2 What is Composer? XAMPP Installation Magento 2 Magento 2 Lume interface Installation ErrorBasic ConfigurationStore Configuration Payment Methods
Bash
Bash Introduction What is Bash? History Of Bash Bash Scripting File System and File permission First Bash Script Bash relative and absolute path Bash Quotes Bash Variable Bash Sleep User Input Bash Arithmetic Operators Bash If Bash If Else Bash Else if (elif) Bash Case Bash For Loop Bash while loop Bash Until loop Bash String Bash Find String Bash Split String Bash String Concatenation Bash Function
Gimp
Gimp Introduction GIMP vs Lightroom Canva Pixlr SUMO Paint MyPaint Pixelmator CorelDraw (Corel Photo-Paint) Paint.NET Inkscape Acorn Affinity Photo Krita PicMonkey Photopea Sketch PhotoWorks
NO SQL
NO SQL Introduction Features of NoSQL Types of NoSQL Databases Query Mechanism Tools For NoSQL Eventual Consistency What is the difference between NoSQL & Mysql DBs’? Explain Oracle NoSQL database?
JSON
JSON Tutorial Introduction to JSON JSON Syntax JSON Data Types JSON Object JSON Schema JSON vs. XML JSON with Python JSON with Java JSON with Ruby JSON with Perl JSON with Ajax JSON with PHP
bootstrap
Bootstrap Tutorial Bootstrap - Environment Setup Bootstrap with CSS Responsive column Resets: Mobile First Containers Bootstrap Containers Bootstrap Typography Abbreviations Addresses Blackquotes Lists Basic Table Bootstrap Tables Optional Table Classes Bordered Table Hover Table Condensed Table Contextual Classes Responsive Tables Bootstrap Forms Vertical or Basic Form Inline Form Horizontal Form Supported Form Controls Textarea Checkboxes and Radio Buttons Bootstrap Buttons Button State
Software Testing
Software Testing Introduction Software Testing Myths Software Testing QA, QC & Testing ISO Standards Software Testing Types Software Testing Methodes Software Testing Methods Software Testing Levels Software Testing Documentation Software Testing Estimation Techniques
Data structure
Data Structure Introduction Data Structure Environment Setup Data Structure Algorithm Asymptotic Analysis Types of the algorithm Greedy Algorithm Divide and Conquer Algorithm Dynamic Programming Algorithm Data structure Stack Queue Searching Binary Search Interpolation Search Hash Table
Hacking
Ethical Hacking - Introduction Types of Hackers Famous Hackers Environmental setup Network Device Access MITM Attacks Computer Gaining Access MSFC Analysis Client-side Attacks Post Exploitation - Introduction Filesystem Commands Website Penetration Whois Lookup Analyzing Discovering Files
PLSQL
PLSQL Introduction Advantages of PL/SQL PL/SQL Environment Basic Syntax PL/SQL Identifiers PL/SQL Comments PL/SQL Numeric Data types and Subtypes PL/SQL Boolean Data types. PL/SQL Datetime and interval Types PL/SQL Large Object (LOB) Data Types PL/SQL User-Defined Subtypes. PL/SQL Variables Initializing variables in PL/SQL PL/SQL constants and Literals PL/SQL Literals PL/SQL Operators PL/SQL Operator Precedence PL/SQL CONDITIONS PL/SQL Loops PL/SQL Strings PL/SQL ARRAYS PL/SQL PROCEDURES Parts of PL/SQL Subprogram PL/SQL Functions PL/SQL CURSORS PL/SQL Records PL/SQL Exceptions PL/SQL Triggers PL/SQL Packages PL/SQL Collections PL/SQL Transactions PL/SQL DATE and TIME PL/SQL DBMS output
CSS
Introduction to CSS CSS - Syntax CSS - Inclusion CSS - Backgrounds Set the Font Stretch Shorthand Property CSS - Text CSS - Images The -moz-opacity Property CSS – Links
Powerpoint
Introduction to PPT PPT - Explore Windows PPT - Backstage View PPT - Create Presentation PPT - Add New Slides PPT - Adding Text in Boxes PPT - Adding New Text Boxes PPT - Deleting Existing Slide PPT - Rearranging Slides PPT - Adding Slide Notes PPT - Managing Sections PPT - Working with Outlines PPT - PowerPoint Sidebar PPT - Presentation Views PPT - Setting Backgrounds PPT - Slide Orientations PPT - Review Presentation PPT - Saving Presentation Review Presentation PPT PPT - Adding Header & Footer PPT - Adding Slide Numbers PPT - Running Slide Show PPT - Keyboard Shortcuts PPT - Get Context Help
Vbscript
VBScript Introduction History of VBScript VBScript Syntax Whitespace and Line Breaks VBScript Enabling in Browsers VBScript Placements VBScript Placement in QTP VBScript Variables Declaring Variables
LINQ
LINQ Introduction Why should you use LINQ? Why was LINQ created? LINQ Setup LINQ Syntax LINQ Query Syntax LINQ Method Syntax LINQ Environment Setup LINQ Query Operators Quantifier Operations LINQ SQL LINQ Objects LINQ Dataset LINQ XML LINQ Entities LINQ Lambda Expressions Standard Query Operators with Lambda LINQ ASP.Net LINQDataSource Control LINQ Conclusion
iOS
Introduction to iOS Using .xcconfig Files Creating xcconfig files Accessing configuration values from code iOS Objective C Basics iOS First iPhone Application First iOS application iOS Actions and Outlets iOS Delegates iOS UI Elements iOS Accelerometer iOS Universal Applications iOS Camera Management iOS Location Handling iOS SQLite Database iOS Sending Email iOS Audio & Video iOS File Handling iOS Accessing Maps iOS In App Purchase iOS iAd Integration iOS GameKit iOS Storyboards iOS Auto Layouts iOS Twitter and Facebook iOS Memory Management iOS - Application Debugging iOS Conclusion
Android
Android Tutorial Introduction What is Android? Android Environment Setup Android Architecture Android - Application Components Android - Hello World Example Android Resources Android Activities Android Services Android Broadcast Receivers Android Content Providers Android Fragments Android Intents/Filters Android User Interface Android UI Controls Android Event Handling Android Styles and Themes Android - Custom Components Android Drag and Drop Android Notifications Location Based Services Android - Sending Email Android Sending SMS Android Phone Calls Publishing Android Application Android Alert Dialogs Android Animations Android Audio Capture Android Audio Manager Android Auto Complete Android Best Practices Android Bluetooth Android Camera Android Clipboard Android Custom Fonts Android Data Backup Android Developer Tools
Digital Marketing
Digital Marketing Introduction Digital Marketing- SEO Digital Marketing- Social Media Digital marketing- Content Digital Marketing- Email Digital Marketing- Facebook Digital Marketing- Pinterest Digital Marketing- Twitter Digital Marketing- LinkedIn Video Optimization Digital Marketing- Mobile Digital Marketing- CRO Digital Marketing- Google AdWords Digital Marketing- Google Analytics Final Thoughts
VB.Net
VB.Net Introduction VB.Net Environment Setup VB.Net Program Structure VB.Net Basic Syntax VB.Net Data Types VB.Net Variables VB.Net Constants VB.Net Modifiers VB.Net Statements VB.Net Operators VB.Net Decision Making VB.Net Loops VB.Net Strings VB.Net Date & Time VB.Net Arrays VB.Net Collections VB.Net Functions VB.Net Subs VB.Net Classes & Objects VB.Net Exception Handling VB.Net File Handling VB.Net Basic Controls VB.Net Dialog Boxes
HTML Tutorial
AWS
AWS Introduction History of AWS AWS Features AWS Free Tier Getting Started with AWS Setting up an AWS account AWS Management Console AWS IAM SAML IAM in AWS Identities and Roles in IAM Storage Services Amazon S3 Storage Classes CDN - Amazon CloudFront Amazon S3 Transfer Acceleration AWS Snowball Gateway in AWS AWS VPN AWS Transit Gateway Application Services Elastic Transcoder API Gateway AWS Kinesis EC2 - Backbone of AWS Amazon Elastic Block Store (EBS) EC2 Security Groups: Amazon Machine Image (AMI) AWS Load Balancing AWS Lambda BASH SCRIPT AWS Route53 Database Services Getting Started with Amazon Aurora: Amazon DynamoDB Amazon DocumentDB (with MongoDB compatibility) Amazon ElastiCache AWS VPC AWS Direct Connect Network Address Translation (NAT) gateway AWS Bastion Host VPC Endpoint: AWS VPC FlowLogs AWS NACL NACL vs Security Group AWS Data Pipeline Amazon Lightsail Amazon SES
Django
Django Introduction History of Django Why Django Django Overview Django Environment Creating a Danjgo Project Django Apps Life Cycle Creating a Django based application: Creating Views in Django Form Processing in Django File Uploading in Django Django Apache Setup Cookies Handling in Django Sessions in Django Caching in Django Comments in Django RSS in Django AJAX in Django
Keras
Keras Home Keras Introduction Keras Installation Keras Backend Configuration Keras Overview of Deep learning Keras Deep learning Keras Modules Keras Layers Keras Customized Layer Keras Models Keras Model Compilation Keras Convolution Neural Network Keras Regression Prediction using MPL Keras Time Series Prediction using LSTM RNN Keras Applications Keras Real Time Prediction using ResNet Model Keras Pre-Trained Models
Java
Introduction to Java History of Java Features of Java Applications of Java Java - Environment Setup Compiling and Running the Java Program Java - Object & Classes Java - Constructors Basic Datatypes in Java Java Variable Types Modifier Types in Java Operators in Java Loop Control n Java Decision Making in Java Numbers in Java Characters and Strings in Java Arrays in Java Date & Time in Java Regular Expressions Methods in Java Files in Java Exceptions in Java Inner classes in Java OOPS in Java
React JS
Introduction to React JS History of ReactJS Benefits of React JS Virtual DOM Cons of React JS Prerequisites for Learning ReactJS What is ES6 ReactJS - Environment Setup ReactJS - JSX ReactJS - Components ReactJS - State ReactJS - Props Overview ReactJS - Props Validation ReactJS - Component Life Cycle ReactJS - Events ReactJS - Refs ReactJS - Keys ReactJS - Router ReactJS - Flux concept ReactJS - Higher order Components ReactJS - Best Practices
PyCharm
Introduction to PyCharm PyCharm - Installation and Configuration PyCharm – Understanding Basics PyCharm – Keymaps PyCharm - Shortcuts PyCharm – Omni PyCharm - Macros PyCharm – Micros PyCharm – Improving and Writing Code Python – Console PyCharm – Interpreters PyCharm – Debugging and Breakpoints PyCharm – Integration of Version Control PyCharm – HTML and CSS Integration PyCharm – JavaScript Support PyCharm – Tips PyCharm – Database Tools PyCharm – Exporting Data PyCharm – Web Frameworks PyCharm – Django PyCharm – Pyramid PyCharm – Flask
Natural Language Processing
Introduction to NLP NLP - Linguistic Resources NLP - Word Level Analysis NLP - Syntactic Analysis NLP - Semantic Analysis NLP - Word Sense Disambiguation NLP - Discourse Processing NLP - Part of Speech (PoS) Tagging NLP – Inception NLP - Information Retrieval NLP - Applications of NLP NLP – Python
Data Science
Introduction to Data Science What is Data? Data Science Database Table Python in Data Science Data Science DataFrame Data Science Functions Data Science-Data Preparation Maths for Data Science Linear Functions in Data Science Plotting Functions in Data Science Slope and Intercept in Data Science Statistics for Data Science Linear Regression for Data Science
close-button
What is MS Access? MS Access-RDBMS Understanding the Relational Database Concept Components of MS Access –Objects How to create a Database? MS Access –Data Types MS Access –Create Tables All About The Primary Key Query Data And Query Criterion RELATING DATA WILDCARDS Queries and filters Difference between Access and Excel
JavaScript C++ DevOps Cloud Computing PHP Blockchain Operating System IOT Kotlin WordPress Ajax Angular 7 Manual Testing Jenkins MS Access Kafka Spring ASP.NET JMETER Tkinter Informatica JPA Magento 2 Bash Gimp NO SQL JSON bootstrap Software Testing Data structure Hacking PLSQL CSS Powerpoint Vbscript LINQ iOS Android Digital Marketing VB.Net HTML Tutorial AWS Django Keras Java React JS PyCharm Natural Language Processing Data Science
OSZAR »