
Lecture Description
In this tutorial we'll learn to use the COUNT, MAX & MIN aggregate functions to determine the number of records returned in a result set, the maximum value of a field and the least value of a field respectively.
Course Index
- Introduction to SQL
- Installing MySQL
- MySQL Workbench and Command Line Client
- Things You Need To Know About Tables
- Create, Use and Drop Databases
- Data-Types in SQL (Part-1)
- Data-Types in SQL (Part-2)
- Constraints in SQL
- Create Table Statement
- Creating Tables from Other Tables
- Removing Tables from Database
- Inserting Data Into Tables
- Inserting Data Into a Table From Another Table
- The SELECT Query
- Arithmetic Operators
- Comparison Operators
- Logical Operators (Part-1)
- Logical Operators (Part-2)
- The WHERE Clause
- AND & OR Operators
- The UPDATE Query
- The DELETE Query
- The LIKE Operator and Wildcard Characters
- The TOP and LIMIT Clauses
- The ORDER BY Clause
- The GROUP BY Clause
- The DISTINCT Keyword
- Aliasing Through AS Clause
- SQL JOINS
- Using GROUP BY Clause with SQL JOINS
- Left Outer JOIN
- Right Outer JOIN
- ABS() Function
- ROUND() Function
- DIV() & MOD() Functions
- Useful Numeric Functions Part-1
- Useful Numeric Functions Part-2
- The CONCAT() Function
- UPPER() and LOWER() Functions
- The TRIM() Function
- SUBSTR(), RIGHT() & LEFT() Functions
- The LENGTH() & INSERT() Functions
- REPEAT() & REPLACE() Functions
- REVERSE() & STRCMP() Functions
- Date & Time Functions (Part-1)
- Date & Time Functions (Part-2)
- Date & Time Functions (Part-3)
- Views in SQL (Part-1)
- Views in SQL (Part-2)
- Views in SQL (Part-3)
- Aggregate Functions (Part-1)
- Aggregate Functions (Part-2)
- The TRUNCATE TABLE Command
- Subqueries in SQL
- The ALTER TABLE Command
- Conclusion
Course Description
A collection of 56 great (not bad, despite the name) tutorials on how to get started with SQL (Structured Query Language), covering basic INSERT, SELECT, UPDATE, and DELETE statements, and more advanced concepts such as string functions, date & time, ALTER TABLE, and others.
Comments
There are no comments.
Be the first to post one.
Posting Comment...