You can join the NEW Web Development batch using the below link.
🔥Delta 3.0(Full Stack Web Development) : https://www.apnacollege.in/course/delta-batch-3
Early bird offer for first 5000 students only!
International Student (payment link) – https://buy.stripe.com/7sI00cdru0tg10saEQ
—————————————————
📌 Details about the Delta 3.0 Batch :
– Start Date : 7th November, 2023
– Alternate day lectures (at 8PM)
– Duration – 4.5 months
– Each Class duration : 1.5 hour-2hour (alternate days)
– Access to the course is for 2 years
– Complete Frontend Development with HTML, CSS, Javascript & ReactJs
– Complete Backend Development (NodeJs, ExpressJs)
– Complete Database -( SQL & MongoDB)
– Complete MERN Stack (MongoDB, Express, React, Node)
– Real Life and Industry Grade Projects
– Live Mentorship Sessions
– 500+Topic Videos
– Certificate will be given on Completion.
Link for SQL Notes : https://drive.google.com/drive/folders/1wfNTKinBAV6CCxaI5lfSnnRFAYpy0uEl?usp=share_link
SQL Timestamps:
Start – 00:00
Introduction to SQL – 01:43
01:48 What is database?
03:45 Types of databases
08:03 Installation of MySQL
13:03 Database Structure
14:21 What is table?
16:29 Creating our first database
22:41 Creating our first table
29:49 SQL Datatypes
37:11 Types of SQL Commands
40:09 Database related queries
43:43 Table related queries
46:11 SELECT Command
47:22 INSERT Command
51:19 Practice Questions
56:25 Keys
01:01:26 Constraints
01:13:04 SELECT Command in Detail
01:15:10 Where Clause
01:21:19 Operators
01:25:21 Limit Clause
01:26:48 Order By Clause
01:29:12 Aggregate Functions
01:32:33 Group By Clause
01:37:51 Practice Questions
01:43:35 Having Clause
01:47:18 General Order of Commands
01:50:31 UPDATE Command
01:56:40 DELETE Command
01:58:41 Revisiting Foreign Keys
02:06:35 Cascading Foreign Keys
02:12:30 ALTER Command
02:15:06 CHANGE and MODIFY Commands
02:20:33 TRUNCATE Command
02:24:00 JOINS in SQL
02:51:23 UNION in SQL
02:53:54 SQL Sub Queries
03:11:26 MySQL Views
コメント