Java FSD Advance Important Links

 Core Java

Core Java (OOPs & Basic Programming Concepts)

JVM - Internals

Garbage Collection

Java 8 - Streams

Java 8 - Lambda Expressions

Java 8 - Functional Interfaces

Collections

OOPS

Operators

Threads

Exception Handling

Interfaces

Memory Management

Executor Framework

Parallel Programming

Java 8

Language Fundamentals

OOPS

Abstract class & Interface

Exceptions Handling

Collections

Threads and Concurrency

Java8 - Functional Interface,Lambda Expressions, Stream API

JVM - Internals

Garbage Collection

Memory Management

Parallel Programming

Executor Frame Work

Mutilthreading & Cuncurrency

https://docs.oracle.com/javase/tutorial/index.html

https://www.journaldev.com/7153/core-java-tutorial

https://howtodoinjava.com/

https://www.mkyong.com/tutorials/java-8-tutorials/

https://www.javatpoint.com/internal-details-of-jvm

https://dzone.com/articles/jvm-architecture-explained

https://www.geeksforgeeks.org/jvm-works-jvm-architecture/

https://www.oracle.com/webfolder/technetwork/tutorials/obe/java/gc01/index.html

https://www.baeldung.com/jvm-garbage-collectors

https://docs.oracle.com/javase/tutorial/essential/concurrency/executors.html

https://www.baeldung.com/java-executor-service-tutorial

https://www.learningcrux.com/course/java-indepth-become-a-complete-java-engineers_2

https://www.youtube.com/watch?v=hBh_CC5y8-s

https://www.youtube.com/watch?v=r59xYe3Vyks&list=PLS1QulWo1RIbfTjQvTdj8Y6yyq4R7g-Al

https://www.youtube.com/playlist?list=PLd3UqWTnYXOnjGmyjD3zbIkyLXP15-6w0

https://www.youtube.com/watch?v=ZBJ0u9MaKtM

https://www.youtube.com/watch?v=UnaNQgzw4zY

https://howtodoinjava.com/java-concurrency-tutorial/

http://tutorials.jenkov.com/java-concurrency/index.html

https://www.vogella.com/tutorials/JavaConcurrency/article.html

https://www.learningcrux.com/course/java-multithreading-concurrency-performance-optimization

Spring Boot

Spring Boot

Spring Security

SSO , OAUTH2(Conceptual) and Caching

Spring Batch

Spring Transaction Management

Spring JPA

https://howtodoinjava.com/spring-boot-tutorials/

https://spring.io/guides/gs/spring-boot/

https://spring.io/projects/spring-security

https://howtodoinjava.com/spring-security-tutorial/

https://mkyong.com/tutorials/spring-security-tutorials/

https://spring.io/guides/tutorials/spring-boot-oauth2/

https://mkyong.com/tutorials/spring-batch-tutorial/

https://spring.io/guides/gs/batch-processing/

https://www.baeldung.com/introduction-to-spring-batch

https://dzone.com/articles/spring-transaction-management

https://www.baeldung.com/spring-programmatic-transaction-management

https://spring.io/projects/spring-data-jpa

https://dzone.com/articles/spring-data-jpa

https://www.baeldung.com/the-persistence-layer-with-spring-data-jpa

https://www.learningcrux.com/course/master-hibernate-and-jpa-with-spring-boot-in-100-steps

https://www.youtube.com/watch?v=msXL2oDexqw&list=PLqq-6Pq4lTTbx8p2oCgcAQGQyqN8XeA1x

https://www.youtube.com/watch?v=sm-8qfMWEV8&list=PLqq-6Pq4lTTYTEooakHchTGglSvkZAjnE

https://www.youtube.com/watch?v=EPd-u8ibXBY&list=PLVApX3evDwJ1d0lKKHssPQvzv2Ao3e__Q

https://www.youtube.com/watch?v=1XEX-u12i0A

https://www.youtube.com/watch?v=1fQtFALX80w&list=PLzS3AYzXBoj-H1SJxp2RuMMS4xUWrPV_3

https://www.youtube.com/watch?v=HcjHJLEbtRs

https://www.youtube.com/watch?v=Zyqpo8gxSO0

Design Patterns

Design Principles

Basic Creational Patterns

Structural Patterns

Behavioural Patterns

https://www.baeldung.com/creational-design-patterns

https://www.journaldev.com/1827/java-design-patterns-example-tutorial

https://howtodoinjava.com/design-patterns/creational/

https://www.youtube.com/watch?v=z3SRC2ckJhI&list=PLWPirh4EWFpGeQoTYL5YpzBz8Gjw-sxJb

https://howtodoinjava.com/design-patterns/structural/

https://www.javatpoint.com/structural-design-patterns

https://dzone.com/articles/structural-design-patterns-composite-pattern

https://www.baeldung.com/java-structural-design-patterns

https://www.youtube.com/watch?v=z3SRC2ckJhI&list=PLWPirh4EWFpGeQoTYL5YpzBz8Gjw-sxJb

https://howtodoinjava.com/design-patterns/behavioral/

https://www.javatpoint.com/behavioral-design-patterns

https://www.journaldev.com/1827/java-design-patterns-example-tutorial

https://www.baeldung.com/java-structural-design-patterns

https://www.youtube.com/watch?v=HFu7sbcKuGk&list=PLVg10KteaEq2oYemA0PhEwSkjUqhWKm2p

UML

UML Basics

UML Modeling

Notations

UML Constructs concepts

Type of Diagrams

https://www.guru99.com/uml-class-diagram.html

https://www.javatpoint.com/uml

Spring

Spring MVC

Spring Core & AOP

Spring Batch

SSO & OAUTH2

Spring Security

Spring JTA and JPA

Caching

Spring Transaction Management

Spring Boot Basics

Introduction to Spring

Dependancy Injection, Containers

Creating Beans Using XML configurations & Java configurations

Autowiring

Scopes

https://howtodoinjava.com/java-spring-framework-tutorials/

https://www.baeldung.com/spring-tutorial

https://howtodoinjava.com/spring-mvc-tutorial/

https://www.javatpoint.com/spring-mvc-tutorial

https://dzone.com/tutorials/java/spring/spring-mvc-tutorial-1.html

https://www.journaldev.com/2433/spring-mvc-tutorial

https://howtodoinjava.com/spring-restful/how-to-write-restful-webservices-using-spring-3-mvc/

https://www.baeldung.com/rest-with-spring-series

https://www.learningcrux.com/course/spring-core-advanced-beyond-the-basics

https://spring.io/guides/gs/rest-service/

https://www.youtube.com/watch?v=GB8k2-Egfv0&list=PLC97BDEFDCDD169D7

https://www.youtube.com/watch?v=b_gpvIO24vs&list=PLfkTJXI2Tk-eQlfpOUURnOM_jrMulVXE2

