Introduction to Database Design and SQL

Häftad, Engelska, 2019

2 089 kr

Beställningsvara. Skickas inom 5-8 vardagar

Fri frakt för medlemmar vid köp för minst 249 kr.

Provides step-by-step instructions with graphics and examples to help students grasp the material and gain the skills needed for database-related employment. Students have access to a full human resources database that can be downloaded from the author's website. This database is referenced throughout the examples and end of chapter exercises.

Produktinformation

Utgivningsdatum2019-12-16
Mått279 x 220 x 20 mm
Vikt726 g
FormatHäftad
SpråkEngelska
Antal sidor277
Upplaga2
FörlagKendall/Hunt Publishing Co ,U.S.
ISBN9781792410864

Tillhör följande kategorier

Programmeringsböcker inom Data och it
Databaser inom Data och it

Chapter 1 - Basic Relational Database DesignChapter ObjectivesPurpose of DatabasesEntitiesPrimary KeysForeign KeysDatabase NormalizationFirst Normal FormSecond Normal FormThird Normal FormSummaryExercisesChapter 2 - Creating a Physical DatabaseCreating a Physical DatabaseChapter ObjectivesStarting SQL ServerConnecting to SQL ServerCreating a DatabaseDatabase ObjectsCharacter Data TypesBinary Data TypesNumeric Data TypesTablesDatabase DiagramCreating a Database DiagramSummaryExerciseChapter 3 -Inserting, Updating, and Deleting DataInserting, Updating, and Deleting DataChapter ObjectivesInsert StatementSaving Your WorkCommentsUPDATE StatementDELETE StatementSummaryExercisesChapter 4 - Single table Query BasicsSingle Table Query BasicsChapter ObjectivesEnvironment SetupSELECT StatementFROM ClauseRenaming ColumnsDISTINCT ClauseWHERE ClauseComparison OperatorsComparing Character DataOrder By ClauseTOP KeywordSummaryExercisesChapter 5 - Using Logical Operators in SQL StatementsChapter ObjectivesAND OperatorOR OperatorNOT OperatorThe IN and NOT IN OperatorThe BETWEEN OperatorLIKE and NOT LIKE OPERATORNULL and NOT NULL OperatorsExpressionsOrder of PrecedenceSummaryExercisesChapter 6 - Grouping Data Using Aggregate FunctionsChapter ObjectivesUsing Aggregate FunctionsCOUNT() FunctionGROUP BY ClauseErrorsHAVING ClauseBasic Grouping RulesAVG() FunctionUsing the DISTINCT KeywordSUM() FunctionMIN() FunctionMAX() FunctionSummaryExercisesChapter 7 - JoinsChapter ObjectivesReferential IntegrityINNER JOINOutdated Join SyntaxCartesian ProductKnow your DataUsing the WHERE Clause with JoinsOUTER JOINFULL OUTER JOINSELF JOINSJoining on Multiple TablesSummaryExercisesChapter 8 - Going Beyond Joins with Set Operations: UNION, INTERSECT, EXCEPTChapter ObjectivesUNION OperatorORDER BYUNION ALLINTERSECT OperatorEXCEPT OperatorUse of UNION operatorSummaryExercisesChapter 9 - SubqueriesChapter ObjectivesNoncorrelated Subqueries and Comparison OperatorsData Type CompatibilityComparing Multiple Return ValuesSubqueries and the IN OperatorUsing the JOIN Operator InsteadSubqueries and the NOT IN OperatorUsing the ALL and ANY Keywords"= ANY" ? Equals Any Operator"!= ANY" ? Not Equal Any OperatorCorrelated SubqueriesEXISTS OperatorNOT EXISTS OperatorSummaryExercisesChapter 10 - More FunctionsChapter ObjectivesString FunctionsLEFT and RIGHT FunctionsLEN() FunctionConcatenationLTRIM and RTRIM FunctionsUPPER and LOWER FunctionsCHARINDEX() FunctionREPLACE() FunctionSUBSTRING() FunctionISNULL() FunctionMATH FunctionsABS() FunctionPOWER() FunctionSQRT() FunctionSQUARE() FunctionROUND() FunctionCONVERT() FunctionCAST() FunctionDate FunctionsGETDATE() FunctionDATEPART() FunctionDATEADD() FunctionDATEDIFF() FunctionCASE StatementSummaryChapter 11 - Views and Stored ProceduresChapter ObjectivesViewsCreate ViewsJoining Views and TablesDropping ViewsStored ProceduresALTER STORED PROCEDURESParametersDropping Stored ProceduresSummaryExercisesIndexAppendix AChapter Exercise AnswersAppendix BInstructions to LoadHuman Resources DatabaseAppendix CHuman Resources DatabaseInsert Statements