MS Access 2016 SQL comprehensive / Pindaro E. Demertzoglou
Material type:
TextPublication details: Albany : Alpha Press, c2019. Description: xiv, 441 p. : ill. ; 28 cmISBN: 9780988330092DDC classification: 005.7585 DEM
| Item type | Current library | Home library | Call number | Status | Date due | Barcode | Item holds |
|---|---|---|---|---|---|---|---|
English Lending
|
Villa College QI Campus | Villa College Library | 005.7585 DEM (Browse shelf(Opens below)) | Available | 16607 | ||
|
English Lending
|
Villa College QI Campus | Villa College Library | 005.7585 DEM (Browse shelf(Opens below)) | Available | 16608 | ||
|
English Lending
|
Villa College QI Campus | Villa College Library | 005.7585 DEM (Browse shelf(Opens below)) | Available | 16609 |
Browsing Villa College Library shelves Close shelf browser (Hides shelf browser)
|
|
|
|
|
|
|
||
| 005.7565 LON Oracle database 11g : the complete reference / | 005.7565076 BEN Querying Microsoft SQL server 2012 : exam 70-461 training kit | 005.7585 DEM MS Access 2016 SQL comprehensive / | 005.7585 DEM MS Access 2016 SQL comprehensive / | 005.7585 DEM MS Access 2016 SQL comprehensive / | 005.7585 SUE MCSA/MCSE : windows server 2003 network infrastructure implementation, management, and maintenance study guide / | 005.7585 VIE Beginning SQL server 2005 programming / |
1 SQL foundation for Business
2 Create, edit, and Delete tables using SQL
3.Create, edit and delete index using SQL
4.Create, edit and delete relationships using SQL
5.The Select Statement
6.The OR and operators
7.Sorting records : the order by clause
8.working with wildcard characters
9.The Like Operator
10.Equality and inequality predicates
11.The between operators
12.The in operators
13. The distinct predicate
14.The Top predicate
15.Calculated Fields
16.Concatenated fields
17.The group by clause
18.Aggregate function
19. Cross Tab quaries ]
20. Parameter quaries
21. conditional Data manipulation
22.Union operators
23.Duplicate, Orphaned, and unrelated records
24.Working with Nulls
25.types conversion function
26. Working with strings
27.working with dates
28. Update SQL satements
30. Working with joins
31.Working with Sub-Quaries
Also includes Index and appendix
Click on an image to view it in the image viewer
There are no comments on this title.