Diploma in Database:

Getting Started

• What is data
• Why data is hot plate?
• How data is Collected
• Job Roles in Database

Data Core Concepts

• Big Data,Meta Data
• Different Tools/Softwares like MS Excel
• Limitation of MS EXCEL
• Types of data
• Database and RDBMS
• Why RDBMS?
• Normalise database
• Levels of Normalisation

Database Literacy  

• Why SQL
• Reading Data
• Relational Database
• Database Design
• Various Keys and Contraints
• Primary Key
• Foreign Key
• Unique Key
• Relationship

SQL Concepts

• Various Types of SQL Statements

• DDL (Data Definition Language)
  • CREATE
    • Create database
    • Create database objects
    • table, index
    • function, views, store procedure,
    • triggers

• DROP
  • Delete objects from the database
• ALTER
  • Alter the structure of the database
• TRUNCATE
  • Remove all records from a table
• COMMENT
  • Add comments to the data dictionary
• RENAME
  • Rename an database object existing in the database

• Data Query Language (DQL)
  • SELECT
    • It is used to retrieve data from the database
• Data Manipulation Language (DML)
  • INSERT
    • Insert data into a table
  • UPDATE
    • Update existing data within a table
  • DELETE
    • Delete records from a database table
  • LOCK
    • Table control concurrency
  • CALL
    • Call a PL/SQL
• DCL
  • GRANT
  • REVOKE
• TCL
  • BEGIN TRANSACTION
  • COMMIT
  • ROLLBACK
  • SAVEPOINT
  • Database & Schema

Getting Started

• Installation and configuration MS SQL Server
• Create Schema
• Various Data Types
  • String,Integer,Decimal,Date
• Creating Table

SQL Constraints

• Primary Key
• Forign Key
• Default
• Unique
• Not Null
• Best Practices
• Data Loading

DML

• Select
• Where clause, And Or
• Operator Precedence
• In, Like, Between, Is Not null
• Comparison Operators
• Select (distinct), Count(distinct)
• Order by, Group by, Having
• Difference between Where and Having
• Limit

Advance DML

• Insert, Insert with various Ways
• Update,Update (Columns) Fields,datatype
• Delete, Truncate, Drop

Aggregate Functions

• Count
• Sum
• Avg
• Round
•  Min & Max

Important Functions          

• String functions,
• Date Functions
• Date-Time Format,
• str_to_date
• Coalesce
• Case,
• IfNull

Joins 

• Why Joins
• Inner Join
• Joins on Multiple Columns
• Left Join
• Right Join
• Join with Group by
• Cross Join
• Cross and Inner Join
• Multiple Joins
• Union and Union All

Subqueries & Views          

• What is Sub Query
• Exists/Not Exists
• Self Join
• What is View?
  • Create
  • Update
  • Drop
  • Delete
  • Advantages/Limitations

Stored Procedures 

• What is Stored procedure
• Create, Update,Execute Stored Procedure
• Functions
• Create Update,Execute Functions
• Function v/s Stored Procedure

Triggers       

• What is Triggers?
• Various types of Triggers
• Usage, Advantage,Limitation
• Best Practice
• Stored procedure and triggers

Indexes

• Clustered and Non clustered Index
• Advantage and disadvantages of Indexes
• Importance of having Index on your table

Optimisation

• Query for better performance
• Stored procedure
• Trigger
• Indexes

 

Basic Excel Modules:

• Font formatting
• Number formatting
• Table formatting
• Conditional formatting
• Hide/ Unhide
• Sort/filter
• Paste special
• Find and select

Insert

• Illustrations
• Charts
• Tex

Basic Functions

• Sum/Average/Count/Max/Min
• Basic Text/date/time/lookup/information functions
• Name manager
• Formula Auditing

Data

• Import from web
• Import from text
• Text to columns
• Remove duplicates
• Grouping and ungrouping

Review

• Proofing
• Comments
• Protection

Views

• Typesofviews
• Zoom
• Windows

Developer

• Enable developer
• Using checkbox/option buttons

 

Advanced Excel Modules: 

Excel 2007 & 2010,2013, 2016 Quick Overview

• Difference between Excel2003, 2007 and 2010, 2013, 2016
• Use of Excel, its boundaries & features

Basic Formula

• Formulae that Add/ Subtract/ Multiply/ Divide
• BODMAS / Formula Error Checking
• The Sum Function

Absolute Referencing