https://www.youtube.com/watch?v=rn5GukaqbSc&list=PL264wQx-QHvl3bx7lW8ey_fjtEkzORIA4

https://www.youtube.com/watch?v=8Gq-fEsN80U&list=PLmjO_jnyV1HX-rYfkeeVwNfbD8gA8tbAh

https://www.youtube.com/watch?v=kXkel8eTCCk&list=PLe5F6J9S-5iHFwY5v-ep2wKgy759jOg8X

https://www.youtube.com/watch?v=YpsFT50mths&list=PLd3UqWTnYXOkkSq5vuX9dmkvSccHhrPXz

Restful Services

RESTFul Services

Data Caching

Web Service

Apache Play

CXF

Jersey - Basics

Web Services - SOAP & REST

SOAP Frameworks

REST Frameworks

REST & SOAP Implementation

Apache CFX, play & Jesersy Basics

https://www.baeldung.com/jax-ws

https://www.javatpoint.com/soap-web-services

https://www.journaldev.com/9131/soap-webservices-in-java-example-eclipse

https://docs.oracle.com/javaee/6/tutorial/doc/gijqy.html

https://dzone.com/articles/restful-web-services-java

https://www.journaldev.com/9170/restful-web-services-tutorial-java

https://dzone.com/articles/soap-web-services-with-apache-cxf-and-spring-boot

https://www.baeldung.com/introduction-to-apache-cxf

https://howtodoinjava.com/jersey-jax-rs-tutorials/

https://www.vogella.com/tutorials/REST/article.html

ORM ORM Basics

Transaction Management

Hibernate Basics

CRUD Operations

Caching

HQL,Criteria & Native API

Build Management, Deployment & Server Config

Maven

GIT/ SVN & Config Management- Basics

Server Config

Profilling Tools

Debugging with Thread Dump

CI/ CD with Jenkins or Hudson

Scaling Systems

Load Balancing

Failover Mechanisms

Oracle

DB Basics

ER Models

Normalization

DDL

DML

DCL

https://www.oracletutorial.com/oracle-basics/

https://www.javatpoint.com/oracle-tutorial

https://www.guru99.com/pl-sql-tutorials.html

https://www.learningcrux.com/course/the-complete-oracle-sql-certification-course

https://www.youtube.com/watch?v=0NLsJQCvKXY&list=PLL_LQvNX4xKwbz1aJe0RofbT9YeJH9huQ

https://www.youtube.com/watch?v=y2CICRujsVw&list=PLWPirh4EWFpGKVoAXc4EjgaV4jbAyLrxe

MySQL

DB Basics

ER Models

Normalization

DDL

DML

DCL

https://dev.mysql.com/doc/refman/8.0/en/tutorial.html

https://www.tutorialspoint.com/mysql/index.htm

https://www.javatpoint.com/mysql-tutorial

https://www.youtube.com/watch?v=yZMfbLReFBg&list=PLC1WCudSg397DV5SxiB2ZZkoouG2b0hJA&index=1

PL/SQL

PL/SQL Basics

Anonymous Blocks

Cursors

Exceptions

Functions & Procedures

Packages and Triggers

https://www.oracletutorial.com/plsql-tutorial/

https://www.guru99.com/pl-sql-tutorials.html

https://www.tutorialspoint.com/plsql/index.htm

https://www.learningcrux.com/course/pl-sql-1-hour-intro-learn-oracle-pl-sql-programming-today

https://www.youtube.com/watch?v=J5wjIf4gdq4&list=PLWPirh4EWFpHj0kKqqYudPNOrGEa0fFIr

https://www.youtube.com/watch?v=rbarR4_gaH8&list=PLL_LQvNX4xKyiExzq9GKwORoH6nvaRnOQ

Advanced PL/SQL

Store Procs.

Functions

Packages

Triggers

HTML 5

Introduction to HTML 5

Html 5 new tags

Html 5 Form tags

Audio & video Tags

Canvas

UI (HTML5, CSS3, JavaScript)

HTML Basics tags

Form elements

Html 5 features

CSS Basics

CSS 3

Introduction to HTML

HTML tags

HTML5 Features

Introduction to CSS3

Introduction to Javascript

Event Handling

Jquery

UI Build Model

JSON

https://www.w3schools.com/html/

https://www.tutorialspoint.com/html/index.htm

https://www.javatpoint.com/html-tutorial

https://www.tutorialspoint.com/html5/index.htm

https://www.learningcrux.com/course/build-responsive-real-world-websites-with-html5-and-css3

https://www.youtube.com/watch?v=eOQXwtsxh3M&list=PL0ggi_UlVzQeKb142Qj2OUt2A1iKT1lRP

https://www.w3schools.com/css/default.asp

https://www.tutorialspoint.com/css/what_is_css.htm

https://www.learningcrux.com/course/build-responsive-real-world-websites-with-html5-and-css3

https://www.tutorialspoint.com/css/css3_tutorial.htm

https://www.youtube.com/watch?v=GvUTqsAm9vE&list=PLamqHyWseJOIliSZ23WDS1Ky-uU5yrjOk

https://www.w3schools.com/js/default.asp

https://www.javatpoint.com/javascript-tutorial

https://www.geeksforgeeks.org/javascript-tutorial/

https://www.w3schools.com/jquery/

https://www.tutorialspoint.com/jquery/index.htm

https://learn.jquery.com/

https://www.freetutorials.ca/course/advanced-javascript

https://www.learningcrux.com/course/javascript-intermediate-level-3-json

https://www.youtube.com/watch?v=le-URjBhevE&list=PLWKjhJtqVAbk2qRZtWSzCIN38JC_NdhW5

https://www.youtube.com/watch?v=2OMzGhlIZpg

Hibernate

ORM Basics

ORM Frameworks

Hiberanate and Other Frameworks

ORM Caching

Advantage and Limitations

https://docs.jboss.org/hibernate/core/4.3/quickstart/en-US/html/

https://www.mkyong.com/tutorials/hibernate-tutorials/

https://howtodoinjava.com/hibernate-tutorials/

https://www.journaldev.com/3793/hibernate-tutorial

https://www.learningcrux.com/course/master-hibernate-and-jpa-with-spring-boot-in-100-steps

https://www.youtube.com/watch?v=gUEizau0-UQ&list=PLWPirh4EWFpF9Gbnu4_DdF4ITHSN6MSsk

https://www.youtube.com/watch?v=Yv2xctJxE-w&list=PL4AFF701184976B25

https://www.youtube.com/watch?v=SZ8abQ3vmdc&list=PLd3UqWTnYXOmXS7oSFk_ZSLcJ7tydnt06

Java Script

Jquery JavaScript Design Patterns - Basics

UI Build Model

JSON

Programing

Problem Solving with Core Java

Application Security

Security Vulnerabilities

https://dzone.com/articles/application-security-for-java-developers

https://medium.com/@chrisbateson80/top-5-java-application-security-frameworks-to-build-secure-apps-e5256b45452b

