CIW Database Specialist Part 3: Database Interaction and JDBC This is the third course in a four part series that teaches students about SQL relational algebra transactions and database security and an introduction to the JDBC. This course covers SQL DDL commands inserting updating and querying with DML statements granting and revoking privileges with DCL statements. The course also teaches about relational algebra concepts to include joins transactions and more...
SQL Server 2000 Querying with Transact SQL Part 1 Manipulating Data ...ements. Identify the functions of Data Control Language (DCL) statements. Identify the guidelines for selecting columns within a table. Identify the guidelines for using the WHERE clause to retrieve rows in a table. Retrieve specific columns from a table. Identify the characteristics of aggregate functions. Identify the considerations for using the GROUP BY clause. Identify the more...
CIW Database Specialist Part 3 Database Interaction JDBC ...ith DML statements, granting and revoking privileges with DCL statements. The course also teaches about relational algebra concepts, to include joins, transactions and database security, and using JDBC drivers and executing SQL statements. Learn To: o Identify features of Structured Query Language (SQL). o Match the SQL data types with their characteristics. o Match data definition more...