DIGIBRAND

WEEKLY UPDATE
EXIT
SEO Plugin by
MicroDegree Program in Data Science with MS SQL – Academy of Data Science

Academy of Data Science

MicroDegree Program in Data Science
with MS SQL

Course Duration

Tools Covered

Learning Mode

We provide

MSSQL Course Content

  1. Introduction to MySQL
  2. What is the MSSQL?
  3. How do I Install MSSQL?
  4. Connecting to the MSSQL
  5.  Creating and Selecting a database
  6.  Adding data to a table
  7. Executing multiple queries
  8. Exporting and Importing data tables.

  1. SQL Syntax
  2. SQL Create Command
  3. SQL Alter Command
  4. SQL Truncate
  5. SQL Delete
  6. SQL Update
  7. SQL Set
  8. SQL Select
  9. SQL Distinct
  10. SQL Where Clause
  11. SQL And & Or
  12. SQL Order By
  13. SQL Insert 
  14.  

  1. Single Row Functions
  2. String Functions, Aggregate Function, Round,
    Truncate, Max, Min, Date-Time Functions
  3. General Functions
  4. Count, Average, Sum etc.

  1. Obtaining data from Multiple Tables
  2. Types of Joins (Inner Join, Left Join, Right Join &
    Full Join)
  3. Sub-Queries Vs. Joins

  1. Distinct, Order by, Group by, Equal to etc. 

  1. Not Null
  2. Unique
  3. Primary Key
  4. Foreign Key

  1. SQL Like
  2. SQL Wildcards
  3. SQL In
  4. SQL Between
  5. SQL Alias
  6. SQL Union/Union All

  1. Data Import Export
  2. Transformations
  3. Variables
  4. Parameters
  5. Containers 

  1. SQL Avg()
  2. SQL Count()
  3. SQL Max()
  4. SQL Min()
  5. SQL Sum()
  6. SQL Group By clause
  7. SQL Having clause

  1. resource group
  2. storage account
  3. Pipeline
  4. Data Factory supports two types of
    activities:
     a) data movement activities
     b) data transformation activities
  5.  activity like(copy activity ,lookup activity ) link service
  6. Integration Runtime
  7. dataset
  8. source
  9.  sink

Power BI Course Content

  1. Overview of BI concepts
  2. Why we need BI?
  3. Introduction to SSBI
  4. SSBI Tools
  5. Why Power BI?
  6. What is Power BI?
  7. Building Blocks of Power BI
  8. Getting started with Power BI Desktop
  9. Get Power BI Tools
  10. Introduction to Tools and Terminology
  11. Dashboard in Minutes
  12. Refreshing Power BI Service Data
  13. Interacting with your Dashboards
  14. Sharing Dashboards and Reports

  1. Power BI Desktop
  2. Power BI Dashboards
  3. Power BI Q & A
  4. Extracting data from various sources
  5. Workspaces in Power BI
  6. Data Transformation
  7. Measures and Calculated Columns
  8. Query Editor 

  1. Introduction to Modelling
  2. Modelling Data
  3. Manage Data Relationship
  4. Optimize Data Models
  5. Cardinality and Cross Filtering
  6. Default Summarization & Sort by
  7. Creating Calculated Columns
  8. Creating Measures & Quick Measures

  1. What is DAX?
  2. Data Types in DAX
  3. Calculation Types
  4. Syntax, Functions, Context Options
  5. DAX Functions
  6. Date and Time
  7. Time Intelligence
  8. Information
  9. Logical
  10. Mathematical
  11. Statistical
  12. Text and Aggregate
  13. Measures in DAX

  1. • Introduction and Sharing Options Overview
  2.  Publish from Power BI Desktop and Publish to
    Web
  3.  Share Dashboard with Power BI Service
  4. Workspaces and Apps (Power BI Pro) and
    Content Packs (Power BI Pro)
  5. Print or Save as PDF and Row Level Security
    (Power BI Pro)
  6. Export Data from a Visualization and Publishing
    for Mobile Apps
  7. Export to PowerPoint and Sharing Options
    Summary

  1. Understanding Data Refresh
  2. Personal Gateway (Power BI Pro and 64-bit
    Windows)
  3. Replacing a Dataset and Troubleshooting
    Refreshing

