SQL/PL SQL

SQL is a standard language for storing, manipulating and retrieving data in databases

This course helps you step-by-step overview and instructions to started with the SQL language. We use SQL/MSSQL, for understanding data structures and techniques for all SQL engines including Access, Oracle and MySQL. We show you how to create SQL statements including SELECT, DELETE, UPDATE and INSERT along with design tables, stored procedures, which allow you to run the same SQL statement multiple times without reprogramming your database. Finally, we show you how to use cursors, use transactions to preserve data integrity, and creating views for larger data sets.