Course Content

Getting Started

How to use LearnVern

SQL Datatypes

SQL Commands

What is DBMS

What is RDBMS

Database Relationships

Primary Key

Unique Key

Foreign Key

Difference between PK, UK and PK & FK

SQL Server Installation Step by Step

How to Create Database in SQL Server

Assignment : SQL Create Table

SQL Constraints

SQL Insert Statement and SQL Alias

Quiz : SQL Constraints & Alias

Filtering Data using Selection Command

Filtering Data using Comparison Operator

SQL Order by Clause

Assignment : Ordering and Filtering

Quiz : Selection Commands Ordering & Filtering

Aggregate Functions in SQL for Data Analysis

SQL Mathematical Functions for Data Analysis

SQL String Functions for Data Analysis

SQL Date & Time Functions for Data Analysis

SQL Window Functions for Data Analysis

SQL Miscellaneous Functions

SQL Functions for Data Analytics - 1

SQL Functions for Data Analytics - 2

Rollup and NTile Function

Row Number Function

DenseRank and Cumulative Distribution

How to use SQL Conditional Statements

How to use SQL Group by Clause

SQL Practical with Examples

Assignment : SQL Date and Time

Quiz : SQL Functions

Type of Joins in SQL - INNER, LEFT

Type of Joins in SQL - RIGHT,SELF,FULL, CARTESIAN

SQL Joins Practical Session 1

SQL Joins Practical Session 2

SQL Joins Practical Session 3

SQL Joins Practical Session 4

SQL Joins Practical Session 5

Assignment : SQL Joins

Assignment : SQL Functions 1

Assignment : SQL Functions 2

Quiz : SQL Join Functions

Practice: SQL Subqueries

Practice: SQL Subqueries & Unions

SQL Correlated Subqueries Part 1

SQL Correlated Subqueries Part 2

SQL Correlated Subqueries Part 3

SQL Correlated Subqueries Part 4

SQL Correlated Subqueries Part 5

Correlated Select, Update & Delete Queries

SQL Union

SQL EXCEPT & INTERSECT

Assignment : SQL SubQueries

Quiz : SQL Sub Queries

SQL Pivot, UnPivot Practical Example - 1

SQL Pivot, UnPivot Practical Example - 2

What are Views?

Examples of SQL Views Part -1

Examples of SQL Views Part -2

Assignment : SQL Views

Quiz : SQL Views

What is SQL Index?

SQL Index types

Quiz : SQL Indexes

Create Tables using Select Statement

Using Correlated Sub Query, Group By with Select Statement

Using Group By and Having Clauses with Select Statement

Using Index Optimizer with Select Statement

Using Union with Select Statement

Adding Multiple Records with Insert Statement

SQL Insert - Considerations and Best Practices

Insertion from Multiple Tables

SQL Delete - Types of Delete Operation Part -1

SQL Delete - Types of Delete Operation Part -2

Assignment : SQL Insert, Update & Delete

Quiz : Advanced SQL

Loading & Connecting Different Files in SQL

Course Summary

Interview Questions Part 1

Interview Questions Part 2

Career Guideline

Primary Key

SQL For Data Analysis Understand Databases and Relationships

Enroll Now For Free

Discussion

Course Content

Getting Started

How to use LearnVern

SQL Datatypes

SQL Commands

What is DBMS

What is RDBMS

Database Relationships

Primary Key

Unique Key

Foreign Key

Difference between PK, UK and PK & FK

SQL Server Installation Step by Step

How to Create Database in SQL Server

Assignment : SQL Create Table

SQL Constraints

SQL Insert Statement and SQL Alias

Filtering Data using Selection Command

Filtering Data using Comparison Operator

SQL Order by Clause

Assignment : Ordering and Filtering

Aggregate Functions in SQL for Data Analysis

SQL Mathematical Functions for Data Analysis

SQL String Functions for Data Analysis

