Content Protected

Please return to the app to continue.

SkillNiti
Student App

MySql

₹999 '3 Month'

MySQL – SkillNiti


💻 About the Course:

MySQL is the world’s most popular open-source database management system (DBMS). It is used to store, organize, and manage data for websites, applications, and businesses. In this SkillNiti module, students will learn database concepts, SQL queries, and real-world applications of MySQL, from basics to advanced level.


📌 What You’ll Learn:


Introduction to Databases & MySQL


Installing & Setting up MySQL


Database Design (Tables, Rows, Columns)


SQL Queries: SELECT, INSERT, UPDATE, DELETE


Constraints, Keys & Relationships


Joins (Inner, Outer, Cross Joins)


Functions & Operators in MySQL


Indexing & Optimization


Backup, Restore & Security Basics


Hands-on Practice with Real Projects



🎯 Why Learn MySQL?


Essential skill for programmers, web developers & data analysts


Used in Govt. Exams (Computer Section), IT jobs & freelancing


Builds strong base for Data Science, Web Development & Software Engineering


High demand in both private & government sector

Enroll / Pay

Please login or register to submit payment proof and unlock full course access.

Login Register
Recorded Videos

First 5 videos can be opened as demo. Remaining videos require course access.

1 Introduction To MySQL

Ready to watch

Open
2 MySQL Implementation Example In Real Life Scenerio

Ready to watch

Open
3 Benefits Of Using MySQL RDBMS

Ready to watch

Open
4 Working Overview and Features In MySQL

Ready to watch

Open
5 Database And RDBMS In MySQL

Ready to watch

Open
6 Tables And Database In MySQL

Locked after demo videos

7 Data Integrity In MySQL

Locked after demo videos

8 Null Values In MySQL

Locked after demo videos

9 SQL

Locked after demo videos

10 Lets Know How MySQL Works Practically

Locked after demo videos

11 Prerequisite To Learn MySQL

Locked after demo videos

12 Software Requirements To Learn MySQL

Locked after demo videos

13 SQL Statements In MySQL

Locked after demo videos

14 How To Run MySQL Online

Locked after demo videos

15 Downloading Xampp For Offline MySQL Usage

Locked after demo videos

16 How To Run MySQL Offline Using Xampp

Locked after demo videos

17 Xampp LocalHost Interface Introduction In MySQL

Locked after demo videos

18 Creating and Managing Database In MySQL

Locked after demo videos

19 How To Use And Drop Databases In MySQL

Locked after demo videos

20 Creating Tables In MySQL

Locked after demo videos

21 Data Types In MySQL

Locked after demo videos

22 Integer And Decimal Datatype In MySQL

Locked after demo videos

23 String And Date Data types In MySQL

Locked after demo videos

24 Inserting Data In MySQL Tables In MySQL

Locked after demo videos

25 Display Data Using Select Command In MySQL Table In MySQL

Locked after demo videos

26 Adding Columns Fields For Existing Tables In MySQL

Locked after demo videos

27 Modify Rename Drop TableFields In The Tables In MySQL

Locked after demo videos

28 Truncate And Drop Command In Tables In MySQL

Locked after demo videos

29 How To Rename A Table In MySQL

Locked after demo videos

30 Column Field based Insert and Select command In MySQL Table

Locked after demo videos

31 Introduction To Constraints in MySQL

Locked after demo videos

32 NULL In MySQL

Locked after demo videos

33 NOT NULL Constraint In MySQL

Locked after demo videos

34 UNIQUE Constraint In MySQL

Locked after demo videos

35 Removing Not Null And Unique Entries

Locked after demo videos

36 Primary Key In MySQL

Locked after demo videos

37 Setting Up Primary Key In MySQL

Locked after demo videos

38 Primary Key On More Than One Fields In MySQL

Locked after demo videos

39 Adding Or Removing PRIMARY KEY On Existing Table

Locked after demo videos

40 Foreign Key In MySQL

Locked after demo videos

41 Setting Up Foreign Key In MySQL

Locked after demo videos

42 Adding Foreign Key In MySQL After Creating Tables

Locked after demo videos

43 Removing Foreign Key In MySQL

Locked after demo videos

44 Check Constraint In MySQL

Locked after demo videos

45 Default Constaint In MySQL

Locked after demo videos

46 Adding Default Constraint In MySQL After Creating Tables

Locked after demo videos

47 DROPING DEFAULT Constraint In MySQL

Locked after demo videos

48 Creating INDEX Constraint In MySQL

Locked after demo videos

49 Dropping INDEX Constraint In MySQL

Locked after demo videos

50 AUTO INCREMENT In MySQL

Locked after demo videos

51 DISTINCT In MySQL

Locked after demo videos

52 WHERE In MySQL

Locked after demo videos

53 Logical And Relational Operator

Locked after demo videos

54 AND OR NOT In MySQL

Locked after demo videos

55 Practical Examples AND OR NOT In MySQL

Locked after demo videos

56 Use Together AND OR NOTIn MySQL

Locked after demo videos

57 UPDATE In MySQL

Locked after demo videos

58 DELETE In MySQL

Locked after demo videos

59 ORDER BYIn MySQL

Locked after demo videos

60 IN In MySQL

Locked after demo videos

61 Between In MySQL

Locked after demo videos

62 BETWEEN And IN MySQL

Locked after demo videos

63 LIKE In MySQL Part One

Locked after demo videos

64 LIKE In MySQL Part Two

Locked after demo videos

65 What Is Regular Expression In MySQL

Locked after demo videos

66 Practical Examples Of Regular Expression In MySQL

Locked after demo videos

67 Functions In MySQL

Locked after demo videos

68 GROUP BY In MySQL

Locked after demo videos

69 HAVING In MySQL

Locked after demo videos

70 Practical Examples Of HAVING In MySQL

Locked after demo videos

71 Providing Names Aliases To Fields In MySQL

Locked after demo videos

72 SUBQUERIES in MySQL

Locked after demo videos

73 JOINS in MySQL

Locked after demo videos

74 Types Of JOINS In MySQL

Locked after demo videos

75 INNER JOIN In MySQL

Locked after demo videos

76 LEFT OUTER JOIN In MySQL

Locked after demo videos

77 RIGHT OUTER JOIN In MySQL

Locked after demo videos

78 CROSS OR FULL OUTER JOIN In MySQL

Locked after demo videos

79 TRANSACTIONS In MySQL PART ONE

Locked after demo videos

80 TRANSACTIONS IN MYSQL PART TWO

Locked after demo videos

81 VIEWS IN MySQL PART ONE

Locked after demo videos

82 VIEWS IN MySQL PART TWO

Locked after demo videos

83 TRIGGERS IN MySQL PART ONE

Locked after demo videos

84 TRIGGERS IN MySQL PART TWO

Locked after demo videos

85 Practical Example Of TRIGGERS IN MySQL

Locked after demo videos

86 STORED PROCEDURE In MySQL

Locked after demo videos

87 Practical Example Of STORED PROCEDURE IN MySQL

Locked after demo videos

NotesTestsLiveHelp
Home Courses Notice Chat Login