https://www.baeldung.com/java-security-overview

Integration Frameworks Spring Integration

Apache Camel

Message Broker (Basics)

Queuing systems Level 1 NA NA

Integration Frameworks Message Broker

SOA and ESB (Conceptual)

Spring Integration/ Apache Camel

https://spring.io/projects/spring-integration

https://www.baeldung.com/spring-integration

https://dzone.com/articles/spring-integration-hands

https://camel.apache.org/manual/latest/getting-started.html

https://www.tutorialspoint.com/apache_camel/index.htm

https://www.springpeople.com/blog/4-message-brokers-you-need-to-know/

https://www.baeldung.com/apache-camel-intro

https://hackernoon.com/scaling-microservices-with-message-queues-spring-boot-and-kubernetes-9ba4b0e48bdf

https://www.youtube.com/watch?v=icIosLjHu3I&list=PLr2Nvl0YJxI5-QasO8XY5m8Fy34kG-YF2

Coding Standards

Coding Standards

Coding Principles

Best Parctices

Coding Practices

Dos and Donts

Coding Samples

Code Bugs

Simple Scenarios

https://developer.ibm.com/tutorials/j-perry-writing-good-java-code/

https://medium.com/@rhamedy/a-short-summary-of-java-coding-best-practices-31283d0167d3

Logger

Logger Frameworks

Architecture

Types of Logging

Log4j

https://howtodoinjava.com/log4j/

https://www.tutorialspoint.com/log4j/index.htm

Build Tools Types of Build Tools

Features

Maven

http://tutorials.jenkov.com/maven/maven-tutorial.html

https://howtodoinjava.com/maven/

https://www.baeldung.com/maven

Junit

Unit testing

Junit

https://junit.org/junit5/docs/current/user-guide/

https://howtodoinjava.com/junit-4/

https://www.baeldung.com/junit

https://www.freetutorials.ca/course/learning-junit-5

https://www.youtube.com/playlist?list=PLqq-6Pq4lTTa4ad5JISViSb2FVG8Vwa4o

CI/CD

CI/CD with Jenkins or Hudson

Load Balancing

Fail over mechanisms

Scaling the application

Profiling tools

Debugging Thred dumps

https://jenkins.io/solutions/java/

https://www.vogella.com/tutorials/Jenkins/article.html

https://www.javatpoint.com/jenkins

https://docs.oracle.com/cd/E19528-01/819-4740/abdgt/index.html

https://dzone.com/articles/load-balance-your-web-applicat

https://docs.oracle.com/cd/E19693-01/819-4635/aaqcw/index.html

https://dzone.com/articles/the-basics-of-scaling-java-ee-applications

https://docs.oracle.com/cd/E13211_01/wle/jcreserv/scale.htm

https://dzone.com/articles/top-9-free-java-process-monitoring-tools-amp-how-t

https://docs.oracle.com/javase/8/docs/technotes/guides/visualvm/profiler.html

https://medium.com/platform-engineer/guide-to-java-profilers-e344ce0339e0

https://dzone.com/articles/how-analyze-java-thread-dumps

https://www.youtube.com/watch?v=PWhqbpVbaTo&list=PLH1ul2iNXl7txKuhhDMKenYOThDww6x8S

https://www.youtube.com/watch?v=DhKpqGDXRCk

Messaging

Async Programming

Messaging Queues and Topics

JMS (Conceptual)

Active MQ

https://howtodoinjava.com/jms/jms-java-message-service-tutorial/

https://www.javatpoint.com/jms-tutorial

https://dzone.com/articles/java-message-service-jms

https://dzone.com/articles/jms-activemq

https://www.javainuse.com/java/ActiveMQTutorial

Java FSD Intermediate Important Links

 Coding Standards

Coding Standards

https://developer.ibm.com/tutorials/j-perry-writing-good-java-code/

https://medium.com/@rhamedy/a-short-summary-of-java-coding-best-practices-31283d0167d3

Design Patterns Design Principles

Basic Creational Patterns

Structural Patterns

https://www.baeldung.com/creational-design-patterns

https://www.journaldev.com/1827/java-design-patterns-example-tutorial

https://howtodoinjava.com/design-patterns/creational/

https://www.youtube.com/watch?v=z3SRC2ckJhI&list=PLWPirh4EWFpGeQoTYL5YpzBz8Gjw-sxJb

https://howtodoinjava.com/design-patterns/structural/

https://www.javatpoint.com/structural-design-patterns

https://dzone.com/articles/structural-design-patterns-composite-pattern

https://www.baeldung.com/java-structural-design-patterns

UML

UML Basics

UML Modeling

Notations

UML Constructs concepts

Type of Diagrams

https://www.w3schools.com/html/

https://www.tutorialspoint.com/html/index.htm

https://www.javatpoint.com/html-tutorial

https://www.tutorialspoint.com/html5/index.htm

https://www.youtube.com/watch?v=eOQXwtsxh3M&list=PL0ggi_UlVzQeKb142Qj2OUt2A1iKT1lRP

https://www.w3schools.com/css/default.asp

https://www.tutorialspoint.com/css/what_is_css.htm

https://www.tutorialspoint.com/css/css3_tutorial.htm

https://www.youtube.com/watch?v=GvUTqsAm9vE&list=PLamqHyWseJOIliSZ23WDS1Ky-uU5yrjOk

https://www.w3schools.com/js/default.asp

https://www.javatpoint.com/javascript-tutorial

https://www.geeksforgeeks.org/javascript-tutorial/

https://www.w3schools.com/jquery/

https://www.tutorialspoint.com/jquery/index.htm

https://learn.jquery.com/

https://www.youtube.com/watch?v=le-URjBhevE&list=PLWKjhJtqVAbk2qRZtWSzCIN38JC_NdhW5

https://www.youtube.com/watch?v=2OMzGhlIZpg

Spring

Spring MVC

Spring Core & AOP

Spring Security

Spring Transaction Management

https://howtodoinjava.com/java-spring-framework-tutorials/

https://www.tutorialspoint.com/plsql/index.htm

https://www.baeldung.com/spring-tutorial

https://howtodoinjava.com/spring-mvc-tutorial/

https://www.javatpoint.com/spring-mvc-tutorial

https://dzone.com/tutorials/java/spring/spring-mvc-tutorial-1.html

https://www.journaldev.com/2433/spring-mvc-tutorial

https://howtodoinjava.com/spring-restful/how-to-write-restful-webservices-using-spring-3-mvc/

https://www.baeldung.com/rest-with-spring-series

https://spring.io/guides/gs/rest-service/

https://www.youtube.com/watch?v=GB8k2-Egfv0&list=PLC97BDEFDCDD169D7

https://www.youtube.com/watch?v=b_gpvIO24vs&list=PLfkTJXI2Tk-eQlfpOUURnOM_jrMulVXE2

