Best Online Tutorials

SQL Tutorial

Free SQL Tutorial

SQL Interview Questions

SQL Practice Questions

SQL Tips & Tricks

SQL Errors

SQL Books

Angular Tutorial

Free Angular Tutorial

Angular Interview Questions

Angular Practice Questions

Angular Tips & Tricks

Angular Errors

Angular Books

Node.js Tutorial

Free Node.js Tutorial

Node.js Interview Questions

Node.js Practice Questions

Node.js Tips & Tricks

Node.js Errors

Node.js Books

React.js Tutorial

Free React.js Tutorial

React.js Interview Questions

React.js Practice Questions

React.js Tips & Tricks

React.js Errors

React.js Books

SSIS Tutorial

Free SSIS Tutorial

SSIS Interview Questions

SSIS Practice Questions

SSIS Tips & Tricks

SSIS Errors

SSIS Books

SEO Tutorial

Free SEO Tutorial

SEO Interview Questions

SEO Practice Questions

SEO Tips & Tricks

SEO Errors

SEO Books

Javascript Tutorial

Free Javascript Tutorial

Javascript Interview Questions

Javascript Practice Questions

Javascript Tips & Tricks

Javascript Errors

Javascript Books

MongoDB Tutorial

Free MongoDB Tutorial

MongoDB Interview Questions

MongoDB Practice Questions

MongoDB Tips & Tricks

MongoDB Errors

MongoDB Books

Next.js Tutorial

Free Next.js Tutorial

Next.js Interview Questions

Next.js Practice Questions

Next.js Tips & Tricks

Next.js Errors

Next.js Books

Advanced SQL Tutorial Topics - DritalConnect 

Prashant Surya  |   Dec 21, 2019  |  Views: 381

Description:

Topics for Advanced SQL Tutorial:



---------------------------------------------
SQL Server Normalization:
-Normalization in DBMS
-1NF
-2NF
-3NF
-4NF
-5NF
-BCNF
-De-normalization
-Normalization Vs De-normalization

---------------------------------------------
SQL Server Authentication and Authorization
-set Username password
-restrict manupulation by role

---------------------------------------------
Pivot and Unpivot

---------------------------------------------
SQL Null Functions:
-ISNULL
-IFNULL
-NVL
-Coalesce
-NULLIF
---------------------------------------------
Advanced SQL 
-SQL UNION
-SQL UNION ALL
-SQL Inline View
-SQL INTERSECT
-SQL MINUS
-SQL LIMIT
-SQL TOP
-SQL Subquery
-SQL EXISTS
-SQL CASE
-SQL DECODE
-SQL AUTO INCREMENT
-SQL IDENTITY
-SEQUENCE & NEXTVAL
-SQL ALIAS
-SQL AS
-SQL SELECT UNIQUE
-SQL Wildcard

---------------------------------------------
SQL Server Bulk Insert
-SQL INSERT INTO
-SQL INSERT INTO SELECT

---------------------------------------------
SQL ALTER TABLE:
-Add Column
-Modify Column
-Rename Column
-Drop Column
-Add Index
-Drop Index
-Add Constraint
-Drop Constraint

---------------------------------------------
SQL Server Joins:
-Inner Join
-Outer Join
-Left JOin
-Cross Join
-Right Join
-Right Outer Join
-FULL OUTER JOIN
---------------------------------------------
SQL Server Views:
-Creating a new view 
-Renaming a view
-Listing views in SQL Server
-Getting view information
-Removing a view
-Creating an indexed view

---------------------------------------------
SQL Server Cases:
-Case update
-Case select
-Case delete
-case in Count

---------------------------------------------
SQL Server Indexes

-Clustered indexes 
-Create nonclustered indexes
-Rename indexes 
-Disable indexes
-Enable indexes 
-Unique indexes 
-Drop indexes 
-Indexes with included columns
-Filtered indexes
-Indexes on computed columns

---------------------------------------------
SQL Server Stored Procedures
-Handling Exceptions
-TRY CAtch
-Raise Error
-Throw
-SP with dynamic query
-SP with cursor
-SP with function
-SP with single return
-SP with multiple return
-SP with optional parameters
-SP with nullable parameters
-SP with CTE
-SP with Cursor
-SP with Joins

---------------------------------------------
SQL Server User-defined Functions
-Use with function
-Functions with optional parameters
-User-defined scalar functions  
-Table variables
-Table-valued functions
-Removing user-defined functions

---------------------------------------------
SQL Server Triggers
-Creating a trigger in SQL Server 
-Creating an INSTEAD OF trigger
-Creating a DDL trigger
-Disabling triggers
-Enabling triggers
-Viewing the definition of a trigger 
-Listing all triggers in SQL Server
-Removing triggers

---------------------------------------------
SQL Server Cursors
-Handling Exceptions
-TRY CAtch
-Raise Error
-Throw
-Cursor with case
-Cursor with Stored Procedure  
-Cursor with cte
-Curror with Joins
-Cursor with Functions
-Cursor with views
-Cursor with nested cursor
-Cursor with dynamic query
 
---------------------------------------------
SQL Server Aggregate Functions
-AVG
-CHECKSUM_AGG
-COUNT
-COUNT_BIG
-MAX
-MIN
-SUM
---------------------------------------------
SQL Server Date Functions

-Returning the current date and time

-CURRENT_TIMESTAMP
-GETUTCDATE
-GETDATE
-SYSDATETIME
-SYSUTCDATETIME
-SYSDATETIMEOFFSET

