SQL Tutorial - Full Database Course for Beginners
In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS.
Want more from Mike? He's starting a coding RPG/Bootcamp - https://simulator.dev/
The course is designed for beginners to SQL and database management systems, and will introduce common database management topics.
Throughout the course we'll be looking at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more.
You can get PopSQL to follow along here: http://popsql.com/freecodecamp
🔗Company Database Code: https://www.giraffeacademy.com/databa...
⭐️ Contents ⭐
⌨️ (0:00) Introduction
⌨️ (2:36) What is a Database?
⌨️ (23:10) Tables & Keys
⌨️ (43:31) SQL Basics
⌨️ (52:26) MySQL Windows Installation
⌨️ (1:01:59) MySQL Mac Installation
⌨️ (1:15:49) Creating Tables
⌨️ (1:31:05) Inserting Data
⌨️ (1:38:17) Constraints
⌨️ (1:48:11) Update & Delete
⌨️ (1:56:11) Basic Queries
⌨️ (2:08:37) Company Database Intro
⌨️ (2:14:05) Creating Company Database
⌨️ (2:30:27 ) More Basic Queries
⌨️ (2:26:24) Functions
⌨️ (2:45:13) Wildcards
⌨️ (2:53:53) Union
⌨️ (3:01:36) Joins
⌨️ (3:11:49) Nested Queries
⌨️ (3:21:52) On Delete
⌨️ (3:30:05) Triggers
⌨️ (3:42:12) ER Diagrams Intro
⌨️ (3:55:53) Designing an ER Diagram
⌨️ (4:08:34) Converting ER Diagrams to Schemas
Course developed by Mike Dane.
218
views
React Native Tutorial - Augmented Reality Mobile App
Learn how to build a React Native app from start to finish.
This app uses React Native and Expo, along with the Google Poly library to display 3D objects.
🔗 Get Expo: https://expo.io/
💻 Code: https://github.com/ProProgramming101/...
⭐️ Contents ⭐
⌨️ (0:00) App Introduction
⌨️ (0:44) Project Setup
⌨️ (6:48) Setup Camera
⌨️ (12:34) Google Poly API
⌨️ (33:07) Poly Component
⌨️ (43:48) Search Component
⌨️ (56:07) Clean Up Search Results
⌨️ (1:04:00) Display Object
⌨️ (1:11:00) Clean Up
59
views
Code Asteroids in JavaScript (1979 Atari game) - tutorial
In this JavaScript tutorial, you will learn to create the 1979 Atari game Asteroids from scratch using vanilla JavaScript.
⭐️Contents⭐️
⌨️1. (0:00) Spaceship creation
💻JavaScript Template: https://drive.google.com/file/d/1W8vb...
💻Part 1 Code: https://drive.google.com/file/d/1Gpws...
⌨️2. (33:55) Astroids creation
💻Part 2 Code: https://drive.google.com/file/d/1Pw4_...
⌨️3. (58:40) Collision Detection and Explosions
💻Part 3 Code: https://drive.google.com/file/d/1G7uw...
⌨️4. (1:19:09) Shooting Lasers and Asteroid Destruction
💻Part 4 Code: https://drive.google.com/file/d/1xJj9...
⌨️5. (1:48:13) Levels, Lives, and Game Over
💻Part 5 Code: https://drive.google.com/file/d/1Wbq9...
⌨️6. (2:10:10) Scoring and Saving Data Locally
💻Part 6 Code: https://drive.google.com/file/d/1tcdb...
⌨️7. (2:20:24) Sound Effects and “Music”
💻Part 7 Code: https://drive.google.com/open?id=1tmj...
🔈 Sounds: https://drive.google.com/file/d/1iSyk...
76
views
Connect Four with Javascript & jQuery - Tutorial
In this programming tutorial, we'll create a basic two player connect four game using Javascript, jQuery, CSS, and HTML. This tutorial is geared towards people who understand the basics of web technologies, but maybe want to watch how another developer builds a connect four application.
💻Code: https://github.com/codyseibert/js-con...
29
views
PHP Programming Language Tutorial - Full Course
Learn the PHP programming language in this full course / tutorial. The course is designed for new programmers, and will introduce common programming topics using the PHP language.
⭐️Course Contents ⭐️
⌨️ 1. (0:00) Introduction
⌨️ 2. (1:56) Windows Installation
⌨️ 3. (7:32) Choosing a Text Editor
⌨️ 4. (11:06) Hello World & Setup
⌨️ 5. (20:29) Writing HTML
⌨️ 6. (27:30) Variables
⌨️ 7. (38:09) Data Types
⌨️ 8. (44:27) Working With Strings
⌨️ 9. (54:50) Working With Numbers
⌨️ 10. (1:05:14) Getting User Input
⌨️ 11. (1:15:37) Building a Basic Calculator
⌨️ 12. (1:22:13) Building a Mad Libs Game
⌨️ 13. (1:28:59) URL Parameters
⌨️ 14. (1:35:52) POST vs GET
⌨️ 15. (1:41:44) Arrays
⌨️ 16. (1:50:26) Using Checkboxes
⌨️ 17. (1:57:22) Associative Arrays
⌨️ 18. (2:04:55) Functions
⌨️ 19. (2:12:10) Return Statements
⌨️ 20. (2:19:10) If Statements
⌨️ 21. (2:37:16) If Statements (con't)
⌨️ 22. (2:47:13) Building a Better Calculator
⌨️ 23. (2:56:53) Switch Statements
⌨️ 24. (3:05:09) While Loops
⌨️ 25. (3:15:18) For Loops
⌨️ 26. (3:26:24) Comments
⌨️ 27. (3:31:08) Including HTML
⌨️ 28. (3:36:51) Include: PHP
⌨️ 29. (3:45:57) Classes & Objects
⌨️ 30. (3:56:23) Constructors
⌨️ 31. (4:06:18) Object Functions - PHP - Tutorial 31
⌨️ 32. (4:13:52) Getters & Setters
⌨️ 33. (4:29:17) Inheritance
Course developed by Mike Dane.
50
views
1
comment
Machine Learning on JavaScript
In this talk you will learn different machine learning algorithms using JavaScript and NodeJS, finally diving into neural networks using SynapticJS.
Talk given by Lucas Aragno at Node Summit 2017.
Thanks to Node Summit for giving us permission to post this talk. freeCodeCamp is not associated with this talk. We're just excited to bring more exposure to to it!
44
views
How to Build Flappy Bird in JavaScript - GameDev Tutorial
Learn how to create a flappy bird game using pure JavaScript.
Download the Starter Template: https://goo.gl/SV7v7V
Download the final Game files: https://goo.gl/h9LE58
27
views
Build an IoT application with Node.js and Docker
Learn how to build and scale an IoT application with microservices using Node.js and Docker. This project will give you a working IoT dashboard connected to a SmartThings IoT hub and devices. You can use the application you will build to monitor IoT devices, but it’s really designed as an example of how to build an IoT application in the cloud that leverages microservices, Node.js and Docker.
Talk given by Shubhra Kar and Wyatt Preul at Node Summit 2017.
Thanks to Node Summit for giving us permission to post this talk. freeCodeCamp is not associated with this talk. We're just excited to bring more exposure to to it!
42
views
MEAN Stack CRUD Operations - Beginners Tutorial
This MEAN stack beginners tutorial shows how to implement CRUD operations from scratch using the MEAN Stack. The app is created using MongoDB, Express, Node.JS and Angular 5.
24
views
Ruby Programming Language - Full Course
Learn the Ruby programming language in this full course / tutorial. The course is designed for new programmers, and will introduce common programming topics using the ruby language.
⭐️Course Contents ⭐️
⌨️ 1. (0:00) Introduction
⌨️ 2. (1:24) Windows Installation
⌨️ 3. (4:45) Mac Installation
⌨️ 4. (6:38) Hello World / Setup
⌨️ 5. (12:01) Drawing a Shape
⌨️ 6. (18:17) Variables
⌨️ 7. (28:32) Data Types
⌨️ 8. (33:13) Working With Strings
⌨️ 9. (44:03) Math & Numbers
⌨️ 10. (53:54) Getting User Input
⌨️ 11. (1:01:09) Building a Calculator
⌨️ 12. (1:08:15) Building a Mad Libs Game
⌨️ 13. (1:12:45) Arrays
⌨️ 14. (1:21:31) Hashes
⌨️ 15. (1:27:42) Methods
⌨️ 16. (1:35:28) Return Statement
⌨️ 17. (1:40:26) If Statements
⌨️ 18. (1:52:24) If Statements (continued)
⌨️ 19. (1:59:11) Building a Better Calculator
⌨️ 20. (2:07:19) Case Expressions
⌨️ 21. (2:16:07) While Loops
⌨️ 22. (2:22:36) Building a Guessing Game
⌨️ 23. (2:35:29) For Loops
⌨️ 24. (2:40:01) Exponent Method
⌨️ 25. (2:44:45) Comments
⌨️ 26. (2:49:23) Reading Files
⌨️ 27. (2:57:55) Writing Files
⌨️ 28. (3:06:34) Handling Errors
⌨️ 29. (3:14:29) Classes & Objects
⌨️ 30. (3:24:13) Initialize Method
⌨️ 31. (3:31:47) Object Methods
⌨️ 32. (3:37:11) Building a Quiz
⌨️ 33. (3:46:21) Inheritance
⌨️ 34. (3:53:50) Modules
⌨️ 35. (3:59:06) Interactive Ruby (irb)
Course developed by Mike Dane.
29
views
Intro to Angular 5 Tutorial
Introduction to Angular. Angular is a TypeScript-based open-source front-end web application platform led by the Angular Team at Google and by a community of individuals and corporations.
26
views
Bulma CSS Framework - complete tutorial
Learn the best CSS framework since Bootstrap! If you want to take the interactive version of the course, visit this page: https://scrimba.com/g/gbulma
Bulma is the brainchild of CSS Guru Jeremy Thomas @jgthms. It's a modern responsive CSS framework based on Flexbox. The framework makes scaffolding and designing websites a breeze with best-in-class documentation and well-designed, intuitive components and modifiers. ✨
Bulma is great not just for building but learning best HTML and CSS3 practices, too! It's like having @jgthms👨🎨 there the whole time. 😍
In this course, you'll learn to create not one, not two, but three beautiful, responsive websites bootstrapped with Bulma in less than an hour.
25
views
From wireframe to website prototype - Webflow Tutorial
Webflow is a responsive website design tool that let's you build websites in the browser. In this Webflow tutorial I show you a step by step process for taking a concept for a website or app and creating a responsive, interactive prototype in Webflow.
24
views
React Fundamentals - Full Course for Beginners
This is an introductory React course / tutorial which will teach you the magic of React.js. React is a JavaScript library, which lets you build user interfaces using separate components.
⭐️Course Contents ⭐️
⌨️1. (0:58) Setting React Environment
⌨️2. (2:45) React Elements
⌨️3. (6:40) JSX
⌨️4. (9:37) Components
⌨️5. (14:09) Props
⌨️6. (17:38) State
⌨️7. (20:17) Lifecycle (componentDidMount)
⌨️8. (22:30) Asynchronous Calls
⌨️9. (26:26) Containers
⌨️10. (29:42) Lists and Keys
⌨️11. (34:47) Refactoring List Component
⌨️12. (36:30) Forms (Input)
⌨️13. (40:03) Conditional Rendering
⌨️14. (45:34) Images (Loader Component)
⌨️15. (49:15) Setting Up React Router
⌨️16. (54:02) Setting Routes
⌨️17. (56:53) Using Route Params
Course developed by Edvinas Daugirdas.
16
views
This is what happens when you don't sleep in | Will Smith Vlogs
here’s a certain quality of life that we all strive for and the people of Sydney, Australia might have found the perfect formula for maximum bliss.
Westbrook Studios | http://westbrookentertainment.com
Executive Producers: Will Smith, Miguel Melendez
Producers: Aaron Ferguson, Lukas Kaiser, Sadao Turner
Director: Mark C. Roe
Editor: Mark C. Roe
Cameras: Aaron Ferguson, Mark C. Roe, Sadao Turner
Music by DAYO
Spotify: https://goo.gl/VNa9d6
Bandcamp: https://goo.gl/5Tw48m
Soundcloud: https://goo.gl/bjBf28
19
views
JavaScript Snake Game Tutorial Using Functional Programming
Build a Snake Game in JavaScript using Functional Programming concepts. No libraries are used in this JavaScript tutorial.
💻 Source code: https://github.com/chrokh/snake
Created by Christopher Okhravi.
17
views
TypeScript 101 (tutorial)
Introduction to TypeScript. TypeScript is an open-source programming language developed and maintained by Microsoft. It is a strict syntactical superset of JavaScript, and adds optional static typing to the language.
27
views
GraphQL Full Course - Novice to Expert
Complete course on GraphQL where you will create a full-stack application from scratch using:
- GraphQL server on Node.js
- React front-end (with Apollo)
- MongoDB to store data
⭐️ Course Contents ⭐️
#1 (0:00)- Introduction to GraphQL
#2 (6:51)- A Birdseye View of GraphQL
#3 (10:59)- Project (stack) Overview
#4 (14:18)- Making Queries (front-end preview)
#5 (20:05)- Express App Setup
#6 (25:41)- Setting up GraphQL
#7 (31:02)- GraphQL Schema
#8 (38:08)- Root Query
#9 (48:20)- The Resolve Function
#10 (53:16)- Testing Queries in Graphiql
#11 (59:49)- GraphQL ID Type
#12 (1:03:36)- Author Type
#13 (1:09:30)- Type Relations
#14 (1:17:41)- GraphQL Lists
#15 (1:25:56)- More on Root Queries
#16 (1:29:39)- Connecting to mLab
#17 (1:35:51)- Mongoose Models
#18 (1:42:53)- Mutations
#19 (1:53:06)- More on Mutations
#20 (1:58:58)- Updating the Resolve Functions
#21 (2:06:45)- GraphQL NonNull
#22 (2:12:20)- Adding a Front-end
#23 (2:15:50)- Create React App
#24 (2:24:18)- Book List Component
#25 (2:27:55)- Apollo Client Setup
#26 (2:34:47)- Making Queries from React
#27 (2:42:26)- Rendering Data in a Component
#28 (2:49:23)- Add Book Component
#29 (2:59:41)- External Query File
#30 (3:04:12)- Updating Component State
#31 (3:12:35)- Composing Queries
#32 (3:24:48)- Query variables
#33 (3:31:05)- Re-fetching Queries
#34 (3:35:11)- Book Details Component
#35 (3:42:47)- Making a Single Query
#36 (3:54:13)- Styling the App
22
views
Australia | Will Smith Vlogs
Before I start filming for my new movie, Gemini Man, let's take a trip down under to Australia and meet some lit koala bears.
Westbrook Studios | http://westbrookentertainment.com
Executive Producers: Will Smith, Miguel Melendez
Producers: Aaron Ferguson, Lukas Kaiser, Sadao Turner
Director: Mark C. Roe
Editor: Ryan Moody
Cameras: Aaron Ferguson, Mark C. Roe, Sadao Turner
Teaching My Son Where Babies Come From:
https://rumble.com/v3zicok-where-do-babies-come-from-will-smith-vlogs.html
One Thing that Arnold Schwarzenegger Told Me:
https://rumble.com/v3zic0g-one-thing-arnold-schwarzenegger-told-me-that-ill-never-forget-will-smith-vl.html
7
views
JavaScript ES6, ES7, ES8: Learn to Code on the Bleeding Edge (Full Course)
JavaScript is one of the most popular programming languages in the world. It’s used almost everywhere: from large-scale web applications to complex servers to mobile and IoT devices.
⭐️ Course content ⭐️
⌨️ Template Literals (1:06)
⌨️ Destructuring (5:32)
⌨️ Object Literal (9:42)
⌨️ For of loop (13:44)
⌨️ Spread operator (17:51)
⌨️ Rest operator (20:57)
⌨️ Arrow Functions (23:02)
⌨️ Default Params (25:50)
⌨️ Array.includes() (27:44)
⌨️ Let & const (28:58)
⌨️ Export & import (32:53)
⌨️ String.padStrart(), String.padEnd() (35:29)
⌨️ Classes (38:05)
⌨️ Trailing commas (49:59)
⌨️ Async/Await (51:27)
⌨️ Sets (1:01:19)
⌨️ What's Next (1:04:08)
19
views
Introduction to JavaScript
The course contains 14 lessons and 7 challenges. In the challenges, you'll be encourage to jump into the code and get your hands dirty. This is both fun and great for making the knowledge stick.
⭐️Course Contents ⭐️
⌨️Data types
⌨️Variables (1:45)
⌨️Strings (4:11)
⌨️Numbers (11:37)
⌨️Booleans (16:41)
⌨️Arrays (20:23)
⌨️Objects (26:32)
⌨️Arithmetic operations (32:43)
⌨️Relational operations (34:31)
⌨️Increment & decrement (40:20)
⌨️If, else if, else (44:03)
⌨️Switch statements (50:22)
⌨️For loops (53:58)
⌨️While & Do While (57:30)
⌨️Functions (1:02:11)
18
views
Where Do Babies Come From? | Will Smith Vlogs
We take over Tokyo, Japan for the final premiere of the Netflix Original film, "Bright". Things take a turn as I have “the talk” and explain the birds and the bee’s with my son, Trey Smith. Awkward! SUBSCRIBE for more from Will Smith: https://goo.gl/BUjQW8
Arnold Schwarzenegger Gave Me Some Advice:
• One Thing Arnold Schwarzenegger Told ...
SHOCKING MY FANS:
• Will Smith Pranks Fans | BRIGHT: Netf...
Westbrook Studios | http://westbrookentertainment.com
SOCIALS:
Instagram: https://goo.gl/8mBb1K
Facebook: https://goo.gl/yzifAY
Website: http://willsmith.com
11
views
Learn HTML5 - full course with code samples
HTML is one of the core building blocks on the web, as it's what holds the content on all the websites you visit. Thus, HTML is a must-have skill for all web developers.
While HTML is a huge subject, the basics can be learned quickly. This course aims at taking you from absolute beginner to proficient in HTML in less than an hour. Throughout the lectures, you'll be building a neat-looking website from scratch together with the brilliant instructor Eric Tirado.
Get the 'index.css' file from this course here: https://gist.github.com/beaucarnes/ec...
What you'll learn in this web development html crash course:
- Intro to web architecture (0:00)
- HTML documents (4:25)
- Nesting (7:19)
- Head elements and scripts (11:23)
- Layout elements (17:33)
- Figure and image elements (20:28)
- Embedding videos (26:54)
- Navbar and list items (31:12)
- Headings (34:05)
- Text formatting (36:04)
- Tables (42:15)
- Links and final touches (49:27)
16
views
Google Fonts Tutorial: Add custom fonts to your website
Want to use Web Fonts to make your pages look better? Google Fonts is your best option.
This tutorial covers how you can use the website to embed fonts in any website you build.
🔗Code GIST: https://gist.github.com/prof3ssorSt3v...
🔗Google Fonts: https://fonts.google.com/
🔗Font Matching site: https://meowni.ca/font-style-matcher/
15
views
Will Smith Pranks Fans | BRIGHT: Netflix Promo Tour
Take an exclusive, behind-the-scenes look at the promo tour for the Netflix Original film BRIGHT. Stream Bright on Netflix December 22nd. SUBSCRIBE for more: https://goo.gl/BUjQW8
Westbrook Studios | http://westbrookentertainment.com
SOCIALS:
Instagram: https://goo.gl/8mBb1K
Facebook: https://goo.gl/yzifAY
Website: http://willsmith.com
19
views