Matches in SemOpenAlex for { <https://semopenalex.org/work/W76930393> ?p ?o ?g. }
Showing items 1 to 87 of
87
with 100 items per page.
- W76930393 abstract "This chapter focuses on databases and their relationship to enterprise applications. This chapter begins by discussing standard terminology associated with databases then quickly moves on to a discussion of SQL. Some of the more common operations including SELECT, INSERT, UPDATE, and DELETE statements for working with data and CREATE, ALTER, and DROP statements for working with database schemas are discussed. Database design topics including the concepts of OLTP versus OLAP database types, database normalization, how keys are used in databases, intersection tables, and indexes are all discussed and their usage given through numerous examples. Access control and database security are discussed in detail and various ways to protect databases and their data are also discussed.Troubleshooting of databases is a critical part of being an enterprise applications administrator and so multiple facets of database troubleshooting are covered in this chapter including the basic need of finding the database, connecting to and communicating with the database, and database security and permissions. Finally, this chapter illustrates concerns about database performance across the board and how to troubleshoot and resolve performance issues." @default.
- W76930393 created "2016-06-24" @default.
- W76930393 creator A5016944585 @default.
- W76930393 date "2014-01-01" @default.
- W76930393 modified "2023-09-24" @default.
- W76930393 title "Databases" @default.
- W76930393 doi "https://doi.org/10.1016/b978-0-12-407773-7.00004-1" @default.
- W76930393 hasPublicationYear "2014" @default.
- W76930393 type Work @default.
- W76930393 sameAs 76930393 @default.
- W76930393 citedByCount "1" @default.
- W76930393 countsByYear W769303932015 @default.
- W76930393 crossrefType "book-chapter" @default.
- W76930393 hasAuthorship W76930393A5016944585 @default.
- W76930393 hasConcept C107535962 @default.
- W76930393 hasConcept C111919701 @default.
- W76930393 hasConcept C115842085 @default.
- W76930393 hasConcept C135572916 @default.
- W76930393 hasConcept C138885662 @default.
- W76930393 hasConcept C147494362 @default.
- W76930393 hasConcept C148840519 @default.
- W76930393 hasConcept C191087605 @default.
- W76930393 hasConcept C201932085 @default.
- W76930393 hasConcept C205295232 @default.
- W76930393 hasConcept C2778553114 @default.
- W76930393 hasConcept C2778625365 @default.
- W76930393 hasConcept C30775581 @default.
- W76930393 hasConcept C41008148 @default.
- W76930393 hasConcept C41895202 @default.
- W76930393 hasConcept C46681722 @default.
- W76930393 hasConcept C54239708 @default.
- W76930393 hasConcept C547195049 @default.
- W76930393 hasConcept C70236469 @default.
- W76930393 hasConcept C72108876 @default.
- W76930393 hasConcept C75949130 @default.
- W76930393 hasConcept C77088390 @default.
- W76930393 hasConcept C78161392 @default.
- W76930393 hasConceptScore W76930393C107535962 @default.
- W76930393 hasConceptScore W76930393C111919701 @default.
- W76930393 hasConceptScore W76930393C115842085 @default.
- W76930393 hasConceptScore W76930393C135572916 @default.
- W76930393 hasConceptScore W76930393C138885662 @default.
- W76930393 hasConceptScore W76930393C147494362 @default.
- W76930393 hasConceptScore W76930393C148840519 @default.
- W76930393 hasConceptScore W76930393C191087605 @default.
- W76930393 hasConceptScore W76930393C201932085 @default.
- W76930393 hasConceptScore W76930393C205295232 @default.
- W76930393 hasConceptScore W76930393C2778553114 @default.
- W76930393 hasConceptScore W76930393C2778625365 @default.
- W76930393 hasConceptScore W76930393C30775581 @default.
- W76930393 hasConceptScore W76930393C41008148 @default.
- W76930393 hasConceptScore W76930393C41895202 @default.
- W76930393 hasConceptScore W76930393C46681722 @default.
- W76930393 hasConceptScore W76930393C54239708 @default.
- W76930393 hasConceptScore W76930393C547195049 @default.
- W76930393 hasConceptScore W76930393C70236469 @default.
- W76930393 hasConceptScore W76930393C72108876 @default.
- W76930393 hasConceptScore W76930393C75949130 @default.
- W76930393 hasConceptScore W76930393C77088390 @default.
- W76930393 hasConceptScore W76930393C78161392 @default.
- W76930393 hasLocation W769303931 @default.
- W76930393 hasOpenAccess W76930393 @default.
- W76930393 hasPrimaryLocation W769303931 @default.
- W76930393 hasRelatedWork W1575391024 @default.
- W76930393 hasRelatedWork W1604501984 @default.
- W76930393 hasRelatedWork W1829550030 @default.
- W76930393 hasRelatedWork W1995751017 @default.
- W76930393 hasRelatedWork W2026205964 @default.
- W76930393 hasRelatedWork W2034583900 @default.
- W76930393 hasRelatedWork W2046006386 @default.
- W76930393 hasRelatedWork W204909595 @default.
- W76930393 hasRelatedWork W2101153507 @default.
- W76930393 hasRelatedWork W2133696345 @default.
- W76930393 hasRelatedWork W2274794968 @default.
- W76930393 hasRelatedWork W2293726547 @default.
- W76930393 hasRelatedWork W2398254568 @default.
- W76930393 hasRelatedWork W2506898509 @default.
- W76930393 hasRelatedWork W2789378471 @default.
- W76930393 hasRelatedWork W2810736596 @default.
- W76930393 hasRelatedWork W2949401951 @default.
- W76930393 hasRelatedWork W2974396252 @default.
- W76930393 hasRelatedWork W6804244 @default.
- W76930393 hasRelatedWork W2911699894 @default.
- W76930393 isParatext "false" @default.
- W76930393 isRetracted "false" @default.
- W76930393 magId "76930393" @default.
- W76930393 workType "book-chapter" @default.