https://www.youtube.com/watch?v=rn5GukaqbSc&list=PL264wQx-QHvl3bx7lW8ey_fjtEkzORIA4

https://www.youtube.com/watch?v=8Gq-fEsN80U&list=PLmjO_jnyV1HX-rYfkeeVwNfbD8gA8tbAh

https://www.youtube.com/watch?v=kXkel8eTCCk&list=PLe5F6J9S-5iHFwY5v-ep2wKgy759jOg8X

https://www.youtube.com/watch?v=YpsFT50mths&list=PLd3UqWTnYXOkkSq5vuX9dmkvSccHhrPXz

Restful Services

RESTFul Services

Web Service

Apache Play

CXF

Jersey - Basics

Web Services - SOAP & REST

https://www.baeldung.com/jax-ws

https://www.javatpoint.com/soap-web-services

https://www.journaldev.com/9131/soap-webservices-in-java-example-eclipse

https://docs.oracle.com/javaee/6/tutorial/doc/gijqy.html

https://dzone.com/articles/restful-web-services-java

https://www.journaldev.com/9170/restful-web-services-tutorial-java

https://dzone.com/articles/soap-web-services-with-apache-cxf-and-spring-boot

https://www.baeldung.com/introduction-to-apache-cxf

https://howtodoinjava.com/jersey-jax-rs-tutorials/

https://www.vogella.com/tutorials/REST/article.html

Spring Boot

Spring Boot Basics

https://howtodoinjava.com/spring-boot-tutorials/

https://spring.io/guides/gs/spring-boot/

https://spring.io/projects/spring-security

https://howtodoinjava.com/spring-security-tutorial/

https://mkyong.com/tutorials/spring-security-tutorials/

https://www.youtube.com/watch?v=msXL2oDexqw&list=PLqq-6Pq4lTTbx8p2oCgcAQGQyqN8XeA1x

https://www.youtube.com/watch?v=sm-8qfMWEV8&list=PLqq-6Pq4lTTYTEooakHchTGglSvkZAjnE

https://www.youtube.com/watch?v=EPd-u8ibXBY&list=PLVApX3evDwJ1d0lKKHssPQvzv2Ao3e__Q

ORM

ORM Basics

Transaction Management

Hibernate Basics

CRUD Operations

Caching

HQL,Criteria & Native API

Build Management, Deployment & Server Config

Maven

GIT/ SVN & Config Management- Basics

Server Config

Log4j

Introduction to Logging Frame work

Introduction to Log4j

Logger,Appendar & Layout

Logging Levels

https://howtodoinjava.com/log4j/

https://www.tutorialspoint.com/log4j/index.htm

Core Java

Core Java (OOPs & Basic Programming Concepts)

JVM - Internals

Garbage Collection

Java 8 - Streams

Java 8 - Lambda Expressions

Java 8 - Functional Interfaces

Collections

OOPS

Operators

Threads

Exception Handling

Interfaces

Memory Management

Parallel Programming

https://docs.oracle.com/javase/tutorial/index.html

https://www.journaldev.com/7153/core-java-tutorial

https://howtodoinjava.com/

https://www.mkyong.com/tutorials/java-8-tutorials/

https://www.javatpoint.com/internal-details-of-jvm

https://dzone.com/articles/jvm-architecture-explained

https://www.geeksforgeeks.org/jvm-works-jvm-architecture/

https://www.oracle.com/webfolder/technetwork/tutorials/obe/java/gc01/index.html

https://www.baeldung.com/jvm-garbage-collectors

https://www.youtube.com/watch?v=hBh_CC5y8-s

https://www.youtube.com/watch?v=r59xYe3Vyks&list=PLS1QulWo1RIbfTjQvTdj8Y6yyq4R7g-Al

https://www.youtube.com/playlist?list=PLd3UqWTnYXOnjGmyjD3zbIkyLXP15-6w0

https://www.youtube.com/watch?v=ZBJ0u9MaKtM

https://www.youtube.com/watch?v=UnaNQgzw4zY

https://howtodoinjava.com/java-concurrency-tutorial/

http://tutorials.jenkov.com/java-concurrency/index.html

https://www.vogella.com/tutorials/JavaConcurrency/article.html

Junit

Introduction Junit

TestCase

Test method

Test Fixure

Test Suite

https://junit.org/junit5/docs/current/user-guide/

https://howtodoinjava.com/junit-4/

https://www.baeldung.com/junit

https://www.youtube.com/playlist?list=PLqq-6Pq4lTTa4ad5JISViSb2FVG8Vwa4o

Hibernate

ORM Basics

ORM Frameworks

Hiberanate and Other Frameworks

ORM Caching

Advantage and Limitations

https://docs.jboss.org/hibernate/core/4.3/quickstart/en-US/html/

https://www.mkyong.com/tutorials/hibernate-tutorials/

https://howtodoinjava.com/hibernate-tutorials/

https://www.journaldev.com/3793/hibernate-tutorial

https://www.youtube.com/watch?v=gUEizau0-UQ&list=PLWPirh4EWFpF9Gbnu4_DdF4ITHSN6MSsk

https://www.youtube.com/watch?v=Yv2xctJxE-w&list=PL4AFF701184976B25

https://www.youtube.com/watch?v=SZ8abQ3vmdc&list=PLd3UqWTnYXOmXS7oSFk_ZSLcJ7tydnt06

Oracle DB Basics

ER Models

Normalization

DDL

DML

DCL

https://www.oracletutorial.com/oracle-basics/

https://www.javatpoint.com/oracle-tutorial

https://www.guru99.com/pl-sql-tutorials.html

https://www.youtube.com/watch?v=0NLsJQCvKXY&list=PLL_LQvNX4xKwbz1aJe0RofbT9YeJH9huQ

https://www.youtube.com/watch?v=y2CICRujsVw&list=PLWPirh4EWFpGKVoAXc4EjgaV4jbAyLrxe

MySQL

DB Basics

ER Models

Normalization

DDL

DML

DCL

https://dev.mysql.com/doc/refman/8.0/en/tutorial.html

https://www.tutorialspoint.com/mysql/index.htm

https://www.javatpoint.com/mysql-tutorial

https://www.youtube.com/watch?v=yZMfbLReFBg&list=PLC1WCudSg397DV5SxiB2ZZkoouG2b0hJA&index=1

PL/SQL

PL/SQL Basics

Anonymous Blocks

Cursors

Exceptions

https://www.oracletutorial.com/plsql-tutorial/

https://www.guru99.com/pl-sql-tutorials.html

https://www.tutorialspoint.com/plsql/index.htm

https://www.youtube.com/watch?v=J5wjIf4gdq4&list=PLWPirh4EWFpHj0kKqqYudPNOrGEa0fFIr

https://www.youtube.com/watch?v=rbarR4_gaH8&list=PLL_LQvNX4xKyiExzq9GKwORoH6nvaRnOQ

