وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert

سرفصل های دوره

JUST COMPLETELY REDONE! Master SQL, Work With Complex Databases, Build Reports, and More!


01 - Introduction & 5 Minutes of SQL
  • 001 This Course Was Just Updated!
  • 002 Course Intro
  • 003 About Me
  • 004 Getting The Course Code
  • 005 First 5 Minutes of SQL
  • 005 slides.zip
  • 005 sql-try-it-editor.zip
  • external-links.zip

  • 02 - Getting Started & Installation
  • 001 Section Introduction
  • 002 What Is A Database
  • 002 slides.zip
  • 003 SQL vs. MySQL
  • 004 Installation START HERE!
  • 005 Installation Windows Instructions
  • 005 windows-mysql-installation.zip
  • 006 Installation Mac Instructions
  • 006 mac-mysql-download.zip
  • 006 mysql-workbench-download.zip
  • 006 optional-dbgate-download.zip
  • 007 Mac Installation Commands.html
  • external-links.zip

  • 03 - Creating Databases & Tables
  • 001 Section Introduction
  • 002 Showing Databases
  • 002 slides.zip
  • 003 CODE Showing Databases.html
  • 004 Creating Databases
  • 005 CODE Creating Databases.html
  • 006 Dropping and Using Databases
  • 007 CODE Dropping and Using Databases.html
  • 008 Introducing Tables
  • 009 Data Types The Basics
  • 010 Basic Datatypes Challenge
  • 011 CODE Basic Datatypes Challenge.html
  • 012 Creating Tables
  • 013 CODE Creating Tables.html
  • 014 How Do We Know It Worked
  • 015 CODE How Do We Know It Worked.html
  • 016 Dropping Tables
  • 017 CODE Dropping Tables.html
  • 018 Tables Basics Activity
  • 019 SOLUTION Tables Basics Activity.html
  • 020 MySQL Comments
  • external-links.zip

  • 04 - Inserting Data
  • 001 Section Introduction
  • 002 INSERT The Basics
  • 002 slides.zip
  • 003 CODE INSERT The Basics.html
  • 004 A Quick Preview of SELECT
  • 005 CODE A Quick Preview of SELECT.html
  • 006 Multi-inserts
  • 007 CODE Multi-inserts.html
  • 008 INSERT Exercise
  • 009 SOLUTION INSERT Exercise.html
  • 010 Working With NOT NULL
  • 011 CODE Working With NOT NULL.html
  • 012 Sidenote Quotes In MySQL
  • 013 Adding DEFAULT Values
  • 014 CODE Adding DEFAULT Values.html
  • 015 Introducing Primary Keys
  • 016 CODE Introducing Primary Keys.html
  • 017 Working With AUTO_INCREMENT
  • 018 CODE Working With AUTO_INCREMENT.html
  • 019 Create Table Insert Exercise
  • 020 SOLUTION Insert Exercise.html
  • external-links.zip

  • 05 - CRUD Basics
  • 001 Section Introduction
  • 002 Introducing CRUD
  • 002 slides.zip
  • 003 Getting Our New Dataset
  • 004 CODE.html
  • 005 Officially Introducing SELECT
  • 006 CODE.html
  • 007 The WHERE clause
  • 008 CODE.html
  • 009 Rapid Fire Exercises
  • 010 Rapid Fire Exercises SOLUTION
  • 011 SOLUTION CODE.html
  • 012 Aliases
  • 013 CODE.html
  • 014 Using UPDATE
  • 015 CODE.html
  • 016 A Quick Rule Of Thumb
  • 017 UPDATE Exercise
  • 018 UPDATE Exercise SOLUTION
  • 019 SOLUTION CODE.html
  • 020 Introducing DELETE
  • 021 CODE.html
  • 022 DELETE Exercise
  • 023 DELETE Exercise SOLUTION
  • 024 SOLUTION CODE.html
  • external-links.zip

  • 06 - CRUD Challenge
  • 001 Section Introduction
  • 002 Introducing the CRUD Challenge
  • 002 slides.zip
  • 003 CRUD Challenge Solution Creating
  • 004 SOLUTION CODE.html
  • 005 CRUD Challenge Solution Reading
  • 006 SOLUTION CODE.html
  • 007 CRUD Challenge Solution Updating
  • 008 SOLUTION CODE.html
  • 009 CRUD Challenge Solution Deleting
  • 010 SOLUTION CODE.html
  • external-links.zip

  • 07 - String Functions
  • 001 Section Introduction
  • 002 The World Of String Functions
  • 002 mysql-docs-string-functions.zip
  • 002 slides.zip
  • 003 Loading Our Books Data
  • 004 CODE.html
  • 005 CONCAT
  • 006 CODE.html
  • 007 SUBSTRING
  • 008 CODE.html
  • 009 Combining String Functions
  • 010 CODE.html
  • 011 Sidenote SQL Formatting
  • 011 sql-formatter.zip
  • 012 REPLACE
  • 013 CODE.html
  • 014 REVERSE
  • 015 CODE.html
  • 016 CHAR_LENGTH
  • 017 CODE.html
  • 018 UPPER & LOWER
  • 019 CODE.html
  • 020 Other String Functions
  • 021 CODE.html
  • 022 String Functions Exercise
  • 023 String Functions Exerise SOLUTION
  • 024 SOLUTION CODE.html
  • external-links.zip

  • 08 - Refining Selections
  • 001 Section Introduction
  • 002 Adding Some New Books
  • 002 slides.zip
  • 003 CODE.html
  • 004 DISTINCT
  • 005 CODE.html
  • 006 ORDER BY
  • 007 CODE.html
  • 008 More On ORDER BY
  • 009 CODE.html
  • 010 LIMIT
  • 011 CODE.html
  • 012 LIKE
  • 013 CODE.html
  • 014 Escaping Wildcards
  • 015 CODE.html
  • 016 Refining Selections Exercise
  • 017 Refining Selections Exercise SOLUTION
  • 018 SOLUTION CODE.html
  • external-links.zip

  • 09 - Aggregate Functions
  • 001 Section Introduction
  • 002 Count Basics
  • 002 slides.zip
  • 003 CODE.html
  • 004 GROUP BY
  • 005 CODE.html
  • 006 MIN and MAX Basics
  • 007 CODE.html
  • 008 Subqueries
  • 009 CODE.html
  • 010 Grouping By Multiple Columns
  • 011 CODE.html
  • 012 MIN and MAX With GROUP BY
  • 013 CODE.html
  • 014 SUM
  • 015 CODE.html
  • 016 AVG
  • 017 CODE.html
  • 018 Aggregate Functions Docs
  • 019 Agg Functions Exercise
  • 020 Agg Functions Exercise SOLUTION
  • 021 SOLUTION CODE.html
  • external-links.zip

  • 10 - Revisiting Data Types
  • 001 Section Introduction
  • 002 Surveying Other Data Types
  • 002 data-types-reference.zip
  • 002 slides.zip
  • 003 CHAR vs. VARCHAR
  • 004 INT, TINYINT, BIGINT, etc
  • 005 DECIMAL
  • 006 FLOAT & DOUBLE
  • 007 DATE and TIME
  • 008 Working With Dates
  • 009 CODE.html
  • 010 CURDATE, CURTIME, & NOW
  • 011 CODE.html
  • 012 Date Functions
  • 013 CODE.html
  • 014 Time Functions
  • 015 CODE.html
  • 016 Formatting Dates
  • 017 CODE.html
  • 018 Date Math
  • 019 TIMESTAMPS
  • 020 DEFAULT & ON UPDATE TIMESTAMPS
  • 021 CODE.html
  • 022 Data Types Exercise
  • 023 Data Types Exercise SOLUTION
  • 024 SOLUTION CODE.html
  • external-links.zip

  • 11 - Comparison & Logical Operators
  • 001 Section Introduction
  • 002 Not Equal
  • 002 slides.zip
  • 003 CODE.html
  • 004 NOT LIKE
  • 005 CODE.html
  • 006 Greater Than
  • 007 CODE.html
  • 008 Less Than Or Equal To
  • 009 CODE.html
  • 010 Logical AND
  • 011 CODE.html
  • 012 Logical OR
  • 013 CODE.html
  • 014 Between
  • 015 CODE.html
  • 016 Comparing Dates
  • 017 CODE.html
  • 018 The IN Operator
  • 019 CODE.html
  • 020 CASE
  • 021 CODE.html
  • 022 IS NULL
  • 023 Exercise
  • 024 Exercise SOLUTION
  • 025 SOLUTION CODE.html
  • external-links.zip

  • 12 - Constraints & ALTER TABLE
  • 001 UNIQUE Constraint
  • 001 slides.zip
  • 002 CODE.html
  • 003 CHECK Constraints
  • 004 CODE.html
  • 005 Named Constraints
  • 006 CODE.html
  • 007 Multiple Column Constraints
  • 008 CODE.html
  • 009 ALTER TABLE Adding Columns
  • 010 CODE.html
  • 011 ALTER TABLE Dropping Columns
  • 012 CODE.html
  • 013 ALTER TABLE Renaming
  • 014 CODE.html
  • 015 ALTER TABLE Modifying Columns
  • 016 CODE.html
  • 017 ALTER TABLE Constraints
  • 018 CODE.html
  • external-links.zip

  • 13 - One to Many & Joins
  • 001 Section Introduction
  • 002 Data is Messy
  • 002 slides.zip
  • 003 Relationships Basics
  • 004 One to Many Relationship
  • 005 Working with FOREIGN KEY
  • 006 CODE.html
  • 007 Cross Joins
  • 008 CODE.html
  • 009 Inner Joins
  • 010 CODE.html
  • 011 Inner Joins With Group By
  • 012 CODE.html
  • 013 Left Join
  • 014 CODE.html
  • 015 Left Join With Group By
  • 016 CODE.html
  • 017 Right Join
  • 018 CODE.html
  • 019 On Delete Cascade
  • 020 CODE.html
  • 021 Joins Exercise
  • 022 EXERCISE STARTER DATA.html
  • 023 Joins Exercise SOLUTION
  • 024 SOLUTION CODE.html
  • external-links.zip

  • 14 - Many to Many
  • 001 Section Introduction
  • 002 Many to Many Basics
  • 002 slides.zip
  • 003 Creating Our Many To Many Tables
  • 004 CODE.html
  • 005 TV Series Challenge #1
  • 006 CODE.html
  • 007 TV Series Challenge #2
  • 008 CODE.html
  • 009 TV Series Challenge #3
  • 010 CODE.html
  • 011 TV Series Challenge #4
  • 012 CODE.html
  • 013 TV Series Challenge #5
  • 014 CODE.html
  • 015 TV Series Challenge #6
  • 016 CODE.html
  • 017 TV Series Challenge #7
  • 018 CODE.html
  • external-links.zip

  • 15 - Views, Modes, & More!
  • 001 Introducing Views
  • 002 CODE.html
  • 003 Updateable Views
  • 004 ReplacingAltering Views
  • 005 CODE.html
  • 006 HAVING clause
  • 007 CODE.html
  • 008 WITH ROLLUP
  • 009 CODE.html
  • 010 SQL Modes Basics
  • 011 CODE.html
  • 012 STRICT_TRANS_TABLES
  • 013 More Modes

  • 16 - Window Functions
  • 001 Introducing Window Functions
  • 001 slides.zip
  • 002 Using OVER()
  • 003 CODE.html
  • 004 PARTITION BY
  • 005 CODE.html
  • 006 ORDER BY with Windows
  • 007 CODE.html
  • 008 RANK()
  • 009 DENSE_RANK, & ROW_NUMBER()
  • 010 CODE.html
  • 011 NTILE()
  • 012 CODE.html
  • 013 FIRST_VALUE
  • 014 CODE.html
  • 015 LEAD and LAG
  • 016 CODE.html
  • external-links.zip

  • 17 - Instagram Database Clone
  • 001 Section Introduction
  • 002 IMPORTANT NOTE ABOUT THIS SECTION!
  • 003 Introducing Instagram Clone
  • 003 slides.zip
  • 004 Users Schema
  • 005 CODE.html
  • 006 Photos Schema
  • 007 CODE.html
  • 008 Comments Schema
  • 009 CODE.html
  • 010 Likes Schema
  • 011 CODE.html
  • 012 Followers Schema
  • 013 CODE.html
  • 014 Note!.html
  • 015 3 Approaches for Hashtags
  • 016 Implementing Hashtags Table
  • 017 CODE.html
  • 018 Complete Instagram Schema.html
  • external-links.zip

  • 18 - Working With Lots of IG Data
  • 001 Section Introduction
  • 002 Getting Lots of Instagram Data
  • 003 CODE.html
  • 003 ig-clone-data.zip
  • 004 Instagram Challenge #1
  • 005 CODE.html
  • 006 Instagram Challenge #2
  • 007 CODE.html
  • 008 Instagram Challenge #3
  • 009 CODE.html
  • 010 Instagram Challenge #4
  • 011 CODE.html
  • 012 Instagram Challenge #5
  • 013 CODE.html
  • 014 Instagram Challenge #6
  • 015 CODE.html
  • 016 Instagram Challenge #7
  • 017 CODE.html

  • 19 - What Next
  • 001 Additional SQL Resources.html

  • 20 - LEGACY Introduction and 5 Minutes of SQL
  • 001 Course Introduction
  • 002 Instructor Introduction(s)
  • 003 Syllabus Walkthrough and Prerequisites
  • 004 Note about SQL Editor.html
  • 005 Your First 5 Minutes of SQL - Lets Get Coding!
  • 005 lecture-slides.zip
  • 005 sql-try-it-editor.zip
  • 006 CODE Your First 5 Minutes of SQL.html
  • 007 How The Course Works
  • external-links.zip

  • 21 - LEGACY Getting Started Overview and Installation
  • 001 Section Introduction
  • 002 What Is a Database
  • 002 slides-for-this-section.zip
  • 003 SQL Vs. MySQL
  • 004 Important note about the next lecture.html
  • 005 Installation Overview - WATCH BEFORE INSTALLING
  • 005 installation-slides.zip
  • 006 Now using GoormIDE instead of Cloud9
  • 006 goorm.io-signup-instructions.zip
  • 007 GoormIDE Registration IMPORTANT - PLEASE READ!!!.html
  • 008 MySQL Tips to Make Your Life Easier.html
  • 008 cheat-sheet-for-mysql-with-goorm.zip
  • 008 how-to-run-mysql-code-from-a-file.zip
  • 009 Mac Installation
  • 010 CODE Mac Installation.html
  • 011 Windows Installation
  • external-links.zip

  • 22 - LEGACY Creating Databases and Tables
  • 001 Section 3 Introduction
  • 002 Creating Databases
  • 002 slides-for-this-section-.zip
  • 003 CODE Creating Databases.html
  • 004 Dropping Databases
  • 005 CODE Dropping Databases.html
  • 006 Using Databases
  • 007 CODE Using Databases.html
  • 008 Introduction to Tables
  • 009 The Basic Datatypes
  • 010 Note about INT max size.html
  • 011 Basic Datatypes Challenge
  • 012 Basic Datatypes Challenge - Solution.html
  • 013 Creating Your Own Tables
  • 014 CODE Creating Your Own Tables.html
  • 015 How Do We Know It Worked
  • 016 CODE How Do We Know It Worked.html
  • 017 Dropping Tables
  • 018 CODE Dropping Tables.html
  • 019 Creating Your Own Tables Challenge
  • 019 slides.zip
  • 020 CODE Creating Your Own Tables Challenge.html
  • external-links.zip

  • 23 - LEGACY Inserting Data (and a couple other things)
  • 001 Section 4 Introduction
  • 002 Inserting Data
  • 002 slides-for-this-section.zip
  • 003 CODE Inserting Data.html
  • 004 Super Quick Intro To SELECT
  • 005 CODE Super Quick Intro To SELECT.html
  • 006 Multiple INSERT
  • 007 CODE Multiple Insert.html
  • 008 INSERT Challenges
  • 009 Note about using quotes inside of inserted values.html
  • 010 INSERT Challenges Solution
  • 011 CODE INSERT Challenges Solution.html
  • 012 NOTE MySQL Warnings.html
  • 013 MySQL Warnings
  • 014 CODE MySQL Warnings.html
  • 015 NULL and NOT_NULL
  • 016 CODE NULL and NOT NULL.html
  • 017 Setting Default Values
  • 018 CODE Setting Default Values.html
  • 019 A Primer On Primary Keys
  • 020 CODE A Primer on Primary Keys.html
  • 021 Table Constraints Exercise
  • 021 exercise-slides.zip
  • 022 Table Constraints Exercise Solution
  • 023 CODE Table Constraints Exercise Solution.html
  • external-links.zip

  • 24 - LEGACY CRUD commmands
  • 001 Section 5 Introduction
  • 002 Introduction to CRUD
  • 002 this-sections-slides.zip
  • 003 CODE Introduction to CRUD.html
  • 004 Preparing Our Data
  • 005 CODE Preparing Our Data.html
  • 006 Official Introduction to SELECT
  • 007 CODE Official Introduction to SELECT.html
  • 008 Introduction to WHERE
  • 009 CODE Introduction to WHERE.html
  • 010 SELECT Challenges
  • 011 SELECT Challenges Solution
  • 012 CODE SELECT Challenges Solution.html
  • 013 Introduction to Aliases
  • 014 CODE Introduction to Aliases.html
  • 015 The UPDATE Command
  • 016 CODE The UPDATE Command.html
  • 017 UPDATE Challenges
  • 018 UPDATE Challenges Solution
  • 019 CODE UPDATE Challenges Solution.html
  • 020 Introduction to DELETE
  • 021 CODE Introduction to DELETE.html
  • 022 DELETE Challenges
  • 022 slides.zip
  • 023 DELETE Challenges Solution
  • 024 CODE DELETE Challenges Solution.html
  • external-links.zip

  • 25 - LEGACY CRUD Challenge Section
  • 001 Section 6 Introduction
  • 002 CRUD Exercise Overview
  • 002 slides.zip
  • 003 CRUD Exercise Create Solution
  • 004 CODE CRUD Exercise Create Solution.html
  • 005 CRUD Exercise Read Solution
  • 006 CODE CRUD Exercise Read Solution.html
  • 007 CRUD Exercise Update Solution
  • 008 CODE CRUD Exercise Update Solution.html
  • 009 CRUD Exercise Delete Solution
  • 010 CODE CRUD Exercise Delete Solution.html
  • external-links.zip

  • 26 - LEGACY The World Of String Functions
  • 001 Section 7 Introduction
  • 002 Important Note about Running SQL Files (please read).html
  • 003 Running SQL Files
  • 003 slides-for-this-section.zip
  • 004 CODE Running SQL Files.html
  • 005 Loading Our Book Data
  • 005 book-data.zip
  • 006 CODE Loading Our Book Data.html
  • 007 Working with CONCAT
  • 008 CODE Working With CONCAT.html
  • 009 Introducing SUBSTRING
  • 010 CODE Introducing SUBSTRING.html
  • 011 Introducing REPLACE
  • 012 CODE Introducing REPLACE.html
  • 013 Using REVERSE
  • 014 CODE Using REVERSE.html
  • 015 Working with CHAR LENGTH
  • 016 CODE Working with CHAR LENGTH.html
  • 017 Changing Case with UPPER and LOWER
  • 018 CODE Changing Case with UPPER and LOWER.html
  • 019 Note about string functions.html
  • 020 String Function Challenges
  • 020 slides.zip
  • 021 String Function Challenges Solution
  • 022 CODE String Function Challenges Solution.html
  • external-links.zip

  • 27 - LEGACY Refining Our Selections
  • 001 Section 8 Introduction
  • 002 Seed Data Adding A Couple New Books
  • 002 slides-for-this-section.zip
  • 003 CODE Seed Data Adding A Couple New Books.html
  • 004 Using DISTINCT
  • 005 CODE Using DISTINCT.html
  • 006 Sorting Data with ORDER BY
  • 007 CODE Sorting Data with ORDER BY.html
  • 008 Using LIMIT
  • 009 CODE Using LIMIT.html
  • 010 Better Searches with LIKE
  • 011 CODE Better Searches with LIKE.html
  • 012 LIKE Part 2 More Wildcards
  • 013 CODE LIKE Part 2 More Wildcards.html
  • 014 Refining Selections Exercises
  • 014 slides.zip
  • 015 Refining Selections Exercises Solution
  • 016 CODE Refining Selections Exercises Solution.html
  • external-links.zip

  • 28 - LEGACY The Magic of Aggregate Functions
  • 001 Section 9 Introduction
  • 002 The Count Function
  • 002 slides-for-this-section.zip
  • 003 CODE The Count Function.html
  • 004 The Joys of Group By
  • 005 Note about SQL Mode only_full_group_by
  • 006 CODE The Joys of Group By.html
  • 007 Min and Max Basics
  • 008 CODE MIN and MAX Basics.html
  • 009 SUBQUERIES - A Problem with Min and Max
  • 010 CODE A Problem with Min and Max.html
  • 011 Using Min and Max with Group By
  • 012 CODE Using Min and Max with Group By.html
  • 013 The Sum Function
  • 014 CODE The Sum Function.html
  • 015 The Avg Function
  • 016 CODE The Avg Function.html
  • 017 Aggregate Functions Challenges
  • 017 slides.zip
  • 018 Aggregate Functions Challenges Solution
  • 019 CODE Aggregate Functions Challenges Solution.html
  • external-links.zip

  • 29 - LEGACY Revisiting Data Types
  • 001 Section 10 Introduction
  • 002 CHAR and VARCHAR
  • 002 slides-for-this-section.zip
  • 003 Note about CHAR and VARCHAR.html
  • 004 CODE CHAR and VARCHAR.html
  • 005 DECIMAL
  • 006 CODE DECIMAL.html
  • 007 FLOAT and DOUBLE
  • 008 CODE FLOAT and DOUBLE.html
  • 009 Note about setting the timezone in Cloud9.html
  • 010 DATE, TIME, and DATETIME
  • 011 Creating Our DATE data
  • 012 CODE Creating Our DATE data.html
  • 013 CURDATE, CURTIME, and NOW
  • 014 Note about formatting dates.html
  • 015 Formatting Dates
  • 016 CODE Formatting Dates.html
  • 017 Date Math
  • 018 CODE Date Math.html
  • 019 Working with TIMESTAMPS
  • 020 CODE Working with TIMESTAMPS.html
  • 021 Data Types Exercises
  • 021 slides.zip
  • 022 Data Types Exercises Solution
  • 023 CODE Data Types Exercises Solution.html
  • external-links.zip

  • 30 - LEGACY The Power of Logical Operators
  • 001 Section 11 Introduction
  • 002 Not Equal
  • 002 slides-for-this-section.zip
  • 003 CODE Not Equal.html
  • 004 Not Like
  • 005 CODE Not Like.html
  • 006 Greater Than
  • 007 CODE Greater Than.html
  • 008 Less Than
  • 009 CODE Less Than.html
  • 010 Logical AND
  • 011 CODE Logical AND.html
  • 012 Logical OR
  • 013 CODE Logical OR.html
  • 014 Between
  • 015 CODE Between.html
  • 016 In And Not In
  • 017 CODE In And Not In.html
  • 018 Case Statements
  • 019 CODE Case Statements.html
  • 020 Logical Operators Exercises
  • 020 slides.zip
  • 021 Logical Operators Exercises Solution
  • 022 CODE Logical Operators Exercises Solution.html
  • external-links.zip

  • 31 - LEGACY Section 12 One To Many
  • 001 Section 12 Introduction
  • 002 Real World Data Is Messy
  • 002 slides-for-this-section.zip
  • 003 Types of Data Relationships
  • 004 One To Many The Basics
  • 005 Working With Foreign Keys
  • 006 CODE Working With Foreign Keys.html
  • 007 Cross Join
  • 008 CODE Cross Joins.html
  • 009 Inner Join
  • 010 CODE Inner Joins.html
  • 011 Left Join
  • 012 CODE Left Joins.html
  • 013 Right Joins Pt 1
  • 014 CODE Right Joins Part 1.html
  • 015 Right Joins Pt 2
  • 016 CODE Right Joins Part 2.html
  • 017 Right and Left Joins A Common Question
  • 018 CODE Right and Left Joins FAQ.html
  • 019 Our First Joins Exercise
  • 019 slides.zip
  • 020 Our First Joins Exercise SOLUTION
  • 021 CODE Our First Joins Exercise.html
  • 022 Our First Joins Exercise SOLUTION PT. 2
  • 023 CODE Our First Joins Exercise SOLUTION PT. 2.html
  • external-links.zip

  • 32 - LEGACY Many To Many
  • 001 Section 13 Introduction
  • 002 Many To Many Basics
  • 002 slides.zip
  • 003 Creating Our Tables
  • 004 CODE Creating Our Tables.html
  • 005 TV Joins Challenge 1
  • 006 CODE TV Joins Challenge 1 Solution.html
  • 007 TV Joins Challenge 2
  • 008 CODE TV Joins Challenge 2 SOLUTION.html
  • 009 TV Joins Challenge 3
  • 010 CODE TV Joins Challenge 3 SOLUTION.html
  • 011 TV Joins Challenge 4
  • 012 CODE TV Joins Challenge 4 SOLUTION.html
  • 013 TV Joins Challenge 5
  • 014 CODE TV Joins Challenge 5 SOLUTION.html
  • 015 TV Joins Challenge 6
  • 016 CODE TV Joins Challenge 6 SOLUTION.html
  • 017 TV Joins Challenge 7
  • 018 CODE TV Joins Challenge 7 SOLUTION.html
  • external-links.zip

  • 33 - LEGACY Instagram Database Clone
  • 001 Section 14 Introduction
  • 002 Introduction To Instagram Clone Schema
  • 002 slides-for-this-section.zip
  • 003 Cloning Instagrams DB Users Schema
  • 004 CODE IG Clone Users Schema.html
  • 005 Cloning Instagrams DB Photos Schema
  • 006 CODE IG Clone Photos Schema.html
  • 007 Cloning Instagrams DB Comments Schema
  • 008 CODE IG Clone Comments Schema.html
  • 009 Cloning Instagrams DB Likes Schema
  • 010 CODE IG Clone Likes Schema.html
  • 011 Cloning Instagrams DB Followers Schema
  • 012 CODE IG Clone Followers Schema.html
  • 013 Note about Cloning Instagrams DB Hashtags Part 1.html
  • 014 Cloning Instagrams DB Hashtags Part 1
  • 015 Cloning Instagrams DB Hashtags Part 2
  • 016 CODE IG Clone Hashtags Schema.html
  • 017 CODE Complete IG Clone Schema.html
  • external-links.zip

  • 34 - LEGACY Working With Lots Of Instagram Data
  • 001 Section 15 Introduction
  • 002 Note about Loading The JUMBO dataset.html
  • 003 Loading The JUMBO dataset
  • 004 The Instagram Clone DATASET.html
  • 004 ig-clone-data.zip
  • 005 Instagram Clone Challenge 1
  • 005 slides.zip
  • 006 Instagram Challenge 1 Solution CODE.html
  • 007 Instagram Clone Challenge 2
  • 008 Instagram Challenge 2 Solution CODE.html
  • 009 Instagram Clone Challenge 3
  • 010 Instagram Challenge 3 Solution CODE.html
  • 011 Instagram Clone Challenge 4
  • 012 Instagram Challenge 4 Solution CODE.html
  • 013 Instagram Clone Challenge 5
  • 014 Instagram Challenge 5 Solution CODE.html
  • 015 Instagram Clone Challenge 6
  • 016 Instagram Challenge 6 Solution CODE.html
  • 017 Note about Instagram Clone Challenge 7.html
  • 018 Instagram Clone Challenge 7
  • 019 Instagram Challenge 7 Solution CODE.html
  • external-links.zip

  • 35 - LEGACY Introducing Node
  • 001 Note about Introducing Node.html
  • 002 Section 16 Introduction
  • 003 MySQL and Other Languages
  • 003 slides-for-this-section.zip
  • 004 BUT WHAT ABOUT PHP
  • 005 Introduction to JOIN US app
  • 006 Note about Setting Up Cloud9 for Node.html
  • 007 5 Minute NodeJS Crash Course
  • 008 CODE 5 Minute Node Crash Course.html
  • 009 Note about Faker install.html
  • 010 Introduction to NPM and Faker
  • 010 fakerjs-github-repo.zip
  • 011 CODE Introduction to NPM and Faker.html
  • 012 Introducing the MySQL Package
  • 012 mysql-node-package-github-repo.zip
  • 013 Note about connecting Node to MySQL.html
  • 014 Connecting Node to MySQL
  • 015 CODE Connecting Node to MySQL.html
  • 016 Creating Our Users Table
  • 017 CODE Creating Our Users Table.html
  • 018 Selecting Using Node
  • 019 CODE Selecting Using Node.html
  • 020 Inserting Using Node
  • 021 CODE Inserting Using Node.html
  • 022 Some MySQLNode Magic
  • 023 Bulk Inserting 500 Users - Finally!
  • 024 CODE Bulk Inserting 500 Users.html
  • 025 500 Users Exercises
  • 025 slides.zip
  • 026 500 Users Exercises Solutions
  • 027 CODE 500 Users Exercises Solutions.html
  • external-links.zip

  • 36 - LEGACY Building Our Web App
  • 001 Section 17 Introduction
  • 002 JoinUsCompleteCode.zip
  • 002 Join Us Completed CODE.html
  • 003 Introducing Express
  • 003 express-documentation.zip
  • 003 slides.zip
  • 004 NPM Init and package.json files
  • 005 Note about Our First Simple Web App.html
  • 006 Our First Simple Web App
  • 007 CODE Our First Simple Web App.html
  • 008 Adding Multiple Routes
  • 009 CODE Adding Multiple Routes.html
  • 010 Connecting Express and MySQL
  • 011 CODE Connecting Express and MySQL.html
  • 012 Adding EJS Templates
  • 013 CODE Adding EJS Templates.html
  • 013 JOIN-US-HTML-AND-CSS.zip
  • 014 Connecting The Form
  • 015 CODE Connecting the Form.html
  • 016 Styling Part 1
  • 017 CODE HTML AND CSS FILES.html
  • 017 JOIN-US-HTML-AND-CSS.zip
  • 018 Styling Part 2
  • external-links.zip

  • 37 - LEGACY Database Triggers
  • 001 Introduction to Database Triggers
  • 001 lecture-slides.zip
  • 002 Writing Our First Trigger Part 1
  • 002 lecture-slides.zip
  • 003 Writing Our First Trigger Part 2
  • 003 lecture-slides.zip
  • 004 Note about next lecture.html
  • 005 Preventing Instagram Self-Follows With Triggers
  • 005 lecture-slides.zip
  • 006 Creating Logger Triggers
  • 006 lecture-slides.zip
  • 007 Managing Triggers And A Warning
  • 007 lecture-slides.zip
  • external-links.zip

  • 38 - Additional Resources
  • 001 Links to Additional SQL Learning Resources.html
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    شناسه: 2114
    حجم: 9233 مگابایت
    مدت زمان: 2193 دقیقه
    تاریخ انتشار: 27 دی 1401
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید