Private Course
Please sign in to contact responsible
| Responsible | gavireddy hruthik |
|---|---|
| Last Update | 29/04/2025 |
| Completion Time | 1 day 5 hours 47 minutes |
| Members | 5 |
Advanced
-
SQL-FULL COURSE110Lessons · 1 day 5 hrs 47 mins
-
SQL - Part 1 - Database Concepts (Database, DBMS, Data Models, RDBMS and SQL)
-
SQL - Part 2 - Practice SQL without installing any Software
-
SQL - Part 3 - Select Command
-
SQL - Part 4 - distinct keyword
-
SQL - Part 5 - SQL is not case sensitive
-
SQL - Part 6 - Semicolon
-
SQL - Part 7 - Where Clause
-
SQL - Part 8 - Using Relational Operators in Where Clause Condition
-
SQL - Part 9 - Using Logical Operators (AND, OR, NOT)
-
SQL - Part 10 - Between Operator
-
SQL - Part 11 - Order By Clause (ASC, DESC)
-
SQL - Part 12 - Using Between Operator with Text
-
SQL - Part 13 - In Operator
-
SQL - Part 14 - Like Operator and Wildcard Characters
-
SQL - Part 15 - Aliases for Table Column Names AS Keyword
-
SQL - Part 16 - Limit Keyword
-
SQL - Part 17 - Breaking the Lengthy SQL Statement into multiple lines
-
SQL - Part 18 - MySQL Built in Functions
-
SQL - Part 19 - upper() MySQL String Function
-
SQL - Part 20 - lower() MySQL String Function
-
SQL - Part 21 - length() MySQL String Function
-
SQL - Part 22 - instr() MySQL String Function
-
SQL - Part 23 - substr() MySQL String Function
-
SQL - Part 24 - concat() MySQL String Function
-
SQL - Part 25 - trim() MySQL String Function
-
SQL - Part 26 - abs() MySQL Numeric Function
-
SQL - Part 27 - mod() MySQL Numeric Function
-
SQL - Part 28 - greatest() and least() MySQL Numeric Functions
-
SQL - Part 29 - truncate() MySQL Numeric Function
-
SQL - Part 30 - power() and sqrt() MySQL Numeric Functions
-
SQL - Part 31 - current_date(), curdate(), current_time(), curtime(), now() & sysdate()
-
SQL - Part 32 - year(),month(),day(),monthname(),dayname() MySQL Date Time Functions
-
SQL - Part 33 - avg(), max(), min(), count() and sum() MySQL Aggregate Functions
-
SQL - Part 34 - Arithmetic Operators
-
SQL - Part 35 - Installing MySQL Server and Workbench Client for Practising SQL
-
SQL - Part 36 - Creating, Deleting, viewing and using Databases
-
SQL - Part 37 - Creating, Viewing, Describing and Deleting Tables
-
SQL - Part 38 - Insert Into Statements (For inserting data into Tables)
-
SQL - Part 39 - Data Types
-
SQL - Part 40 - Null Value, Is Null Operator and Is Not Null Operator
-
SQL - Part 41 - Delete Statement (For Deleting the Records from Table)
-
SQL - Part 42 - Update Statement and Set Keyword (For Updating the Table Records)
-
SQL - Part 43 - Rename statement and To Keyword (For Renaming Table Name)
-
SQL - Part 44 - Alter Statement, Add, Modify Column, Rename Column, and Drop Column
-
SQL - Part 45 - Set Autocommit
-
SQL - Part 46 - Commit Statement
-
SQL - Part 47 - Rollback Statement
-
SQL - Part 48 - Truncate Statement
-
SQL - Part 49 - Single Line and Multi Line Comments
-
SQL - Part 50 - Group By Clause
-
SQL - Part 51 - Having Clause
-
SQL - Part 52 - Sequence of using where, group by, having and order by clauses
-
SQL - Part 53 - Set Operators
-
SQL - Part 54 - Union Operator
-
SQL - Part 55 - Union All Operator
-
SQL - Part 56 - Intersect Operator
-
SQL - Part 57 - Minus Operator
-
SQL - Part 58 - Tables and Aliases
-
SQL - Part 59 - Joins (Inner Join, Left Join, Right Join, Full Join and Self Join)
-
SQL - Part 60 - Sub Query (Single Row Sub Query explained by solving different problems)
-
SQL - Part 61 - In Operator
-
SQL - Part 62 - Using In Operator with Multi Row Sub Query
-
SQL - Part 63 - Using Any Operator in Multi Row Sub Query
-
SQL - Part 64 - Using All Operator in Multi Row Sub Query
-
SQL - Part 65 - Exists Operator
-
SQL - Part 66 - Using Sub Queries for retrieving the records from multiple tables
-
SQL - Part 67 - Using Multiple Sub Queries in a single SQL statement
-
SQL - Part 68 - Integrity Constraints
-
SQL - Part 69 - Not Null Integrity Constraint
-
SQL - Part 70 - Unique Integrity Constraint
-
SQL - Part 71- Primary Key Integrity Constraint
-
SQL - Part 72 - Foreign Key Integrity Constraint
-
SQL - Part 73 - Check Integrity Constraint
-
SQL - Part 74 - Default Integrity Constraint
-
SQL - Part 75 - auto_increment
-
SQL - Part 76 - Insert Into
-
SQL - Part 77 - AS Keyword
-
SQL - Part 78 - IfNull() function
-
SQL - Part 79 - Case, When, Then and End Keywords
-
SQL - Part 80 - Delimiter
-
SQL - Part 81 - Delimiter usage in Stored Procedures
-
SQL - Part 82 - Views
-
SQL - part 83 - Indexes
-
SQL - Part 84 - JDBC (MySQL Database connection from Java Programs)
-
SQL - Part 85 - ODBC (Object Database Connectivity) using SQL ODBC Query Client Tool
-
SQL - Part 86 - MySQL Shell Command Line Tool
-
SQL - Part 87 - MySQL Command Line Client
-
SQL - Part 88 - Using default Windows Command Prompt for connecting to MySQL Server
-
SQL - Part 89 - Types of SQL Statements
-
SQL - Part 90 - Grant and Revoke SQL Statements
-
SQL - Part 91 - Temporary Tables
-
SQL - Part 92 - Show Columns,Show Indexes,Show Privileges and Show Grants Statements
-
SQL - Part 93 - Inserting Null
-
SQL - Part 94 - Using trim() for trimming the corner characters of the Table Values
-
SQL - Part 95 - Using wild cards as normal characters
-
SQL - Part 96 - Database Objects
-
SQL - Part 97 - Creating Linux Virtual Machine
-
SQL - Part 98 - Installing MySQL Server in Linux Ubuntu Machine
-
SQL - Part 99 - Putty for Connecting to a Remote Machine having MySQL Server
-
SQL - Part 100 - Oracle 11g Software, SQL Plus, SQL Developer and Executing SQL Queries
-
SQL - Part 101 - Oracle SQL Queries
-
SQL - Part 102 - Oracle SQL Built in functions
-
SQL - Part 103 - Oracle SQL Queries (Part 2)
-
SQL - Part 104 - Oracle SQL Queries (Part 3)
-
SQL - Part 105 - Oracle SQL Queries (Part 4)
-
SQL - Part 106 - Oracle SQL Queries (Part 5)
-
SQL - Part 107 - DBeaver Universal DB Client Tool
-
SQL - Part 108 - XAMPP for Practicing SQL
-
SQL for Beginners - Part 109 - Savepoint
-
SQL for Beginners - Uninstalling MySQL Server completely from Windows Machine
-