💻EMRS TGT CS T-2 Paid Course 🌱

📝View PDF Notes SQL Funtions: Math functions: POWER(), ROUND(), MOD() Text functions: UCASE()/UPPER(),LCASE()/LOWER(),MID()/SUBSTRING()/ SUBSTR(), LENGTH(), LEFT(), RIGHT(), INSTR(),LTRIM(), RTRIM(), TRIM() Date Functions: NOW(), DATE(), MONTH(), MONTHNAME(), YEAR(), DAY(), DAYNAME() Aggregate Functions: MAX(), MIN(), AVG(), SUM(), COUNT(); using COUNT(*) Querying and manipulating data using Group by, Having, Order by.

📝View PDF Notes PART-2 Structured Query Language: group by, having clause, joins: Cartesian product on two tables, equi-join, Union and natural join

📝View PDF Notes PART-1 Structured Query Language: introduction, Data Definition Language and Data Manipulation Language, data type (char(n), varchar(n), int, float, date), constraints (not null, unique, primary key), create database, use database, show databases, drop database, show tables, create table, describe table, alter table (add and remove an attribute, add and remove primary key), drop table, insert, delete, select, operators (mathematical, relational and logical), aliasing, distinct clause, where clause, in, between, order by, meaning of null, is null, is not null, like, update command, delete command.

📝View PDF Notes Database Concept: • introduction to database concepts and its need Relational Data Model: • relation, attribute, tuple, domain, degree, cardinality, • keys(candidate key, primary key, alternate key, foreign key)

📝View PDF Notes Use of AI Tools: • ChatGPT – Text generation, explanations, brainstorming. • Gemini (Google) – AI search and summarization. • Claude (Anthropic) – Writing, summarizing, reasoning tasks. • Microsoft Copilot – Integrated with Word, Excel, PowerPoint for AI assistance. • Canva AI – Magic Write, AI design suggestions, image generation Application Software: • Word Processor • Electronic Spreadsheet • Presentation Tools

📝View PDF Notes Artificial Intelligence: AI Core Concepts: AI domains, ethics, project cycle, data literacy, generative AI, modeling, evaluation, stats, CV, NLP, Automated vs. autonomous systems, Basics of machine learning, Importance of cybersecurity in AI