SQL Date & Time Functions for Data Analysis

SQL Window Functions for Data Analysis

SQL Miscellaneous Functions

SQL Functions for Data Analytics - 1

SQL Functions for Data Analytics - 2

Rollup and NTile Function

Row Number Function

DenseRank and Cumulative Distribution

How to use SQL Conditional Statements

How to use SQL Group by Clause

SQL Practical with Examples

Assignment : SQL Date and Time

Type of Joins in SQL - INNER, LEFT

Type of Joins in SQL - RIGHT,SELF,FULL, CARTESIAN

SQL Joins Practical Session 1

SQL Joins Practical Session 2

SQL Joins Practical Session 3

SQL Joins Practical Session 4

SQL Joins Practical Session 5

Assignment : SQL Joins

Assignment : SQL Functions 1

Assignment : SQL Functions 2

Practice: SQL Subqueries

Practice: SQL Subqueries & Unions

SQL Correlated Subqueries Part 1

SQL Correlated Subqueries Part 2

SQL Correlated Subqueries Part 3

SQL Correlated Subqueries Part 4

SQL Correlated Subqueries Part 5

Correlated Select, Update & Delete Queries

SQL Union

SQL EXCEPT & INTERSECT

Assignment : SQL SubQueries

SQL Pivot, UnPivot Practical Example - 1

SQL Pivot, UnPivot Practical Example - 2

What are Views?

Examples of SQL Views Part -1

Examples of SQL Views Part -2

Assignment : SQL Views

What is SQL Index?

SQL Index types

Create Tables using Select Statement

Using Correlated Sub Query, Group By with Select Statement

Using Group By and Having Clauses with Select Statement

Using Index Optimizer with Select Statement

Using Union with Select Statement

Adding Multiple Records with Insert Statement

SQL Insert - Considerations and Best Practices

Insertion from Multiple Tables

SQL Delete - Types of Delete Operation Part -1

SQL Delete - Types of Delete Operation Part -2

Assignment : SQL Insert, Update & Delete

Loading & Connecting Different Files in SQL

Course Summary

Interview Questions Part 1

Interview Questions Part 2

Career Guideline

FAQs

A primary key is a field in a database table that uniquely identifies each row/record. Primary keys must have distinct values. NULL values are not allowed in a primary key column. A table can only have one primary key, which can be made up of one or more fields.

The column or columns that hold values that uniquely identify each row in a table are known as primary keys. For Optim to insert, update, restore, or delete data from a database table, the table must contain a primary key. Optim makes use of database-defined primary keys.

Text and ntext columns cannot have a primary key. However, you may achieve the same functionality by using a varchar datatype (8000). The only difference is that this column can now hold up to 8000 characters.

A primary key is a field (or combination of fields) in a table that has values that are unique across all rows. Because each record has a unique value for the key, values of the key can be used to refer to whole records. There can only be one primary key per table.

A surrogate key is a one-of-a-kind identifier for a client's business entity or a database object. Natural keys cannot always be used to establish a unique table primary key. When a data modeller or architect chooses to use surrogate or helping keys for a table in the LDM, this is what happens.

Recommended Courses

Python Programming Course

Students Enrolled : 144123

4.3

(1839)

हिन्दी

Be A Promising Game, App Developer, Data Science Expert...

Enroll For Free

Excel For Data Analysis

Students Enrolled : 19580

4

(66)

हिन्दी

Complete Data Analytics Course Using Excel taught in Hi...

Enroll For Free

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image

App QR Code Image

Code Scan or Download the app

Google Play Store

598K+ Downloads

App Download Section Circle 1

4.57 Avg. Ratings

App Download Section Circle 2

15K+ Reviews

App Download Section Circle 3

Learn anywhere on the go
Get regular updates about your enrolled or new courses
Share content with your friends
Evaluate your progress through practice tests
No internet connection needed
Enroll for the webinar and join at the time of the webinar from anywhere