Python With MySQL

Python With MySQL course is offered by Webbird Software Institute. Webbird Software Institute is the best IT training institute in Delhi NCR, which provides various programs and courses at an affordable cost. We are known for our excellence, quality, and consistency. We have well-qualified and experienced faculties in various streams.

Course Content:

• Python Programming
• Define Python, Introduction
• Installation, Syntax
• Identifier, Keyword
• Operators (Arithmetic, Relational, Logical, Assignment, String, Ternary)
• Comments, Variables, Data Types
• Decision Making (if, if-elif, nested-if)
• Loops (for, while)
• Jumping Statements (break, continue, pass), Variable Scope
• List, Tuples, Sets, Dictionary
• Arrays (1D, 2D), Sorting
• Functions (Arrays, Date, String, Math)
• User-Defined Functions, Recursive
• Modules (Build-In, User-Defined)
• Function using position argument, keyword argument, variable length
• File Handling (Create, Read, Write, Checking, Rename, Delete)
• Working with Directory
• Exception Handling (try, except, finally)
• Assignments
• MySQL
• MySQL Introduction
• Create Database, table
• Constraints, Data types
• Insert, Select, OrderBy, Top
• Distinct, Update, Delete, Drop
• Alter table, Constraints
• Joins (Inner, Left, Right, Full, Cross)
• Functions (Aggregate, String, Date)
• Python - MySQL Connectiviy
• Project
• CSS3 (Cascading Style Sheet)
• CSS Intro, Types, Selectors
• Comment, Font, Background
• Color (Hex Codes, RGB, RGA, HSL, HSLA), Gradient (Linear, Radial)
• Box Model (Border, Padding, Margin,)
• Box sizing, Box Shadow, Stying Navbar
• Visibility, Float, Clear
• Display (None, Inline, Block, Grid, Flexbox)
• Position (Static, Absolute, Relative, fixed, Sticky)
• Google Font, Map,
• Combinators (Descendant Selector, Child Selector, Gereral Sibling Selector, Adjacent Sibling Selector)
• Pseudo Classes and Pseudo Elements, 2D, 3D Transform, Animation, Creating different shapes
• Question-Answer
• Bootstrap5
• Introduction, Download Bootstrap
• Grid System, Typography
• Colors, Table, Images,
• Buttons, Button Group, Pagination
• Dropdown, Collapse, Accordian
• Progress bar, Spinner, Card
• Alert, Tooltip, Popover
• Toast, Modal, Carousel
• Nav, Tab, Pills, Navbar
• Bootstrap Offcanvas, Scrollspy
• Form, Form Validation, Custom Form
• Multiple Choice Questions
• Question & Answers
• Project
• Advance JavaScript
• Var, Let, Const variable
• Arrow function
• Objects, this, Map, Set
• Recursion and Stack
• Classes, Private and Protected
• Properties and Methods
• Inheritance, Instanceof
• Error Handling (try…catch)
• Promises, async/await
• Form controls (focus, blur)
• Form Validation
• Regular Expressions
• Assignments
• Question-Answers
• Advance Python with MySQL
• Arrays using NumPy
• Lambda, Filter, Map, Reduce function
• Reg Expressions
• Object-Oriented Programming System
• Classes, Objects, Classes Method,
• Nested Classes
• Constructor, Inheritance
• Operator Overloading
• Graphics – Tkinter
• Django – Python Framework
• Introduction, Installation
• MVT Structure, Apps Life Cycle
• URLs, Views, Dynamic URLs
• Templates, Static files
• Request Method – Get, Post
• Django Forms, Include, Extends
• Operators (Arithmetic, Relational)
• If - elif - else, Loops
• Models, SuperUser
• Sending E-mails
• Session, Cookies
• Form classes
• Validation, Authentication
• AutoSlugField, Pagination
• ImageUpload, File Upload
• Database Connectivity – CRUD
• Deploying Django framework
• Project
• HTML5 (HyperText Markup Language)
• Define HTML4, HTML5, Doctype
• Difference between HTML4 and HTML5
• HTML Page Structure, Body tag
• Heading, Paragraph, Hyperlink tags
• Image, List, Table, Iframe,
• Fieldset tags, Div, Span
• Header, Aside, Nav, Main, Section, Article, Figure Footer
• Form elements – label, text, checkbox, radio, select, datalist, file, range, number, color, date, time, button
• Form method, action
• Audio, Video, Embed Youtube Video
• HTML5 Semantic Elements
• Question & Answers
• JavaScript
• Define JavaScript
• Operators (Arithmetic, Relational, Logical, Assignment, Compound Assignment, Increment, Decrement)
• Internal, External JavaScript
• Comments, Variables, Data types
• Conditional Statements: (if, if-else, nested-if, switch)
• Popup Boxes: (Alert, Prompt, Confirm)
• User-Defined Functions
• Loops (for, while, do-while)
• Arrays, Arrays functions
• Events (Keyboard, Mouse, Load)
• Styling HTML Elements
• Document Object Model (DOM)
• Browser Object Model (BOM)
• Build-in Functions: (Math, String, Date)
• Random Function, Theme Change
• Assignments
• JQuery
• Define jQuery, How to use jQuery
• jQuery Methods, Selectors
• jQuery Event
• Manipulate CSS Style
• jQuery Traversing, Animation
• AJAX (Asynchronous JavaScript And XML)
• jQuery Plugins
• Assignments
• React JS
• Introduction, Installation
• Creating first React Application
• Architecture, Folder structure
• Components: Function, Class
• Styling, JSX, Refs
• Properties, Event Handling
• State management, setState
• HTTP Get, Post Request
• Building and Deployment
• Project