Advanced PL/SQL

Store Procs.

Functions

Packages

Triggers

HTML 5

Introduction to HTML 5

Html 5 new tags

Html 5 Form tags

Audio & video Tags

JSP/ JSF

Introduction to JSP

JSP Scripting Elements

Implicit Objects

Directives

Standard Actions

Customs Action Tags

Introduction to JSF

https://www.tutorialspoint.com/jsp/index.htm

https://www.javatpoint.com/jsp-tutorial

https://www.journaldev.com/2114/servlet-jsp-tutorial

https://www.tutorialspoint.com/jsf/index.htm

https://www.javatpoint.com/jsf-tutorial

https://www.youtube.com/watch?v=6jSzVlpylNQ&list=PL0YXTEfmqmyQIK0OyB1khjzcwUeYec5SP

Java Script/Jquery

JavaScript Design Patterns - Basics

Javascript frameworks - Jquery and others - an overview

Programing

Problem Solving with Core Java

Messaging

Async Programming

Messaging Queues and Topics

JMS (Conceptual)

Active MQ

https://howtodoinjava.com/jms/jms-java-message-service-tutorial/

https://www.javatpoint.com/jms-tutorial

https://dzone.com/articles/java-message-service-jms

https://dzone.com/articles/jms-activemq

https://www.javainuse.com/java/ActiveMQTutorial

Server Config

Types of Server

Http / Web Servers

App Servers

Application archives

Application templates

Application deployment

Data Sources

Server Ports

Tomcat Features

Connection Pooling

Performance Standards

Advantage and Limitations

https://www.javatpoint.com/server-web-vs-application

https://www.tutorialspoint.com/internet_technologies/web_servers.htm

Build Tools

Types of Build Tools

Features

Maven

http://tutorials.jenkov.com/maven/maven-tutorial.html

https://howtodoinjava.com/maven/

https://www.baeldung.com/maven

Java FSD Beginner Important Links

 

UML

1.UML Basics

2.UML Modeling

3.Notations

4.UML Constructs concepts

5.Type of Diagrams

https://www.tutorialspoint.com/uml/index.htm

https://www.geeksforgeeks.org/unified-modeling-language-uml-introduction/

https://www.guru99.com/uml-tutorial.html

https://www.youtube.com/watch?v=gUEizau0-UQ&list=PLWPirh4EWFpF9Gbnu4_DdF4ITHSN6MSsk

UI (HTML5, CSS3, JavaScript)

1.HTML Basics tags

2.Form elements

3.Html 5 features

4.CSS Basics

5.CSS 3

6.JS Basics

7.Function

8.DOM manpulation

9.Events

10.Form Validations

https://www.w3schools.com/html/

https://www.tutorialspoint.com/html/index.htm

https://www.javatpoint.com/html-tutorial

https://www.tutorialspoint.com/html5/index.htm

https://www.youtube.com/watch?v=eOQXwtsxh3M&list=PL0ggi_UlVzQeKb142Qj2OUt2A1iKT1lRP

https://www.w3schools.com/css/default.asp

https://www.tutorialspoint.com/css/what_is_css.htm

https://www.tutorialspoint.com/css/css3_tutorial.htm

https://www.youtube.com/watch?v=GvUTqsAm9vE&list=PLamqHyWseJOIliSZ23WDS1Ky-uU5yrjOk

https://www.w3schools.com/js/default.asp

https://www.javatpoint.com/javascript-tutorial

https://www.geeksforgeeks.org/javascript-tutorial/

https://www.youtube.com/watch?v=le-URjBhevE&list=PLWKjhJtqVAbk2qRZtWSzCIN38JC_NdhW5

MySQL

1.DB Basics

2.DDL

3.DML

4.DCL

https://dev.mysql.com/doc/refman/8.0/en/tutorial.html

https://www.tutorialspoint.com/mysql/index.htm

https://www.javatpoint.com/mysql-tutorial

https://www.youtube.com/watch?v=yZMfbLReFBg&list=PLC1WCudSg397DV5SxiB2ZZkoouG2b0hJA&index=1

Oracle

1.DB Basics

2.ER Models

3.Normalization

4.DDL

5.DML

6.DCL

7.PL SQL Basics

https://www.oracletutorial.com/oracle-basics/

https://www.javatpoint.com/oracle-tutorial

https://www.guru99.com/pl-sql-tutorials.html

https://www.youtube.com/watch?v=0NLsJQCvKXY&list=PLL_LQvNX4xKwbz1aJe0RofbT9YeJH9huQ

https://www.youtube.com/watch?v=y2CICRujsVw&list=PLWPirh4EWFpGKVoAXc4EjgaV4jbAyLrxe

Spring

1.Spring Core

2.Spring JDBC

3.Spring ORM

4.Spring MVC

5.Restful Service

https://howtodoinjava.com/java-spring-framework-tutorials/

https://www.tutorialspoint.com/plsql/index.htm

https://www.baeldung.com/spring-tutorial

https://howtodoinjava.com/spring-mvc-tutorial/

https://www.javatpoint.com/spring-mvc-tutorial

https://dzone.com/tutorials/java/spring/spring-mvc-tutorial-1.html

https://www.journaldev.com/2433/spring-mvc-tutorial

https://howtodoinjava.com/spring-restful/how-to-write-restful-webservices-using-spring-3-mvc/

https://www.baeldung.com/rest-with-spring-series

https://spring.io/guides/gs/rest-service/

https://www.youtube.com/watch?v=GB8k2-Egfv0&list=PLC97BDEFDCDD169D7

https://www.youtube.com/watch?v=b_gpvIO24vs&list=PLfkTJXI2Tk-eQlfpOUURnOM_jrMulVXE2

https://www.youtube.com/watch?v=rn5GukaqbSc&list=PL264wQx-QHvl3bx7lW8ey_fjtEkzORIA4

https://www.youtube.com/watch?v=8Gq-fEsN80U&list=PLmjO_jnyV1HX-rYfkeeVwNfbD8gA8tbAh

https://www.youtube.com/watch?v=kXkel8eTCCk&list=PLe5F6J9S-5iHFwY5v-ep2wKgy759jOg8X

https://www.youtube.com/watch?v=YpsFT50mths&list=PLd3UqWTnYXOkkSq5vuX9dmkvSccHhrPXz

Spring Boot

1.Spring Boot

2.Restful Sevices

WebServices

1.SOAP Frameworks

2.REST Frameworks

3.REST & SOAP Implementation

4.SOAP and REST Client

https://www.baeldung.com/jax-ws

https://www.javatpoint.com/soap-web-services

https://www.journaldev.com/9131/soap-webservices-in-java-example-eclipse

https://docs.oracle.com/javaee/6/tutorial/doc/gijqy.html

https://dzone.com/articles/restful-web-services-java

https://www.journaldev.com/9170/restful-web-services-tutorial-java

Hibernate

