Complete SQL Real-time Live Training with interview preparation by Pandey Guruji

Course link: https://pandeyguruji.graphy.com/courses/complete-sql-real-time-live-training-with-interview-preparation-12-2
For any queries contact me on Whats App: +918309569513
----------------------------------------------------------------------------------------------------------------
This course contains In-depth coverage of SQL. Covers all of the important query tools and SQL commands. You'll learn how to read and write complex queries. Handle tricky SQL interview questions. Implement complex SQL queries and answer popular interview questions on SQL. This course will help to get jobs in SQL Developer, Database Developer, Data Engineer, Reporting Analyst, Data Analytics, Data scientist.
-----------------------Course Module--------------------------------------------------------------------
1. Basics of Database, SQL, and SQL Languages
2. Temp table, Table Variable, Constrains & Indexes in SQL
3. Data Query Language(DQL), Aggregated function, Group by, Having Clauses.
4. SQL Built in Functions(System function)
5. Joins, Sub Query, Set operator, and CTE
6. Views, Cursors, While Loop, If & Case-Control
7. Stored Procedures, Transaction Management & Exception Handling
8. User-Defined Functions & Triggers
9. SQL Interview Preparation
10. How to prepare the SQL interview and most important Interview Questions. A better strategy to crack any SQL interview.
--------------------------------------------------------------------------------------------------------------------
1. Basics of Database, SQL, and SQL Languages:
Introduction to Database. Introduction to SQL Server. Introduction to well-known database software used. Advantages and Drawbacks of SQL Server Compared to Oracle and DB2. Connecting to Server Server Type Server Name Authentication Modes: SQL Server Authentication Mode Windows Authentication Mode, log in and Password. SQL Server Management Studio and Tools in Management Studio. Data Definition Language (DDL), Data Manipulation Language (DML), Data Query Language (DQL), Data Control Language (DCL), Transaction Control Language (TCL)
2. Temp table, Table Variable, Constrains & Indexes in SQL: Local & Global Temp Table, Table Variable, Primary Key constraints. • foreign key constraints. • Unique key constraints. • Not Null constraints. • Default constraints. • Check constraints• Clustered Index • Non-Clustered Index • Create, Alter and Drop Indexes • Using Indexes
3. Data Query Language(DQL), Aggregated function, Group by, Having Clauses: Where clause • Order by Clause • Distinct Keyword • IsNull() function • Column aliases • Predicates • Between … And • In • Like • Is Null, Top n Clause Group by and Having Clauses. • SUM, AVG, Count, Max, Min Aggregated function.
4. SQL Built in Functions(System function): Date Time Function: GETDATE(), DATEADD(), DATEPART(),DATEDIFF(),DATENAME(),DAY(),MONTH(),YEAR(),EOMONTH(), ISDATE() String Functions:ASCII() ,CHAR() ,NCHAR() ,DIFFERENCE() , LEFT() ,RIGHT(),LTRIM() ,RTRIM() ,REPLACE() ,REVERSE() ,CHARINDEX ,PATINDEX ,LEN,STUFF,SUBSTRING,LOWER / UPPER, Conversion Function: Cast,Convert Ranking Functions: Rank, Densk Rank, row_number(), ntile
5. Joins, Sub Query, Set operator, and CTE:Joins: • Inner Join • Outer Join I. Left Outer Join II. Right Outer Join III. Full Outer Join • Self-Join • Cross Join. Sub Queries. • Single Row Sub Queries • Multi-Row Sub Queries • Nested Sub Queries • Co-Related Sub Queries • Exists and Not Exists • In and Not In. • Union, Union all, Intersect, and excerpt operator. Common Table Expressions (CTE).
6. Views, Cursors, While Loop, If & Case-Control:Purpose of Views • Creating, Altering, and Dropping Indexes • Simple and Complex Views • Encryption and Schema Binding Options in creating views. • Working with Cursors • Types of Cursors I. Forward Only and Scroll Cursors II. Static, Dynamic, and Keyset Cursors III. Local and Global Cursors • Conditional Control Statements: If & Case. • Looping Control Statements: While Loop.
7. Stored Procedures, Transaction Management & Exception Handling:
8. User-Defined Functions & Triggers:Creating, Altering, and Dropping • Types of User-Defined Functions I. Scalar Functions. II. Inline Table-Valued Functions III. Multi Statement Table Valued Functions, Purpose of Triggers • Differences Between Stored Procedures and User-Defined Functions and Triggers • Creating, Altering and Dropping Triggers • Magic Tables • Instead of Triggers.
9. SQL Interview Preparation:How to prepare the SQL interview and most important Interview Questions. A better strategy to crack any SQL interview.
10. Resume Preparation and Mock Interview
How to prepare an attractive resume and Mock interview.
#SQLLiveTraining, #SQL, #PandeyGuruji

Видео Complete SQL Real-time Live Training with interview preparation by Pandey Guruji канала Pandey Guruji