Simple Queries in SQL – Notes
Coming Soon
SQL Functions , Grouping Records, Joins in SQL – Notes
SQL Functions – Single Row and Aggregate Group By , Having clause Joins in SQL Functions in SQL Function is used to perform some particular task and it returns zero or more values as a result. Functions can be applied to work on single or multiple records (rows) of a table. Depending on their application
SQL Functions , Grouping Records, Joins in SQL – Notes Read More »
Interface Python with Mysql – Notes
Real world application needs to manipulate data stored in the database through an application designed, by using any programming language like Python, Java, etc. vIn order to connect to a database from within Python or any other programming language, we need a Driver or Connector library or Interface. vIn case of Python we can use
Society, Law, and Ethics: Societal Impacts – Notes
Societal Impacts Topics: Digital Footprint: Whenever we surf the Internet using smartphones, tablets, computers, etc., we leave a trail of data reflecting the activities performed by us online, which is our digital footprint. Our digital footprint can be created and used with or without our knowledge. It includes websites we visit, emails we send, and
Society, Law, and Ethics: Societal Impacts – Notes Read More »
Data Handling Using Pandas – I
Python Library Data Structure in Pandas – Series Creation of Series Using Sequence Using Scalar Value Using NumPy Array Using Dictionary Using Additional Features Series Attributes & Methods Accessing, Selecting, Slicing & Updating Series Series Mathematical Operation drop( ) and reindex( ) What are Python Libraries Python libraries contain a collection of built-in modules that
Data Handling Using Pandas – II
Data Handling using Pandas – IIIntroductionDescriptive StatisticsData Aggregations Sorting a DataFrameGroup by FunctionsAltering the IndexOther DataFrame OperationsHandling Missing Values
Plotting Data using Pyplot of Matplotlib
IntroductionPlotting using MatplotlibCustomization of PlotsThe Pandas Plot Function (Pandas Visualisation)
Import and Export Data between CSV/MySQL and Pandas
Import and Export Data between CSV Files and DataFrames Import and Export Data between MySQL Files and DataFrame
Import and Export Data between CSV/MySQL and Pandas Read More »
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 »