ORM Basics

ORM Frameworks

Hiberanate and Other Frameworks

ORM Caching

Advantage and Limitations

https://docs.jboss.org/hibernate/core/4.3/quickstart/en-US/html/

https://www.mkyong.com/tutorials/hibernate-tutorials/

https://howtodoinjava.com/hibernate-tutorials/

https://www.journaldev.com/3793/hibernate-tutorial

https://www.youtube.com/watch?v=gUEizau0-UQ&list=PLWPirh4EWFpF9Gbnu4_DdF4ITHSN6MSsk

https://www.youtube.com/watch?v=Yv2xctJxE-w&list=PL4AFF701184976B25

https://www.youtube.com/watch?v=SZ8abQ3vmdc&list=PLd3UqWTnYXOmXS7oSFk_ZSLcJ7tydnt06

Core Java

1.Fundamentals(Operators,Control Statememts)

2.OOPS

3.Exceptions Handling

4.Collections Frameworks

5. Multi Threading

6.IO,Serialization

7.Java 5,6,7,8 Features

8.Mutilthreading & Cuncurrency

https://docs.oracle.com/javase/tutorial/index.html

https://www.journaldev.com/7153/core-java-tutorial

https://howtodoinjava.com/

https://www.mkyong.com/tutorials/java-8-tutorials/

https://www.youtube.com/watch?v=hBh_CC5y8-s

https://www.youtube.com/watch?v=r59xYe3Vyks&list=PLS1QulWo1RIbfTjQvTdj8Y6yyq4R7g-Al

https://www.youtube.com/playlist?list=PLd3UqWTnYXOnjGmyjD3zbIkyLXP15-6w0

https://howtodoinjava.com/java-concurrency-tutorial/

http://tutorials.jenkov.com/java-concurrency/index.html

https://www.vogella.com/tutorials/JavaConcurrency/article.html

Design Patterns

1.Design Pattern Basics

2.Core Java Design Patterns

3.Creational

4.Structural

5.Behavioral

6.J2EE Blue Prints patterns

UI Design Pattern

1.UI Design Pattern Basics

2.JS Design Patters

PL/SQL

1.PL/SQL

2.Advanced PL/SQL

3.Store Procs.

4.Cursors

5.Triggers

6.DB Links

https://www.oracletutorial.com/plsql-tutorial/

https://www.guru99.com/pl-sql-tutorials.html

https://www.tutorialspoint.com/plsql/index.htm

https://www.youtube.com/watch?v=J5wjIf4gdq4&list=PLWPirh4EWFpHj0kKqqYudPNOrGEa0fFIr

https://www.youtube.com/watch?v=rbarR4_gaH8&list=PLL_LQvNX4xKyiExzq9GKwORoH6nvaRnOQ

Coding Standards

1.Coding Standards

2.Coding Principles

3.Best Parctices

4.Coding Practices

5.Dos and Donts

https://developer.ibm.com/tutorials/j-perry-writing-good-java-code/

https://medium.com/@rhamedy/a-short-summary-of-java-coding-best-practices-31283d0167d3

Coding

1.Coding Samples

2.Code Bugs

3.Simple Scenarios

https://developer.ibm.com/tutorials/j-perry-writing-good-java-code/

https://medium.com/@rhamedy/a-short-summary-of-java-coding-best-practices-31283d0167d3

Unit Testing

1.Testing Frameworks

2.Test Suits

3.Testing Methodologies

4.Code Coverage

Logger

1.Logger Frameworks

2.Architecture

3.Types of Logging

4.Log4j

https://howtodoinjava.com/log4j/

https://www.tutorialspoint.com/log4j/index.htm

Build Tools

1.Types of Build Tools

2.Features

3.Maven

http://tutorials.jenkov.com/maven/maven-tutorial.html

https://howtodoinjava.com/maven/

https://www.baeldung.com/maven

Junit

1.Unit Testing

2.Junit

https://junit.org/junit5/docs/current/user-guide/

https://howtodoinjava.com/junit-4/

https://www.baeldung.com/junit

https://app.pluralsight.com/library/courses/junit-5-fundamentals/table-of-contents

Servers

1.Types of Server

2.Web Servers

3.App Servers

4.Application archives

5.Application templates

6.Application deployment

7.Data Sources

8.Server Ports

9.Tomcat Features

10.Advantage and Limitations

https://www.javatpoint.com/server-web-vs-application

https://www.tutorialspoint.com/internet_technologies/web_servers.htm

Some useful SQL Queries

Block queries

SELECT

    spid

    ,sp.status

    ,loginame   = SUBSTRING(loginame, 1, 12)

    ,hostname   = SUBSTRING(hostname, 1, 12)

    ,blk        = CONVERT(char(3), blocked)

    ,open_tran

    ,dbname     = SUBSTRING(DB_NAME(sp.dbid),1,10)

    ,cmd

    ,waittype

    ,waittime

    ,last_batch

    ,SQLStatement       =

        SUBSTRING

        (

            qt.text,

            er.statement_start_offset/2,

            (CASE WHEN er.statement_end_offset = -1

                THEN LEN(CONVERT(nvarchar(MAX), qt.text)) * 2

                ELSE er.statement_end_offset

                END - er.statement_start_offset)/2

        )

FROM master.dbo.sysprocesses sp

LEFT JOIN sys.dm_exec_requests er

    ON er.session_id = sp.spid

OUTER APPLY sys.dm_exec_sql_text(er.sql_handle) as qt

WHERE spid IN (SELECT blocked FROM master.dbo.sysprocesses)

AND blocked = 0

      

Kill process  - kill and processID

kill 201;

check Index

select the db and run

SELECT ps.database_id, object_name(ps.OBJECT_ID) as table_name, ps.index_id, b.name as index_name, ps.avg_fragmentation_in_percent,ps.page_count

FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS ps

INNER JOIN sys.indexes AS b ON ps.OBJECT_ID = b.OBJECT_ID

inner join sys.tables as c ON b.object_id = c.object_id

AND ps.index_id = b.index_id

WHERE ps.database_id = DB_ID()

and b.name is not null

ORDER BY ps.avg_fragmentation_in_percent desc

Check last executed stats

/* 1.Query to check when statistics was last executed */

SELECT

  st.object_id                          AS [Table ID]

, OBJECT_NAME(st.object_id)             AS [Table Name]

, st.name                               AS [Index Name]

, STATS_DATE(st.object_id, st.stats_id) AS [LastUpdated]

, modification_counter                  AS [Rows Modified]

FROM

sys.stats st

CROSS APPLY

sys.dm_db_stats_properties(st.object_id, st.stats_id) AS sp

WHERE

STATS_DATE(st.object_id, st.stats_id)<=DATEADD(DAY,-1,GETDATE()) 

AND modification_counter > 0

AND OBJECTPROPERTY(st.object_id,'IsUserTable')=1

order by OBJECT_NAME(st.object_id)