• Problems with Absolute /Relative Cell Referencing
• Creating Absolute /Mixed References

LOOKUP Functions

• The VLOOKUP/ HLOOKUP Functions

Pivot Tables

• Creating,Formatting Simple Pivot Tables
• Page Field in a Pivot Table
• Formatting a Pivot Table
• Creating/ Modifying a Pivot Chart

Logical Functions

• IFs and Nested IF Functions
• Using AND/OR/ NOT Functions

Statistical Functions

• Using The SUM IF / COUNT IF Functions
• Using The AVERAGE/COUNT/LARGER/SMALLER Functions

Pivot Tables–Advance

• Adding new calculated Fields/Items
• Changing the Summary Function
• Consolidate Pivot table

LOOKUP Functions–Advance

• MATCH with VLOOKUP Functions
• INDEX& MATCH Functions
• OFFSET/INDIRECT functions

Logical Functions–Advance

• If Loop and Nested IF Loop Functions
• Using IF/IS ERROR Functions

Chart Data Techniques

• The Chart Wizard
• Chart Types
• Adding Title/Legends/ Labels
• Printing Charts
• Adding Data to a Chart
• Formatting/Renaming/Deleting Data Series
• Changing the Order of Data Series

Date / Time Functions

• Using The Today
• Now& Date Functions
• Using The Dated if/ Network days/Eomonth Functions
• Using The Week num Functions
• Using The Edate/Network days.Intl/Weekdays.Intl Functions

Text Functions Using

• The Mid/Search/Left/Right Functions
• Using The Trim/Clean/Upper/Lower Functions
• Using The Substitute/Text Functions
• Using The Trim/Clean/Proper/Dollar Function

Validations

• Input Messages/Error Alerts/Drop-Down Lists
• Conditional Formatting

Advanced Filters

• Extracting Records with Advanced Filter
• Using Formula sin Criteria

Advanced Sorting

• Sorting by Top to Bottom/Left to Right
• Creating/Deleting Custom List
• Sort by using Custom List

Hyper/Data Linking

• Hyper linking data,within sheet/workbook
• Linking&Updating links between workbooks&application

Math & Trigonometry Functions

• Using SUM PRODUCT Functions
• Using FLOOR/CEILING/MROUND/MOD/QUOTIENT Functions

Summarizing Data

• Creating Subtotals/Nested Subtotals
• SUBTOTALS Formula

Outlining

• Creating/Working with an Automatic/Manual Outline
• Grouping/Un grouping

Consolidation

• Consolidating Data with Identical/Different Layout

Using Auditing Tools

• Displaying/Removing Dependent&Precedent Arrows
• Evaluate Formula–StepIN/StepOut

Custom Views

• Creating Custom Views
• Displaying Custom Views
• Deleting Custom Views

Sharing and Protecting Workbooks

• Sharing Workbooks&Tracking Changes
• Protecting sheets/workbooks/Files

Importing & Exporting Data

• Importing Data from Database/ TextFiles/Web
• Exporting Data
• Changing External Data Range

Once you master your chosen program at Yess Infotech , you’ll

walk away with a Valuable certification!

Why Choose Yess InfoTech?
Yess InfoTech offers a comprehensive approach to IT education and career development. Here’s why you should choose them:

Optimal Learning Environment
Study Room: A dedicated space for focused learning.
Computer Equipped Lab: Hands-on practice with the latest technology.

Expert Guidance
Experienced Trainers: Industry professionals sharing real-world knowledge.
Career Coach Sandip Sir: 8+ years of MNC experience providing valuable career guidance.
Personality Development Trainer: Enhancing soft skills essential for professional success.

Comprehensive Support
Dedicated Placement Team: Assisting with job search and interview preparation.
Placement Record of 12 LPA: Demonstrating successful career outcomes.
Notes Availability: Additional resources for effective learning.
Recorded Sessions on Trechto App: Flexibility to review lessons at your convenience.
In essence, Yess InfoTech provides a holistic learning experience that equips students with the necessary technical skills, soft skills, and career support to excel in the IT industry.

By combining a conducive learning environment, expert faculty, and a strong focus on career development, Yess InfoTech sets itself apart as a preferred choice for aspiring IT professionals.

Would you like to know more about a specific aspect of Yess InfoTech?

Database Trainer of Yess InfoTech having 10+ years experience the field of software training and development. They are excellent in delivering good quality of teaching and support after training.

We Will Be Updated Soon.