Database Management System (DBMS)

Advertisements

Topics

  • Exceptional Handling in Python
    • Introduction of Exception Handling in Python
    • Syntax Errors
    • Exceptions
    • Built-in Exceptions
    • Raising Exceptions
    • Handling Exceptions
    • Finally Clause
    • Types of Function
    • Creating User Defined Function
    • Arguments and Parameters
    • Default Parameters
    • Positional Parameters
    • Function Returning Values
    • Flow of Execution
    • Scope of a Variable
    • Class 11 Revision
  • Object Oriented Programming with Python
    • Concept of Object Oriented Programming with Python
    • Data Hiding in Python
    • Data Encapsulation in Python
    • Class and Object in Python
    • Polymorphism in Python
    • Inheritance in Python
    • Advantages of Object Oriented Programming Over Earlier Programming Methodologies in Python
    • Defining Classes (Attributes, Methods)
    • Creating Instance Objects
    • Accessing Attributes and Methods
    • Using Built in Class Attributes (Dict, Doc, Name, Module, Bases)
    • Constructor(_Init()_ _, _ _Del()_ _ and _ _ Str()_ _) Methods in a Class
    • Private Attributes (Limited Support)
    • Importance of "Self" (Acts as a Pointer to Current Calling Object) Operator Overloading with Methods
    • Concept of Base Class and Derived Class
    • Single, Multilevel and Multiple Inheritance
    • Overriding Methods
    • Using Super() in Derived Class to Invoke _ _Init()_ _ Or Overridden Methods of Parent Class
  • Unit 1: Computational Thinking and Programming
  • File Handling in Python
    • Introduction to Files
    • Types of Files in Python
    • Types of Path in Python
    • Opening and Closing a Text Files
    • Text File Open Modes
    • Writing to a Text File
    • Reading from a Text File
    • Setting Offsets in a File
    • Creating and Traversing a Text File (Data Manipulation)
    • The Pickle Module
    • Opening and Closing a Binary File in Python
    • Binary File Open Modes
    • Writing to a Binary File
    • Reading from a Binary File
    • Appending in a Binary Files
    • Searching a Binary File
    • Update Operations in a Binary File
    • Import CSV Module
    • Opening and Closing a CSV File in Python
    • Read and Write a CSV File Using Python
  • Unit 2: Database Management
  • Advance Programming with Python
    • Linear List Manipulation
    • Sequential Allocation
    • Traversal
    • Insertion of an Element in a Sorted List
    • Deletion of an Element from the List
    • Searching (Linear, Binary)
    • Sorting (Insertion, Selection, Bubble)
    • Introduction to Stack in Python (LIFO Operations)
    • Operations on Stack (PUSH and POP) and Its Implementation in Python
    • Converting Expressions from INFIX to POSTFIX Notation and Evaluation of Postfix Expression in Python
    • Queues (List Implementation)
    • Introduction to Queue in Python (FIFO)
    • Operations on Queue (INSERT and DELETE) and Its Implementation in Python
    • Need for Data File in Python
    • Types of Files in Python
    • Opening and Closing a Text Files
    • Access Modes (Output, Input, Default)
    • File Object
    • Reading and Writing a File - Read(), Readline(), Readlines(), Write(), Writelines
    • File Positions (Seek(), Tell())
    • Renaming and Deleting a File.,Flush()
    • Searching for Particular Data from a File
    • Insertion and Deletion of Data from an Already Existing File
    • Modification of Data in File
    • Error and Exceptions - NameError, IndexError, TypeError, IO Error, ImportError, ValueError, EOFError
    • Generator Function Using Yield
  • Unit 3: Computer Networks
  • Stack
    • Stack
    • Operations on Stack
    • Implementation of Stack in Python
    • Notations for Arithmetic Expressions
    • Conversion from Infix to Postfix Notation
    • Evaluation of Postfix Expression
  • Python - Databases and SQL
  • Python - Boolean Algebra
    • Binary-valued Quantities
    • Boolean Variable
    • Boolean Constant and Boolean Operators - AND, OR, NOT
    • Truth Tables (Boolean Algebra)
    • Closure Property
    • Commutative Law
    • Associative Law
    • Identity Law
    • Inverse Law
    • Principle of Duality
    • Idempotent Law
    • Distributive Law
    • Absorption Law
    • Involution Law
    • DeMorgan’S Law/Theorem and Their Applications
    • Obtaining Sum of Product (SOP) and Product of Sum (POS) Form the Truth Table
    • Reducing Boolean Expression (SOP and POS) to Its Minimal Form
    • Use of Karnaugh Map for Minimization of Boolean Expressions (Up to 4 Variables)
    • Application of Boolean Logic - Digital Electronic Circuit Design Using Basic Logic Gates (NOT, AND, OR, NAND, NOR)
    • Use of Boolean Operators (NOT, AND, OR) in SQL SELECT Statements
    • Use of Boolean Operators (AND, OR) in Search Engine Queries
  • Queue
    • Introduction to Queue in Python (FIFO)
    • Operations on Queue
    • Implementation of Queue Using Python
    • Introduction to Deque
    • Implementation of Deque Using Python
  • Project
  • Python - Communication Technologies
    • Evolution of Networking
    • ARPANET
    • Internet
    • Interspace Different Ways of Sending Data Across the Network with Reference to Switching Techniques (Circuit and Packet Switching)
    • Data Communication Terminologies
    • Concept of Channel
    • Bandwidth (Hz, KHz, MHz) and Data Transfer Rate (Bps, Kbps, Mbps, Gbps, Tbps)
    • Twisted Pair Cable
    • Coaxial Cable
    • Optical Fiber
    • Infrared
    • Radio Link
    • Microwave Link
    • Satellite Link
    • Network Devices
    • Networking Topologies
    • Network Protocol - TCP/IP (Transmission Control Protocol/Internet Protocol)
    • Network Protocol - FTP (File Transfer Protocol)
    • Network Protocol - Point to Point Protocol (PPP)
    • Network Protocol - SMTP (Simple Mail Transfer Protocol)
    • Network Protocol - POP3 Remote Login (Talent)
    • Internet Wireless/Mobile Communication Protocol - GSM, CDMA, GPRS, and WLL
    • Mobile Telecommunication Technologies
    • Mobile Processors
    • Electronic Mail Protocols Such as SMTP, POP3
    • Protocols for Chat and Video Conferencing VOIP
    • Wireless Technologies Such as Wi-Fi and WiMax
    • Network Threats and Its Prevention
    • Cookies
    • Protection Using Firewall
    • https
    • India IT Act
    • Cyber Law
    • Cyber Crimes
    • IPR Issues
    • Hackers and Crackers (Hacking)
    • World Wide Web (WWW)
    • Hyper Text Markup Language (HTML)
    • Extensible Markup Language (XML)
    • Hyper Text Transfer Protocol (HTTP)
    • Network Protocol – DNS (Domain Name System)
    • Uniform Resource Locator (URL)
    • Website
    • Web Browser
    • Web Servers
    • Web Hosting
    • Web Scripting - Client Side (VB Script, Java Script, PHP)
    • Server Side (ASP, JSP, PHP)
    • Web 2.0 (For Social Networking)
    • E-commerce Payment Transactions Using Online Banking
    • Mobile Banking and Payment Apps and Services
  • Sorting
    • Introduction of Sorting
    • Bubble Sort
    • Selection Sort
    • Insertion Sort
    • Time Complexity of Algorithms
  • Searching
    • Introduction of Searching
    • Linear Search
    • Binary Search
    • Search by Hashing
  • Understanding Data
    • Introduction to Data
    • Importance of Data
    • Types of Data
    • Data Collection
    • Data Storage
    • Data Processing
    • Statistical Techniques for Data Processing
    • Measures of Central Tendency for Data Processing
    • Measures of Variability
  • Database Concepts
    • Introduction to Database Concepts
    • File System
    • Limitations of a File System
    • Database Management System (DBMS)
    • Applications of DBMS
    • File System to Database Management System (DBMS)
    • Key Concepts in Database Management System (DBMS)
    • Relational Data Model
    • Terminologies in Relational Data Model
    • Properties of a Relational Data Model
    • Keys in a Relational Database
  • Structured Query language (SQL)
    • Introduction of Structured Query Language (SQL)
    • Structured Query Language (SQL)
    • Data Types and Constraints in MySQL
    • SQL for Data Definition
    • SQL for Data Manipulation
    • SQL for Data Query
    • Data Updation and Deletion
    • Functions in SQL
    • GROUP BY Clause in SQL
    • Operations on Relations
    • Using Two Relations in Query
    • Connecting SQL with Python
    • Performing Insert, Update, Delete Queries Using Cursor
    • Display Data by Using Fetchone(), Fetchall(), Rowcount
    • Creating Database Connectivity Applications
  • Computer Networks
    • Introduction to Computer Networks
    • Evolution of Networking
    • Types of Computer Networks
    • Network Devices
    • Networking Topologies
    • Types of Networking Topologies
    • Identifying Nodes in a Networked Communication
    • Internet, Web and the Internet of Things
    • Network Protocol – DNS (Domain Name System)
    • Hyper Text Markup Language (HTML)
    • Extensible Markup Language (XML)
    • Website
    • Web Browser
    • Web Servers
    • Web Hosting
    • Uniform Resource Locator (URL)
  • Data Communication
    • Concept of Data Communication
    • Components of Data Communication
    • Measuring Capacity of Communication Media
    • Types of Data Communication
    • Switching Techniques
    • Transmission Media
    • Transmission Media
    • Mobile Telecommunication Technologies
    • Network Protocol
    • Network protocols - HTTP (HyperText Transfer Protocol)
    • Network Protocol - FTP (File Transfer Protocol)
    • Network Protocol - Point to Point Protocol (PPP)
    • Network Protocol - SMTP (Simple Mail Transfer Protocol)
    • Network Protocol - TCP/IP (Transmission Control Protocol/Internet Protocol)
  • Security Aspects
    • Network Threats and Its Prevention
    • Malware
    • Antivirus
    • Spam
    • HTTP vs HTTPS
    • Protection Using Firewall
    • Cookies
    • Hackers and Crackers (Hacking)
    • Network Security Threats
  • Project Based Learning
    • Introduction of Project Based Learning
    • Approaches for Solving Projects
    • Teamwork
    • Components of Teamwork
    • Project Description
  • Introduction to DBMS
  • Evolution of DBMS
  • DBMS Concepts
  • Characteristics of Database Management System
  • Advantages of DBMS
  • Components of DBMS
If you would like to contribute notes or other learning material, please submit them using the button below.

Shaalaa.com | Database Management System: Basics

Shaalaa.com


Next video


Shaalaa.com


Database Management System: Basics [00:04:21]
S
Series:
0%


Advertisements
Share
Notifications



      Forgot password?
Use app×