There are no items in your cart
Add More
Add More
| Item Details | Price | ||
|---|---|---|---|
SQL Mastery
Instructor: Drishya
Language: English, Malayalam
Validity Period: Lifetime
₹10000 including 18% GST
No Description Available
| 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 :
Other Courses
Launch your Graphy