Ch 1: DATABASE INTRODUCTION

• Databases Introduction & Purpose
• Database Types : OLTP, DWH, OLAP
• Microsoft SQL Server Advantages, Use
• SQL Server Components and Usage
• Microsoft SQL Server - Career Options
• Developer, DBA, Data Engineer
• Data Analyst, Data Scientist Careers

• SQL : Purpose, Real-time Usage Options
• SQL Versus Microsoft T-SQL [MSSQL]
• Course Plan, Real-time Project, Resume
• 24 x 7 Online Lab for Remote DB Access
• Versions and Editions of SQL Server
• SQL Server Pre-requisites : S/W, H/W
• System Configuration Checker Tool

Ch 5: SQL Basics - 3, TSQL INTRO

• Database Objects : Tables and Schemas
• Schemas : Group Tables in Database
• Schemas : Security Management Object
• Creating Schemas & Batch Concept
• Using Schemas for Table Creation
• Data Storage in Tables with Schemas
• Data Retrieval & Usage with Schemas

• Table Migrations across Schemas
• Import and Export Wizard in SSMS
• Data Imports with Excel File Data
• Performing Bulk Operations in SSMS
• Temporary Tables : Real-time Use
• Local and Global Temporary Tables
• # and ## Prefix, Scope of Usage

Ch 9: Functions, Procedures Basics

• Functions with SQL Server, TSQL
• Scalar, Inline, Table Functions
• Variables: Declare, Real-time Use
• Creating, Executing Functions
• Functions for Computations
• Functions for Parameterized Joins
• Procedures: Usage in Real-time

• Using Parameters in SQL Server
• Parameterized Joins in TSQL
• Compilation with Stored Procedures
• sp_help, sp_helptext, sp_helpindex
• sp_helpdb, sp_rename, sp_recompile
• System Views For Metadata Audits
• DBID, DBName, ObjectID, ObjectName

Ch 2: SQL SERVER INSTALLATION

• SQL Server & SSMS Installation Plan
• SQL Server Pre-requisites : S/W, H/W
• SQL Server 2022 & 2019 Installation
• Database Engine Feature, OLTP
• Instances : Types and Properties
• Default Instance, Named Instances
• Service and Service Account Use

• Authentication Modes and Logins
• Windows Logins and SQL Logins
• SQL Server Management Studio
• Server Connections with SSMS Tool
• Local and Remote Connections
• System Databases: Master and Model
• MSDB, TempDB, Resource Databases

Ch 6: Constraints, Index Basics

• Constraints and Keys - Data Integrity
• NULL, NOT NULL Property on Tables
• UNIQUE KEY Constraints: Importance
• PRIMARY KEY Constraint: Importance
• FOREIGN KEY Constraint: Importance
• REFERENCES, CHECK & DEFAULT
• Candidate Keys and Identity Property

• Database Diagrams and ER Models
• Relationships Verification and Links
• Indexes : Basic Types and Creation
• Index Sorting and Search Advantages
• Clustered and NonClustered Indexes
• Primary Key and Unique Key Indexes
• Need for Indexes - working with Keys

Ch 10: TRIGGERS & TRANSACTIONS

• Triggers - Purpose, Real-world Usage
• FOR/AFTER Triggers - Real time Use
• INSTEAD OF Triggers - Real time Use
• INSERTED, DELETED Memory Tables
• Using Triggers for Data Replication
• Enable Triggers and Disable Triggers
• Database Level, Server Level Triggers

• Transactions : Types, ACID Properties
• Transaction Types and AutoCommit
• EXPLICIT & IMPLICIT Transactions
• COMMIT and ROLLBACK Statements
• Batch Concept and Go Statement
• Open Transactions in Real-time
• Using Conditional Commits, Rollbacks

Ch 3: SSMS Tool, SQL BASICS - 1

• Creating Databases: Files [MDF, LDF]
• Creating Tables in User Interface
• Data Insertion & Report in User Interface
• SQL : Purpose and Real-time Usage
• SQL Versus T-SQL : Basic Differences
• DDL, DML, SELECT, DCL and TCL
• Creating SSMS Sessions : SPID

• Create, Connect Databases using SQL
• Creating Tables with INT, CHAR
• Data Storage, Inserts - Basic Level
• Table Data Verifications with Select
• SELECT Statement for Table Retrieval
• Identify Databases and Tables
• Identify Sessions and Session ID

Ch 7: Joins Basics, TSQL Queries

• JOINS - Table Comparisons Queries
• INNER JOINS For Matching Data
• OUTER JOINS For (non) Match Data
• Join Queries with "ON" Conditions
• Left Outer Joins - Example Queries
• Right Outer Joins - Example Queries
• FULL Outer Joins: Realtime Scenarios

• CROSS JOIN and CROSS APPLY
• One-way, Two way Data Comparisons
• Using Table Aliases & Column Aliases
• Optimizing Join Queries with Indexes
• Choosing Correct Comparison Columns
• Joining Unrelated Tables in TSQL
• Self References, Self Joins in TSQL

Ch 11:  Normal Forms, Cursors

• First Normal Form and Atomicity
• Third Normal Form and MVD Property
• Boycee-Codd Normal Form : BNCF
• Fourth Normal Form : Advantages
• Self Reference Keys and 4 NF Usage
• 1:1, 1:M, M:1, M:M Relationship Types
• Linked Servers Configurations, RPC

• Linked Servers, Remote Joins in TSQL
• 2 Part, 3 Part, 4 Part Naming Styles
• Remote Joins Queries and Aliases
• Cursors - Basics, Data Operations
• Cursors - Life Cycle & Declaration
• Cursors Types, FETCH Operations
• Cursors - Deallocate, Real-world Use

Ch 4: SQL BASICS - 2

• Creating Tables: VARCHAR, FLOAT
• Single Row Inserts, Multi Row Inserts
• Rules for Data Insertion Statements
• SELECT with WHERE Conditions
• AND and OR Operators Usage
• IN Operator and NOT IN Operator
• Between, Not Between Operators

• LIKE and NOT LIKE Operators
• ORDER BY, TOP & OFFSET
• Basic Sub Queries with SELECT
• UPDATE Statement & Conditions
• DELETE & TRUNCATE Statements
• ALTER, ADD COLUMN Statements
• DROP Statements: Table, Database

Ch 8: Group By in TSQL, Views Basics

• GROUP BY: Importance, Realtime Use
• GROUP BY Queries and Aggregations
• Group By Queries with Having Clause
• Group By Queries with Where Clause
• Using WHERE and HAVING in T-SQL
• Group By with Joins in TSQL
• Query Execution Order & Aliases

• Joins with Sub Queries, Formatting
• Database Objects: Overview & Usage
• Views: Types, Usage in Real-time
• Creating, Executing & Verifying Views
• Storing Queries in Database Views
• Excel Analytics - Joins & Views
• Excel Office Data Connection Reports

Ch 12: TSQL Queries, SQL Analytics

• IIF() Function with SELECT Query
• WHEN..THEN..ELSE
• WHEN MATCHED, NOT MATCHED
• Incremental Loads, Upsert Statement
• Stored Procedures: Merge Statement
• UNION and UNION ALL Operator
• Window Functions: Rank, Dense Rank

• Row_Number, PartitionBy in TSQL
• Duplicate Row Identification, Deletion
• Grouping, Cube, Rollup, Lag, Lead
• Data Types: Numerical, Date, Time
• Data Types: Characters, Real, Float
• Date & Time Functions, DateAdd
• String Functions, Concat, SubString

Ch 1 : TABLEAU INTRO, INSTALLATION