read sp

sp_helptext 'myDb.spName'

few

SELECT

       r.session_id

       ,st.TEXT AS batch_text

       ,SUBSTRING(st.TEXT, statement_start_offset / 2 + 1, (

                     (

                           CASE

                                  WHEN r.statement_end_offset = - 1

                                         THEN (LEN(CONVERT(NVARCHAR(max), st.TEXT)) * 2)

                                  ELSE r.statement_end_offset

                                  END

                           ) - r.statement_start_offset

                     ) / 2 + 1) AS statement_text

       ,qp.query_plan AS 'XML Plan'

       ,r.*

FROM sys.dm_exec_requests r

CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) AS st

CROSS APPLY sys.dm_exec_query_plan(r.plan_handle) AS qp

ORDER BY cpu_time DESC

select

    P.spid,

       P.status

,   right(convert(varchar,

            dateadd(ms, datediff(ms, P.last_batch, getdate()), '1900-01-01'),

            121), 12) as 'batch_duration'

,   P.program_name

,   P.hostname

,   P.loginame

from master.dbo.sysprocesses P

where P.spid > 50

and      P.status not in ('background', 'sleeping','runnable')

and      P.cmd not in ('AWAITING COMMAND'

                    ,'MIRROR HANDLER'

                    ,'LAZY WRITER'

                    ,'CHECKPOINT SLEEP'

                    ,'RA MANAGER')

order by batch_duration desc

Some useful SQL Queries

Some Useful SQL commands
-------------------------

-- get database names
SELECT name,* FROM master.dbo.sysdatabases



Job History
-----------


USE msdb ; 
GO 

SELECT j.name JobName,h.step_name StepName,
CONVERT(CHAR(10), CAST(STR(h.run_date,8, 0) AS dateTIME), 111) RunDate,
STUFF(STUFF(RIGHT('000000' + CAST ( h.run_time AS VARCHAR(6 ) ) ,6),5,0,':'),3,0,':') RunTime,
h.run_duration StepDuration,
case h.run_status when 0 then 'failed'
when 1 then 'Succeded'
when 2 then 'Retry'
when 3 then 'Cancelled'
when 4 then 'In Progress'
end as ExecutionStatus,
h.message MessageGenerated
FROM sysjobhistory h inner join sysjobs j
ON j.job_id = h.job_id
-- name of the job
where j.name='Populate_TTC_Task_Details'
-- only failed jobs
AND h.run_status=0
ORDER BY h.run_date desc

Full Job history
------------------

USE msdb ; 
GO 

EXEC dbo.sp_help_jobhistory 
    @job_name = N'Populate_TTC_Task_Details' ; 
GO

Job names
----------
select s.name,l.name
 from  msdb..sysjobs s
 left join master.sys.syslogins l on s.owner_sid = l.sid
 order by s.name

 -- find guid from backups
use [msdb]
SELECT * FROM log_shipping_primary_databases

"D:\Program Files\Microsoft SQL Server\110\Tools\Binn\sqllogship.exe" -Backup E842CE8C-9F88-4483-B3AE-96BA97F62E25 -server ServerName



Most CPU Intensive Queries
--------------------------

--- https://www.red-gate.com/simple-talk/blogs/how-to-find-cpu-intensive-queries/

SELECT
       -- using statement_start_offset and
       -- statement_end_offset we get the query text
       -- from inside the entire batch
       SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1,
                           ((CASE qs.statement_end_offset
                                        WHEN -1 THEN DATALENGTH(qt.TEXT)
                                        ELSE qs.statement_end_offset
                           END
                           - qs.statement_start_offset)/2)+1)
                           as [Text],
qs.execution_count,
qs.total_logical_reads, qs.last_logical_reads,
qs.total_logical_writes, qs.last_logical_writes,
qs.total_worker_time,
qs.last_worker_time,
-- converting microseconds to seconds
qs.total_elapsed_time/1000000 total_elapsed_time_in_S,
qs.last_elapsed_time/1000000 last_elapsed_time_in_S,
qs.last_execution_time,
qp.query_plan
FROM sys.dm_exec_query_stats qs
       -- Retrieve the query text
       CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) qt
       -- Retrieve the query plan
       CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp
ORDER BY qs.total_worker_time DESC -- CPU time


Longest Running queries
-----------------------
SELECT  st.text,
        qp.query_plan,
total_worker_time,
        qs.*
FROM    (
    SELECT  TOP 50 *
    FROM    sys.dm_exec_query_stats
    ORDER BY total_worker_time DESC
) AS qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st
CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) AS qp
WHERE qs.max_worker_time > 300
      OR qs.max_elapsed_time > 300
 
 
Permission
----------
USE (your database)
EXEC sp_addrolemember 'db_datareader', '(your user name)'



Server Info
-----------

SELECT
            SERVERPROPERTY('MachineName') AS [ServerName],
SERVERPROPERTY('ServerName') AS [ServerInstanceName],
            SERVERPROPERTY('InstanceName') AS [Instance],
            SERVERPROPERTY('Edition') AS [Edition],
            SERVERPROPERTY('ProductVersion') AS [ProductVersion],
Left(@@Version, Charindex('-', @@version) - 2) As VersionName



Change Recovery Model
---------------------
USE [master]
GO
ALTER DATABASE [Mydb] SET RECOVERY SIMPLE WITH NO_WAIT
GO


Get Recovery Info
-----------------
SELECT name, recovery_model_desc 
   FROM sys.databases 
      WHERE name in ('Mydb')
 
 
 
Shrink Files
---------------

USE [Mydb]
GO
DBCC SHRINKFILE (N'mydb_log' , 0, TRUNCATEONLY)
GO


Update Column uppercase
------------------------

update [MyDB].[myTable].[HostNameCountry]
set hostname=upper(hostname)



database Size
--------------


IF OBJECT_ID('tempdb.dbo.#space') IS NOT NULL
    DROP TABLE #space

CREATE TABLE #space (
      database_id INT PRIMARY KEY
    , data_used_size DECIMAL(18,2)
    , log_used_size DECIMAL(18,2)
)

DECLARE @SQL NVARCHAR(MAX)

