Full Stack Python Developer Bootcamp: For Absolute Beginners

Learn to create a MySQL database from Python using PyMySQL, including connecting to localhost, creating the creative online school database, and building an owners table with id, name, and gender.

Connect to a MySQL database and load data from comma separated files into owners and pets tables using Python, with inserts, dot format, and commit to save changes.

Display database data in HTML tables using Python, build the HTML head and table, fetch owner data, render rows, and write the HTML output to a file.

Learn to create and manage a MySQL database in Python using a class-based approach. Define a data be class to initialize the database, add tables and elements, and view tables.

Explore database storage engines like CSV, ISAM, MyISAM, heap, and InnoDB, their tradeoffs for transactions, indexing, and speed, and learn to switch engines in phpMyAdmin and Workbench.

Explore table joining fundamentals and syntax, including inner, left, right, and full outer joins, and learn how to use the having clause with multiple joins.

Master multi-table joins across purchases, name, and product with aliases for clear results. Use the having clause to filter data by date after joins and refine results.

Sort query results with order by, including multiple fields in ascending or descending order. Apply arithmetic and string manipulation with plus, minus, multiply, divide, floor, ceil, concat, and substr.

Explore creating computed totals from product_id and name_id, filtering with having after a select, and calculating sum and avg using length checks on first name data.

Group by data to consolidate multiple rows into one per common value, then use max and sum in select to show most recent purchase date and total spend.

Learn to group by name.id to get each person's max date of purchase and total items, refine with having, and extend to per-product totals using subqueries.

Master subqueries and their benefits with basic examples that pull the most recent records, including using subqueries to obtain a product ID when a key is missing and join results.

Master subqueries to fetch the most recent purchase data with inner joins and subquery aliases, while handling null values using is null and is not null.

Discover how sequences drive auto incrementing IDs in MySQL and how transactions use start transaction, commit, and rollback to keep multi-step operations safe.

Compare traditional session based authentication with J.W., noting server storage, stateless design, and load reduction. See how J.W. enables horizontal scaling, flexible expiration, and cross-domain authentication with proper token handling.

Django rest framework enables rapid development with security, authentication, and session handling, plus seamless orm integration; it's extensible with serializers, viewsets, routers, throttling, pagination, and versioning for scalable multi-tenant architectures.

Explore how HTML works as a markup language, using tags to structure a web page, with opening and closing elements and hyperlinks to other pages and files.

Explore the evolution from HTML4 to HTML5, compare strict and transitional variants, and learn how HTML5 introduces video, audio, header, nav, canvas, and geolocation features that reduce plugins.

Create your first html page using a simple text editor, save as index.html, and test locally in a browser to see basic html tags and bold text.

Explore free and low-cost HTML editors, including Sublime Text, Brackets, and Dreamweaver, and learn how to edit, save, and preview web pages across platforms.

Explore the anatomy of a basic HTML page, compare HTML4 and HTML5 doctypes, and show how the head and body, title, meta, and index.html demonstrates external CSS and JavaScript.

Use the HTML paragraph tag with opening and closing p elements to create separate paragraphs, illustrated with El Ipsum Greek copy in the browser.

Apply break tags to force a line break within a paragraph, using br as a self-contained tag (no closing tag), creating a soft return without extra paragraph spacing.

Learn how header tags format text in HTML and boost SEO by using h1 through h4 to place keywords effectively, with best practices like one h1 per page.

Learn to style text with bold and italic tags in HTML, comparing bold versus strong and i versus em, and understand accessibility considerations for screen readers and best practices.

Learn to create and convert unordered and ordered lists in HTML, using ul, ol, and li tags, with practical examples of bulleted and numbered lists and proper markup.

Explore the difference between relative and absolute links in HTML, including linking images and pages, and how folder placement affects link reliability.

Learn hyperlinking with the HTML anchor tag to connect pages and external sites. Use href for absolute or relative links, and target _blank to open pages in a new tab.

