SQL for DBMS
SQL is a query language for the database management system (DBMS). SQL is used to Insert data, Update data, Select data and Delete data from the database.
Either you are a web application developer or mobile application developer or desktop application developer you have to know database and SQL.
Course Curriculum
- 1 Introductions
- 2 The SQL SELECT Statement
- 3 SQL WHERE Clause
- 4 SQL AND OR NOT Logical Operators
- 5 Use of SQL ORDER BY keyword for sorting by ascending and descending order
- 6 Insert Data Into Database Using SQL
- 7 Working With NULL Value in SQL
- 8 Updating Database Data Using SQL UPDATE statement
- 9 Delete Data From Database Using SQL Query
- 10 Use of SQL Limit
- 11 SQL MIN() and MAX() Aggregate Functions
- 12 SQL COUNT(), AVG() and SUM() Aggregate Functions
- 13 Use of SQL LIKE Operator
- 14 Use of SQL IN Operator
- 15 The SQL BETWEEN Operator in Where Condition
- 16 Use Aliases on SQL Query