/CourseBundles(35841)/2372187-4.png)
Course Overview
Schedule of Classes
Course Curriculum
5 Subjects
Ms Office - Word and PPT
1 Exercises • 16 Learning Materials
MS Word - Introduction
MS Word - Introduction
External Link
Navigation and Managing Text
Navigation and Managing Text
External Link
Formatting Text
Formatting Text
External Link
Modifying Document Appearance
Modifying Document Appearance
External Link
Document Formatting
Document Formatting
External Link
Inserting Tables
Inserting Tables
External Link
Inserting Shapes
Inserting Shapes
External Link
Aligning Shapes
Aligning Shapes
External Link
Formatting Shapes
Formatting Shapes
External Link
Smart Art
Smart Art
External Link
Charts
Charts
External Link
Page & Text Format
Page & Text Format
External Link
Introduction to PPT
Introduction to PPT
External Link
Inserting Slides and Sections
Inserting Slides and Sections
External Link
Formatting Font & Paragraph
Formatting Font & Paragraph
External Link
Drawing Effects
Drawing Effects
External Link
Certification Assessment
MS Office Assessment
Exercise
Certification Assessment - MS Office
PowerBI Foundation
21 Learning Materials
Introduction to MS Excel
Introduction to MS Excel
External Link
Managing Worksheets
Managing Worksheets
External Link
Managing Worksheets and Data Formatting
Managing Worksheets and Data Formatting
External Link
Working with Data
Working with Data
External Link
File Management
File Management
External Link
Referencing
Referencing
External Link
Sum & Count
Sum & Count
External Link
IF and Conditional Formatting
IF and Conditional Formatting
External Link
Pie Charts
Pie Charts
External Link
Data Tools - Remove Duplicates
Data Tools - Remove Duplicates
External Link
Data Tools - Text to Columns
Data Tools - Text to Columns
External Link
Data Validation and Data Protection
Data Validation and Data Protection
External Link
EXERCISE ON POWERBI MODULE 1
Session - 1
External Link
Session - 2
External Link
Session - 3
External Link
EXERCISE ON POWERBI MODULE 2
Session - 4
External Link
Session - 5
External Link
Session - 6
External Link
EXERCISE ON POWERBI MODULE 3
Session - 7
External Link
Session - 8
External Link
Session - 9
External Link
Project on College Attendance
Project on A Company Growth
Project on Sales
PowerBI Full Stack
30 Learning Materials
MODULE - 1
Session - 1
External Link
Session - 2
External Link
Session - 3
External Link
MODULE - 2
Session - 4
External Link
Session - 5
External Link
Session - 6
External Link
MODULE - 3
Session - 7
External Link
Session - 8
External Link
Session - 9
External Link
MODULE - 4
Session - 10
External Link
Session - 11
External Link
Session - 12
External Link
MODULE - 5
Session - 13
External Link
Session - 14
External Link
Session - 15
External Link
MODULE - 6
Session - 16
External Link
Session - 17
External Link
Session - 18
External Link
MODULE - 7
Session - 19
External Link
Session - 20
External Link
Session - 21
External Link
MODULE - 8
Session - 22
External Link
Session - 23
External Link
Session - 24
External Link
MODULE - 9
Session - 25
External Link
MODULE - 10
Session - 26
External Link
Session - 27
External Link
Session - 28
External Link
Session - 29
External Link
Session - 30
External Link
E - Data Base Design
40 Learning Materials
UNIT-1
Basic Concepts of DBMS
External Link
Data Base Management System
External Link
Applications and Components of Database
External Link
Costs and Risks of Database Approach
External Link
Database Developement Process
External Link
Data Base Analysis
External Link
UNIT-2
Enhanced ER Model
External Link
Constraints and Discriminators
External Link
Relational Model
External Link
Relational Keys
External Link
Integrity Constraints
External Link
Transferring EER to Relational Schema
External Link
Normalization Part-1
External Link
Normalization Part-2
External Link
UNIT-3
Relational Alzebra
External Link
Relational Calculus
External Link
SQL Part-1
External Link
SQL Part-2
External Link
Set Theory Operators
External Link
Joins
External Link
SQL Constraints Part-1
External Link
SQL Constraints Part-2
External Link
SQLSet Operators
External Link
SQL Nested Queries
External Link
Aggregate Functions and Clauses
External Link
Procedures and Triggers
External Link
UNIT-4
File Organization and Indexing Part-1
External Link
File Organization and Indexing Part-2
External Link
Index Data Structures
External Link
B+ Tree
External Link
Hashing(Static)
External Link
Dynamic Hashing(Extendible and Linear)
External Link
UNIT-5
ACID Properties
External Link
Transaction and Schedule Part-1
External Link
Transaction and Schedule Part-2
External Link
Concurrent Execution
External Link
Lock Based Concurrency Control&2PL
External Link
Serializability and Recoverability
External Link
Introduction to Lock Management
External Link
Dealing with Deadlock
External Link
E - SQL
21 Learning Materials
UNIT 1
SQL Intoduction
External Link
History and Architecture of SQL
External Link
SQL commands
External Link
RDBMS
External Link
Constraints and Normal Forms
External Link
UNIT 2
MY SQL
External Link
MS SQL Server
External Link
Oracle
External Link
Ms Access
External Link
Various Syntaxes in SQL
External Link
UNIT 3
SQL Datatypes
External Link
Operators in SQL
External Link
SQL Expression
External Link
Creating and Dropping Databases
External Link
Creating Tables Using SQL Commands
External Link
Populating One Table Using Another Table
External Link
UNIT 4
SQL AND, OR Operators
External Link
Like Clause
External Link
Top Clause
External Link
Order By and Group By Clause
External Link
SQL Distinct Keyword
External Link
UNIT 5
Course Instructor
/1767938-32_-_32_PNG.png)
EDUREPUBLIC
248 Courses • 6741 Students
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy