SQL Made Simple Video
- Understand how SQL helps users create, read, update, and delete data stored in relational database tables.
- Become familiar with Database Management Systems (DBMS).
- Learn what SQL can do, and what it is designed not to do.
- Learn how to measure time complexity, which will need to be considered when writing SQL.
- Learn about sorting and primary keys.
- Learn what SQL can do and how ANSI standardization helps.
- Use direct and nested SQL.
- Learn about data definition language, data manipulation language, data control language, and transaction control language.
- Become comfortable with the SELECT, FROM, WHERE, GROUP BY, and HAVING clauses.
- Learn about the Data Definition Language (DDL) and modify and access table structures.
- Learn about the TRUNCATE, ALTER, MODIFY, and DROP statements.
- Learn about the Data Manipulation Language (DML) including the SELECT, UPDATE, DELETE, and INSERT statements.
- Learn about the Data Control Language (DCL), and grant privileges, rights, and permissions, on tables, functions, and processes, using the RUN and INVOKE commands.
- Learn about the Transaction Control Language (TCL), and work with transactions in the database using the COMMIT, ROLLBACK, SAVEPOINT, and SET TRANSACTION commands.
- See how to embed SQL in programming languages and also leverage PL/SQL.
Instructor: Viktor Shcherban
Length: 2 hours
Access period: For one year starting from purchase date