tut4it
Active member
SQL Bootcamp | TechTFQ
English | Size: 32.04 GB
Genre: eLearning
English | Size: 32.04 GB
Genre: eLearning
Course Contents
Introduction & Pre-Requisites
Introduction to data, database, schema and SQL.
Understand why do we use SQL and how data is stored in database
How to choose a database and IDE
Installing a database and tools required to get started
Basic SQL
SQL Commands
DDL commands
CREATE, ALTER, DROP, TRUNCATE
DML commands
INSERT, UPDATE, DELETE, MERGE
TCL commands
COMMIT, ROLLBACK and SAVEPOINT
DCL commands
GRANT and REVOKE
DQL commands
SELECT statement
Data Types
String data type like VARCHAR, TEXT etc
Integer data type like INT, NUMBER etc.
DATE
FLOAT / DECIMAL
BOOLEAN
IDENTITY column (Auto Increment column)
Constraints
PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, NOT NULL and DEFAULT constraints
Understanding how foreign key and primary is used to build relationship between tables.
Normalization in SQL
Different normal forms like 1NF, 2NF, 3NF, BCNF
Understand ER (Entity Relationship) diagram
Operators
Arithmetic operator
Logical operator
Comparison operator
UNION, UNION ALL operator
CASE statement
Simple case statement as well nested case statement.
Important SQL clause
DISTINCT clause
Order by clause
Limit / Top clause
INNER join
How to fetch data from multiple tables.
Intermediate SQL
Group By and Having clause
Aggregate functions
MIN, MAX, AVG, SUM, COUNT
Order of Execution in SQL Queries
Sub-Queries
Different type of subqueries like scalar subquery, multirow subquery and correlated subqueries
CTE table / WITH clause
All type of Joins
LEFT Join, RIGHT Join, FULL OUTER Join
CROSS Join, SELF Join
In-built functions
String functions like Substring, Position, Coalesce etc.
Date functions like Extract, To_Date etc.
Window functions
RANK, DENSE_RANK, ROW_NUMBER, LEAD, LAG
FIRST_VALUE, LAST_VALUE, NTH_VALUE, NTILE
Views in SQL
Advanced SQL
Recursive SQL Queries
PIVOT table / CROSSTAB function
Materialized Views
Stored Procedure
User Defined Functions
SQL Case study
You will be given a scenario with sample dataset
Understand the scenario and analyze the given data
Solve multiple SQL problems for the given problem statement
Code:
https://rapidgator.net/file/3a2ef602cb8ec66b4a51a9a2b9fa86d7/TechTFQ-SQL-Course-Beginner-to-Advanced.part01.rar.html
https://rapidgator.net/file/ab4a56d5d676afad4c184393bf18d79e/TechTFQ-SQL-Course-Beginner-to-Advanced.part02.rar.html
https://rapidgator.net/file/be451bdc41598096625362ac9ba8f7d4/TechTFQ-SQL-Course-Beginner-to-Advanced.part03.rar.html
https://rapidgator.net/file/c61e1fd029036e82bfd9f5b014a79169/TechTFQ-SQL-Course-Beginner-to-Advanced.part04.rar.html
https://rapidgator.net/file/e0e8924b63ceeba0a0d112ee7ae9ae39/TechTFQ-SQL-Course-Beginner-to-Advanced.part05.rar.html
https://rapidgator.net/file/4088949346b86e7937e117a844facaa6/TechTFQ-SQL-Course-Beginner-to-Advanced.part06.rar.html
https://rapidgator.net/file/175bfe2d1e1a17555f66178310be64fc/TechTFQ-SQL-Course-Beginner-to-Advanced.part07.rar.html
https://rapidgator.net/file/b1dc97b7ad629d38b79f19b5c739049f/TechTFQ-SQL-Course-Beginner-to-Advanced.part08.rar.html
https://rapidgator.net/file/32fa5dd01eafdc24451fb3ac059f80e4/TechTFQ-SQL-Course-Beginner-to-Advanced.part09.rar.html
https://rapidgator.net/file/f198524317a0ea255768daa400da856f/TechTFQ-SQL-Course-Beginner-to-Advanced.part10.rar.html
https://rapidgator.net/file/1367aa89fb3a88d5683e75ebc1c10e29/TechTFQ-SQL-Course-Beginner-to-Advanced.part11.rar.html
https://rapidgator.net/file/a3cc7af852119e1fe296bd6efc664b43/TechTFQ-SQL-Course-Beginner-to-Advanced.part12.rar.html
https://rapidgator.net/file/6b0523f94215d2da44e6d28276fad4f8/TechTFQ-SQL-Course-Beginner-to-Advanced.part13.rar.html
https://rapidgator.net/file/178dad784aaf31b6d7d69c14fea35700/TechTFQ-SQL-Course-Beginner-to-Advanced.part14.rar.html
https://rapidgator.net/file/925b79618f81482b7a745694e75e80f0/TechTFQ-SQL-Course-Beginner-to-Advanced.part15.rar.html
https://rapidgator.net/file/dad4d13c9b8e5b39be6ea1fe54c0fddf/TechTFQ-SQL-Course-Beginner-to-Advanced.part16.rar.html
https://rapidgator.net/file/005ca15b5a897ce874a0d115f9f8223c/TechTFQ-SQL-Course-Beginner-to-Advanced.part17.rar.html
https://rapidgator.net/file/28926fce08d54a3c9952efe08e4da170/TechTFQ-SQL-Course-Beginner-to-Advanced.part18.rar.html
https://rapidgator.net/file/edb6116f601219ca21bfa600b8eefe3c/TechTFQ-SQL-Course-Beginner-to-Advanced.part19.rar.html
https://rapidgator.net/file/24333fd1e5c1426490c2ea5d46c12840/TechTFQ-SQL-Course-Beginner-to-Advanced.part20.rar.html
https://rapidgator.net/file/7aa33fd9c62b514ab99780789c77f793/TechTFQ-SQL-Course-Beginner-to-Advanced.part21.rar.html
https://rapidgator.net/file/7521590055d790822fe50dabd8d10580/TechTFQ-SQL-Course-Beginner-to-Advanced.part22.rar.html
https://rapidgator.net/file/11f18b2bd1b111e4bb05d2c6ef38dea0/TechTFQ-SQL-Course-Beginner-to-Advanced.part23.rar.html
https://rapidgator.net/file/f4d1909c55b7992f343225993f1de4c9/TechTFQ-SQL-Course-Beginner-to-Advanced.part24.rar.html
https://rapidgator.net/file/76f9118d8d75de494e3429a12a7a0335/TechTFQ-SQL-Course-Beginner-to-Advanced.part25.rar.html
https://rapidgator.net/file/5117ebbd2e81bab82fb56484e855d211/TechTFQ-SQL-Course-Beginner-to-Advanced.part26.rar.html
https://rapidgator.net/file/3b2846d2ea072081f8dca8299eab9cb3/TechTFQ-SQL-Course-Beginner-to-Advanced.part27.rar.html
https://rapidgator.net/file/349c110f8e630e5cbc3b84a2a1a417a0/TechTFQ-SQL-Course-Beginner-to-Advanced.part28.rar.html
https://rapidgator.net/file/6162087bd1b12dc88459809c612c7486/TechTFQ-SQL-Course-Beginner-to-Advanced.part29.rar.html
https://rapidgator.net/file/082abb5014142be566740930231826e9/TechTFQ-SQL-Course-Beginner-to-Advanced.part30.rar.html
https://rapidgator.net/file/1dfbf80da6896af925f96b163369555d/TechTFQ-SQL-Course-Beginner-to-Advanced.part31.rar.html
https://rapidgator.net/file/6dcf3c4c9be8a2fb287ed4701d899a55/TechTFQ-SQL-Course-Beginner-to-Advanced.part32.rar.html
https://rapidgator.net/file/0b5b225c5297f1cdd72fb64aff43518c/TechTFQ-SQL-Course-Beginner-to-Advanced.part33.rar.html
Code:
https://nitroflare.com/view/DE3866E1C814388/TechTFQ-SQL-Course-Beginner-to-Advanced.part01.rar
https://nitroflare.com/view/EDB6DD09057E774/TechTFQ-SQL-Course-Beginner-to-Advanced.part02.rar
https://nitroflare.com/view/D10B743167BFB4A/TechTFQ-SQL-Course-Beginner-to-Advanced.part03.rar
https://nitroflare.com/view/BD4D88514D781F2/TechTFQ-SQL-Course-Beginner-to-Advanced.part04.rar
https://nitroflare.com/view/780488091DFC9EB/TechTFQ-SQL-Course-Beginner-to-Advanced.part05.rar
https://nitroflare.com/view/3282249679E3CA1/TechTFQ-SQL-Course-Beginner-to-Advanced.part06.rar
https://nitroflare.com/view/8FB9192FCAE0E8F/TechTFQ-SQL-Course-Beginner-to-Advanced.part07.rar
https://nitroflare.com/view/4F5FED0DA5F7F8A/TechTFQ-SQL-Course-Beginner-to-Advanced.part08.rar
https://nitroflare.com/view/AE72A3E1119DE02/TechTFQ-SQL-Course-Beginner-to-Advanced.part09.rar
https://nitroflare.com/view/92BD771B08B9187/TechTFQ-SQL-Course-Beginner-to-Advanced.part10.rar
https://nitroflare.com/view/E3F95BA510A9D85/TechTFQ-SQL-Course-Beginner-to-Advanced.part11.rar
https://nitroflare.com/view/91BB95F89CB46EF/TechTFQ-SQL-Course-Beginner-to-Advanced.part12.rar
https://nitroflare.com/view/CF14CD6871C27D6/TechTFQ-SQL-Course-Beginner-to-Advanced.part13.rar
https://nitroflare.com/view/DDBC1EB1F38D94D/TechTFQ-SQL-Course-Beginner-to-Advanced.part14.rar
https://nitroflare.com/view/37AC4774EA6AB70/TechTFQ-SQL-Course-Beginner-to-Advanced.part15.rar
https://nitroflare.com/view/64B7D2167064D0B/TechTFQ-SQL-Course-Beginner-to-Advanced.part16.rar
https://nitroflare.com/view/A34F1140DFC26AE/TechTFQ-SQL-Course-Beginner-to-Advanced.part17.rar
https://nitroflare.com/view/086E186F3675292/TechTFQ-SQL-Course-Beginner-to-Advanced.part18.rar
https://nitroflare.com/view/119D564021BE243/TechTFQ-SQL-Course-Beginner-to-Advanced.part19.rar
https://nitroflare.com/view/ABC989049BFFB9B/TechTFQ-SQL-Course-Beginner-to-Advanced.part20.rar
https://nitroflare.com/view/294C601226EAD7F/TechTFQ-SQL-Course-Beginner-to-Advanced.part21.rar
https://nitroflare.com/view/75DB013BEA07022/TechTFQ-SQL-Course-Beginner-to-Advanced.part22.rar
https://nitroflare.com/view/B07C7E29807BB5F/TechTFQ-SQL-Course-Beginner-to-Advanced.part23.rar
https://nitroflare.com/view/3A5CA3695138AF6/TechTFQ-SQL-Course-Beginner-to-Advanced.part24.rar
https://nitroflare.com/view/D54043DAC2E4783/TechTFQ-SQL-Course-Beginner-to-Advanced.part25.rar
https://nitroflare.com/view/0B3B6927F3BAD91/TechTFQ-SQL-Course-Beginner-to-Advanced.part26.rar
https://nitroflare.com/view/00272F4154C00A1/TechTFQ-SQL-Course-Beginner-to-Advanced.part27.rar
https://nitroflare.com/view/9FDE92AF22FE300/TechTFQ-SQL-Course-Beginner-to-Advanced.part28.rar
https://nitroflare.com/view/DB699CE7107804F/TechTFQ-SQL-Course-Beginner-to-Advanced.part29.rar
https://nitroflare.com/view/90928A9E7E6E3ED/TechTFQ-SQL-Course-Beginner-to-Advanced.part30.rar
https://nitroflare.com/view/D416306E361F491/TechTFQ-SQL-Course-Beginner-to-Advanced.part31.rar
https://nitroflare.com/view/9D31115846C470A/TechTFQ-SQL-Course-Beginner-to-Advanced.part32.rar
https://nitroflare.com/view/EB2C2B4920C481C/TechTFQ-SQL-Course-Beginner-to-Advanced.part33.rar
Code:
https://forms.gle/e557HbjJ5vatekDV9