{"id":326,"date":"2024-10-11T03:49:30","date_gmt":"2024-10-11T03:49:30","guid":{"rendered":"https:\/\/itxperts.co.in\/blog\/?p=326"},"modified":"2024-10-27T10:47:14","modified_gmt":"2024-10-27T10:47:14","slug":"comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions","status":"publish","type":"post","link":"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/","title":{"rendered":"Comprehensive MySQL Practice Worksheet for CBSE Class 11th &amp; 12th: Mastering DDL, DML, TCL, and SQL Functions"},"content":{"rendered":"\n<p>MySQL is an essential part of the Class 11th and 12th CBSE Computer Science curriculum. Mastering MySQL enables students to manage and interact with databases effectively, a skill highly valued in programming and data management. This worksheet is designed to give CBSE students hands-on practice with MySQL operations, including <strong>Data Definition Language (DDL)<\/strong>, <strong>Data Manipulation Language (DML)<\/strong>, <strong>Transaction Control Language (TCL)<\/strong>, and commonly used <strong>SQL Functions<\/strong>. Let\u2019s dive into some key exercises that will help you get familiar with these concepts.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Part 1: Data Definition Language (DDL)<\/strong><\/h3>\n\n\n\n<p>DDL commands are used to define or modify the structure of the database and database objects like tables. The most common DDL commands are <code>CREATE<\/code>, <code>ALTER<\/code>, <code>DROP<\/code>, and <code>TRUNCATE<\/code>.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Exercise 1: Create and Modify Tables<\/strong><\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Create a table<\/strong> <code>Students<\/code> with the following structure:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>StudentID<\/code> (INT, PRIMARY KEY, AUTO_INCREMENT)<\/li>\n\n\n\n<li><code>FirstName<\/code> (VARCHAR(30))<\/li>\n\n\n\n<li><code>LastName<\/code> (VARCHAR(30))<\/li>\n\n\n\n<li><code>DOB<\/code> (DATE)<\/li>\n\n\n\n<li><code>Marks<\/code> (INT) <strong>Solution:<\/strong><\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql line-numbers\">   CREATE TABLE Students (\n     StudentID INT PRIMARY KEY AUTO_INCREMENT,\n     FirstName VARCHAR(30),\n     LastName VARCHAR(30),\n     DOB DATE,\n     Marks INT\n   );<\/code><\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>Alter the table<\/strong> to add a new column <code>Gender<\/code> (CHAR(1)) to the <code>Students<\/code> table. <strong>Solution:<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">   ALTER TABLE Students ADD Gender CHAR(1);<\/code><\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>Drop a column<\/strong> from the table.<br>Drop the <code>Marks<\/code> column from the <code>Students<\/code> table. <strong>Solution:<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">   ALTER TABLE Students DROP COLUMN Marks;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Part 2: Data Manipulation Language (DML)<\/strong><\/h3>\n\n\n\n<p>DML commands deal with manipulating data in the tables. Common commands include <code>INSERT<\/code>, <code>UPDATE<\/code>, <code>DELETE<\/code>, and <code>SELECT<\/code>.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Exercise 2: Insert, Update, and Delete Data<\/strong><\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Insert records<\/strong> into the <code>Students<\/code> table. Insert the following data:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>FirstName<\/code>: Ravi, <code>LastName<\/code>: Kumar, <code>DOB<\/code>: 2004-05-15, <code>Gender<\/code>: M<\/li>\n\n\n\n<li><code>FirstName<\/code>: Priya, <code>LastName<\/code>: Sharma, <code>DOB<\/code>: 2003-08-10, <code>Gender<\/code>: F <strong>Solution:<\/strong><\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">   INSERT INTO Students (FirstName, LastName, DOB, Gender) \n   VALUES ('Ravi', 'Kumar', '2004-05-15', 'M'), \n          ('Priya', 'Sharma', '2003-08-10', 'F');<\/code><\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>Update a record<\/strong>: Change Priya&#8217;s last name from Sharma to Gupta. <strong>Solution:<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql line-numbers\">   UPDATE Students \n   SET LastName = 'Gupta' \n   WHERE FirstName = 'Priya' AND LastName = 'Sharma';<\/code><\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>Delete a record<\/strong>: Remove Ravi\u2019s record from the <code>Students<\/code> table. <strong>Solution:<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql line-numbers\">   DELETE FROM Students \n   WHERE FirstName = 'Ravi';<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Part 3: Transaction Control Language (TCL)<\/strong><\/h3>\n\n\n\n<p>TCL commands control the transactions in a database. Common TCL commands include <code>COMMIT<\/code>, <code>ROLLBACK<\/code>, and <code>SAVEPOINT<\/code>.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Exercise 3: Manage Transactions<\/strong><\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Insert data<\/strong> and use transactions to manage it.<br>Insert a new student record (<code>Anil<\/code>, <code>Verma<\/code>, <code>2005-07-20<\/code>, <code>M<\/code>), and use TCL commands to handle the transaction. <strong>Solution:<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql line-numbers\">   START TRANSACTION;\n\n   INSERT INTO Students (FirstName, LastName, DOB, Gender) \n   VALUES ('Anil', 'Verma', '2005-07-20', 'M');\n\n   -- If satisfied with the result, commit the changes\n   COMMIT;\n\n   -- Otherwise, rollback the transaction\n   -- ROLLBACK;<\/code><\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>Set a savepoint<\/strong> during the transaction.<br>Insert another record (<code>Nisha<\/code>, <code>Singh<\/code>, <code>2004-09-25<\/code>, <code>F<\/code>), but create a savepoint before committing the changes. <strong>Solution:<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql line-numbers\">   START TRANSACTION;\n\n   INSERT INTO Students (FirstName, LastName, DOB, Gender) \n   VALUES ('Anil', 'Verma', '2005-07-20', 'M');\n\n   SAVEPOINT savepoint1;\n\n   INSERT INTO Students (FirstName, LastName, DOB, Gender) \n   VALUES ('Nisha', 'Singh', '2004-09-25', 'F');\n\n   -- Rollback to the savepoint if necessary\n   -- ROLLBACK TO savepoint1;\n\n   COMMIT;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Part 4: SQL Functions<\/strong><\/h3>\n\n\n\n<p>SQL Functions are used to perform operations on the data stored in a database. They can be aggregate functions like <code>SUM()<\/code>, <code>AVG()<\/code>, or string functions like <code>UPPER()<\/code>, <code>LOWER()<\/code>.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Exercise 4: Use SQL Functions<\/strong><\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Find the average age<\/strong> of all students in the table (assuming the current year is 2024). <strong>Solution:<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql line-numbers\">   SELECT AVG(YEAR(CURDATE()) - YEAR(DOB)) AS AverageAge \n   FROM Students;<\/code><\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>Count the number of students<\/strong> in the table. <strong>Solution:<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql line-numbers\">   SELECT COUNT(*) AS TotalStudents \n   FROM Students;<\/code><\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>Concatenate the first and last names<\/strong> of the students to display their full names. <strong>Solution:<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"python\" class=\"language-python\">   SELECT CONCAT(FirstName, ' ', LastName) AS FullName \n   FROM Students;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Additional Practice Questions<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Create a table <code>Books<\/code> with columns <code>BookID<\/code>, <code>Title<\/code>, <code>Author<\/code>, <code>Price<\/code>, and <code>PublishedYear<\/code>.<\/li>\n\n\n\n<li>Insert at least 3 records into the <code>Books<\/code> table.<\/li>\n\n\n\n<li>Update the price of a book using the <code>UPDATE<\/code> statement.<\/li>\n\n\n\n<li>Use <code>SELECT<\/code> statements with <code>WHERE<\/code> clauses to filter records (e.g., books priced above 500).<\/li>\n\n\n\n<li>Try out TCL commands with a series of inserts and deletions and see how <code>COMMIT<\/code> and <code>ROLLBACK<\/code> work in practice.<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Conclusion<\/strong><\/h3>\n\n\n\n<p>This worksheet provides a comprehensive foundation for CBSE Class 11th and 12th students to understand and practice essential MySQL commands, including DDL, DML, TCL, and SQL functions. Regular practice of these exercises will enhance your ability to manage databases effectively and prepare you for exams and future coursework. Happy learning!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL is an essential part of the Class 11th and 12th CBSE Computer Science curriculum. Mastering MySQL enables students to manage and interact with databases effectively, a skill highly valued in programming and data management. This worksheet is designed to give CBSE students hands-on practice with MySQL operations, including Data Definition Language (DDL), Data Manipulation [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":327,"comment_status":"open","ping_status":"open","sticky":false,"template":"custom-post-with-sidebar.php","format":"standard","meta":{"_acf_changed":false,"googlesitekit_rrm_CAow44u0DA:productID":"","footnotes":""},"categories":[159],"tags":[24,34,33],"class_list":["post-326","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-learn-mysql","tag-cbse","tag-cs-coaching","tag-ip-coaching"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Comprehensive MySQL Practice Worksheet for CBSE Class 11th &amp; 12th: Mastering DDL, DML, TCL, and SQL Functions - Itxperts<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Comprehensive MySQL Practice Worksheet for CBSE Class 11th &amp; 12th: Mastering DDL, DML, TCL, and SQL Functions - Itxperts\" \/>\n<meta property=\"og:description\" content=\"MySQL is an essential part of the Class 11th and 12th CBSE Computer Science curriculum. Mastering MySQL enables students to manage and interact with databases effectively, a skill highly valued in programming and data management. This worksheet is designed to give CBSE students hands-on practice with MySQL operations, including Data Definition Language (DDL), Data Manipulation [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/\" \/>\n<meta property=\"og:site_name\" content=\"Itxperts\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/itxperts.co.in\" \/>\n<meta property=\"article:published_time\" content=\"2024-10-11T03:49:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-27T10:47:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2024\/10\/mysql.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1792\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"@mritxperts\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"@mritxperts\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/\"},\"author\":{\"name\":\"@mritxperts\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/#\/schema\/person\/77ad4d47f9f82583ee23e37010a52fc6\"},\"headline\":\"Comprehensive MySQL Practice Worksheet for CBSE Class 11th &amp; 12th: Mastering DDL, DML, TCL, and SQL Functions\",\"datePublished\":\"2024-10-11T03:49:30+00:00\",\"dateModified\":\"2024-10-27T10:47:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/\"},\"wordCount\":483,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2024\/10\/mysql.webp\",\"keywords\":[\"CBSE\",\"CS Coaching\",\"IP Coaching\"],\"articleSection\":[\"Learn MySQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/\",\"url\":\"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/\",\"name\":\"Comprehensive MySQL Practice Worksheet for CBSE Class 11th &amp; 12th: Mastering DDL, DML, TCL, and SQL Functions - Itxperts\",\"isPartOf\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2024\/10\/mysql.webp\",\"datePublished\":\"2024-10-11T03:49:30+00:00\",\"dateModified\":\"2024-10-27T10:47:14+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/#primaryimage\",\"url\":\"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2024\/10\/mysql.webp\",\"contentUrl\":\"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2024\/10\/mysql.webp\",\"width\":1792,\"height\":1024},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/itxperts.co.in\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Comprehensive MySQL Practice Worksheet for CBSE Class 11th &amp; 12th: Mastering DDL, DML, TCL, and SQL Functions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/#website\",\"url\":\"https:\/\/itxperts.co.in\/blog\/\",\"name\":\"Itxperts\",\"description\":\"Leading Website Design Company in Madhya Pradesh\",\"publisher\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/#organization\"},\"alternateName\":\"Itxperts | Website Development in Madhya Pradesh\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/itxperts.co.in\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/#organization\",\"name\":\"Itxperts\",\"alternateName\":\"Leading Website Design Company in Madhya Pradesh \u2013 Itxperts\",\"url\":\"https:\/\/itxperts.co.in\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/05\/cropped-itxperts_logo.png\",\"contentUrl\":\"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/05\/cropped-itxperts_logo.png\",\"width\":512,\"height\":512,\"caption\":\"Itxperts\"},\"image\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/itxperts.co.in\",\"https:\/\/www.linkedin.com\/company\/itxpertsshivpuri\/\",\"https:\/\/www.instagram.com\/itxperts.co.in\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/#\/schema\/person\/77ad4d47f9f82583ee23e37010a52fc6\",\"name\":\"@mritxperts\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/702cffafd84d85872c0d42d33a9fa39140418d7c60a1311a1f8f55b005d0570b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/702cffafd84d85872c0d42d33a9fa39140418d7c60a1311a1f8f55b005d0570b?s=96&d=mm&r=g\",\"caption\":\"@mritxperts\"},\"description\":\"I am a full-stack web developer from India with over 8 years of experience in building dynamic and responsive web solutions. Specializing in both front-end and back-end development, I have a passion for creating seamless digital experiences. When I'm not coding, I enjoy sharing insights and tutorials on the latest web technologies, helping fellow developers stay ahead in the ever-evolving tech landscape.\",\"sameAs\":[\"https:\/\/itxperts.co.in\/blog\"],\"url\":\"https:\/\/itxperts.co.in\/blog\/author\/mritxpertsgmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Comprehensive MySQL Practice Worksheet for CBSE Class 11th &amp; 12th: Mastering DDL, DML, TCL, and SQL Functions - Itxperts","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/","og_locale":"en_US","og_type":"article","og_title":"Comprehensive MySQL Practice Worksheet for CBSE Class 11th &amp; 12th: Mastering DDL, DML, TCL, and SQL Functions - Itxperts","og_description":"MySQL is an essential part of the Class 11th and 12th CBSE Computer Science curriculum. Mastering MySQL enables students to manage and interact with databases effectively, a skill highly valued in programming and data management. This worksheet is designed to give CBSE students hands-on practice with MySQL operations, including Data Definition Language (DDL), Data Manipulation [&hellip;]","og_url":"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/","og_site_name":"Itxperts","article_publisher":"https:\/\/www.facebook.com\/itxperts.co.in","article_published_time":"2024-10-11T03:49:30+00:00","article_modified_time":"2024-10-27T10:47:14+00:00","og_image":[{"width":1792,"height":1024,"url":"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2024\/10\/mysql.webp","type":"image\/webp"}],"author":"@mritxperts","twitter_card":"summary_large_image","twitter_misc":{"Written by":"@mritxperts","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/#article","isPartOf":{"@id":"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/"},"author":{"name":"@mritxperts","@id":"https:\/\/itxperts.co.in\/blog\/#\/schema\/person\/77ad4d47f9f82583ee23e37010a52fc6"},"headline":"Comprehensive MySQL Practice Worksheet for CBSE Class 11th &amp; 12th: Mastering DDL, DML, TCL, and SQL Functions","datePublished":"2024-10-11T03:49:30+00:00","dateModified":"2024-10-27T10:47:14+00:00","mainEntityOfPage":{"@id":"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/"},"wordCount":483,"commentCount":0,"publisher":{"@id":"https:\/\/itxperts.co.in\/blog\/#organization"},"image":{"@id":"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2024\/10\/mysql.webp","keywords":["CBSE","CS Coaching","IP Coaching"],"articleSection":["Learn MySQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/","url":"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/","name":"Comprehensive MySQL Practice Worksheet for CBSE Class 11th &amp; 12th: Mastering DDL, DML, TCL, and SQL Functions - Itxperts","isPartOf":{"@id":"https:\/\/itxperts.co.in\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/#primaryimage"},"image":{"@id":"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2024\/10\/mysql.webp","datePublished":"2024-10-11T03:49:30+00:00","dateModified":"2024-10-27T10:47:14+00:00","breadcrumb":{"@id":"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/#primaryimage","url":"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2024\/10\/mysql.webp","contentUrl":"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2024\/10\/mysql.webp","width":1792,"height":1024},{"@type":"BreadcrumbList","@id":"https:\/\/itxperts.co.in\/blog\/comprehensive-mysql-practice-worksheet-for-cbse-class-11th-12th-mastering-ddl-dml-tcl-and-sql-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/itxperts.co.in\/blog\/"},{"@type":"ListItem","position":2,"name":"Comprehensive MySQL Practice Worksheet for CBSE Class 11th &amp; 12th: Mastering DDL, DML, TCL, and SQL Functions"}]},{"@type":"WebSite","@id":"https:\/\/itxperts.co.in\/blog\/#website","url":"https:\/\/itxperts.co.in\/blog\/","name":"Itxperts","description":"Leading Website Design Company in Madhya Pradesh","publisher":{"@id":"https:\/\/itxperts.co.in\/blog\/#organization"},"alternateName":"Itxperts | Website Development in Madhya Pradesh","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/itxperts.co.in\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/itxperts.co.in\/blog\/#organization","name":"Itxperts","alternateName":"Leading Website Design Company in Madhya Pradesh \u2013 Itxperts","url":"https:\/\/itxperts.co.in\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/itxperts.co.in\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/05\/cropped-itxperts_logo.png","contentUrl":"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/05\/cropped-itxperts_logo.png","width":512,"height":512,"caption":"Itxperts"},"image":{"@id":"https:\/\/itxperts.co.in\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/itxperts.co.in","https:\/\/www.linkedin.com\/company\/itxpertsshivpuri\/","https:\/\/www.instagram.com\/itxperts.co.in\/"]},{"@type":"Person","@id":"https:\/\/itxperts.co.in\/blog\/#\/schema\/person\/77ad4d47f9f82583ee23e37010a52fc6","name":"@mritxperts","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/itxperts.co.in\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/702cffafd84d85872c0d42d33a9fa39140418d7c60a1311a1f8f55b005d0570b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/702cffafd84d85872c0d42d33a9fa39140418d7c60a1311a1f8f55b005d0570b?s=96&d=mm&r=g","caption":"@mritxperts"},"description":"I am a full-stack web developer from India with over 8 years of experience in building dynamic and responsive web solutions. Specializing in both front-end and back-end development, I have a passion for creating seamless digital experiences. When I'm not coding, I enjoy sharing insights and tutorials on the latest web technologies, helping fellow developers stay ahead in the ever-evolving tech landscape.","sameAs":["https:\/\/itxperts.co.in\/blog"],"url":"https:\/\/itxperts.co.in\/blog\/author\/mritxpertsgmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/posts\/326","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/comments?post=326"}],"version-history":[{"count":1,"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/posts\/326\/revisions"}],"predecessor-version":[{"id":328,"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/posts\/326\/revisions\/328"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/media\/327"}],"wp:attachment":[{"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/media?parent=326"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/categories?post=326"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/tags?post=326"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}