Setup Menus in Admin Panel

Course Curriculum

Introduction to Databases, SQL, and MYSQL
1.1 Introduction to Databases 00:00:00
1.2 Welcome to SQL 00:00:00
1.3 Welcome to the course 00:00:00
1.4 Why MySQL 00:00:00
1.5 Why SQL 00:00:00
SQL Theory
2.1 Data Control Language (DCL) 00:00:00
2.2 Data Definition Language (DDL) 00:00:00
2.3 SQL Keywords 00:00:00
2.4 Transaction Control Language (TCL) 00:00:00
Basic Database Terminology
3.1 Database Terminology 00:00:00
3.2 Databases vs spreadsheets 00:00:00
3.3 Foreign Key 00:00:00
3.4 Relational Schemas Primary Key 00:00:00
3.5 Relationships 00:00:00
3.6 Unique Key and Null Values 00:00:00
Installing MySQL & Getting Acquainted with the Interface
4.1 Installing MySQL 00:00:00
4.2 Introduction to the MySQL Interface 00:00:00
4.3 New Authentication Plugin – Creating a New User 00:00:00
4.4 Setting Up a Connection 00:00:00
4.5 The Client-Server Model 00:00:00
First Steps in SQL
5.1 Additional Notes on Using Tables 00:00:00
5.2 Creating a Database – Part II 00:00:00
5.3 Creating a Table 00:00:00
5.4 Fixed and Floating-Point Data Types 00:00:00
5.5 Integers 00:00:00
5.6 Introduction to Data Types 00:00:00
5.7 Other Useful Data Types 00:00:00
5.8 String Data Types 00:00:00
5.9 Using Databases and Tables 00:00:00
MY SQL Constraints
6.1 DEFAULT Constraint 00:00:00
6.2 FOREIGN KEY Constraint – Part I 00:00:00
6.3 FOREIGN KEY Constraint – Part II 00:00:00
6.4 NOT NULL Constraint – Part I 00:00:00
6.6 UNIQUE Constraint 00:00:00
SQL Best Practices
SQL SELECT STATEMENT
9.1 AND 00:00:00
9.2 BETWEEN… AND… 00:00:00
9.3 GROUP BY 00:00:00
9.4 HAVING 00:00:00
9.5 IN – NOT IN 00:00:00
9.6 Introduction to Aggregate Functions 00:00:00
9.7 IS NOT NULL – IS NULL 00:00:00
9.8 LIMIT 00:00:00
9.9 Operator Precedence 00:00:00
9.10 OR 00:00:00
9.11 ORDER BY 00:00:00
9.12 Other Comparison Operators 00:00:00
9.13 SELECT DISTINCT 00:00:00
9.14 Using Aliases (AS) 00:00:00
9.15 WHERE 00:00:00
9.16 WHERE vs HAVING – Part I 00:00:00
9.17 WHERE vs HAVING – Part II 00:00:00
9.18 Wildcard Characters 00:00:00
SQL INSERT STATEMENT
10.1 Inserting Data INTO a New Table 00:00:00
10.2 The INSERT Statement – Part I 00:00:00
10.3 The INSERT Statement – Part II 00:00:00
SQL UPDATE Statement
11.1 TCL’s COMMIT and ROLLBACK 00:00:00
11.2 The UPDATE Statement- Part I 00:00:00
11.3 The UPDATE Statement- Part II 00:00:00
My SQL Aggregate Functions
13.1 Another Way to Create a Procedure in MySQL 00:00:00
13.2 AVG() 00:00:00
13.3 MIN() and MAX() 00:00:00
13.4 ROUND() 00:00:00
13.5 SUM() 00:00:00
SQL JOIN'S
14.1 CROSS JOIN 00:00:00
14.2 INNER JOIN – Part I 00:00:00
14.3 INNER JOIN – Part II 00:00:00
14.4 JOIN and WHERE Used Together 00:00:00
14.5 JOIN more than Two Tables in SQl 00:00:00
14.6 LEFT JOIN – Part I 00:00:00
14.7 LEFT JOIN – Part II 00:00:00
14.8 RIGHT JOIN 00:00:00
14.9 The New and the Old Join Syntax 00:00:00
14.10 Tips and Tricks for JOINs 00:00:00
14.11 UNION vs UNION ALL 00:00:00
14.12 Using Aggregate Functions with JOINs 00:00:00
SQL Routlines
17.1 Stored Procedures – Example – Part I 00:00:00
17.2 Stored Procedures – Example – Part II 00:00:00
17.3 Stored Procedures with an Input Parameter 00:00:00
17.4 Stored Procedures with an Output Parameter 00:00:00
17.5 The MySQL Syntax for Stored Procedures 00:00:00
17.6 User-Defined Functions in MySQL 00:00:00
Advanced SQL Topics
18.1 MySQL Indexes 00:00:00
18.2 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE 3 00:00:00
18.3 The CASE Statement 00:00:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

PRIVATE COURSE
  • PRIVATE
  • 1 year
1 STUDENTS ENROLLED
Copyright @2019