
Lecture Description
Hey guys, thank you so much for watching the tutorials in this course. It's been a pleasure recording videos on SQL for all of you.
If you've got any doubts regarding the content of the course, feel free to comment on the videos or email me. I will get back to your queries as soon as possible.
Also, you may subscribe to my channel for updates about my future projects and we may also connect on Facebook or Google Plus!
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...