SQL DB

Course Instructor

FREE

Course Overview

Schedule of Classes

Course Curriculum

1 Subject

SQL DB

123 Exercises • 231 Learning Materials

Assignments

Select query assignment

Assignment

Oracle function assement

Assignment

Exam Questions

Assignment

SQL INTERVIEW ASSIGNMENT

Assignment

Teaching material

Collections

PPT

SQL basics

PDF

SQL interview model answer

PDF

SQL NOTES

PDF

SQL INTERVIEW PREPARATION

PDF

SQL INTERVIEW QUETION ANSWER PREPARATION

PDF

SQL NOTES

PDF

SQL PREPARATION

PDF

Test

Subquery Test

Assignment

SQL BATCH 1 TEST

Assignment

Concatenate,Savepoint,Time,Sub queries,Views clause,Between,Curd operations

Exercise

Aptitude Test 2

Exercise

Blood Relation

Exercise

SQL BATCH 1/2/3 ADVANCED QUERIES TEST 1

Exercise

Letter & Symbol Series.

Exercise

SQL 4 BASIC&JOINS

Exercise

Simplification (20/01/2024)

Exercise

Direction Test (03/02/2024)

Exercise

SQL 4 BASIC COMMANDS

Exercise

Syllogism(10/02/2024)

Exercise

SQL 1,2,3 SUBQUERY

Exercise

SQL 4 DDL DML TCL

Exercise

SQL 1,2,3 ALL CONCEPTS TEST1

Exercise

Seating Arrangement(17/02/2024)

Exercise

Permutations and Combinations (02/03/2024)

Exercise

SQL 1,2,3 ALL CONCEPTS TEST 2 (2 March)

Exercise

Ranking and Order(09/03/2024)

Exercise

SQL -PLSQL (9/3/2024)

Exercise

Coding and Decoding(16/03/2024)

Exercise

SQL-ETL Test (16/3/2024)

Exercise

SQL 1 2 3 JOINS-Test (13/4/2024)

Exercise

SQL 1 2 3 Builtin func- Test( 4/5/2024)

Exercise

SQL 1 2 3 JOINS- Test ( 11/5/2024)

Exercise

Pattern Completion (11/05/2024)

Exercise

HCF/LCM(18/05/2024)

Exercise

SQL 1 2 3 Abinitio -Test( 18/5/2024)

Exercise

SQL 1 2 3 ETL-Test(1/6/2024)

Exercise

SQL 1 2 3 Unix-Test (8/6/2024)

Exercise

SQL 4 BASIC CLAUSES( 08/06/2024)

Exercise

SQL 1 2 3 Views-Test(15/6/2024)

Exercise

SQL 1 2 3 DWH-Test(21/6/2024)

Exercise

SQL 1 2 3 Func-Test(5/7/2024)

Exercise

SQL - MCQ Test

Interview Questions

SQL interview questions

PDF

Sql 1

Assignment

Reference section

DEMO 1

Video

31:32

SQL Commands Clauses Oracle Install VID1

Video

35:55

SQL Installation and Commands VID2

Video

38:55

Session 2

Video

30:51

session 3

Video

35:13

session 4

Video

38:14

Session 5

Video

29:25

session 6

Video

36:45

SESSION 7

Video

35:4

SESSION 8

Video

38:37

SESSION 9

Video

24:38

SESSION 10

Video

36:59

SESSION 11

Video

39:10

SESSION 12 constraints1

Video

35:7

SESSION 13 constraints2

Video

38:59

SESSION 14 set operators

Video

37:51

SESSION 15 string functions1

Video

33:11

SESSION 16 numeric functions

Video

36:43

SESSION 17 numeric functions2

Video

38:15

SESSION 18 date functions

Video

30:7

SESSION 19 string functions

Video

38:48

SESSION 20 Substr instr

Video

39:17

SESSION 21 SUB-QUERY 1

Video

35:47

SESSION 22 SUBQUERY 2

Video

38:40

SESSION 23 SUBQUERY 3

Video

39:5

SESSION 24 CORELATED SUB QUERY

Video

26:29

SESSION 25 DELETE DUPLICATE RECORDS

Video

16:54

SESSION 26 GROUP BY HAVING

Video

39:6

SESSION 27 Joins 1

Video

37:54

SESSION 28 Joins 2

Video

39:23

SESSION 29 Joins 3

Video

