access
Lifetime
content
8 Hours
enrolled
557
Description
Whether you work in marketing, sales, or app development, chances are you'll have questions that only data can solve, which is why virtually everyone can benefit from learning MySQL. Based on SQL (Structured Query Language), MySQL is the world's most popular open-source SQL database and is used by the likes of Amazon, Apple, Twitter, many other top companies. This course serves as your SQL and MySQL primer, walking you through the basic syntax, queries, and more so you can add this data-driven tool to your workflow.- Access 159 lectures & 8 hours of training 24/7
- Learn how to fluently use SQL & MySQL
- Explore the basic syntax of MySQL
- Discover how to join two or more tables
- Learn how to design and develop schemes
- Explore building web applications with PHP
- Learn how to build the data structure of a social networking website
Instructor
Joe Parys is a certified life coach, professional motivational speaker, entrepreneur, licensed psychology teacher and head basketball coach for USA Basketball. His main areas of expertise are teaching, coaching, public speaking, personal development, personal transformation, the human mind, maximizing human potential, motivation and goal setting.Important Details
- Length of time users can access this course: lifetime
- Access options: web and mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: beginner
Requirements
- Internet required
Terms
- Unredeemed licenses can be returned for store credit within 15 days of purchase. Once your license is redeemed, all sales are final.
Course Outline
- INTRODUCTION TO MYSQL
- Would You Like To Learn MySQL From Scratch?! - 2:10
- 0.5) Welcome to the Complete MySQL Course! - 2:33
- 1 Introductin to Intro - 3:29
- 2 How to Use MySQL - 3:40
- 3 Tooling and isntalling mysql - 2:44
- 4 Tooling and Hello world - 4:38
- DATABASES AND QUERIES
- 1 Creating Database - 4:38
- 1 Creating Databases
- 2 Dropping Databases
- 2 Dropping Databases - 3:19
- 3 Data Types - 3:52
- 3 Data Types
- 4 Creating Table - 7:57
- 5 Dropping Table - 4:09
- 5 Dropping Table
- 6 Alter Table
- 6 Alter Table - 8:10
- 7 Inserting Data into Database - 8:05
- 7 Inserting Data into Database
- 8 Inserting Multiple Records - 3:22
- 8 Inserting Multiple Data
- 9 Deleting A Row - 3:01
- 9 Deleting A Row
- 10 Deleting Multiple Rows - 2:18
- 10 Deleting Multiple Rows
- 11 Truncate - 2:03
- 11 Truncate
- 12 Inserting Fake Data - 5:50
- SQL Statements Fundamentals
- 1 Statements Basics - 0:47
- 1 Generate Fake Data
- 2 The Select Statement - 9:00
- 2 SELECT Statement
- 3 SELECT DISTINTC - 4:14
- 3 SELECT DISTINCT
- 4 WHERE - 9:52
- 4 WHERE
- 5 Alises AS
- 5 Alias AS - 2:56
- 6 LIMIT and Offset - 2:58
- 6 LIMIT and Offset
- 7 SELECT COUNT - 4:09
- 7 SELECT COUNT
- 8 Between - 2:07
- 8 Between
- 9 IN - 2:49
- 9 IN
- 10 Order By - 5:44
- 10 Order By
- 11 Aggregate Function - 4:27
- 11 Aggregate Functions
- 12 Group By - 14:42
- 12 Group by
- 13 HAVING - 5:44
- 13 HAVING
- Create, Read, Update, Delete (CRUD)
- 1 Intro - 2:33
- 1 intro
- 2 Create - 3:20
- 2 Create
- 3 Read - 2:39
- 3 Read
- 4 Update
- 4 Update - 5:35
- 5 Delete
- 5 Delete - 5:43
- Data Types and Operators
- 1 Intro - 0:42
- 2 CHAR - 11:09
- 2 CHAR
- 3 Decimal - 7:29
- 3 Date and Time
- 3 Decimal
- 4 Date and Time - 8:26
- 4 Date and Time
- 5 Current Time and Date
- 5 Current Time and Date - 4:12
- 6 Date and Time Functions
- 6 Date and Time Funcations - 7:48
- 7 DATEDIFF - 6:41
- 8 DATEADD - 4:35
- 8 DateADD
- 9 TIMEstamps and CURRENTTIME STAMP - 10:43
- 9 Timestamps and CURRENT TIME STAMP
- 10 SDate Format - 4:02
- 10 Date Format
- Links
- String and Mathematical Functions
- 1 Intro - 2:16
- 1 Substr
- 2 Substr - 2:25
- 3 Concat - 3:05
- 3 Concat
- 4 ASCII - 2:27
- 4 ASCII
- 5 BIN - 2:05
- 5 BIN
- 6 TRIM
- 6 TRIM - 2:22
- 7 String Length
- 7 String Length - 2:21
- 8 Upper and Lower Case - 3:09
- 8 Upper and Lower Case
- 9 Reverse - 2:13
- 9 Reverse
- 10 String Replace - 4:47
- 10 String Replace
- 11 String Compare - 2:59
- 11 String Compare
- 12 Intro to Maths Functions - 0:44
- 13 Rand - 1:28
- 13 Rand
- 14 Round - 1:54
- 14 Rand
- Joins and Relationships
- 1 Introduction to Relationships - 4:58
- 1 Inner Join
- 2 Types Of Relation - 6:17
- 2 Cross Join
- 3 One to Many Relation - Free Preview - 7:30
- 3 Left Join
- 4 Querying Table - 5:58
- 5 Cross Join - 2:14
- 5 Querying Table
- 6 Inner Join - 15:54
- 7 Left Join - 9:00
- 8 Right Join - 4:26
- PROJECT I : Twitter Clone Design & Development
- 1 Intro - 0:49
- 2 Our Entities Basics - 3:27
- 3 Working with Users Schema - 8:43
- 4 Tweets Schema - 10:15
- 5 Inserting Tweets - 6:56
- 6 Tweet Replies - 14:39
- 7 Relation Between Users and Replies - 4:42
- 8 Tweet Has Reply - 6:10
- 9 Likes and Its relation - 20:43
- Porject Codes
- Project II : Contact Diary Web Application
- 1 Intro - 3:44
- 2 Building UI - 8:10
- 3 Table Schema - 3:45
- 4 Connecting to Database - 6:24
- 5 Adding Contacts to Database - 7:27
- 6 Contact Lists - 4:42
- 7 Deleting From Table - 6:03
- 8 Details of Contact - 7:40
- 9 Update Contacts - 8:15
- 10 Checks - 3:40
- contacts
- edit
- DB_SCHEMA
- contacts
- index
- update
- conn
- details
- delete
- BONUS: Git and Github
- 1 Intro - 2:02
- 2 Git Installation - 3:41
- 3 Cloning From Github - 5:46
- 4 Repositories - 5:35
- 5 Pushing on github - 7:41
- 6 Pull from Github - 3:13
- 7 Branches Basics - 7:22
- Course Summary, and Conclusion
- MYSQL CONCLUSION - 1:37
access
Lifetime
content
8 Hours
enrolled
557