• Introduction to Tableau, Reporting Tools
• Report Types in Real-time: Interactive
• Paginated, Analytical and Mobile Reports
• Data Sources for Report Design Process
• Databases & Types: OLTP, DWH, OLAP
• Tableau : Basic Understanding, Workflow
• Tableau as a Self Service BI Tool
• Tableau Features, Technical Advantages

• Tableau Public Desktop : Installation
• Development, Production and Access
• Data Sources Types in Tableau
• Tableau Prep Tools - Data Modelling
• Power BI Licensing Plans - Types
• Tableau Training : Course Plan, Lab
• Study Material, Certifications, FAQs

Ch 7 : TABLEAU VIZ - LEVEL 1

• Tableau Visualizations - Types
• Visualization Categories, Usage
• Tableau Bar Charts and Types
• Simple Bar Charts and Usage
• Horizontal & Colored Bar Charts
• Stacked Bar Charts, Measures
• Side By Side Bar Charts and Use
• Interactive Bar Charts & Filters

• Line Charts and Data Points
• Continous Line Charts and Usage
• Discrete Line Charts and Usage
• Dual Line Chart and Types
• Area Charts : Discrete, Continous
• Stacked Area Charts, Reports
• Combine Area Charts & Line Charts

Ch 13 : DASHBOARDS & STORIES

• Dashboards and Stories in Tableau
• Bulding Dashboards - Views, Sheets
• Dashboard Size, Views, Objects
• Legends and Quick Filters in Tableau
• Tiles, Floating Layouts in Tableau
• Layout Containers, Images, Web Pages
• Dashboard Extensions, Management
• API Extensions - Usage in Tableau
• Device Designer - Default Layout
• Adding and Customizing Layouts
• Story Points - Creation and Updates
• Bollinger Bands - Views, Summary
• Data Cleansing - Bulk Re-aliasing
• Tableau Prep : Installation ETL
• Tableau Desktop Store, Server Store

Ch 2: BASIC REPORTS, GROUPING

• Tableau Public Desktop : Installation
• Tableau Workbook Creation, Data Sources
• Tableau Worksheets : Creation, Options
• Row Shelf & Column Shelf, Details View
• Marks : Text, Detail, Tooltip, Colors
• VizQL : Vizualization Query Language
• Tableau In-Memory Database Usage
• Dimensions, Measures Identification

• Working with Data Sources, WorkBooks
• Worksheets, Marks, Shelves, Axis
• Basic Report Design Terminology
• Grouping : Data Categorization
• Creating Groups on Static Data
• Dynamic Data Grouping, Binnig
• Hierarchies: Creation, Real-time Use
• Drilldown Reports in Tableau

Ch 8 : TABLEAU VIZ - LEVEL 2

• Tableau Pie Charts, Real-time Use
• Simple Pie Charts - Examples
• Stacked Pie Charts - Examples
• Side By Side Pie Charts
• Reverse Rows and Row Count
• Donut Charts and Agle Properties
• Inner / Outer Pie Charts, Stacking
• Drill-down Pie Charts and Usage

• CrossTab Charts and Text Properties
• Rows, Columns and Marks : Text
• Conditional Formatting, Divergence
• Using Quick Claculations in Tableau
• Highlight Tables and Color Palettes
• Box & Wishker Plots - Text Tables
• Heat Maps and Real-time Usage
• Size Controls and Color Options

Ch 14 : TABLEAU SERVER

• Tableau Server - Architecture
• Tableau Server - Installation Process
• Publish Tableau Workbook, Verify
• Sharing Options and Layouts
• Adding Device Layouts in Tableu Server
• Adding Custom Layouts in Tableau Server
• Adding Content to Custom Layouts
• Java Script API in Table Server
• Tableau Online Versus Table Server
• Security Advantages @ Tableau Server
• Tableau Online - Architecture
• Publish Tableau Workbook, Verify
• Sharing Options and Layouts
• Adding Device Layouts in Tableu Online
• Adding Custom Layouts in Tableau Online
• Adding Content to Custom Layouts
• Security Advantages @ Tableau Online

