Mastering Angular Reactive Forms: Part 1 - Building Dynamic and Interactive Forms

 #AngularReactiveForms #AngularForms #ReactiveFormsTutorial #AngularTutorial #AngularFormsPart1 #AngularFormValidation #AngularFormSubmissions #DynamicForms #InteractiveForms #AngularDevelopment #FrontendDevelopment #WebDevelopment

https://youtu.be/EpdRLNpm3F0

<iframe width="560" height="315" src="https://www.youtube.com/embed/EpdRLNpm3F0" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>

Sql tutorial final part 1 in hindi #sql #sqltutorials

 https://www.youtube.com/channel/UC_X3n9JVuK36F4ADJBajM9A/join

EXCEPTION HANDLING IN SQL ?

Select *from EMPLOYEES

--CREATE TABLE TEST

--(

--   ID INT,

--   [NAME] NVARCHAR(10)

--)

SELECT ID,[NAME] FROM TEST

INSERT INTO TEST([NAME],ID) VALUES('SHYAM',88)

--Using Distinct Keyword to select Unique records

SELECT DISTINCT ID,[NAME] FROM TEST

--select records using where clause

SELECT ID,[NAME] FROM TEST WHERE ID=20

--select records using where AND/OR Clause

SELECT ID,[NAME] FROM TEST WHERE ID=20 AND [NAME]='RAM' OR [NAME]='SHYAM'

--select records using where IN Clause

SELECT ID,[NAME] FROM TEST WHERE [NAME] IN ('RAM','SHYAM')

--select records using where BETWEEN Clause

SELECT ID,[NAME] FROM TEST WHERE ID BETWEEN 55 AND 99

--select records using where LIKE Clause

SELECT ID,[NAME] FROM TEST WHERE [NAME] LIKE '%YAM%'

--select records using Order BY Clause

SELECT ID,[NAME] FROM TEST ORDER BY 2 DESC

--select records using Group BY Clause

SELECT SUM(ID) ID,[NAME] FROM TEST GROUP BY [NAME]

--select records using Count Clause

SELECT COUNT(ID) ID FROM TEST

--select records using MAX Clause

SELECT MAX(ID) ID FROM TEST

--select records using Having Clause

SELECT ID FROM TEST GROUP BY ID HAVING MAX(ID)>20

CREATE INDEX INDEX_TEST_ID

ON TEST(ID)

ALTER TABLE TEST

DROP INDEX INDEX_TEST_ID ON TEST  --- DROP INDEX FROM TABLE

--------EXCEPTION HANDLING-----------

 BEGIN TRY

SELECT *FROM TEST

DECLARE @A INT = 1;

DECLARE @B INT = 0;

DECLARE @C INT = 0;

SET @C = @A/@B;

END TRY

BEGIN CATCH

PRINT 'CATCH'

END CATCH

SQL Statements?

 --SELECT,INSERT,UPDATE,DELETE,ALTER,DROP,TRUNCATE,CREATE,USE,SHOW

--USE [LiveSession]

--SELECT *FROM EMPLOYEES

--SELECT *FROM EMPLOYEESALARY

--INSERT INTO EMPLOYEES([NAME],ID,IsActive,AGE) VALUES('HELLO',5,0,60)

--UPDATE EMPLOYEES SET [NAME] = 'ABC',AGE=1 WHERE ID=5

--DELETE EMPLOYEES WHERE ID=5

--DELETE EMPLOYEESALARY

--ALTER TABLE EMPLOYEESALARY ADD T INT

--ALTER TABLE EMPLOYEESALARY ALTER COLUMN T BIT  -- ALT+F1

--TRUNCATE VS DROP VS DELETE

TRUNCATE TABLE EMPLOYEESALARY -- IDENTITY(1,1)

DROP TABLE EMPLOYEESALARY