Full-Stack Web Development Certificate (NYC or Online)
- Difficulty
- Beginner
- Format
- Live or Self-paced
Choose how you learn
Compare formats, then explore the details for your choice.
Book directly on nobledesktop.com. Opens in a new tab.
Book live on Noble DesktopSummary
Learn to develop every aspect of a web application in this comprehensive program. You'll gain the skills to code both the front-end user experience and the back-end infrastructure, building interactive and dynamic websites from scratch.
- Front-End Development with HTML, CSS, & JavaScript: Learn how to design responsive web pages using HTML for structure, CSS for styling, and JavaScript to add interactive elements. Develop visually engaging, user-friendly websites that look great on all devices, from desktops to mobile screens.
- Build & Manage Full-Stack Web Applications: Use the MERN stack (MongoDB, Express.js, React, and Node.js) to build complete web applications. You'll learn to manage databases, handle server-side development, and create dynamic, data-driven web experiences.
- Deployment & Version Control: Discover how to deploy your web applications to the cloud using AWS and other platforms. You'll also gain expertise in Git for version control and collaborating with other developers, and learn the process behind tracking changes in your code.
- Hands-On Projects & Real-World Experience: Work on real-world projects throughout the program to build a portfolio of web applications that showcase your skills. Solve coding challenges that prepare you for the job market with opportunities to practice debugging, optimizing, and refining your skills.
Who this course is for
The Full-Stack Web Development Certificate is for individuals who want to code all parts of websites and web apps. This program is best suited for: Individuals looking to learn web development (both front end and back end). Anyone looking to start a career as a JavaScript Full Stack Developer. People who are technically oriented, enjoy working with computers, and want to have full command of building web apps and websites.
Topics included
Curriculum
What you'll learn
- Front-end responsive layouts with HTML and CSS
- Client-side JavaScript programming fundamentals (DOM manipulation)
- Client-side JavaScript libraries and frameworks (React.js)
- Node.js development to create web apps
- MongoDB for working with databases
- Express.js for API development
- Deployment to the cloud with AWS and alternate stacks
- Git to track changes in your code and collaborate with other developers
Course outline
-
Web Development with HTML & CSS 18 hours
Learn how to code webpages using HTML and CSS, from structuring and tagging content to styling and making the pages responsive. Upload and make your websites live using FTP.
- Start learning to build websites by hand-coding HTML and CSS
- Markup content (text, images, lists, links, etc.) using HTML (Hypertext Markup Language)
- Style the content using CSS (Cascading Style Sheets), setting font, size, color, spacing, width, and more
- Create multi-page websites with text, images, and more
- Adapt the layout for different screen sizes to create responsive webpages
- Use web browser developer tools to look behind the scenes and experiment with code changes
- Upload your website files using FTP to make the site live
-
Advanced HTML & CSS 18 hours
Take your CSS skills to the next level with this comprehensive training course. Learn about advanced topics such as SVG, CSS variables, gradients, shadows, positioning, transitions, transforms, responsive images, and more to help you code professional-looking webpages.
- Master important CSS concepts such as positioning, advanced CSS selectors, relative sizing units (px, em, rem), calc() and much more
- Learn sophisticated styling with multiple background images, transparent colors using RGBA, CSS gradients, shadows, and more
- Learn multiple ways to use and style SVG in webpages
- Code responsive images using img srcset and the picture element
- Learn CSS variables for cleaner, more flexible code
- Create mobile-optimized off-screen navigation menus using only CSS
- Create animated effects using CSS transitions and transforms
-
Flexbox, Grid, & Bootstrap 12 hours
Learn how to use CSS flexbox and grid to layout and align webpage content and make it adapt to different size screens. See how both of these newer CSS techniques are useful and when to use each. You’ll also learn how to use Bootstrap (which uses Flexbox) to build out layouts quickly.
- CSS Flexbox to lay out and align webpage content
- CSS Grid for an entirely new way to think about laying out entire webpages
- Use Bootstrap (which is made with Flexbox) to build out layouts quickly
- Learn how Flexbox and Grid change the way you approach webpage layout
- Size, position, align, and reorder content using Flexbox and Grid
-
Front-End Tools & Portfolio 18 hours
Learn how to turn a webpage design into code, track changes, collaborate with other developers using Git and GitHub, and increase your coding speed with Emmet and Visual Studio Code. Develop your portfolio with the guidance of an expert instructor and gain hands-on coding experience.
- Go from design to a coded website with guidance from an expert developer
- What Git is and how it works
- Installing and setting up Git to track changes in your code
- Using GitHub for collaboration with other developers
-
JavaScript for Front-End 18 hours
Learn how to make your webpages more dynamic and engaging with JavaScript and animations using GreenSock. From the fundamentals of JavaScript code to creating stunning animations with GSAP, this course will equip you with the skills to transform your web projects into complex, interactive designs.
- Write JavaScript code to add animation and interactivity to webpages
- Learn the fundamentals of the JavaScript language (variables, loops, arrays, functions, etc.)
- Understand how to use free pre-made JavaScripts to quickly add many different kinds of common functionality
- Create animated slideshows and build animated image enlargers
- Learn to animate any content within a webpage, including SVG, using GreenSock (GSAP)
-
JavaScript Programming Bootcamp 120 hours
Learn JavaScript programming essentials for creating web applications, including variables, conditional logic, functions, DOM manipulation, arrays, loops, async events, APIs, and OOP. This hands-on course aims to prepare students for work on practical web design projects.
- Fundamentals of JavaScript programming from the ground up
- Variables, conditional logic (if-else), arrays, objects, and loops
- Modern ES6+ features, including arrow functions, let, and const
- Functions, parameters, arguments, and return values
- Higher-level functions and callbacks
- Array and string methods
- Asynchronous JavaScript with promises and async-await
- APIs (Application Programming Interfaces)
- Parsing and working with JSON (JavaScript Object Notation) data
- OOP (Object-Oriented Programming) and modules
- Coding interview challenge prep
- Projects and portfolio development
- JavaScript libraries
-
JavaScript Development with Node, Express, & MongoDB 96 hours
Learn to build and host web applications with Node, build APIs with Express, and store data with MongoDB. Gain skills in I/O engine, working with npm, file system, API route development, middleware, MongoDB setup, schema development, MongoDB application management, and querying.
- Synchronous and Asynchronous JavaScript in Node.js
- The purpose of Node Package Manager (npm)
- The fundamentals of starting an Express.js server
- Integration of MongoDB (a NoSQL database)
- Authentication, server security, and API development
-
React Development Bootcamp 96 hours
Learn how to build dynamic web applications with React in this comprehensive bootcamp. From the basics of React and Node.js to advanced components and server deployment, you'll gain the skills necessary to create fully-functioning web apps.
- The fundamentals of React functionality: components, props, and state
- The lifecycle of React hooks: useEffect, useState, useContext, and more
- One-way data binding and the reusability of React components
- The use of higher-order components (HOC) in React
- Front-end web security
- Deployment to the cloud with AWS and alternate stacks
- The complete cycle of full-stack web development using the MERN stack
-
Entering the Web Development Industry 24 hours
Learn how to pursue employment as a web developer. In this course, you'll explore a typical day in the industry, build a portfolio, connect with tech recruiters, and practice interview preparation through practical, hands-on workshops.
- Build a professional portfolio
- Practice solving algorithms
- Prepare for technical and behavioral interviews
-
Web Development Labs (Self-Paced)
Enroll in this project-based, self-paced course to gain hands-on skills for designing and developing your own websites and web applications. Learn HTML, CSS, JavaScript, and Git through practical exercises you can complete on your own schedule.
- Code-along to book (class-style)
- On-your-own coding challenges (but with kickstarter code/scaffolding)
- Job interview-style challenges (harder, no scaffolding, ok-better-best solutions)
- Debugging code (errors and/or flaws in logic that make it not work)
- Targeted drills: "reps" to build specific skills
-
SQL Bootcamp 18 hours
Learn to extract information from databases by writing SQL queries, joining tables, aggregating data, and filtering results. You'll learn PostgreSQL in this class, but the concepts apply equally to other databases such as SQL Server and MySQL.
- Explore information stored in a database (tables, columns, rows, etc.) using the graphical interface of DBeaver, a popular free database app.
- Write SQL queries to retrieve data from tables in the database
- Combine information from multiple tables using JOIN statements
- Filter data, group it, and sort it to extract the specific information you need
- Master advanced techniques, including subqueries, string functions, and IF‑Else logic with CASE
- Learn how to use views and functions with parameters instead of directly querying tables
-
WordPress Bootcamp 18 hours
Learn how to create and manage websites using WordPress without any web design background. This extensive training course covers everything from installing WordPress to customizing themes and creating custom templates, making it an essential skill for web developers as over 40% of websites use WordPress.
- Build websites or blogs with WordPress
- Create or edit webpages and blog posts in a WordPress site, format text, images, links, and more
- Install WordPress themes (which control the appearance of a WordPress site) and customize their appearance
- See how WordPress plugins add functionality
- Install WordPress locally so you can write and test your code
- Learn how WordPress code works behind the scenes and how to use HTML, CSS, and PHP to customize and control it
What's included
- Free course retake within one year to refresh the material and gain practice.
- 12 one-on-one mentoring sessions
- Course workbook
- Class recordings
Stated by the provider. Confirm what your tuition covers before enrolling.
Live classes
Choose dates and book your instructor-led class on nobledesktop.com.
-
–
In-person or live online
Tue, Wed, Thu, Mon, Fri
10:00–17:00 · America/New_York (EST/EDT)
-
–
In-person or live online
Tue, Wed, Thu, Mon, Fri
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Tue, Wed, Thu, Mon, Fri
10:00–17:00 · America/New_York (EDT/EST)
Confirm current dates and availability on Noble Desktop before booking.
Self-paced course
Learn through recorded lessons on your own schedule.
This program is available for 300 days. You can choose when to start your access period. Once you activate, you will have 300 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.
- Tuition
- $7,995
- Course length
- 420 hours
- Schedule
- On your schedule
Learn to develop every layer of a web application in this thorough self-paced program. You'll build the skills to code both the front-end user experience and the back-end infrastructure, creating interactive and dynamic websites from the ground up.
- Front-End Development with HTML, CSS, and JavaScript: Learn to design responsive web pages using HTML for structure, CSS for styling, and JavaScript to layer in interactive elements. Put together visually engaging, user-friendly websites that hold up beautifully across devices, from desktop monitors to mobile screens.
- Build and Manage Full-Stack Web Applications: Work with the MERN stack (MongoDB, Express.js, React, and Node.js) to construct complete web applications. You'll learn how to manage databases, handle server-side development, and craft dynamic, data-driven web experiences.
- Deployment and Version Control: Find out how to deploy your web applications to the cloud using AWS and other platforms. You'll also build solid Git skills for version control and collaboration with other developers, getting comfortable with the process of tracking changes in your code.
- Hands-On Projects and Real-World Experience: Work on real projects throughout the program to assemble a portfolio of web applications that highlights your skills. Tackle coding challenges that get you ready for the job market, with plenty of room to practice debugging, optimizing, and refining your work.
Who the self-paced course is for
The Full-Stack Web Development Certificate is built for anyone who wants to code every layer of websites and web apps. This program is a strong match for: People looking to learn web development across both the front end and the back end. Anyone aiming to launch a career as a JavaScript Full-Stack Developer. Technically minded individuals who enjoy working with computers and want full command over building web apps and websites.
Self-paced curriculum
What you'll learn self-paced
- Front-end responsive layouts built with HTML and CSS
- Client-side JavaScript programming fundamentals, including DOM manipulation
- Client-side JavaScript libraries and frameworks like React.js
- Node.js development for creating web apps
- MongoDB for working with databases
- Express.js for API development
- Deployment to the cloud using AWS and other stacks
- Git for tracking changes in your code and collaborating with fellow developers
Self-paced course outline
-
Web Development with HTML & CSS Course Online (Self-Paced) 18 hours
Learn how to code webpages using HTML and CSS, from structuring and tagging content to styling and making the pages responsive. Upload and make your websites live using FTP.
- Start learning how to build websites by hand-coding HTML & CSS
- Mark up content (text, images, lists, links, etc.) using HTML (Hypertext Markup Language)
- Style the content using CSS (Cascading Style Sheets) by setting font, size, color, spacing, width, and much more
- Create multi-page websites with text, images, & more
- Adapt the layout for different-sized screens to create responsive webpages
- Use web browser developer tools to look behind the scenes and experiment with code changes
- Upload your website files using FTP to make the site live
-
Advanced HTML & CSS (Self-Paced) 18 hours
Take your CSS skills to the next level with this comprehensive self-paced course. Learn advanced topics such as SVG, CSS variables, gradients, shadows, positioning, transitions, transforms, and responsive images to help you code polished, professional-looking webpages.
- Master advanced CSS concepts including positioning, complex selectors, relative sizing units (px, em, rem), and the calc() function
- Create sophisticated visual styles using multiple background images, RGBA transparency, gradients, shadows, and more
- Work with SVG graphics in multiple ways and learn how to style them directly with CSS
- Build responsive images using img srcset and the picture element for optimized performance
- Use CSS variables to write cleaner, more flexible, and maintainable code
- Create mobile-friendly off-screen navigation menus using only CSS
- Add motion and interactivity with CSS transitions and transforms
-
Flexbox, Grid, & Bootstrap (Self-Paced) 12 hours
Learn how to use CSS flexbox and grid to layout and align webpage content and make it adapt to different size screens. See how both of these newer CSS techniques are useful and when to use each. You’ll also learn how to use Bootstrap (which uses Flexbox) to build out layouts quickly.
- CSS Flexbox to lay out and align webpage content
- CSS Grid for an entirely new way to think about laying out entire webpages
- Use Bootstrap (which is made with Flexbox) to build out layouts quickly
- Learn how Flexbox and Grid change the way you approach webpage layout
- Size, position, align, and reorder content using Flexbox and Grid
-
Front-End Tools & Portfolio (Self-Paced) 18 hours
Learn how to turn a webpage design into code, track changes, collaborate with other developers using Git and GitHub, and increase your coding speed with Emmet and Visual Studio Code. Develop your portfolio with the guidance of an expert instructor and gain hands-on coding experience.
- Go from design to a coded website with guidance from an expert developer
- What Git is and how it works
- Installing and setting up Git to track changes in your code
- Using GitHub for collaboration with other developers
-
JavaScript for Front-End (Self-Paced) 18 hours
Learn how to make your webpages more dynamic and engaging with JavaScript and animations using GreenSock. From the fundamentals of JavaScript code to creating stunning animations with GSAP, this course will equip you with the skills to transform your web projects into complex, interactive designs.
- Write JavaScript code to add animation and interactivity to webpages
- Learn the fundamentals of the JavaScript language (variables, loops, arrays, functions, etc.)
- Understand how to use free pre-made JavaScripts to quickly add many different kinds of common functionality
- Create animated slideshows and build animated image enlargers
- Learn to animate any content within a webpage, including SVG, using GreenSock (GSAP)
-
JavaScript Programming Bootcamp (Self-Paced) 120 hours
Pick up the essentials of JavaScript programming for creating web applications, including variables, conditional logic, functions, DOM manipulation, arrays, loops, async events, APIs, and OOP. This hands-on course is designed to prepare you for work on practical web design projects.
- JavaScript programming fundamentals from the ground up, including variables, conditional logic (if-else), arrays, objects, and loops
- The latest ES6 and ES7 features such as arrow functions, let, and const
- Functions, parameters, arguments, return values, plus higher-level functions and callbacks
- Array methods, string methods, and parsing JSON (JavaScript Object Notation) data
- Asynchronous JavaScript using promises and async-await
- APIs (Application Programming Interfaces) and JavaScript libraries
- OOP (Object-Oriented Programming) and modules
- Coding interview challenge prep alongside projects and portfolio development
-
JavaScript Development with Node, Express, & MongoDB (Self-Paced) 96 hours
Learn how to build and host web applications with Node, create APIs through Express, and store data using MongoDB. You'll pick up skills in the I/O engine, working with npm, the file system, API route development, middleware, MongoDB setup, schema design, MongoDB application management, and querying.
- Synchronous and asynchronous JavaScript inside Node.js
- The role of Node Package Manager (npm)
- The basics of getting an Express.js server up and running
- Integration with MongoDB (a NoSQL database)
- Authentication, server security, and API development
-
React Development Bootcamp (Self-Paced) 96 hours
Learn how to create dynamic web applications with React through this comprehensive bootcamp. From the basics of React and Node.js through advanced components and server deployment, you'll build the skills needed to put together fully functioning web apps.
- The fundamentals of React functionality, including components, props, and state
- The lifecycle of React hooks, covering useEffect, useState, useContext, and more
- One-way data binding and the reusability that React components offer
- How higher-order components (HOC) come into play in React
- Front-end web security
- Deployment to the cloud through AWS and alternate stacks
- The full cycle of full-stack web development using the MERN stack
-
Entering the Web Development Industry (Self-Paced) 24 hours
Find out how to land a job as a web developer. In this course, you'll get a sense of what a typical day in the industry looks like, build a portfolio, connect with tech recruiters, and sharpen your interview skills through practical, hands-on workshops.
- Put together a professional web development portfolio that highlights your skills and projects.
- Practice working through coding challenges and algorithms that come up often in technical interviews.
- Shape a networking strategy for connecting with tech recruiters and industry professionals.
- Learn how to present your skills and experience clearly and effectively during job interviews.
- Get a real feel for the day-to-day responsibilities and expectations placed on web developers.
- Prepare for actual job applications through hands-on workshops and expert guidance.
-
Web Development Labs (Self-Paced)
Enroll in this project-based, self-paced course to gain hands-on skills for designing and developing your own websites and web applications. Learn HTML, CSS, JavaScript, and Git through practical exercises you can complete on your own schedule.
- Code-along to book (class-style)
- On-your-own coding challenges (but with kickstarter code/scaffolding)
- Job interview-style challenges (harder, no scaffolding, ok-better-best solutions)
- Debugging code (errors and/or flaws in logic that make it not work)
- Targeted drills: "reps" to build specific skills
-
SQL Course Online (Self-Paced) 18 hours
Learn to extract information from databases by writing SQL queries, joining tables, aggregating data, and filtering results. You'll learn PostgreSQL in this class, but the concepts apply equally to other databases such as SQL Server and MySQL.
- Explore information stored in a database (tables, columns, rows, etc.) using the graphical interface of DBeaver (a popular free database app)
- Write SQL queries to retrieve data from tables in a database
- Combine information from multiple tables with JOIN statements
- Filter data, group it, and sort it to extract the specific info you need
- Learn advanced techniques like subqueries, string functions, and IF‑ELSE logic with CASE
- Learn how to use views and functions with parameters instead of directly querying tables
-
WordPress Bootcamp (Self-Paced) 18 hours
Learn how to create and manage websites with WordPress, even with no prior web design experience. This comprehensive course covers everything from installation to theme customization and custom templates, making it an essential skill for web developers since over 40 percent of websites run on WordPress.
- Build and manage websites or blogs using WordPress
- Create and edit pages and blog posts, including formatting text, images, links, and other content
- Install WordPress themes and customize their look and layout
- Explore how plugins extend functionality and add new features
- Set up WordPress locally to write, test, and experiment with code
- Understand how WordPress works behind the scenes and use HTML, CSS, and PHP to customize and control your sites
What's included with self-paced
- Self-paced video lessons
Self-paced lessons
Watch free previews and explore the lessons included with enrollment at Noble Desktop.
Web Development with HTML & CSS Course Online (Self-Paced)
-
Welcome & Downloading Course Materials
Lesson 1: HTML Essentials: Structure, Links & Images
1:10
Download the PDF workbook and class files, then watch the coding videos and complete the step-by-step exercises to learn HTML and CSS through repetition.
This preview is temporarily unavailable. Please try again later.
-
Before You Begin Getting a Code Editor
Lesson 1: HTML Essentials: Structure, Links & Images
3:06
Set up your code editor by installing Visual Studio Code, configuring browser preview and keyboard shortcuts, and preparing to follow along with the training materials.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Coding Basics Intro to HTML Syntax
Lesson 1: HTML Essentials: Structure, Links & Images
28:28
Learn how to create and structure a basic HTML webpage using tags like html, head, body, p, h1, ul, and li, then preview and edit it using Visual Studio Code and a web browser.
View enrollment options at Noble Desktop -
Enrollment required
Tags & Attributes Strong, Em, Doctype, Lang, & Meta
Lesson 1: HTML Essentials: Structure, Links & Images
16:16
Learn to apply semantic HTML tags like strong and em for accessibility, use language and charset attributes for correct rendering, and include required metadata like for proper browser interpretation.
View enrollment options at Noble Desktop -
Enrollment required
Coding Links Absolute & Relative URLs
Lesson 1: HTML Essentials: Structure, Links & Images
18:57
Create and organize internal and external website links using proper HTML anchor tags, file naming conventions, and relative or absolute paths.
View enrollment options at Noble Desktop -
Enrollment required
Adding Images
Lesson 1: HTML Essentials: Structure, Links & Images
15:50
Add images to webpages using the tag with a src attribute for the image path and an alt attribute for accessibility, without requiring a closing tag.
View enrollment options at Noble Desktop -
Intro to Cascading Style Sheets (CSS)
Lesson 2: Styling Content and Page Layout
7:07
Learn how to use embedded CSS to style HTML elements by customizing properties like color, font, size, and spacing.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
CSS Class Selectors
Lesson 2: Styling Content and Page Layout
18:51
Learn how to use CSS classes and span tags to selectively style HTML elements with semantic naming and specificity.
View enrollment options at Noble Desktop -
Enrollment required
Div Tags, ID Selectors, & Basic Page Formatting
Lesson 2: Styling Content and Page Layout
27:06
Use div tags to create a centered, max-width content wrapper with appropriate padding, margin, and background styling, leveraging Emmet shortcuts, span vs. div behavior, and CSS shorthand to structure and style the page efficiently.
View enrollment options at Noble Desktop -
Enrollment required
Browser Developer Tools & Validating HTML
Lesson 2: Styling Content and Page Layout
22:15
Use browser DevTools to experiment with HTML and CSS changes in real time, inspect elements, identify layout issues, and validate your HTML for errors using a validator.
View enrollment options at Noble Desktop -
HTML Semantic Elements & the Document Outline
Lesson 3: Building Page Structure with Semantic HTML & the Box Model
15:00
Understand that the Web Hypertext Application Technology Working Group, not the W3C, now defines the HTML living standard used by modern browsers.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Revolution Travel Page Layout
Lesson 3: Building Page Structure with Semantic HTML & the Box Model
23:25
Build the foundational HTML structure of a responsive travel website by creating semantic sections, organizing content with proper heading levels, and inserting images and navigation using VS Code and Emmet shortcuts.
View enrollment options at Noble Desktop -
Enrollment required
The Box Model
Lesson 3: Building Page Structure with Semantic HTML & the Box Model
22:23
Continue building the Revolution Travel website by embedding CSS to style layout, typography, spacing, and responsiveness for a more polished and flexible design.
View enrollment options at Noble Desktop -
Enrollment required
Coding Links Images & Page Jumps
Lesson 3: Building Page Structure with Semantic HTML & the Box Model
19:54
Add internal, external, image, and same-page anchor links to your website, apply unique IDs for jump links, and enhance user experience with smooth scrolling and basic link styling using classes.
View enrollment options at Noble Desktop -
Styling Links
Lesson 4: Styling Navigation and Preparing for Mobile
8:34
Style links using CSS pseudo-classes like :link, :visited, :hover, :focus, and :active to control their color, decoration, and behavior across different user interactions and browsers.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Styling the Navigation
Lesson 4: Styling Navigation and Preparing for Mobile
23:20
Style a navigation list using CSS by removing default bullets, eliminating margins and padding, displaying list items inline-block for proper spacing and box model behavior, and targeting only nav-specific lists to avoid affecting others.
View enrollment options at Noble Desktop -
Enrollment required
Specificity, Shared CSS, & Centering Content
Lesson 4: Styling Navigation and Preparing for Mobile
25:56
Move embedded CSS to an external stylesheet, link it across all pages to enable global styling updates, improve maintainability, and ensure consistent design using proper specificity and browser caching.
View enrollment options at Noble Desktop -
Enrollment required
Setting the Viewport Meta Tag
Lesson 4: Styling Navigation and Preparing for Mobile
17:01
Add the viewport meta tag and CSS text-size-adjust properties (including vendor prefixes) to ensure consistent and accessible mobile rendering across devices.
View enrollment options at Noble Desktop -
Starting a New Site & CSS Background Images
Lesson 5: Designing a Branded Homepage with Custom Fonts & Layout
14:23
Create and style a responsive hero section with centered text and a background image using CSS, incorporating best practices like fallback colors, percentage-based padding, and background-size: cover.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Adding Custom Fonts (using Google Fonts)
Lesson 5: Designing a Branded Homepage with Custom Fonts & Layout
34:45
Load and apply custom Google Fonts to a webpage using CSS while optimizing layout with max-width, auto margins, padding, and font-display settings.
View enrollment options at Noble Desktop -
Enrollment required
Page Layout Fine Tuning with the Box Model
Lesson 5: Designing a Branded Homepage with Custom Fonts & Layout
20:56
Add a logo using an SVG image with defined width and height to improve loading, fix inline spacing issues with vertical-align: bottom in CSS, apply padding and background colors to header and footer, remove unwanted paragraph margins in the footer, and use reusable class-based wrapper divs to control content width independently of full-width elements.
View enrollment options at Noble Desktop -
Navigation Bar Layout Intro to Flexbox
Lesson 6: Responsive Layouts with Flexbox, Grid & HiDPI Images
8:57
Use Flexbox to align elements side by side with display: flex, align-items for vertical alignment, and margin with auto for flexible spacing.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Hipstirred Hi Res Images
Lesson 6: Responsive Layouts with Flexbox, Grid & HiDPI Images
18:38
Use images that are twice the pixel dimensions of their display size in code to ensure they appear sharp on high-resolution (2x or 3x) screens.
View enrollment options at Noble Desktop -
Enrollment required
Creating Columns Intro to CSS Grid & Media Queries
Lesson 6: Responsive Layouts with Flexbox, Grid & HiDPI Images
24:20
Learn how to use CSS Grid and media queries to build responsive, multi-column layouts that adapt to different screen sizes.
View enrollment options at Noble Desktop -
Enrollment required
Course Wrap up & Your Next Steps
Lesson 6: Responsive Layouts with Flexbox, Grid & HiDPI Images
3:13
Practice coding regularly, review previous lessons and exercises, complete additional challenges, and build small personal web projects to reinforce your skills.
View enrollment options at Noble Desktop
SQL Course Online (Self-Paced)
-
Benefits of Learning SQL
Lesson 1: Setting Up the Work Environment
Download the PDF workbook and class files, and install the free dBeaver Community Edition to practice SQL querying without modifying databases.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Connecting to Our Database
Lesson 1: Setting Up the Work Environment
14:06
Set up a database connection in dBeaver using the provided credentials, test connectivity, and review available tables.
View enrollment options at Noble Desktop -
Getting Started & Your First Query
Lesson 2: Let's Start Learning SQL Code
7:29
Navigate databases in dBeaver by adjusting preferences, exploring schemas, and running practice queries to build familiarity.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Learning the SQL Language
Lesson 2: Let's Start Learning SQL Code
14:10
Review SQL syntax through slides, live demos, and exercises focused on SELECT, FROM, ORDER BY, DISTINCT, execution order, and result limits.
View enrollment options at Noble Desktop -
Enrollment required
Coding Exercise PostgreSQL
Lesson 2: Let's Start Learning SQL Code
18:29
Connect to the correct database environment and complete Exercise 1C by writing and executing SQL queries.
View enrollment options at Noble Desktop -
Enrollment required
Solution PostgreSQL Challenge
Lesson 2: Let's Start Learning SQL Code
15:11
Query users and orders tables to view, filter, sort, and remove duplicate records.
View enrollment options at Noble Desktop -
Data Types and Filtering Results
Lesson 3: Working with Characters & Numbers
4:44
Differentiate database data types to query text and numeric values correctly, applying quotes and comparison logic appropriately.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Coding Exercise Filtering with WHERE
Lesson 3: Working with Characters & Numbers
5:34
Define the active data source to enable code hints when querying product data based on price conditions.
View enrollment options at Noble Desktop -
Enrollment required
Solution Filtering with WHERE
Lesson 3: Working with Characters & Numbers
22:42
Refine queries to filter specific records, sort results, perform calculations, handle data types accurately, and eliminate duplicates.
View enrollment options at Noble Desktop -
Pattern Matching
Lesson 4: Using SQL Wildcards
4:46
Apply wildcard characters such as percent signs and underscores with LIKE and ILIKE to identify data patterns.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Combining Filters and Aliases
Lesson 4: Using SQL Wildcards
4:32
Combine conditions using AND, OR, and NOT, perform calculations, and assign column aliases for clearer result sets.
View enrollment options at Noble Desktop -
Enrollment required
Coding Exercise Like and Wildcards
Lesson 4: Using SQL Wildcards
12:31
Practice filtering records using LIKE, ILIKE, and NOT to control query results precisely.
View enrollment options at Noble Desktop -
Enrollment required
Solution Like and Wildcards
Lesson 4: Using SQL Wildcards
23:49
Explore table structures and ER diagrams to understand relationships and safely query data such as email domains or state-based orders.
View enrollment options at Noble Desktop -
Database Terminology and Primary & Foreign Keys
Lesson 5: Indentifying Rows & Connecting Tables
6:44
Connect related tables by identifying primary and foreign keys to manage relationships and avoid duplication.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Joins Combining Data from Multiple Tables
Lesson 5: Indentifying Rows & Connecting Tables
12:28
Perform inner joins by matching common columns and using table aliases to simplify query syntax.
View enrollment options at Noble Desktop -
Enrollment required
Exercise Inner Join
Lesson 5: Indentifying Rows & Connecting Tables
18:40
Reinforce inner join logic by combining tables, filtering shared data, and presenting unified results.
View enrollment options at Noble Desktop -
Enrollment required
Solution Inner Join
Lesson 5: Indentifying Rows & Connecting Tables
10:36
Join users, orders, and line items to identify high-value purchases and return distinct customer details.
View enrollment options at Noble Desktop -
Inner vs. Outer Joins
Lesson 6: Inner vs. Outer Joins
9:45
Compare inner joins with left, right, and full outer joins to understand how non-matching rows are handled.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Exercise Outer Join and NULL
Lesson 6: Inner vs. Outer Joins
23:37
Open the designated file, review warm-up exercises, and complete challenge problems to reinforce learning.
View enrollment options at Noble Desktop -
Enrollment required
Solution Outer Join and NULL
Lesson 6: Inner vs. Outer Joins
34:12
Analyze database relationships to uncover insights such as unsold products or specific purchasing behaviors, then export results as CSV files.
View enrollment options at Noble Desktop -
Cast
Lesson 7: Changing Data Types
7:07
Convert data types within queries using CAST without altering the underlying database structure.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Aggregate Functions
Lesson 7: Changing Data Types
6:33
Apply aggregate functions to calculate totals, counts, minimums, maximums, and averages for analysis.
View enrollment options at Noble Desktop -
Enrollment required
Exercise Aggregate Function and ROUND
Lesson 7: Changing Data Types
27:56
Manipulate aggregated results using rounding functions and column aliases for readable output.
View enrollment options at Noble Desktop -
Enrollment required
Solution Aggregate Function and ROUND
Lesson 7: Changing Data Types
19:00
Build aggregate queries incrementally, validating intermediate results before final execution.
View enrollment options at Noble Desktop -
Date Functions
Lesson 8: Working with Dates
2:20
Work with date and time functions to retrieve current timestamps, extract components, and convert data types.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Exercise 2.0 Date Functions
Lesson 8: Working with Dates
19:52
Extract, format, filter, and convert date values using date_part, to_char, CAST, and range-based conditions.
View enrollment options at Noble Desktop -
Enrollment required
Solution 2.0 Date Functions
Lesson 8: Working with Dates
17:40
Analyze account creation data to determine user age, creation year, weekend sign-ups, and date-range activity.
View enrollment options at Noble Desktop -
Grouping Data
Lesson 9: Organizing Statistical Results Into Categories
8:18
Group records using GROUP BY to apply aggregate functions across defined categories.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Subqueries
Lesson 10: Subqueries
27:41
Nest subqueries within main queries to process intermediate results before final selection.
View enrollment options at Noble Desktop -
Enrollment required
Solution Subqueries
Lesson 10: Subqueries
24:51
Prefer joins over subqueries when appropriate to improve clarity and performance.
View enrollment options at Noble Desktop -
Enrollment required
Aggregate Window Functions
Lesson 11: Aggregate Window Functions
23:01
Use window functions to add aggregate insights while preserving row-level detail.
View enrollment options at Noble Desktop -
Enrollment required
Solution WIndow Functions
Lesson 11: Aggregate Window Functions
9:34
Apply PARTITION BY within window functions to analyze grouped metrics without collapsing results.
View enrollment options at Noble Desktop -
Enrollment required
Conditionals
Lesson 12: Conditionals
18:26
Create conditional logic with CASE statements to classify, transform, or correct query output.
View enrollment options at Noble Desktop -
Enrollment required
CASE Exercise
Lesson 12: Conditionals
14:36
Categorize data into regions or groups, calculate order counts, and manage joins for broader analysis.
View enrollment options at Noble Desktop -
Enrollment required
Views
Lesson 13: Views
18:50
Save reusable queries as views to simplify access, enhance security, and streamline workflows.
View enrollment options at Noble Desktop -
Enrollment required
Views Solution
Lesson 13: Views
0:46
Summarize and filter user spending patterns using flexible query criteria.
View enrollment options at Noble Desktop -
String Functions
Lesson 14: String Functions
4:34
Manipulate text data with string functions to change case, extract substrings, split values, and evaluate length.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Learning Resources
Lesson 15: Additional Resources
3:24
Reinforce skills through external SQL resources, practice platforms, cheat sheets, and coding challenges.
View enrollment options at Noble Desktop -
Enrollment required
Finding Datasets
Lesson 15: Additional Resources
2:04
Source datasets from Kaggle and convert them into usable databases with guided setup support.
View enrollment options at Noble Desktop -
AI and SQL
Lesson 16: AI and SQL
11:06
Use AI tools such as ChatGPT to explain, refine, and generate SQL queries while validating results independently.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Challenge AI and SQL
Lesson 16: AI and SQL
5:13
Generate SQL queries from database visuals using tools like Chat2BT, specifying structure and dialect requirements.
View enrollment options at Noble Desktop -
Enrollment required
Solution AI and SQL
Lesson 16: AI and SQL
14:13
Apply best practices for using AI-generated SQL by providing clear requirements, verifying accuracy, and learning from explanations.
View enrollment options at Noble Desktop