Używamy cookies, aby ułatwić korzystanie z Portalu. Możesz określić warunki przechowywania, dostępu do plików cookies w Twojej przeglądarce. Dowiedz się więcej.
strona główna Strona główna | Nowości | Promocje | Zapowiedzi Twoje konto | Zarejestruj | Schowek | Kontakt | Pomoc
mapa działów
Szukaj: szukanie zaawansowane
Koszyk
Książki \ Bazy danych \ SQL Server

Microsoft SQL Server 2012 Step by Step Język: 2

978-0-7356-6386-2

Cena Brutto: 194.25

Cena netto: 185.00

Ilość:
Wersja: Drukowana
Autor Patrick LeBlanc
Liczba_stron 432
Wydawnictwo Microsoft Press
Oprawa miękka
Data_Wydania 2013-03-01

Microsoft

SQL Server 2012

Step by Step                                                     

_______________________________________________________________________________

Książka z grupy:

SQL Server podręcznik

 

        Your hands-on, step-by-step guide to building applications with Microsoft® SQL Server® 2012

Teach yourself the programming fundamentals of SQL Server 2012—one step at a time. Ideal for beginning SQL Server database administrators and developers, this tutorial provides clear guidance and practical, learn-by-doing exercises for building database solutions that solve real-world business problems.