-Returning the date and time Parts

-DATENAME
-DATEPART
-DAY
-MONTH
-YEAR
-Returning a difference between two dates

-DATEDIFF

-Modifying dates

-DATEADD
-EOMONTH
-SWITCHOFFSET
-TODATETIMEOFFSET

-Constructing date and time from their parts

-DATEFROMPARTS
-DATETIME2FROMPARTS
-DATETIMEOFFSETFROMPARTS
-TIMEFROMPARTS

-Validating date and time values

-ISDATE


---------------------------------------------
SQL Server String Functions

-ASCII
-CHAR
-CHARINDEX
-CONCAT
-CONCAT_WS
-DIFFERENCE
-FORMAT
-LEFT
-LEN
-LOWER
-LTRIM
-NCHAR
-PATINDEX
-QUOTENAME
-REPLACE
-REPLICATE
-REVERSE
-RIGHT
-RTRIM
-SOUNDEX
-SPACE
-STR
-STRING_AGG
-STRING_ESCAPE
-STRING_SPLIT
-STUFF
-SUBSTRING
-TRANSLATE
-TRIM
-UNICODE
-UPPER

---------------------------------------------
SQL Server System Functions
-CAST 
-CONVERT 
-CHOOSE
-ISNULL
-ISNUMERIC
-IIF
-TRY_CAST
-TRY_CONVERT
-TRY_PARSE
-Convert datetime to string
-Convert string to datetime
-Convert datetime to date

---------------------------------------------
SQL Server Window Functions

-CUME_DIST
-DENSE_RANK
-FIRST_VALUE
-LAG
-LAST_VALUE
-LEAD
-NTILE
-PERCENT_RANK
-RANK
-ROW_NUMBER
---------------------------------------------
DB Lock:
Optimization
Backup & Restore
Database Transaction
Schedules in DBMS
Database Interface
Data Models
Object based Data Models
Physical Data Models
Record based Data Models
Basic Concepts of ER Data Model
ER Data Model
Convert ER Diagram into Tables
Database Abstraction
Database Users and Administrators
Hashing Concepts
Codd’s Rule
Sorting
Conjunctions, Disjunction and Negation




Comments:
Content Contributor
Prashant Surya

Prashant Surya

Software developer at Uniserve Data Technologies Pvt. Ltd.  |   Noida, Uttar Pradesh, India

I am a software developer, freelancer and trainer working on technologies likes. MEAN stack, MERN Stack, ASP.NET full stack, WebRTC, socket.io ,PWA, SQL, JavaScript, jQuery, HTML, CSS, SEO, responsive UI/UX designing... having 7 years of experience in development in multiple domains like, eCommerce, RTA, capital markets, education, real estate...


Read related articles

SQL Sever-Disk Usage Reports

Pooja Goel  |   Jun 20, 2020  |  Views: 556

How to optimize the Query in SQL SERVER

Pooja Goel  |   Jun 16, 2020  |  Views: 440

SQL Server - ORDER by using @Parameter

Pooja Goel  |   Jun 13, 2020  |  Views: 355

What is ACID fundamental

Prashant Surya  |   Mar 18, 2020  |  Views: 196

What is SQL Injection

Prashant Surya  |   Mar 18, 2020  |  Views: 297

Best website to learn SQL for free

Prashant Surya  |   Jan 24, 2020  |  Views: 214

SQL Tutorials Online

Prashant Surya  |   Jan 24, 2020  |  Views: 269

Top 10 SQL tutorial

Prashant Surya  |   Jan 24, 2020  |  Views: 260

SQL Tutorial

Prashant Surya  |   Jan 24, 2020  |  Views: 233

SQL Tutorials

Prashant Surya  |   Jan 24, 2020  |  Views: 263

Best SQL Tutorial

Prashant Surya  |   Jan 24, 2020  |  Views: 277

Advanced SQL Tutorial Topics - DritalConnect

Prashant Surya  |   Dec 21, 2019  |  Views: 382

Ways to get Execution Plan of Running SQL Query

Pooja Goel  |   Dec 4, 2019  |  Views: 690

Best SQL book for beginners - SQL Tutorial

Pooja Goel  |   Nov 23, 2019  |  Views: 381

Top 30 SQL Interview practice questions

Prashant Surya  |   Nov 23, 2019  |  Views: 500

Best website to learn sql tutorial online

Prashant Surya  |   Nov 22, 2019  |  Views: 278

SQL tutorials - DritalConnect

Prashant Surya  |   Nov 20, 2019  |  Views: 344

Performance tuning in SQL Server

Pooja Goel  |   Oct 19, 2019  |  Views: 1299

Ways to call SSIS Package in CA Workload

Abhishek Roy  |   Oct 9, 2019  |  Views: 607

Ways to Improve SQL Query Performance

Prashant Surya  |   Oct 7, 2019  |  Views: 1283

Want to sell your software ?-

If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.

  • Sell ERP
  • Sell Website Clones
  • Sell App Clones
  • Sell Readymade Portals
  • Sell Readymade Websites
  • Sell Mobile Apps
  • Sell Window Apps

Clients will find it using our advanced search filter and will contact you directly.

No any charge for the product lsiting.

Do you own a Company ?+

Property.sale

Buy or Sell Commercial Property+

Are you a freelancer ?+

Looking for a job ?+

Are you a Service Provider ?+

Are you a blogger ?+

Do you own an IT Institute ?+



Property.sale