Ch 3 : TABLEAU ARCHITECTURE, JOINS

• Data Sources, Connectors, Clients
• Tableau Server Components and Use
• Application Server and Repository
• VizQL Server and Data Engine
• Backgrounder, Data Server, Search
• Fast Data Engine, Gateway Components
• Alias, Bins, Bookmarks, Calcualtions

• Tableau File Types and Workbooks
• CrossTabs, Dashboards, Data Pane
• Data Source Page and Dimensions
• Extract, Filters, Pages, Rows, Columns
• Visual Sync Limitations with Slicer
• Level of Detail, Sets, Marks, Workbooks
• Using Joins in Tableau Sources
• Inner, Left / Right Outer Joins

Ch 9 : TABLEAU VIZ - LEVEL 3

• Tableau Treemaps & Nested Rectangles
• Marks Type, Color, Size and Label
• Comparing Treemaps with Bars & Tables
• Circle View Vizualization and Usage
• Side By Side Circle View, Usage
• Scatter Plot - Labels, Axis Items
• Packed Bubbles and Circles - Lables

• Tableau Symbol Maps - Examples
• Tableau Filled Maps - Examples
• Using Quick Table Calculations
• Histogram Charts and Properties
• Measures and Value Comparisions
• Tableau Motion Charts and Axis
• Bullet Graphs and Limitations
• Dimension - Measure Considerations

Ch 15 : Colloborate TABLEAU ONLINE

• Tableau Online - Purpose, LIVE Reports
• Projects and Workbooks in Tableau Online
• Tableau Report Views in Tableau Online
• Searching Content, Data Sources, Sites
• Account Settings, Drill Down, Actions
• Custom Views, Comments - Tableau Online
• Downloads, Exports - Tableau Online
• Sharing, Subscription and favorites
• Web Authoring, Edits and Publish Online
• Data Driven Alerts - Refining, Managing
• Stacked Bars and Views For Alerting
• Navigations, Snapshots, Searching
• Mobile Reports - Phone Marks and Maps
• Interacting with Content on Tableau Online

Ch 4 : BIG DATA ACCESS, BLENDING

• Azure Data Access with Tableau
• Remote Data Sources and Joins
• Using SQL Queries in Tableau
• Use Azure SQL Warehouse (DWH)
• Data Blending Options in Tableau
• Working with Multiple Data Sources
• Data Combinations & Aggregations
• Show Data & Data Grouping Options

• Tableau Operators and Types
• Tableau Functions and Real-time Use
• Tableau Calculations and Formats
• Numerical Calculatins & Examples
• Aggregated Calculations in Tableau
• Creating Calculations From Shelfs
• Calculation Edits, Identifications

Ch 10 : TABLEAU FILTERS

• Tableau Filters - Types & Usage
• Extract Filters and TDE (hyper)
• Data Source Filters (twb Files)
• String and Numerical Data Fields
• Date/ Time Data Fields, Usage
• All Rows, Too & Bottom Rows
• Aggregated Extracts and Usage
• Extract History, TDE Files

• Context Fitlers and Realtime Use
• Context Filters: Performance Benefit
• Dimension Filters & Limitations
• Measure Filters and Aggregations
• Measure Name Filters, Measure Values
• Table Calculation Filters, Usage
• Tableau Filters - Execution Order
• Fiters Scope and Quick Filters

Ch 16: Colloborate TABLEAU SERVER

• Tableau Server - Purpose, LIVE Reports
• Projects, Workbooks in Tableau Server
• Tableau Report Views in Tableau Server
• Searching Content, Data Sources, Sites
• Account Settings, Drill Down, Actions
• Custom Views, Comments in Tableau Server
• Downloads and Exports in Tableau Server
• Sharing, Subscription and favorites
• Web Authoring, Edits and Publish Online
• Data Driven Alerts - Refining, Managing
• Stacked Bars, Alerting Views in Server
• Navigations, Snapshots, Searching in Server
• Mobile Reports - Phone Marks and Maps
• Interacting with Content on Tableau Server