SELECT @SQL = STUFF((
    SELECT '
    USE [' + d.name + ']
    INSERT INTO #space (database_id, data_used_size, log_used_size)
    SELECT
          DB_ID()
        , SUM(CASE WHEN [type] = 0 THEN space_used END)
        , SUM(CASE WHEN [type] = 1 THEN space_used END)
    FROM (
        SELECT s.[type], space_used = SUM(FILEPROPERTY(s.name, ''SpaceUsed'') * 8. / 1024)
        FROM sys.database_files s
        GROUP BY s.[type]
    ) t;'
    FROM sys.databases d
    WHERE d.[state] = 0
    FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 2, '')

EXEC sys.sp_executesql @SQL

SELECT
      d.database_id
    , d.name
    , d.state_desc
    , d.recovery_model_desc
    , t.total_size
    , t.data_size
    , s.data_used_size
    , t.log_size
    , s.log_used_size
    , bu.full_last_date
    , bu.full_size
    , bu.log_last_date
    , bu.log_size
FROM (
    SELECT
          database_id
        , log_size = CAST(SUM(CASE WHEN [type] = 1 THEN size END) * 8. / 1024 AS DECIMAL(18,2))
        , data_size = CAST(SUM(CASE WHEN [type] = 0 THEN size END) * 8. / 1024 AS DECIMAL(18,2))
        , total_size = CAST(SUM(size) * 8. / 1024 AS DECIMAL(18,2))
    FROM sys.master_files
    GROUP BY database_id
) t
JOIN sys.databases d ON d.database_id = t.database_id
LEFT JOIN #space s ON d.database_id = s.database_id
LEFT JOIN (
    SELECT
          database_name
        , full_last_date = MAX(CASE WHEN [type] = 'D' THEN backup_finish_date END)
        , full_size = MAX(CASE WHEN [type] = 'D' THEN backup_size END)
        , log_last_date = MAX(CASE WHEN [type] = 'L' THEN backup_finish_date END)
        , log_size = MAX(CASE WHEN [type] = 'L' THEN backup_size END)
    FROM (
        SELECT
              s.database_name
            , s.[type]
            , s.backup_finish_date
            , backup_size =
                        CAST(CASE WHEN s.backup_size = s.compressed_backup_size
                                    THEN s.backup_size
                                    ELSE s.compressed_backup_size
                        END / 1048576.0 AS DECIMAL(18,2))
            , RowNum = ROW_NUMBER() OVER (PARTITION BY s.database_name, s.[type] ORDER BY s.backup_finish_date DESC)
        FROM msdb.dbo.backupset s
        WHERE s.[type] IN ('D', 'L')
    ) f
    WHERE f.RowNum = 1
    GROUP BY f.database_name
) bu ON d.name = bu.database_name
ORDER BY t.total_size DESC


Get size of db from back up file
--------------------------------


-- give the path of backup file
RESTORE FILELISTONLY FROM DISK = N'C:\DB_Backup\Mydb.bak'



Link Server Query
----------------

-- get the details of the linkservers
sp_linkedservers



-- query from link server
-- below is the example
select * from openquery(LInkServerName, 'select * from XXXX.XXV_V')



Session Precheck / any active sessions for DB
---------------------------------------------

BEGIN TRANSACTION
SET NOCOUNT ON
BEGIN
DECLARE @V_COUNT INTEGER

SELECT @V_COUNT = count(*) FROM MASTER..SYSPROCESSES P, MASTER..SYSDATABASES D WHERE P.DBID = D.DBID AND D.DBID = DB_ID('#DBNAME#') and P.SPID <> @@spid and P.SPID > 50;

IF (@V_COUNT > 0)
BEGIN
SELECT SPID,hostname FROM MASTER..SYSPROCESSES P, MASTER..SYSDATABASES D
WHERE P.DBID = D.DBID AND D.DBID = DB_ID('#DBNAME#') and P.SPID <> @@spid;
RAISERROR('',16,1)
ROLLBACK TRANSACTION
RETURN
END
END


Add user
---------

USE [master]
GO
CREATE LOGIN [NEXA\username] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO
USE [Mydb]
GO
CREATE USER [NEXA\username] FOR LOGIN [NEXA\username]
GO
USE [Mydb]
GO
EXEC sp_addrolemember N'db_owner', N'NEXA\username'
GO


Check Performance and kill running Scripts
------------------------------------------

sp_who2

kill 74


Shrink DB
------------------


USE [MyDB]
GO
/****** Object:  StoredProcedure [mydb].[Nexa_Shrink_MyDBTrasactionLog]    Script Date: 9/27/2016 12:00:58 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [MyDB].[Nexa_Shrink_MyDBTrasactionLog] 
 
AS 
 
BEGIN 
 -- Declare required variables. 
 DECLARE @vcDBMirroringStatus VARCHAR (100); 
 DECLARE @vcMirroringStatus VARCHAR (100); 
 DECLARE @intDBId INT; 
 
 -- Set the values for variables. 
 
 SET @vcMirroringStatus = 'SYNCHRONIZED' -- This is the syncronized status 
 SET @intDBId = DB_ID();-- This is the digite mirroring DB id. 
 
 -- Get the Digite DB mirroring status 
 SET @vcDBMirroringStatus = (select mirroring_state_desc from sys.database_mirroring where database_id = @intDBId) 
 
 -- If Digite DB mirroring status is 'SYNCHRONIZED' only shrink the DB log 
 IF @vcDBMirroringStatus = @vcMirroringStatus 
 BEGIN 
  CHECKPOINT 
  BACKUP LOG  MyDb to disk = 'C:\ShrinkDBLogs\Mydb1.trn' 
  DBCC SHRINKFILE (Mydb_log, 15360) 
 END 
 
END 




-------------


SELECT TOP 25
dm_mid.database_id AS DatabaseID,
dm_migs.avg_user_impact*(dm_migs.user_seeks+dm_migs.user_scans) Avg_Estimated_Impact,
dm_migs.last_user_seek AS Last_User_Seek,
OBJECT_NAME(dm_mid.OBJECT_ID,dm_mid.database_id) AS [TableName],
'CREATE INDEX [IX_' + OBJECT_NAME(dm_mid.OBJECT_ID,dm_mid.database_id) + '_'
+ REPLACE(REPLACE(REPLACE(ISNULL(dm_mid.equality_columns,''),', ','_'),'[',''),']','') +
CASE
WHEN dm_mid.equality_columns IS NOT NULL AND dm_mid.inequality_columns IS NOT NULL THEN '_'
ELSE ''
END
+ REPLACE(REPLACE(REPLACE(ISNULL(dm_mid.inequality_columns,''),', ','_'),'[',''),']','')
+ ']'
+ ' ON ' + dm_mid.statement
+ ' (' + ISNULL (dm_mid.equality_columns,'')
+ CASE WHEN dm_mid.equality_columns IS NOT NULL AND dm_mid.inequality_columns IS NOT NULL THEN ',' ELSE
'' END
+ ISNULL (dm_mid.inequality_columns, '')
+ ')'
+ ISNULL (' INCLUDE (' + dm_mid.included_columns + ')', '') AS Create_Statement
FROM sys.dm_db_missing_index_groups dm_mig
INNER JOIN sys.dm_db_missing_index_group_stats dm_migs
ON dm_migs.group_handle = dm_mig.index_group_handle
INNER JOIN sys.dm_db_missing_index_details dm_mid
ON dm_mig.index_handle = dm_mid.index_handle
WHERE dm_mid.database_ID = DB_ID()
ORDER BY Avg_Estimated_Impact DESC
GO



---------------------------------