39:12

SESSION 30 Index views 1

Video

36:9

SESSION 31 Index views 2

Video

35:44

SESSION 32 Index views 3

Video

35:22

SESSION 33 merge

Video

37:12

SESSION 34 sql query tunning

Video

37:15

SESSION 35 Index views1

Video

36:9

SESSION 36 Index views2

Video

35:44

SESSION 37 Index views3

Video

35:22

SESSION 38 Configure domain in client

Video

36:28

SESSION 39 First job

Video

34:23

SESSION 40 INFORMATICA CLEINT INSTALLATION

Video

19:54

SESSION 41 Informatica server installation

Video

19:50

SESSION 42 Informatica introduction1 VID 1

Video

28:59

SESSION 43 Informatica introduction 2 VID 2

Video

24:49

SESSION 44 Repository Integration service Creation

Video

35:40

SESSION 45 First Job explanation1

Video

35:34

SESSION 46 First job explanation 2

Video

39:20

SESSION 47

Video

35:51

SESSION 48

Video

36:50

SESSION 49 Expression 2

Video

35:51

SESSION 50 Filter trans

Video

38:39

SESSION 51 Versoning control

Video

35:47

SESSION 52 Router trans

Video

37:34

SESSION 53 Two filters

Video

39:10

SESSION 54 Two pipelines

Video

18:15

SESSION 55 normalizer trans.mp4

Video

1:36:55

SESSION 56 Sorter trans

Video

35:27

SESSION 57 Sorter sequence generator

Video

35:53

SESSION 58 Sequence generator 2

Video

16:6

SESSION 59 rank trans

Video

39:3

SESSION 60 rank sql query.mp4

Video

34:34

SESSION 61 SCENARIOS

Video

23:55

62 Customized SQL

Video

35:6

63 Joiner 1

Video

39:5

64 Joiner 2

Video

19:9

65 Aggregator

Video

36:25

66 union trans

Video

34:33

67 JAVA SOE

Video

38:57

68 distinct duplicate 1.mp4

Video

36:22

69 distinct duplicate 2

Video

38:55

70 UNIT TESTING

Video

27:11

71 DM FLATFILE 1

Video

37:32

72 LIST FILE

Video

29:36

73 Dynamic flatfiles

Video

33:12

74 Table to file 1

Video

36:30

75 Table to file 2

Video

28:20

76 LOOKUP 1

Video

36:52

77 LOOKUP 2

Video

38:12

78 LOOKUP 3

Video

28:7

Abinition_Reference Videos_29/01/2024

BRE and ACE.mp4

Video

31:36

continuous components.mp4

Video

45:41

Latest scenarios.mp4

Video

1:9:51

Metaprogrammoing functions and PDL.mp4

Video

1:21:35

Order of Parameter evaluation.mp4

Video

1:39:57

PLANS.mp4

Video

46:9

PSET and PDL.mp4

Video

1:58:46

RMF and WMF.mp4

Video

1:4:8

Scenarios.mp4

Video

56:32

Session 20 _ Phase and Checkpoint.mp4

Video

1:4:45

Session 23 - Sandbox and EME.mp4

Video

1:20:29

Session 24 - Air Commands.mp4

Video

52:13

Session 31_ Parlleism and Brodcast and replicate_ 26_May_2017.mp4

Video

52:40

Session 32_AbInitio Functions_ 29_May_2017.mp4

Video

1:34:22

Session 35_AbInitio Database components in Detail_ 2_June_2017.mp4

Video

1:44:50

Session27_ Ab Initio Lookup file

Video

1:042

Abinition_Reference Documents_29/01/2024

Abinitio notes very useful.pdf

PDF

Abinitio notes very useful(1).pdf

PDF

Abinitio notes very useful(2).pdf

PDF

Abinitio_ACE.ppt

PPT

AbInitio_Scenarios(1).docx

Audio

AbInitio_Scenarios(2).docx

Audio

AbInitio_Scenarios.docx

Audio

ACE.docx

Audio

adv_dml.ppt

PPT

aphs-7.doc

application/octet-stream

As we know client name BMO is a largest bank in Canada(1).docx

Audio

BEST_SQL_PLSQL_material.doc

Audio

As we know client name BMO is a largest bank in Canada(2).docx

Audio

As we know client name BMO is a largest bank in Canada.docx

Audio

BEST_SQL_PLSQL_material.doc

