A summary of this last section follows. Structured Query Language or SQL has several components which we discussed in the section. DDL or data Definition Language was used for creating the database tables, and DML. The data manipulation language was used to query and modify the database tables. We did mention also dcl or data control language. SQL statements can be embedded into programming languages such as Java, and C sharp.
We learned how to process SQL from a command window and from a SELECT FROM WHERE clause. Microsoft Access 2016 uses a variant of SQL we have called it MS SQL access. Another name you will hear for this is Microsoft jet sequel. We've covered a lot of ground in this section, including keys join, select from where statement, constraints, unique cascade, parameter query, Query Design and query wizard. As we indeed indicated, there was much much more that could be added and studied. Here were a few other topics to consider.
Count some min max, group by order by count in a join. update some to some language is rich and flexible and can do countless operations on relational tables. The most important takeaway is to select from where statements select identifies the columns or fields in the table from the table name. Where statement is powerful and it allows an addition of a criteria We use quotes around the values that were identified. The example we used was Kingston, but double quotes are allowed only for small and long text fields. You can include compound conditions with either and, or, or.
And conditions such as in and noddin. And like a part of the where clause. It will take time to gain expertise in SQL, but well worth the effort. It has been around for a long time, and there is little evidence that it will be replaced.