SQL Basics

• Filtering and Sorting Data: Practice using WHERE clause to filter data based on specific conditions, and using ORDER BY clause to sort data in ascending or descending order.

• Aggregate Functions: Learn about aggregate functions like COUNT, SUM, AVG, MIN, and MAX to perform calculations on groups of rows.

• Grouping Data: Understand how to group data using the GROUP BY clause, allowing you to perform aggregate functions on subsets of data.

• Joins: Learn about different types of joins (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN) to combine data from multiple tables based on related columns.

• Subqueries: Understand how to use subqueries to nest one SELECT statement within another, allowing you to perform more complex queries.

• Data Types: Familiarize yourself with common data types such as INTEGER, VARCHAR, DATE, and understand their usage and limitations.

• Constraints: Learn about constraints such as PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL, and how they enforce data integrity rules.

• Views: Understand how to create and use views, which are virtual tables generated by a query, providing a convenient way to encapsulate complex logic.

Syllabus:

• Introduction to SQL: Understand what SQL is, its purpose, and its common use cases in managing and querying databases.

• Relational Databases: Learn the basics of relational databases, including tables, rows, columns, and relationships between tables (primary keys, foreign keys).

• Data Manipulation Language (DML):

  • SELECT: Learn how to retrieve data from a database using the SELECT statement. Understand filtering data using WHERE clause, sorting data using ORDER BY clause, and limiting results using LIMIT clause.

  • INSERT: Learn how to add new records to a table using the INSERT statement.

  • UPDATE: Understand how to modify existing records in a table using the UPDATE statement.

  • DELETE: Learn how to remove records from a table using the DELETE statement.

• Data Definition Language (DDL):

  • CREATE TABLE: Learn how to create tables in a database specifying column names, data types, and constraints.

  • ALTER TABLE: Understand how to modify the structure of an existing table, such as adding, modifying, or dropping columns.

  • DROP TABLE: Learn how to delete tables from a database.

• Data Control Language (DCL):

  • GRANT: Grants specific privileges to a user or role, giving them permission to perform certain operations on database objects (e.g., SELECT, INSERT, UPDATE, DELETE).

  • REVOKE: Revokes previously granted privileges from a user or role, restricting their access to database objects.

Prerequisites:

• No prior knowledge of SQL or databases is required. Basic understanding of computer operations is helpful.

Python Basics

Syllabus:

• Introduction to Python : What is Python? Where is Python used? Why Python? History of Python

• Python Basics : Literal Constants,Numbers, Strings, Comments, print(),format(), Indentation

• Mathematical Calculations : Addition, Subtraction, Division, Modulus, Composite expression, Floating Point Expressions

• Variables and Data Types : Variable Declaration and Assignment

  • Declaration and Assignment : Python has no command for delcaring a variable. Assign a value and start using it

  • Naming conventions : List of rules to be followed for naming a variable

  • Data types : Integer, Float, Boolean, String, Operations on Strings

Prerequisites:

• No prior knowledge of python is required. Basic understanding of computer operations is helpful.

• Modules, Packages and Libraries : Installation

  • Modules : Installing Standard Modules

  • Packages : Installing Packages

  • Libraries : Installing External libraries. Installing pip and Installing libraries

  • Importing Modules : import statement. Selective imports. Module search path

Power BI Basics

Syllabus:

• Introduction to Power BI : What is Power BI? Where is Power BI used? Why Power BI? History of Power BI

• Architecture : Power BI Architecture

• Evolution of Power BI : Evolution of Power BI from Power Query, Data mash up engine

• Power Pivot : Why Power Pivot, Versions and relationships

• Power Map : Why Power Map, 3-D visualization with Power Map

• Power View : Why Power view, Sorting, Filtering techniques in Power View

• Explore : Power Pivot, Power Map and Power View

• Power Query : Basics of Power Query

• Explore : Install and Explore Power BI Desktop and relationships

  • Features : Get data from Different sources XML, Folder, CSV file

  • Query Editor : How to use Query Editor

  • Understanding of ERD : Understanding of Data modelling and Relationships

  • Measures : Create Calculated Measures

  • Differentiate Power Pivot : Differentiate Power Pivot in Power BI Desktop with other components

  • Analyze Power view : Analyze Power View Difference in Power BI Desktop

Prerequisites:

• No prior knowledge of Power BI or databases is required. Basic understanding of computer operations is helpful.