Ch 5 : STRING, DATE FUNCTIONS

• String Functions in Tableau
• ASCII, CHAR, LEN, ENDSWITH
• FIND, FINDNTH, LEFT, CONTAINS
• LOWER, UPPER, LTRIM, RTRIM
• MID, MIN, REPLACE, RIGHT
• SPACE, SPLIT, UPPER, MAX

• STARTSWITH, AND, CASE
• ELSE, ELSEIF, END, IF, IIF
• IFNULL, ISDATE, ISNULL, MAX
• MIN, NOT, OR, THEN, WHEN, ZN
• DATEADD, DATEDIFF, DATENAME
• DATEPART, DATETRUNC, DAY
• ISDATE, MAKEDATE, MONTH
• NOW, QUARTER, TODAY, YEAR

Ch 11 : PARAMETERS, SETS

• Tableau Parameters - Working
• Creating Parameters, Conditions
• Linking Parameters to Calculations
• Using Calculations in Fields/View
• Dynamic Filters using Parameters
• Dynamic Dimension using Parameters
• Dynamic Measures using Parameters

• Creating, Using Sets in Tableau
• IN and OUT Concepts in Sets
• Working with Filters and Sets
• Show Set Options and Exclude
• Comparing Tableau Sets & Groups
• Comparing Tableau Sets & Hierarchies
• Dynamic Sets : Creation & Usage

Ch 17 : MANAGE TABLEAU SERVER

• Tableau Server - Administration Concepts
• Tableau Sites, Users, Groups Security
• Group Rules, Web Edits in Tableau Server
• Project Permission and Locking Options
• Data Security with user Filters in Server
• user Filters and Hybrid Models in Server
• Access Roles, Schedules, Extraction
• TSM : Tableau Services Manager
• TSM Configuration for Real-time Use
• Browser, Maintenance, GUI and CLI
• Backups and Restores with Tableau TSM
• TSM Upgrades For Tableau Report Config
• Tabcmd : Command Line Utility - Imports
• Tabcmd : user Import via CSV File
• Comparing Tableau & Microsoft Power BI

Ch 6 : TABLE, LOD CALCULATIONS

• Calcualtions For Year, Quarter, Month
• Custom Calculations, Data Appending
• Custom Date and Time Formatting
• Calculations Reuse and Edits
• Date and Time Conversions To INT
• Two Digit Conversions with Date
• Table Functions with Tableau
• Running Total and Row Number
• Case Statements, FIRST, LOOKUP

• Table Calculations, Level of Details
• Real-time Use of Table Calculations
• Partitioning, Addressing Benefits
• LOD : Types of Level Of Detail
• FIXED LOD Expressions - Examples
• INCLUDE LOD Expressions - Examples
• EXCLUDE LOD Expressions - Examples

Ch 12 : TABLEAU FORECASTS, ACTIONS

• Tableau Trend Lines and Usage
• Reference Lines and Show Data
• Forecasts, Exponential Smooting
• Creating and Using Forecasts
• Describing, Controlling Forecasts
• Adding / Editing Bookmarks
• Using Data Analytics in Tableau

• Tableau Actions and Real-time Use
• Tableau Action Types, Limitations
• Filter Actions: Static/Dynamic
• Highlight Actions, Dynamic Types
• URL and Parameter Action Types
• Set Actions, Runtime Actions
• Tableau Actions & Dashboards
• Use Field and Filter Actions

• Project Requirement Analysis
• Implementing SDLC Phases
• Requirement Gathering, FSA

• TABLEAU Report Design
• Visualizations, Properties
• Analytics and Formating

• Data Modeling, Tableau Prep
• Dynamic Connections, Azure DB
• Parameters and VizQL Scripts

• Tableau Online Analysis
• Cloud and Tableau Server
• Project FAQs and Solutions