The Complete MySQL Bootcamp: Become an Expert in SQL & MySQL

Description

In this course, you will : 

• Be able to build web applications using PHP and MySQL
• Be able to create small and big databases using SQL and MySQL
• Be able to write simple and complex queries
• Be able to write complex queries on tables.
• Be able to fluently understand and apply SQL and MySQL for future jobs and freelancing positions

Syllabus :

1. Databases and Queries

• Creating Databases
• Dropping Databases
• Data Types
• Creating Table
• Dropping Table
• Alter Table
• Inserting Data Into Database
• Inserting Multiple Data Records
• Deleting Single Record
• Deleting Multiple Records
• Truncate
• Inserting Fake Data

 

2. SQL Statements Fundamentals

• Statement Basics
• The Select Statement
• SELECT DISTINCT
• WHERE
• AS
• LIMIT and Offset
• SELECT COUNT
• Between
• IN
• Order By
• Aggregate Function
• Group By
• Having

 

3. 4 Create, Read, Update, Delete (CRUD)

• Introduction to CRUD
• Create
• Read
• Update
• Delete

 

5. Data Types and Operators

• Char
• Decimal
• Date and Time
• Current Time and Date
• Date and Time Functions
• Date Diff
• DATEADD
• TIMESTAMP and CURRENTTIMESTAMP
• Date Format

 

6. String and Mathematical Functions

• Introduction to String and Mathematical Functions
• Sub String
• Concatenation
• ASCII
• BIN
• TRIM
• String Length
• Upper and Lower Case
• Reverse
• String Replace
• String Compare
• Introduction to Mathematical Functions
• Rand
• Round

 

7. Joins and Relationships

• Introduction to Relationships
• Types Of Relation
• One to Many Relation
• Querying Table
• Cross Join
• Inner Join
• Left Join
• Right Join

 

8. PROJECT I : Twitter Clone Design & Development

• Our Entities
• Working with Users Schema
• Tweets Schema
• Inserting Tweets
• Tweet Replies
• Relation Between Users and Replies
• Tweet Has Reply
• Like and its Relation

 

9. Project II : Contact Diary Web Application

• Building User Interface (UI)
• Table Schema
• Connecting to Database
• Adding Contacts to Database
• Contact Lists
• Deleting From Table
• Details of Contacts
• Update Contacts
• Checks
• Project & DB Schema

Show more