MySQL SQL Revision Tour
Introduction Relational Model Terminology MySQL – DDL and DML Commands
Database Querying using SQL – Functions, Join and Set Operation
Topics Covered: Functions – Introduction MySQL Single Row Functions Mathematical Functions String / Text Functions Date & Tiime Functions MySQL Aggregate Functions AVG() COUNT() MAX() MIN() SUM() . Functions – Introduction My SQL function performs a pre-defined task and returns a single value such as a numerical, string, or date/time value. Functions operate on zero,
Database Querying using SQL – Functions, Join and Set Operation Read More »
Introduction to Computer Network and types of network
Topics Covered Computer Network – Introduction, Data Communication, Needs of Computer Networks, Advantages & Disadvantages of Network, Network Terminology, Node, Workstation, Server, Types of Server, Dedicated and Non-Dedicated Server, NIC, MAC Address, and IP Address Types of network: LAN, MAN, WAN, PAN, LAN vs WAN Networking Devices: Modem, Hub, Repeater, Switch, Bridge, Gateway Network Topology:
Introduction to Computer Network and types of network Read More »
Introduction to Internet and Web
Topics covered : Introduction to Internet, URL, WWW, and its applications- Web, email, Chat, VoIP Website: Introduction, the difference between a website and webpage, static vs dynamic web page, web server, and hosting of a website. Web Browsers: Introduction, commonly used browsers, browser settings, add-ons, and plug-ins, cookies Internet – Introduction and Web Services What
Societal Impacts
Topics: Introduction Digital Footprints Digital Society and Netizen Data Protection Creative Commons Cyber Crime Indian Information Technology Act (IT Act) E-waste: Hazards and Management Impact on Health Digital Footprint Whenever you go online you leave behind information about yourself. This is known as Digital Footprint. Digital footprint or digital shadow or cyber shadows refers to
Terms and Conditions
Terms and Conditions Welcome to mycsturial.in! These terms and conditions outline the rules and regulations for the use of mycsturial.in Website, located at https://mycstutorial.in By accessing this website we assume you accept these terms and conditions. Do not continue to use Mycsturial.in if you do not agree to take all of the terms and conditions
Disclaimer
Disclaimer for mycsturial.in If you require any more information or have any questions about our site’s disclaimer, please feel free to contact us by email at info.mycstutorial@gmail.com Disclaimers for Mycsturial.in All the information on this website – www.mycstutorial.in – is published in good faith and for general information purpose only. Mycsturial.in does not make any warranties about
Privacy Policy
Privacy Policy for mycsturial.in At mycsturial.in, accessible from, one of our main priorities is the privacy of our visitors. This Privacy Policy document contains types of information that is collected and recorded by mycsturial.in and how we use it. If you have additional questions or require more information about our Privacy Policy, do not
Class 12 Informatics Practical File
Index Practical’s of IP Pr. No. Practical’s Name / Description Page. No. 1. Write python code to find out the biggest and smallest three items from the given Series. The series Area has been created like:- Area = pd.Series([3659,858,9659,78965,34568, 12456, 6935, 25649, 85214, 9645,3695] 2. Write python code to find out the areas that
Class 12 Informatics Practices Practical File
Index Pr. No. Practical’s Name / Description Page. No. 1. Write a program to create a Series object using a dictionary that stores the number of students in each section of class 12 in your class. 2. Write a program to create a Series object using individual vowel characters. 3. Write
Term Wise Syllabus of CBSE Class 11 Information Technology (802) 2021-2022
CBSE | DEPARTMENT OF SKILL EDUCATION CURRICULUM FOR SESSION 2021-2022 INFORMATION TECHNOLOGY (SUB. CODE – 802) CLASS XI 2021-22 (TERM WISE) JOB ROLE: DOMESTIC IT HELPDESK ASSISTANT CLASS – XI & XII The present course curriculum offers an opportunity for students to understand the basics of computer software and hardware for working efficiently on computer.
Term Wise Syllabus of CBSE Class 11 Information Technology (802) 2021-2022 Read More »
Syllabus of Information Technology of Class 12
CBSE | DEPARTMENT OF SKILL EDUCATION CURRICULUM FOR SESSION 2020-2021 INFORMATION TECHNOLOGY(SUB.CODE-802) JOB ROLE: DOMESTIC IT HELPDESK ASSISTANT CLASS – XII (SESSION 2021-2022) CBSE | DEPARTMENT OF SKILL EDUCATION CURRICULUM FOR SESSION 2021-2022 INFORMATION TECHNOLOGY (SUB. CODE – 802) JOB ROLE: DOMESTIC IT HELPDESK ASSISTANT CLASS – XI & XII The present course curriculum offers
Deleted Syllabus of Computer Science of Class 12
DEDUCTED COMPUTER SCIENCE – 083 CLASS – XII Unit I: Computational Thinking and Programming – 2 Recursion – simple algorithms with recursion : print a message forever, sum of first n natural numbers, factorial, Fibonacci numbers, recursion on arrays : binary search Idea of efficiency : performance measurement in terms of the number of
Deleted Syllabus of Computer Science of Class 12 Read More »
Deleted Syllabus of Computer Science of Class 11
DEDUCTED COMPUTER SCIENCE – 083 CLASS XI Topic reduced Unit I: Computer Systems and Organisation Encoding Schemes : UTF8, UTF32 Concept of cloud computing and cloud services (SaaS,IaaS, PaaS),cloud (public/private), Blockchain technology Unit II: Computational Thinking and Programming – 1 Decomposition – concept, need for decomposing a problem, examples of problem-solving using
Deleted Syllabus of Computer Science of Class 11 Read More »
Revised Syllabus of Computer Science Class 12
Revised Syllabus Computer Science CLASS-XII Code No. 083 2020-21 Prerequisites Computer Science- Class XI Distribution of Marks: Unit No. Unit Name Theory Marks Theory Periods Practical Periods I Computational Thinking and Programming – 2 40 50 30 II Computer Networks 10 10 — III Database Management 20 20 10 Total 70
Computer Science Class 11 Revised Syllabus
Computer Science(Revised)CLASS-XICode No. 0832020-21 Distribution of Marks Unit No. Unit Name Theory Marks Theory Periods Practical Periods I Computer Systems and Organisation 10 10 5 II Computational Thinking and Programming – 1 45 50 35 III Society, Law and Ethics 15 20 —- Total 70 80 40 Unit I: Computer Systems and Organisation Basic
Deleted Syllabus of class 12 Informatics Practices
DEDUCTED PORTIONInformatics Practices – 065Class XII Unit-1 Data handling using Pandas – IIDescriptive Statistics: max, min, count, sum, mean, median, mode, quartile, Standarddeviation, variance.Data Frame operations: Aggregation, group by, Sorting, Deleting and Renaming Index,Pivoting.Handling missing values – dropping and filling.Importing/Exporting Data between MySQL database and Pandas.Data Visualization, pie chart, frequency polygon, box plot and scatter
Deleted Syllabus of class 12 Informatics Practices Read More »
Deleted Syllabus of class 11 Informatics Practices
DEDUCTED PORTIONInformatics Practices – 065Class XI Unit 3: Data Handling using NumPyData and its purpose, importance of data, structured and unstructured data, data processingcycle, basic statistical methods for understanding data – mean, median, mode, standarddeviation and variance.Introduction to NumPy library, NumPy arrays and their advantage, creation of NumPy arrays;indexing, slicing, and iteration; concatenating and splitting
Deleted Syllabus of class 11 Informatics Practices Read More »
XII Informatics Practices Syllabus
Informatics Practices CLASS XII Code No. 065 2020-2021 1. Prerequisite: Informatics Practices – Class XI 2. Learning Outcomes At the end of this course, students will be able to: Create Series, Data frames and apply various operations. Visualize data using relevant graphs. Design SQL queries using aggregate functions. Import/Export data between SQL database and
XI Informatics Practices Syllabus
Revised Syllabus Informatics Practices (2020-21) CLASS XI Code No. 065 Prerequisite. None Learning Outcomes At the end of this course, students will be able to: Identify the components of the computer system. Create Python programs using different data types, lists, and dictionaries. Understand database concepts and Relational Database Management Systems. Retrieve and
