Data A&E Essentials

-

 SQL Server Index/Topics:

  • Introduction to SQL Server
  • SQL Server Overview
  • Structured Query Language (SQL)
  • Databases
  • Tables
    • Create, Alter, Rename, Temp, Derieved)
  • Data Types
  • SQL Basic Commands 
    • (DML, DDL, TCL, INSERT, TRUNCATE, PIVOT, MERGE, CASE, CTE)
  • Constraints
    • (PK, FK, CHECK, DEF, UNIQUE)
  • Joins
  • Subqueries
  • Built in Functions
  • Operators
  • Decision Making Statements
  • Views
  • Indexes
    • CLUSTERED, NON-CLUSTERED, FILTERED)
  • Advanced SQL:
    • Table Partitions
    • Try Catch errors
    • Views
    • T-SQL Programming
    • Stored Procedures
    • Triggers
    • User Defined Functions
    • Cursors
  • Advanced SQL Functions:
    • Aggregate Functions
    • String Functions
    • Date functions
    • system methods
    • Ranking Functions
    • Logical Functions
    • Analytics functions
    • Conversion functions
  • Normalization
  • Transactions (Optional)
  • Locks (Optional)
  • Rules and Defaults (Optional)
  • Backup and Recovery

Case Study
Examples for Practice
Interview Preparation tips and prac



Cloud Technologies:

  • Azure Cloud
    • Basics:
      • Introduction to Azure Cloud
      • Services Available
      • Subscription, resource group
    • Technologies/Services:
      • Azure SQL Server
      • Azure Data Factory
      • Azure Analysis Services
      • Azure Blob Storage
      • Azure Logic Apps
      • Azure Functions
      • Azure Key Vaults
      • Azure Data Bricks (PySpark)


Reporting Tools:

  • Power BI
    • Power BI Desktop
    • Power BI service

    

Programming Languages:

  • Python


Comments

Post a Comment

Popular posts from this blog

SyBase Database Migration to SQL Server

-
  Sybase ASC vs. Sybase Database – What’s the Difference? 1. Sybase Database (General Term) "Sybase database" is a generic term that refers to any database system developed by Sybase, Inc. Over the years, Sybase has created several database products, including: Sybase ASE (Adaptive Server Enterprise) – the most well-known, high-performance relational database. Sybase ASA (Adaptive Server Anywhere) – designed for mobile and embedded systems (later became SQL Anywhere ). Sybase IQ – a column-based database for analytics and reporting. Sybase Replication Server , etc. So, when someone says "Sybase database" , they could be referring to any of these products. 2. Sybase ASC (Adaptive Server Cluster Edition) Sybase ASC is a specific edition of Sybase ASE (Adaptive Server Enterprise) designed to support database clustering . It allows multiple ASE instances to work together as a single clustered database system . Designed for high avail...
Read more

Basics of US Healthcare -Medical Billing

-
 In this blog I will be sharing the basics Terminology used in the Healthcare as this will help us to understand the healthcare in more detail. Basics of US Healthcare  Basic Terms: Patient :  The Person who visits doctor for any kind of counselling, wellness check-up or to get treated for symptom of an illness. Provider:    Doctor who provides treatment  to the patient and charge to their insurance company for payments Payer:  The Insurance company whoh covers the patient for any disease or illness and pay to the doctor when a claim arise. Guarantor/Subscriber :    The person who has the insurance policy is guarantor/subscriber. A patient visiting a Doctor may be covered under someone's policy ex. a child, spouse under husbands policy. Practice:  A place where services are performed. sometimes it is same as the name of the clinic or Hospital. Patient Demographic Information: Some Specific information that needed to create patients ...
Read more