Audio

BRE_Ruleset.docx

Audio

Continuous_Flows_Reference.pdf

PDF

Data Profiler Guide And Reference.pdf

PDF

Document_BRE.pdf

PDF

e_st (ABInitio).docx

application/octet-stream

FAQ 1(1).doc

Audio

FAQ 1(2).doc

Audio

FAQ 6(1).docx

Audio

FAQ 6(2).docx

Audio

FAQ 7(1).docx

Audio

FAQ 7(2).docx

Audio

FAQ 7.docx

Audio

FAQ 8(1).doc

Audio

FAQ 8(2).doc

Audio

FAQ 8.doc

Audio

FAQ 9.doc

Audio

FAQ 9(1).doc

Audio

FAQ 9(2).doc

Audio

FAQ 10.docx

Audio

FAQ 10(1).docx

Audio

FAQ 10(2).docx

Audio

FAQ 11.docx

Audio

FAQ 11(1).docx

Audio

FAQ 11(2).docx

Audio

FAQ 12.docx

Audio

FAQ 12(1).docx

Audio

FAQ 12(2).docx

Audio

Flow Chart.docx

Audio

Flow Chart(1).docx

Audio

Flow Chart(2).docx

Audio

Graphs-7.doc

Audio

Graphs-7(1).doc

Audio

Graphs-7(2).doc

Audio

Guidelines for AbInitio Performance Tunning.doc

Audio

Guidelines to upload documents - NEw SVS(1).docx

Audio

Guidelines to upload documents - NEw SVS(2).docx

Audio

Guidelines to upload documents - NEw SVS.docx

Audio

M_Commands.pdf

PDF

M_Commands(1).pdf

PDF

M_Commands(2).pdf

PDF

Oracle Queries.pdf

PDF

M_Commands(1).pdf

PDF

M_Commands(2).pdf

PDF

Performence Tuning.pdf

PDF

Performence Tuning(1).pdf

PDF

Performence Tuning(2).pdf

PDF

performence tuning.docx

Audio

Plan_It_06Feb06_1469012209006.pdf

PDF

Project_Xplanation.docx

Audio

Project_Xplanation(1).docx

Audio

Project_Xplanation(2).docx

Audio

Que_st (ABInitio).docx

Audio

Que_st (ABInitio)(1).docx

Audio

Que_st (ABInitio)(2).docx

Audio

Sample_HLD.doc

Audio

Sample_HLD(1).doc

Audio

Sample_HLD(2).doc

Audio

Sample_LLD.doc

Audio

Sample_LLD(1).doc

Audio

Sample_LLD(2).doc

Audio

Sample_Mapping_Document.xls

Audio

Sample_Mapping_Document(1).xls

Audio

Sample_Mapping_Document(2).xls

Audio

we know client name BMO is a largest bank in Canada(1).docx

application/octet-stream

XML_Processing_Guide.pdf

PDF

Unix_Shell_Scripting_exercises1(1).pdf

PDF

PSet_creation_V2.pdf

PDF

Knowledge Sharing - Defect Preventation.pdf

PDF

EME wonders.pdf

PDF

adv_dml.pdf

PDF

Abinitio_ACE.pdf

PDF

FAQ 4.pdf

PDF

Unix_Reference Videos_29/01/2024

Session 16 _ UNIX setup 18_Apr_2017.mp4

Video

54:7

Session 17 _ UNIX commands 19_Apr_2017.mp4

Video

1:7:38

Session 18 _ UNIX commands 21_Apr_2017.mp4

Video

1:18:24

Session 19 _ UNIX commands 28_Apr_2017.mp4

Video

54:23

Session 20 _ UNIX command SED_ 3_May_2017.mp4

Video

57:48

Session20_ Read Multiple files.mp4

Video

56:44

Session 22_ UNIX command FIND_ 5_May_2017.mp4

Video

1:2:11

Session22_ split xml component.mp4

Video

1:22:20

Session 23_ UNIX command AWK_ 7_May_2017.mp4

Video

49:15

Session 24_ UNIX command VI Editor_ 8_May_2017.mp4

Video

59:24

Session 25_ UNIX Shell Scripting_ 15_May_2017.mp4

Video

49:33

Session 26_ UNIX and EME setup_ 16_May_2017.mp4

Video

1:038

Session34_ UNIX env discussions.mp4

Video

1:4:31