book

Microsoft SQL Server 2012 Administration: Real-World Skills for MCSA Certification and Beyond (Exams 70-461, 70-462, and 70-463)

by Tom Carpenter

June 2013

Intermediate to advanced

936 pages

23h 54m

English

Sybex

Read now

Unlock full access

What Is Information Technology?Introduction to DatabasesDatabase Servers and ApplicationsSQL Server’s RoleSummaryChapter Essentials
Installation PlanningInstalling a Default InstanceInstalling Named InstancesInstalling to a ClusterInstalling Extra FeaturesUpgrading from Previous VersionsValidating an InstallationRemoving an InstallationSummaryChapter Essentials
SQL Server Configuration ManagerSQL Server Management StudioSQL Server Data ToolsSQL Server ProfilerBooks OnlineWindows Server Administration for the DBASummaryChapter Essentials
Introducing the Command PromptGeneral CommandsBatch FilesMastering SQLCMDIntroducing Windows PowerShellUsing SQL Server PowerShell ExtensionsSummaryChapter Essentials
Understanding the SQL LanguageSQL Statement TypesSQL Syntactical ElementsCoding RecommendationsUsing SELECT StatementsAdvanced Query TechniquesUsing DDL StatementsUsing DCL StatementsModifying DataTuning and Optimizing QueriesSummaryChapter Essentials
Relational Database TheoryDatabase Design ProcessesProject Management for the DBASummaryChapter Essentials
Planning a DatabaseUnderstanding Entity Relationship DiagrammingBuilding an ERDCapacity PlanningSummaryChapter Essentials
Designing for NormalizationDesigning for PerformanceDesigning for AvailabilityDesigning for SecuritySummaryChapter Essentials
SQL Server DatabasesDatabase StorageDatabase Options and PropertiesCreating Databases in the GUICreating Databases with T-SQLCreating Databases with PowerShellAttaching and Detaching DatabasesDatabase SnapshotsSummaryChapter Essentials
Data TypesCollationsTable Creation ProcessData PartitioningSummaryChapter Essentials
Understanding IndexesCreating Basic IndexesCreating Advanced IndexesManaging IndexesUnderstanding ViewsCreating ViewsSummaryChapter Essentials
Triggers DefinedUsing TriggersCreating TriggersUnderstanding Stored ProceduresCreating Stored ProceduresSummaryChapter Essentials
Understanding and Installing Analysis ServicesUnderstanding Integration ServicesUnderstanding and Installing Reporting ServicesImplementing Database MailConfiguring Full-Text IndexingImplementing Transparent Data EncryptionData CompressionSummaryChapter Essentials
Standardize, Automate, and UpdateUnderstanding SQL Server JobsCreating T-SQL JobsCreating SSIS JobsCreating Windows Command JobsCreating and Using OperatorsCreating and Using AlertsUsing WSUS for SQL Server 2012SummaryChapter Essentials
Performance Tuning PrinciplesPerformance and Troubleshooting ToolsBlocks, Locks, and DeadlocksSQL Server ProfilerDatabase Engine Tuning AdvisorPerformance Monitoring with System MonitorUsing the Resource GovernorPerformance StudioAdvanced Monitoring ToolsSummaryChapter Essentials
Policy-Based ManagementCentralized Server ManagementStandardizing with PBM and CMSSummaryChapter Essentials
Backing Up a DatabaseBacking Up System DatabasesRestoring a DatabaseBacking Up the EnvironmentSummaryChapter Essentials
Security DefinedSecurity ThreatsSecurity PrinciplesSummaryChapter Essentials
Understanding AuthenticationSQL Server Authentication MethodsLogins, Users, and RolesUnderstanding EncryptionSummaryChapter Essentials
Establishing BaselinesImplementing Least PrivilegeAuditing SQL Server ActivityConfiguring the Surface AreaUnderstanding Common Criteria and C2SummaryChapter Essentials
Introducing AlwaysOn TechnologyMirroring and AlwaysOnFailover SolutionsSelecting Hardware for AlwaysOnSummaryChapter Essentials
Understanding Windows Failover Clustering ServiceImplementing a Windows ClusterInstalling SQL Server 2012 to a ClusterMonitoring and Managing a SQL Server ClusterSummaryChapter Essentials
RAID-based Data RedundancyUsing Database MirroringUnderstanding Log ShippingImplementing Database SnapshotsSummaryChapter Essentials
SQL Server ReplicationImporting and Exporting DataSummaryChapter Essentials
Understanding Data WarehousesImplementing Fact TablesImplementing DimensionsSummaryChapter Essentials
Integration IssuesInstalling SSISConfiguring SSIS Security SettingsDeploying PackagesSSIS Auditing and Event HandlingExtracting, Transforming, and Loading DataSummaryChapter Essentials
Understanding Data Quality ConcernsInstalling Data Quality ServicesUsing Master Data ServicesCleaning DataSummaryChapter Essentials

Content preview from Microsoft SQL Server 2012 Administration: Real-World Skills for MCSA Certification and Beyond (Exams 70-461, 70-462, and 70-463)

Chapter 6 Database Concepts and Terminology

TOPICS COVERED IN THIS CHAPTER:

Relational Database Theory

Database Design Processes

Project Management for the DBA

Now that your SQL Server is up and running and you’ve learned the ins and outs of querying the server, you need to make sure you fully understand the database concepts and terminology introduced in Chapter 1, “Understanding SQL Server’s Role,” before you create your databases. If you create ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

Microsoft SQL Server 2012 Certification Training - Exam 70-462

Denny Cherry

Professional Microsoft SQL Server 2014 Administration

Adam Jorgensen, Bradley Ball, Steven Wort, Ross LoForte, Brian Knight

SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Tom Carpenter

Microsoft SQL Server 2012 Certification - Exam 70-461

Mark Long

Publisher Resources

ISBN: 9781118654903Purchase book

Chapter 6

Database Concepts and Terminology