Discover how to create email hyperlinks in html using mailto:, opening the user’s email client with the address in the to field. Explore behavior when the user’s email setup differs.

learn how to hyperlink to a file with the a href tag, linking to a pdf or zip in the same directory or a subfolder, and open in blank window.

Learn to embed audio and video with HTML5, using the audio and video tags and multiple sources (mp4, mp3, ogg) with controls for cross-browser playback.

Embed video in your HTML page with the video tag, using mp4 or ogg sources and adding controls, autoplay, and loop while setting width, height, and preload options.

Explore CSS fundamentals with an experienced instructor, confirming you have a basic HTML understanding and an HTML editor to build a small website.

Discover how CSS styles websites by controlling fonts, colors, and layout alongside HTML, without programming. Learn cascading stylesheets and external files that streamline updates across multiple pages.

Discover CSS3's major upgrades, including mobile-first responsive design with media queries, module-based coding, web font support, and 2D/3D transformations, animations, and transitions.

Explore how CSS selectors target elements on a page, from basic id, class, and element selectors to more advanced options introduced in CSS3, helping you define and target page parts.

Discover how id selectors define areas with the # symbol in CSS, and ensure the same id name is used in both HTML and CSS.

Learn how class selectors style small page areas and define columns, text areas, and image interactions, reused within a page, with meaningful names like purple button or half column.

Target html tags with element selectors by applying classes directly to tags like p, without periods or hashes, and use them alongside class or id selectors for flexibility across pages.

Explore how the universal all selector resets default HTML styles by removing margins and padding to prevent conflicts, using a dedicated CSS file before styling with id and class selectors.

Learn how to implement internal style sheets in HTML by placing styles in the head, creating a class, and applying it to paragraphs to control font family, size, and color.

Learn how to use an external style sheet to style multiple web pages by linking a single styles.css file in the HTML header, enabling centralized updates.

Learn how inline styles fit within the CSS hierarchy, comparing internal, external, and inline styles, and see how inline styles overwrite external and internal rules on a single element.

Master the CSS box model and how width, border, padding, and margins shape page elements. See how style sheets use pixels and hex colors, and differentiate padding from margin.

Learn how jQuery, a framework of pre-written JavaScript, simplifies cross-browser tasks, speeds websites by using a single file, and enables HTML/CSS manipulation, animation, Ajax, and practical projects.

Take a first look at jQuery code by linking the library and using the dollar sign to select the document. Run a ready callback to append HTML to the body.

Learn to use jQuery selectors and filters to edit html and css, targeting specific elements like the first or last h1 tags and applying borders and styles.

Learn how to replace content on the page using jQuery by targeting classes or IDs, creating a text box, and appending new text.

Learn to handle browser events with jQuery by wiring on click and mouse leave on a styled text box, updating its HTML with dynamic messages such as you clicked me.

Learn to implement show and hide interactions using jQuery, toggle a text box with click events, and apply a simple CSS display none approach.

Explore creating a hover effect with jQuery by toggling a highlight class on hover, applying text and background styling, and tweaking CSS for responsive hover behavior.

Learn to create jQuery fading effects by fading a text box in and out on click, using IDs and durations in milliseconds (e.g., 3000 ms), with alerts signaling completion.

learn how to use jQuery to slide text up and down, hiding and revealing it with click actions, including slide up, slide down, and slide toggle on a text box.

Learn how to use jQuery to toggle a text box on click, hiding and showing with a four-second swing animation.

Explore practical jQuery animation techniques by applying the animate function to multiple elements, including grow, move, bigger, and many things, with CSS-like properties and durations.

Learn how to use jQuery selectors to target HTML elements by tag, class, and ID, and apply CSS-like styles such as borders to paragraphs.

Discover how jQuery filters target specific paragraphs within a container, using first, last, even, and odd selectors, and apply on-the-fly CSS such as borders and gray backgrounds.