Discover how to:

  • Install and work with core components and tools
  • Create tables and index structures
  • Manipulate and retrieve data
  • Secure, manage, back up, and recover databases
  • Apply techniques for building high-performing applications
  • Use clustering, database mirroring, and log shipping
  1. Getting started with Microsoft SQL Server 2012

    1. Chapter 1 Overview of Microsoft SQL Server 2012

      1. Business intelligence
      2. Database Engine
      3. T-SQL programming interface
      4. Security subsystem
      5. Replication
      6. Summary
    2. Chapter 2 Installing, Configuring, and Upgrading Microsoft SQL Server 2012

      1. Editions of SQL Server 2012
      2. Choosing hardware for SQL Server
      3. Software prerequisites
      4. Before installation
      5. Installing SQL Server
      6. After installation
      7. How to upgrade to SQL Server 2012
      8. Summary
    3. Chapter 3 Using SQL Server 2012 administration and development tools

      1. Using SQL Server Books Online
      2. Using SQL Server Management Studio
      3. Using SQL Server Management Studio to create solutions and projects
      4. Using SQL Server Data Tools
      5. Using SQL Server Configuration Manager
      6. Summary
  2. Designing databases

    1. Chapter 4 Designing SQL Server databases

      1. Understanding SQL Server system databases
      2. Understanding the SQL Server database structure
      3. Adding files and filegroups
      4. Detaching and attaching SQL Server databases
      5. Understanding database recovery models
      6. Summary
    2. Chapter 5 Creating your first table

      1. Developing a naming standard
      2. Understanding schemas
      3. Understanding SQL Server data types
      4. Understanding column properties
      5. Creating tables
      6. Altering tables
      7. Understanding computed columns
      8. Adding constraints to a table
      9. Understanding the FileTable
      10. Creating database diagrams
      11. Summary
    3. Chapter 6 Building and maintaining indexes

      1. Index structure overview
      2. Adding index options
      3. Adding included columns
      4. Adding filters to indexes
      5. Placing indexes
      6. Disabling and dropping indexes
      7. Summary
  3. Advanced database design topics

    1. Chapter 7 Table compression

      1. Understanding row compression
      2. Understanding page compression
      3. Estimating effects of compression
      4. Compression considerations
      5. Summary
    2. Chapter 8 Table partitioning

      1. Creating a partition function
      2. Creating a partition scheme
      3. Partitioning tables and indexes
      4. Summary
    3. Chapter 9 Database snapshots

      1. Understanding database snapshot prerequisites and limitations
      2. Creating and viewing database snapshots
      3. Dropping database snapshots
      4. Reverting to a database snapshot
      5. Summary
    4. Chapter 10 The SELECT statement

      1. Writing a SELECT statement
      2. Sorting results
      3. Filtering data with the WHERE clause
      4. Creating aliases
      5. Using the JOIN operator to return data from multiple tables
      6. Limiting the data returned in your result set
      7. Using UNION to combine result sets
      8. Summary
  4. Using Transact-SQL (T-SQL)

    1. Chapter 11 Advanced data retrieval topics

      1. Pivoting and unpivoting data
      2. Paging data
      3. Writing expressions
      4. Using variables
      5. Summary
    2. Chapter 12 Modifying data

      1. Inserting data into SQL Server tables
      2. Using sequence numbers
      3. Updating data in tables
      4. Deleting data from tables
      5. Merging data
      6. Returning output data
      7. Summary
    3. Chapter 13 Built-in scalar functions

      1. Using date and time functions
      2. Using conversion functions
      3. Using string functions
      4. Using logical functions
      5. Summary
  5. Creating other database objects

    1. Chapter 14 Advanced T-SQL topics

      1. Aggregating, windowing, and grouping
      2. Windowing
      3. Using SQL Server temporary objects
      4. Handling T-SQL errors
      5. Controlling flow keywords
      6. Summary
    2. Chapter 15 Views

      1. What are views?
      2. Creating indexed views
      3. Summary
    3. Chapter 16 User-defined functions

      1. Understanding user-defined scalar functions
      2. Understanding table-valued functions
      3. Limitations of functions
      4. Summary
    4. Chapter 17 Stored procedures

      1. Working with stored procedures
      2. Using the EXECUTE keyword
      3. Parameterizing stored procedures
      4. Dropping stored procedures
      5. Summary
    5. Chapter 18 Data manipulation triggers

      1. Types of triggers
      2. Creating triggers
      3. Altering triggers
      4. Dropping triggers
      5. Enabling and disabling triggers
      6. Summary
  6. SQL Server replication

    1. Chapter 19 Replication

      1. Types of replication
      2. Replication agents
      3. Configuring replication
      4. Monitoring replication
      5. Summary
  7. Database maintenance

    1. Chapter 20 Backups

      1. Understanding backup devices
      2. Full database backups
      3. Differential database backups
      4. Transaction log database backups
      5. Restoring databases
      6. Summary
    2. Chapter 21 Managing and maintaining indexes and statistics

      1. Checking index fragmentation
      2. Defragmenting indexes
      3. Creating and updating database statistics
      4. Summary
    3. Chapter 22 Maintenance plans

      1. Performing database consistency checks
      2. Creating maintenance plans
      3. Summary
  8. Database management

    1. Chapter 23 SQL Server Profiler

      1. Understanding SQL Server Profiler
      2. Creating traces
      3. Running server-side traces
      4. Summary
    2. Chapter 24 Extended Events

      1. Understanding the Extended Events architecture
      2. Creating and configuring an Extended Events session
      3. Using an Extended Events session to monitor system performance
      4. Summary
    3. Chapter 25 SQL Server security

      1. Understanding principals
      2. Creating server logins
      3. Creating user-defined server roles
      4. Creating database users
      5. Creating built-in database roles
      6. Configuring contained databases
      7. Summary
    4. Chapter 26 Resource Governor

      1. Enabling and disabling Resource Governor
      2. Creating resource pools
      3. Creating a workload group
      4. Using classifier functions
      5. Testing classifier functions
      6. Modifying Resource Governor configurations
      7. Summary
    5. Chapter 27 SQL Server Agent

      1. SQL Server Agent components
      2. Viewing SQL Server Agent Configuration Manager options
      3. Configuring SQL Server Agent properties
      4. Creating operators
      5. Configuring alerts
      6. Configuring jobs
      7. Creating proxies
      8. Summary
    6. Chapter 28 Database Mail

      1. Database Mail components
      2. Configuring Database Mail
      3. Sending email using Database Mail
      4. Monitoring Database Mail
      5. Summary
    7. Chapter 29 Data definition triggers

      1. Types of triggers
      2. Creating triggers
      3. Altering triggers
      4. Enabling and disabling triggers
      5. Dropping triggers
      6. Summary
    8. Chapter 30 Dynamic management objects

      1. Retrieving SQL Server metadata from DMOs
      2. Querying server performance statistics
      3. Querying server information
      4. Querying performance information
      5. Querying indexing statistics
      6. Summary
  9. High-availability solutions

    1. Chapter 31 AlwaysOn

      1. Failover cluster instance improvements
      2. Creating AlwaysOn Availability Groups
      3. Administering AlwaysOn Availability Groups
      4. Reading secondary database copies
      5. Summary
    2. Chapter 32 Log shipping

      1. Log shipping components
      2. Log shipping prerequisites
      3. Configuring log shipping
      4. Summary
    3. Appendix About the Author

powrót
 
Produkty Podobne
Exam Ref 70-764 Administering a SQL Database Infrastructure
SQL Server i T-SQL w mgnieniu oka. Wydanie II
SQL Server 2016 High Availability Unleashed (includes Content Update Program)
Microsoft SQL Server 2016 Analysis Services: Modelowanie tabelaryczne
Tabular Modeling in Microsoft SQL Server Analysis Services, 2nd Edition
Exam Ref 70-768 Developing SQL Data Models
Exam Ref 70-762 Developing SQL Databases
Microsoft SQL Server T-SQL in 10 Minutes, Sams Teach Yourself, 2nd Edition
Pierwsze kroki z SQL. Praktyczne podejście dla początkujących
Podstawy języka T-SQL: Microsoft SQL Server 2016 i Azure SQL Database
Więcej produktów