Introductory SQL Training Manual Classroom in a Book is popular PDF and ePub book, written by TeachUcomp in 2019-10-27, it is a fantastic choice for those who relish reading online the Computers genre. Let's immerse ourselves in this engaging Computers book by exploring the summary and details provided below. Remember, Introductory SQL Training Manual Classroom in a Book can be Read Online from any device for your convenience.
Introductory SQL Training Manual Classroom in a Book Book PDF Summary
Complete classroom training manual to learn Introductory SQL. 84 pages and 43 individual topics. Includes practice exercises and keyboard shortcuts. The goal of this course to give the student the knowledge of which SQL statement they will need to use to accomplish specific tasks within a database, as well as provide links to database-specific implementations of those core statements. Topics Covered: Introduction to Databases and SQL 1. Overview of a Database 2. The “Flat-File” Method of Data Storage 3. The Relational Model of Data Storage 4. Tips for Creating a Relational Database 5. What is SQL? 6. Using SQL in Access 2013 Data Definition Language 1. The CREATE Statement 2. The CREATE DATABASE Statement 3. The CREATE TABLE Statement 4. The CREATE INDEX Statement 5. SQL Constraints 6. The DROP Statement 7. The ALTER TABLE Statement 8. NULL Values in SQL 9. Data Types in SQL 10. Auto-Increment in SQL Data Manipulation Language 1. The INSERT Statement 2. The UPDATE Statement 3. The DELETE Statement 4. The SELECT Statement 5. The WHERE Clause 6. Criteria Notation and Wildcard Characters in the WHERE Clause 7. The ORDER BY Clause 8. The GROUP BY Clause and Aggregate Functions 9. The JOIN Clause 10. The UNION Operator 11. The SELECT INTO Statement 12. The INSERT INTO SELECT Statement 13. Subqueries Data Control Language 1. The CREATE USER and CREATE ROLE Statements 2. Privileges 3. The GRANT Statement 4. The REVOKE Statement 5. The ALTER USER and ALTER ROLE Statements 6. The DROP USER and DROP ROLE Statements Transaction Control Language 1. The TRANSACTION Statement SQL Functions and Aliases 1. Understanding SQL Functions 2. Calculated Fields and Column Aliases 3. Table Aliases Views 1. About Views 2. The CREATE VIEW Statement 3. The ALTER VIEW Statement 4. The DROP VIEW Statement
Detail Book of Introductory SQL Training Manual Classroom in a Book PDF
- Author : TeachUcomp
- Release : 27 October 2019
- Publisher : TeachUcomp Inc.
- ISBN : 978186723xxxx
- Genre : Computers
- Total Page : 84 pages
- Language : English
- PDF File Size : 15,9 Mb
If you're still pondering over how to secure a PDF or EPUB version of the book Introductory SQL Training Manual Classroom in a Book by TeachUcomp , don't worry! All you have to do is click the 'Get Book' buttons below to kick off your Download or Read Online journey. Just a friendly reminder: we don't upload or host the files ourselves.