Python Course Content

  1. What is Python?
  2. Why Python?

  1. What is Variable?
  2. Variables and Constants in Python
  3. Variable, names and Value
  4. Values and Types
  5. What Does “Type” Mean?

  1. What is string?
  2. String operations and indices
  3. Basic String Operations
  4. String Functions, Methods
  5. Delete a string
  6. String Multiplication and concatenation
  7. Python Keywords, Identifiers and Literals
  8. String Formatting Operator
  9. Structuring with indentation in Python
  10. Built-in String Methods
  11. Define Data Structure?
  12. Data Structures in PYTHON

  1. Arithmetic, Relational Operators and Comparison Operators
  2. Python Assignment Operators
  3. Short-hand Assignment Operators
  4. Logical Operators or Bitwise Operators

  1. How to use “if condition” in conditional structures
  2. if statement (One-Way Decisions)
  3. if .. else statement (Two-way Decisions) 
  4. How to use “else condition”
  5. Logical Operators or Bitwise Operators
  6. if .. elif .. else statement (Multi-way)
  7. How to use “elif” condition
    Nested IF Statement

  1. How to use “While Loop” and “For Loop”
  2. How to use For Loop for set of other things besides numbers
  3. Break statements, Continue statements, Enumerate
  4. function for For Loop
  5. Practical Example
  6. How to use for loop to repeat the same statement over and again
  7. Break, continue statements

  1. Strings
  2. Lists
  3. Tuples

  1. Lists are mutable
  2. Getting to Lists
  3. List indices
  4. Traversing a list
  5. List operations, slices and methods
  6. Map, filter and reduce
  7. Deleting elements
  8. Lists and strings

  1. Advantages of Tuple over List
  2. Packing and Unpacking
  3. Comparing tuples
  4. Creating nested tuple
  5. Using tuples as keys in dictionaries
  6. Deleting Tuples
  7. Slicing of Tuple

  1. How to create a set?
  2. Iteration Over Sets
  3. Python Set Methods
  4. Python Set Operations
  5. Union of sets
  6. Built-in Functions with Set
  7. Python Frozenset

  1. What is Variable?
  2. Variables and Constants in Python
  3. Variable, names and Value
  4. Values and Types
  5. What Does “Type” Mean?

  1. How to create a dictionary?
  2. Python Dictionary Methods
  3. Copying dictionary
  4. Updating Dictionary
  5. Delete Keys from the dictionary
  6. Dictionary items() Method
  7. Sorting the Dictionary
  8. Python Dictionary in-built Function
  9. Dictionary len() Method
  10. Variable Types
  11. Python List cmp() Method
  12. Dictionary Str(dict)

  1. What is a function?
  2. How to define and call a function in Python
  3.  Types of Functions
  4.  How Function Return Value?
  5. Types of Arguments in Functions
  6. Default Arguments and Non-Default
    Arguments
  7. Keyword Argument and Non-keyword
    Arguments
  8.  Rules to define a function in Python
  9. Scope and Lifetime of variables
  10.  Nested Functions
  11. Call By Value, Call by Reference
  12. Passing functions to function

  1. How to Use Date & DateTime Class
  2. How to Format Time Output
  3. How to use Timedelta Objects
  4. Calendar in Python
  5. datetime classes in Python
  6. How to Format Time Output?
  7. The Time Module
  8.  Python Calendar Module
  9. Python Text Calendar, HTML Calendar Class
  10. Unix Date and Time Commands

  1. What is a data, Information File?
  2. File Objects
  3. File Different Modes and Object Attributes
  4. How to create a Text Fil and Append Data to a File and Read a File
  5. Closing a file
  6. Read, read line ,read lines, write, write
    lines…!!
  7. Renaming and Deleting Files
  8. Directories in Python
  9. Working with CSV files and CSV Module
  10. Handling IO Exceptions

  1. Chain of importance Of Exception
  2. Exception Handling
  3. Try … Except
  4. Try .. Except .. else
  5. Try … finally
  6. Argument of an Exception
  7. Python Custom Exceptions
  8. Ignore Errors
  9. Assertions
  10. Using Assertions Effectively

  1. Python Iterators, Generators, Closures,
    Decorators and Python @property

  1. Introduction to OOPs Programming
  2. Object Oriented Programming System
  3. OOPS Principles
  4. Define Classes
  5. Creating Objects
  6. Class variables and Instance Variables
    Constructors
  7. Basic concept of Object and Classes