There are no items in your cart
Add More
Add More
Item Details | Price |
---|
Instructor: Drishya
Language: English, Malayalam
Validity Period: Lifetime
Module 1: Introduction to Database | |||
01.SQL INTTRODUCTION 15:00 | |||
Module 2: SQL Concepts | |||
02.SQL THEORY-DDL 17:00 | |||
03.SQL THEORY-DML 9:00 | |||
04.SQL THEORY-DCL | |||
05.SQL THEORY-TCL 6:00 | |||
Module 3: Basic Database Terminology | |||
06. BASIC DATABASE TERMINOLOGY 16:00 | |||
07.PRIMARY KEY 6:00 | |||
08.FOREIGN KEY 6:00 | |||
09.UNIQUE KEY AND NULL VALUES 3:00 | |||
10.RELATIONSHIPS 6:00 | |||
Module 4: Installing SQL | |||
11-Installing MYSQL 22:00 | |||
Module 5: First Steps in SQL | |||
11.FIRST STEPS IN MYSQL-CREATE DATABASE 15:00 | |||
12. INTRODUCTION TO DATA TYPES 6:00 | |||
13. STRING DATA TYPES 8:00 | |||
14. INTEGER DATA TYPES 5:00 | |||
15. FIXED AND FLOATING POINT DATA TYPES 11:00 | |||
16.OTHER USEFUL DATA TYPES 8:00 | |||
17. CREATING A TABLE 4:00 | |||
Module 6: My SQL Constraints | |||
18. MYSQL CONSTRAINTS-PRIMARY KEY 22:00 | |||
19. FOREIGN KEY CONSTRAINT 19:00 | |||
20. UNIQUE KEY CONSTRAINT 13:00 | |||
21. DEFAULT CONSTRAINT 13:00 | |||
22. not null constraints 9:00 | |||
Module 7: SQL Best Practices | |||
23. CODING TECHNIQUES AND BEST PRACTICES 11:00 | |||
Module 8: SQL Select Statement | |||
24. LOADING EMPLOYEES DATABASE 14:00 | |||
25.SELECT..FROM | |||
26.SELECT..FROM..WHERE 5:00 | |||
27 .SELECT..FROM..WHERE..AND 5:00 | |||
28.SELECT...FROM.WHERE.OR 5:00 | |||
29. OPERATOR PRECEDENCE | |||
30.IN -NOT IN OPERATORS 7:00 | |||
31.LIKE- NOT LIKE OPERATORS | |||
32.BETWEEN AND-NOT BETWEEN AND OPERATORS | |||
33.IS NOT NULL-IS NULL OPERATORS 6:00 | |||
34. OTHER COMPARISON OPERATORS 10:00 | |||
35.SELECT DISTINCT 3:00 | |||
36.introduction to aggregate functions 9:00 | |||
37. ORDER BY CLAUSE 6:00 | |||
38.GROUP BY CLAUSE, ALIASES 9:00 | |||
39.HAVING, WHERE VS HAVING,LIMIT 22:00 | |||
Module 9: SQL Insert Statement | |||
40. INSERT STATEMENTS-PART 1,2 AND 3 | |||
Module 10: SQL Update Statement | |||
41.UPDATE STATEMENT PART 1 AND 2 13:00 | |||
Module 11: SQL Delete Statement | |||
42. DELETE STATEMENT PART 1 AND 2 12:00 | |||
Module 12: SQL Aggregate Function | |||
43.SQL AGGREGATE FUNCTIONS-COUNT() 13:00 | |||
44. Aggregate Functions-sum(),min(),max(),avg() 6:00 | |||
45.ROUND() 6:00 | |||
46.IFNULL(),COALESCE() 25:00 | |||
Module 13: SQL Joins | |||
47. INTRODUCTION TO SQL JOINS 14:00 | |||
48. INNER JOIN 23:00 | |||
49.DUPLICATE RECORDS 8:00 | |||
50.LEFT JOIN 6:00 | |||
51. RIGHT JOIN 4:00 | |||
52.cross join 11:00 | |||
53.join more than two tables with aggregate funtion 7:00 | |||
54.UNION---UNION ALL 18:00 | |||
Module 14: SQL SubQueries | |||
55. SQL SUB QUERY- NESTED IN 14:00 | |||
56.subqueries nested exists-not exists 18:00 | |||
57. SUBQUERIES SELECT..FROM | |||
Module 15: SQL Self Join | |||
58.self join | |||
Module 16: SQL Views | |||
59. SQL VIEWS 24:00 | |||
Module 17: SQL Routines | |||
60.STORED ROUTINE 6:00 | |||
61.MYSQL SYNTAX FOR STORED PROCEDURE 11:00 | |||
62.CREATING STORED PROCEDURE BY WORK BENCH INTERFACE 6:00 | |||
63.STORED PROCEDURE WITH IN PARAMETER 20:00 | |||
64.STORED POCEDURE WITH OUT PARAMETER 15:00 | |||
65.SQL VARIABLES 5:00 | |||
66.USER DEFINED FUNCTIONS 10:00 | |||
Module 18: Advanced SQL Topics | |||
67.ADVANCE SQL TOPICS-TYPES OF VARIABLES-LOCAL VARIABLES 13:00 | |||
68.session variable 8:00 | |||
69.GLOBAL VARIABLES 6:00 | |||
Module 19: Combining Tableau and SQL | |||
70. MY SQL INDEXES 14:00 | |||
71.MYSQLTRIGGERS 18:00 | |||
Project 1: Bank Database System | |||
bank database management system Part 1 3:00 | |||
bank database management system Part 2 9:00 | |||
bank database management system Part 3 11:00 | |||
Project 2: Employee Payroll Management System | |||
EMPLOYEE DATABASE AND PAYROLL MANAGEMENT SYSTEM Part 1- 4:00 | |||
EMPLOYEE DATABASE AND PAYROLL MANAGEMENT SYSTEM Part 2 11:00 | |||
EMPLOYEE DATABASE AND PAYROLL MANAGEMENT SYSTEM Part 3 10:00 | |||
EMPLOYEE DATABASE AND PAYROLL MANAGEMENT SYSTEM Part 4 7:00 | |||
Project 3: Library Management System | |||
library management system Part 1 16:00 | |||
library management system Part 2 29:00 | |||
Project 4: Railway Reservation System | |||
railway reservation management system Part 1 12:00 | |||
railway reservation management system Part 2 6:00 | |||
railway reservation management system Part 4 10:00 | |||
railway reservation management system Part3 10:00 | |||
Project 5: Store Database System | |||
store database management system Part 1 15:00 | |||
store database management system Part 2 4:00 | |||
store database management system Part 3 8:00 | |||
Project 6: Geospatial Data in MySql Server | |||
geospatial database Managment system- | |||
Project 7: Airbnb | |||
Airbnb part 1 10:00 | |||
Airbnb Part 2 12:00 | |||
Airbnb Part 3 5:00 | |||
Project 8: Software Integration of Airport Data base | |||
Airport database management Part 1 12:00 | |||
Airport database management Part 2 5:00 | |||
Airport database management Part 3 7:00 | |||
Airport database management Part 4 18:00 | |||
Airport database management Part 5 20:00 | |||
Project 9: Sales Insights | |||
sales insights 19:00 | |||
Project 10: Realtime Manufacturing | |||
realtime manufacturing Part 1 3:00 | |||
realtime manufacturing Part 2 12:00 | |||
realtime manufacturing Part 3 17:00 |
After successful purchase, this item would be added to your courses.
You can access your courses in the following ways :