IT & Software
SQL & MySQL for Data Handling
Learn relational database concepts, SELECT queries, filtering, joins, grouping, inserts, updates and safe data handling.
Provided by HiringMart India
About this course
Learn relational database concepts, SELECT queries, filtering, joins, grouping, inserts, updates and safe data handling.
What you will learn
Understand the core concepts, complete guided practice, apply the workflow to a realistic task, and demonstrate competency through module quizzes and assignments. / मूल अवधारणाएँ समझें, निर्देशित अभ्यास पूरा करें, वास्तविक कार्य पर प्रक्रिया लागू करें और मॉड्यूल क्विज़ व असाइनमेंट से अपनी दक्षता दिखाएँ।
Course curriculum
Relational Database Foundations / मॉड्यूल 14 lessons
1. Tables, Rows, Columns and Data TypesArticle · 15 min
2. Primary Keys and Foreign KeysArticle · 18 min
3. Relationships and Normalisation BasicsArticle · 21 min
4. Create Databases and Tables SafelyArticle · 24 min
Querying Data / मॉड्यूल 24 lessons
1. SELECT, WHERE and ORDER BYArticle · 15 min
2. DISTINCT, LIMIT and Pattern MatchingArticle · 18 min
3. Aggregate Functions and GROUP BYArticle · 21 min
4. HAVING and Summary ReportsArticle · 24 min
Joining and Changing Data / मॉड्यूल 34 lessons
1. INNER, LEFT and RIGHT JOINArticle · 15 min
2. Subqueries and Common Table Expressions BasicsArticle · 18 min
3. INSERT, UPDATE and DELETE SafelyArticle · 21 min
4. Transactions, Commit and RollbackArticle · 24 min
Data Quality and Practical Project / मॉड्यूल 44 lessons
1. NULL Handling and COALESCEArticle · 15 min
2. Indexes and Query Performance BasicsArticle · 18 min
3. Constraints, Backups and Access ControlArticle · 21 min
4. Build a Recruitment Reporting Query SetArticle · 24 min