Beginners Learn SQL Server PDF

Source: Internet
Author: User
Tags arithmetic arithmetic operators case statement logical operators what sql management studio sql server management sql server management studio

: Network Disk Download

Content IntroductionEdit Novice SQL Server: Open the key to the door to SQL Server database technology
From the basic concept to start to explain, and gradually into the actual development
Example rich: 150 examples are interspersed when explaining knowledge points, with strong practicability
Job Orientation: Provides common interview questions to help readers understand the job interview
Typical application: The application of database in 3 directions is introduced to improve the application level of readers database.
Video Tutorial: Provides 6-hour multimedia teaching video to learn more intuitively.
Disc contents
6-hour multimedia teaching video
Source code involved in the case
Teaching PPT
Reader Object
Getting Started with SQL Server and improving people
Various software development and database developers
Database Technology Enthusiasts
Students in secondary schools
Related Social training students
The main content covered
SQL development Environment Data SQL statement Operations--DML
Installing SQL Server Control SQL statement Operations--DCL
SQL Server Manager import and export data
Create a database offline with an online database
Table operations backing up and restoring Databases
Using the Table Designer SQL Server Reporting Services
Function Transaction Management
View SQL Server Agent service
Stored Procedure Index
Trigger Security and user rights
E-r diagrams and diagrams using Visual C + + development Database Projects
Transact-SQL statements use ASP. NET (C #) to develop database projects
Object SQL statement Operations--DDL using ASP to develop database projects
Series features
Targeted, specifically tailored for readers without a programming foundation
With the multimedia teaching video to explain, the reader is very easy to get started
Attention to the concept of the explanation, beginners to read without any obstacles
Provides a wealth of typical examples to help readers understand the relevant knowledge points
Provides a comprehensive case to help readers improve the level of actual development
Clear explanation, clear operation procedure, rich code annotation, easy to master
Most of the authors have worked in programming for many years and have extensive experience in the development of the book Catalog Editor 1th installment with configuration
1th. Installing SQL Server 2008
1.1 Versions and components of SQL Server 2008
1.1.1 Server version of SOL Server 2008
1.1.2 SQL Server 2008 Professional Edition
1.1.3 SQL Server for Intemet server
1.1.4 SQL Server for client/server applications
1.1.5 Selecting components for SQL Server
1.2 new features in SQL Server 2008
1.2.1 new features for SQL Server
1.2.2 Other Technologies
1.3 Installation requirements for SQL Server 2008
1.3.1 SQL Server Developer Edition (64-bit)
1.3.2 SQL Server Developer Edition (32-bit)
1.3.3 Hard disk space requirements (32-bit and 64-bit)
1.3.4 Cross-language support
1.4 Installing or upgrading SQL Server
1.4.1 installation steps for SQL Server2008
1.4.2 Upgrading to SQL Server2008
1.4.3 Configuring SQL Server with SQL Server utility
1.5 Installing the SQL Server 2008 sample and Sample Databases
1.5.1 System Database
1.5.2 Installing the sample database
1.6 Common face questions
1.7 Summary
1.8 Exercises
Chapter 2nd Understanding SQL Server Manager
2.1 Administering SQL Server instances using SQL Server Configuration Manager
2.1.1 Starting an instance of SQL Server
2.1.2 Stopping an instance of SQL Server
2.2 Connecting to other computers by using SQL Server Configuration Manager
2.2.1 Connecting to another computer
2.2.2 Saving a connection to a remote SQL Server Configuration Manager
2.3 SQL Server Enterprise Manager
2.3.1 Accessing SQL Server Management Studio (Enterprise Manager)
2.3.2 Object Explorer
2.3.3 Template Explorer
2.3.4 Solution Explorer
2.3.5 Properties Window
2.3.6 Code Editor
2.3.7 SQL Editor Toolbar
2.4 Common face questions
2.5 Summary
2.6 Exercises
2nd Common operation
3rd. Creation, modification and deletion of database
3.1 Concept of the database
3.1.1 Types of databases
Software for the 3.1.2 database
3.1 13 Principles of the database (E-r map)
Operating language SQL for the 3.1.4 database
3.1.5 Integrity of the database
3.2 Database Terminology
3.2.1 Relational Model terminology
3.2.2 Database Related terms
3.2.3 Components of SQL
3.3 Creating a Database
3.3.1 Database File Size
3.3.2 Creating a default database
3.3.3 Creating a custom database
3.4 Modifying the database
3.4.1 Extending the database
3.4.2 Shrinking Database
3.4.3 Adding and deleting data files or transaction log files
3.4.4 Renaming a database
3.4.5 Changing the database owner
3.5 Deleting a database
3.5.1 Prerequisites for Deleting a database
3.5.2 Deleting a database
3.6 Common face questions
3.7 Summary
3.8 Exercises
4th Chapter Table Operation
4.1 Data types
4.1.1 Numerical type
4.1.2 Date and Time type
4.1.3 Character data type
4.1.4 Binary data types
4.1.5 Other data types
4.1.6 Data type synonyms
4.2 New Table
4.2.1 New Table
4.2.2 Inserting table Data
4.2.3 viewing data in a table
4.2.4. modifying data in a table
4.2.5 deleting data from a table
4.3 Modifying a table
4.3.1 Modifying table names
4.3.2 Inserting columns
4.3.3 Renaming columns
4.3.4 Deleting columns
4.3.5 Unable to save modified table error
4.4 Modifying columns
4.4.1 The default value for the specified column
4.4.2 Specifying computed columns
4.4.3 Modifying the data type of a column
4.4.4 to modify the length of a column:
4.4.5 Modifying the precision of a column
4.4.6 Modifying the number of decimal digits of a column
4.4.7 Modifying the identity properties of a column
4.4.8 null value options for modifying columns
4.5 Deleting a table
4.6 Common face questions
4.7 Summary
4.8 Exercises
Chapter 5th using the Table Designer
5.1 Table Designer
5.2 Managing Indexes
5.2.1 Creating an Index
5.2.2 Creating a unique index
5.2.3 Creating a clustered index
5.2.4 Changing index Properties
5.2.5 renaming an index
5.2.6 Deleting an index
5.3 Managing Primary keys
5.3.1 Creating a primary key
5.3.2 Modifying primary keys
5.3.3 Deleting a primary key
5.4 Managing composite primary keys
5.4.1 Creating a composite primary key
5.4.2 Changing the order of composite primary keys
5.4.3 Delete one or several keys in a composite primary key
5.4.4 Delete all keys in a composite primary key
5.5 Managing Relationships
5.5.1 Creating a Relationship
5.5.2 Show Relationship Properties
5.5.3 Changing Relationship Properties
5.5.4 Deleting a relationship
5.6 Managing CHECK constraints
5.6.1 Attaching a new Check constraint
5.6.2 Modifying a CHECK Constraint
5.6.3 Deleting a check constraint
5.7 Common face questions
5.8 Summary
5.9 Exercises
6th Chapter function
6.1 Common operators
6.1.1 Arithmetic operators
6.1.2-bit operators
6.1.3 comparison Operators
6.1.4 logical operators
6.1.5 assignment operator
6.1.6 string Join operator
Precedence of the 6.1.7 operator
6.2 Using an operator in an expression
6.2.1 using the Join operator
6.2.2 Changing column names
6.2.3 working with renamed columns
6.2.4 Use of arithmetic expressions
6.3 Why a function is required
6.4 Common aggregation functions
6.4.1 averaging using AVG function
6.4.2 using the Min function to find the lowest value
6.4.3 using the Max function to find the maximum value
6.4.4. Using the SUM function to find the sum
6.4.5 using the Count function and the Countl_big function to find the total number of rows
6.5 commonly used date and time functions
6.5.1 using the DateDiff function to get the date and time difference
6.5.2 Use the IsDate function to determine whether an expression is a valid date or time value
6.6 Common system functions
6.6.1 converting data types using CAST and conver_t functions
6.6.2 using the identity function to generate a self-increment column
6.6.3 using the IsNull function to check if an expression is null
6.6.4 Use the IsNumeric function to determine whether an expression is a valid numeric type
6.7 commonly used String functions
6.7.1 String Handling function Introduction
6.7.2 Character conversion function
6.7.3 to string whitespace function
6.7.4 function to take string length
6.7.5 querying data that contains partial string content
6.7.6 Order of reversed strings
6.7.7 string substitution
6.8 Creating a user-defined function
6.8.1 Creating Custom Function syntax
6.8.2 Syntax parameter description
6.8.3 Creating an example
6.9 Common face questions
6.10 Summary
6.11 Exercises
7th Chapter View
7.1 Creating a View
Related concepts of the 7.1.1 view
The role of the 7.1.2 view
7.2 Visualizing the creation of views
7.2.1 generating views from a single table
7.2.2 generating views from multiple tables
7.2.3 generating views from a view
7.3 View Designer
7.3.1 the Diagram pane
7.3.2 the Criteria Pane
7.3.3 the SQL pane
7.3.4 the Results pane
7.4 Modifying and deleting views
7.4.1 Modifying a view
7.4.2 Renaming a View
7.4.3 Deleting a view
7.5 Common face questions
7.6 Summary
7.7 Exercises
8th Chapter Stored Procedures
8.1 Understanding Stored Procedures
The role of 8.1.1 stored procedures
8.1.2 types of stored procedures
8.2 Creating a stored procedure
8.2.1 Named Stored procedures
8.2.2 creating a stored procedure with SQL Server Management Studio
8.3 Executing stored procedures
8.3.1 executing system stored Procedures
8.3.2 executing user-defined stored procedures
8.3.3 specifying parameters for a stored procedure
8.4 Modifying and deleting stored procedures
8.4.1 Modifying stored procedures
8.4.2 Deleting a stored procedure
8.5 program control statements in stored procedures
Overview of 8.5.1 Control statements
8.5.2 IfElse Conditional Selection statement
8.5.3 Beginend statement block
8.5.4 Case Statement
8.5.5 While Loop statement
8.5.6 waitfor WAIT Statement
8.6 Issues that a stored procedure must be aware of
8.6.1 returns the value of a given parameter from a stored procedure
8.6.2 handling errors when executing stored procedures
Statement requirements for 8.6.3 stored procedures
8.6.4 Execute stored Procedure no response
8.7 Common Face questions
8.8 Summary
8.9 exercises
9th Chapter Trigger
9.1 What is a trigger
The role of 9.1.1 triggers
Types of 9.1.2 Triggers
How the 9.1.3 Trigger works
9.2 Creating a trigger using SQL Server Management Studio Manager
9.3 Managing triggers
9.3.1 Modifying triggers
9.3.2 Disabling and enabling triggers
9.3.3 Deleting triggers
9.4 Frequently asked questions about using triggers
9.4.1 Createtrigger must be the first statement in a query batch
9.4.2 statement that returns an error message
9.4.3 the difference between triggers and constraints
The effect of 9.4.4 trigger on database system
9.5 viewing triggers using system stored procedures
9.5.1 using system stored procedures SP_HELP query triggers
9.5.2 using system stored procedures sp_helptext to view the definition text of a trigger
9.5.3 using system stored procedures sp_depends to view a reference table for a trigger
9.6 Common face questions
9.7 Summary
9.8 Exercises
10th chapter E-r Diagram and Relationship diagram
10.1 e-r Map
10.1.1 The concept of entity (E) and relationship (R)
10.1.2 Design E-r Diagram
Design principles of 10.1.3 e-r diagram
10.2 Database Diagram Designer
10.3 Database Diagram
10.3.1 Creating a Database diagram
10.3.2 Saving a database diagram
10.3.3 Open a database diagram
10.3.4 Renaming a database diagram
10.3.5 Deleting a database diagram
10.4 Common face questions
10.5 Summary
10.6 Exercises
The 3rd chapter of Transact-SQL Common grammar and Real pour
11th Chapter Transact-SQL statements
11.1 Transact-SQL syntax explanation
11.2 Creating a Database object
11.2.1 Creating a Database
12th. Object SQL statement Operation--DDL
The 13th Chapter data Operation Language--DML
The 14th Chapter Controls SQL statement operation--DCL
The 4th chapter of Practical Management
15th Chapter Import and Export data
Chapter 16th offline and online databases
17th. Backing up and Restoring a database
18th. SQL Server Reporting Services
5th Operation Advanced
Chapter 19th Transaction Management
20th Chapter SQL Server Agent service
21st chapter of the introduction of the order
22nd Safety-Security and user rights
6th SQL Server Application Development
The 23rd chapter uses the VC development database project
24th. Developing a database project using ASP (C #)
The 25th chapter uses ASP to develop database project
Appendix A
Appendix B
Appendix C Abstracts Editing Illustrations:
1th. Installing SQL Server 2008
SQL Server 2008 is an important version of the database system for Microsoft (Microsoft), and Microsoft has added many new features and made key improvements that make it the most powerful and comprehensive version of the Sql-server so far. SQL Server 2008 not only improved the legacy performance, but also added many new features, such as new data integration capabilities, improved analytics services, Reporting Services, and Office integration. SQL Server 2008 is also a basic database platform for system development based on the Windows platform, and SQL Server is the preferred system development for a wide variety of business systems that need to persist data storage.
The main points of this chapter are:
· Versions and components of SQL Server 2008.
· Installation requirements and visual installation of SQL Server 008.
• Install the SQL Server 2008 samples and sample databases.
1.1 Versions and components of SQL Servee 2008
Depending on the needs of your application, the installation requirements will vary. Different versions of SQL Server can meet the unique performance, uptime, and price requirements of organizations and individuals, and what SQL Server components are installed depends on the specific needs. The following shows how to choose between different versions of SQL Server 2008 and the available components. Preface to the editing of Microsoft's SQL Server database, from the birth to SQL Server 2000 to the big line, and then to SQL Server2005, until the recent SQL Server 2008, are based on the Windows Platform Software development and application of great shock and impact.
SQL Server 2008 is the most important database system for project development on the Windows platform. In the process of software development, database management and scripting, although not like other mainstream programming languages such as C # and C + + for the Java and. NET platforms, require certain technical capabilities, but in the actual project development process, a good database design can greatly affect the performance of the whole project system. This is also interested in software and Internet application developers, at the beginning of the most easy to ignore the problem, always think the database is simple, no technical content, always in the pursuit of the latest programming skills, in the end this is the entire software industry misleading.
The author carefully wrote this manual, the purpose is to combine their years of database project application experience, for the vast number of SQL Server 2008-based developers to introduce a variety of database based on project application knowledge, to help you better complete project development. Characteristics
SQL Server 2008 is one of the mainstream database systems, praised by the industry for its powerful and easy-to-operate management, and is also the easiest database software for beginners to get started. In the software development process, because the database is only a small part of the code writing, often lacks a necessary reference material to assist programming. The author has many years of experience in the project, from the perspective of how a software developer applies SQL Server for project development.
Nonetheless, the content organization of the chapters still follows the style from easy to difficult, from visual operations to scripting. In fact, SQL Server visual operations are ultimately implemented by the application script, in the database is all scripts, nothing but DDL, DML and DCL and SQL server database Some specific functions, procedures to assist the completion.

: Network Disk Download

Beginners Learn SQL Server PDF

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.