Transcription
Transact-SQL Querying - Fast TrackCourse TitleTransact-SQL Querying - Fast TrackInstructorAmit R S BansalTotal Duration6 hrs 40 minsTotal Lecture Time2 hrs 10 minsTotal Demo Time4 hrs 30 mins (Yeah, demos are the real value )Delivery FormatVideo Course. Stream anywhere, anytime, any device, as many times.Course Description
If you work with SQL Server, querying data using T-SQL is certainly an integral part of your work.Irrespective of your role - Developer, Database Administrator, Data Architect, Data Analyst, BusinessIntelligence, Data Scientist, or just a power user – T-SQL querying skills are critical for you to besuccessful. This video course gives you a strong foundational skill with T-SQL querying and loads ofpractical examples that you can start using right away. You will learn about T-SQL language elements,logical flow, Query Optimizer, all the types of logical and physical joins, apply operator, set operators,sub-queries, tables expressions, ranking functions, aggregations and pivoting. Yes, very comprehensivecoverage in a fast-track mode, packed with loads of real-world demos. Along the way, you will learnabout a few T-SQL enhancements in different versions of SQL Server. Wherever relevant, query tuningis discussed with examples. At the end of the course, you will be able to write accurate andperformant T-SQL code.Pre-RequisiteJust basic experience with SQL Server.Course OutlineModule 0: Introduction Before You Begin Modules Demo Setup What Not To Expect What To Expect How To Get The Best Out Of This CourseModule 1: Introduction To T-SQL Querying Historical Information Logical Flow of a SELECT Statement T-SQL Language Elements TOP Clause Query Optimizer Basics Understanding Execution Plans TRUE, FALSE & UNKNOWN Demos
SummaryModule 2: Joins CROSS Join INNER Join OUTER Joins Other Join Types Physical Join Types APPLY Operator Demos SummaryModule 3: Set Operators UNION UNION ALL INTERSECT EXCEPT Caveats Demos SummaryModule 4: Subqueries IntroductionTypes of SubqueriesClassificationLimitations / Side EffectsDemosSummaryModule 5: Table Expressions Derived Tables Common Table Expressions Demos
SummaryModule 6: Ranking Functions ROW NUMBER RANK DENSE RANK NTILE Caveats DemosModule 7: Aggregations OVER Clause Running Aggregations CUBE and ROLLUP Grouping Sets Grouping ID Demos SummaryModule 8: Pivoting PIVOT UNPIVOT Demos SummaryModule 9: Wrap UpLearn More: http://bit.ly/SQLMaestrosVC
Course TitleTransact-SQL Querying - Fast TrackModule NamesModule 0: IntroductionContent TypeDuration (mm:ss:00)LectureFull ModuleLectureBefore You Begin The Intro & AgendaHistorical InformationLogical Flow of a SELECT StatementDemos: Logical Flow of a SELECT StatementT-SQL Language ElementsTOP ClauseDemos: Working with TOP ClauseQuery Optimizer BasicsUnderstanding Execution PlansDemos: Query Optimizer BasicsDemos: Understanding Execution PlansTRUE, FALSE & UNKNOWNDemos: TRUE, FALSE & UNKNOWNSummaryTotal Duration11:44:00Before You Begin The Demos7:42:00Module 1: Introduction To 014:48:004:40:009:09:002:03:0074:38:00Module 2: JoinsLectureLectureLectureLectureIntro & AgendaCross JoinInner JoinInner Join with NULLsOuter Join (LEFT, RIGHT, FULL)Other Join TypesPhysical Join TypesNested Loop Join4:04:005:33:006:00:002:59:00
l Join TypesMerge JoinPhysical Join TypesHash JoinCaveatsAPPLY OperatorDemos: Cross JoinDemos: Inner & Outer JoinDemos: APPLY OperatorSummaryTotal :0081:04:00Intro & AgendaUNIONUNION ALLINTERSECTEXCEPTCaveatsDemos: SET OperatorsSummaryTotal Duration10:45:0018:02:000:54:0029:41:00Intro & AgendaTypes of SubqueriesClassificationsLimitations / Side EffectsDemos: Scalar SubqueriesDemos: Correlated SubqueriesSummaryTotal :00Module 3: Set OperatorsLectureDemosLectureModule 4: SubqueriesLectureDemosLectureModule 5: Table ExpressionsLectureIntro & AgendaDervied TablesCommon Table Expressions4:32:00
DemosLectureDemos: Derived Tables & Common TableExpressionsSummaryTotal Duration26:11:000:47:0031:30:00Intro & AgendaROW NUMBERRANKDENSE RANKNTILECaveatsDemos: Ranking FunctionsSummaryTotal Duration8:29:0027:01:001:00:0036:30:00Intro & AgendaOver ClauseRunning AggregationsCUBE and ROLLUPGrouping SetsGrouping IDDemos: OVER ClauseDemos: CUBE & ROLLUPDemos: Grouping Sets & Grouping IDDemos: Cumulative AggregationsSummaryTotal 5:0063:12:00Intro & AgendaPivotingUnpivotingDemos: Pivoting & UnpivotingSummaryTotal Duration3:32:0012:57:000:59:0017:28:00Module 6: Ranking FunctionsLectureDemosLectureModule 7: le 8: PivotingLectureDemosLecture
Module 9: Wrap UpLectureFull ModuleTotal Course Duration (MM:SS:00)Total Course Duration (HH:MM:SS)Total Lecture TimeTotal Demo TimeYeah, demos are the real value !2:21:00399:54:006 hrs 40 mins2 hrs 10 mins4 hrs 30 mins
about a few T-SQL enhancements in different versions of SQL Server. Wherever relevant, query tuning is discussed with examples. At the end of the course, you will be able to write accurate and performant T-SQL code. Pre-Requisite Just basic experience with SQL Server. Course Outline Module 0: Introduction Before You .
