|
|
|
You Will Learn How To
- Build and manage SQL Server 2008 databases
- Retrieve and manipulate data with SQL queries
- Integrate SQL Server with .NET, Microsoft Office and XML
- Secure and monitor databases with Management Studio
- Replicate data over multiple servers with merge replication
- Transform data into strategic information using business intelligence processes
Course Benefits SQL Server 2008 offers a progressive and powerful way to manage your organisation's information. A robust and scalable enterprise solution, SQL Server 2008 extends the features of SQL Server 2005 and improves application development time and cost management. This hands-on course provides a solid foundation on which to build essential SQL Server development and administrative skills, including creating databases, generating Transact-SQL statements, implementing security and replicating data over multiple servers.
Who Should Attend Those who are new to Microsoft SQL Server. Familiarity with relational databases is helpful.
Hands-On Training Throughout the course, you gain extensive experience with SQL Server 2008. Practical exercises include:
- Installing SQL Server 2008 R2
- Creating tables and constraints
- Manipulating data with SQL
- Integrating SQL Server with Office
- Securing access to SQL Server from intruders
- Backing up databases to prevent disasters with the Maintenance Plan Wizard
- Replicating data between multiple databases
- Rendering a report with Reporting Services
Course Content Getting Started with SQL Server 2008
Overview of SQL Server architecture
- Fundamentals of relational databases
- Client/server model
SQL Server 2008 editions
- Standard
- Enterprise
- Workgroup
- Express
- Compact
- Developer
SQL Server components and tools
- SQL Server Management Studio
- Management reports
- Business Intelligence Development Studio
- SQL Server Agent
- Database engine
Constructing the Database
Creating a database
- Choosing files and directories
- Allocating file size and growth parameters
- Implementing database schemas
Designing tables
- Analysing various datatypes
- Defining column attributes
- Indexing tables with Management Studio
- Adding, deleting or changing columns
Protecting data with constraints
- Enforcing uniqueness with primary key constraints
- Check constraints to validate conditions
- Building relationships with foreign keys
Server-Side Programming
Data retrieval with Transact-SQL
- Leveraging Query Designer to construct SQL statements
- Writing multiple table join queries
- Aggregating data for business analysis
Modifying data
- Adding new rows with the INSERT command
- Changing targeted data with UPDATE
- Deleting specific rows
Programming constructs
- Writing stored procedures for performance and productivity
- Capturing change events with triggers
- Simplifying data access with user-defined functions
Integrating with Client Applications
Connecting to SQL Server
- Authenticating with SQL Server and Windows logins
- Programming client applications
Interacting with Microsoft Office
- Pulling data from SQL Server into Excel
- Migrating an Access database to SQL Server
Leveraging XML and .NET features
- Retrieving data in XML form
- Utilising a .NET CLR component
Administering SQL Server 2008
Securing the database infrastructure
- Controlling access to SQL Server
- Granting or revoking permissions
- Defining roles and user memberships
Running the Maintenance Plan Wizard
- Automating backups by scheduling jobs
- Checking database integrity and defragmenting data
- Notifying operators via e-mail
Monitoring SQL Server activity
- Viewing locks and queries
- Requesting management reports with Management Studio
Sharing Data through Replication
Defining the replication architecture
- Snapshot
- Transactional
- Merge replication
- Choosing a replication strategy
Configuring merge replication
- Distributing published data
- Subscribing to a publication
Business Intelligence Components
Transforming data with Integration Services
- Importing and exporting files
- Moving and denormalising data into a data warehouse
Producing information with Analysis Services
- Building multidimensional cubes
- Predicting trends with data mining
Information delivery with Reporting Services
- Designing reports quickly with the Report Wizard
- Deploying reports to a Report Server for centralised access
|
<< Back to SQL Server
Related Courses
SQL Server 2008 is a registered trademark of Microsoft Corporation.
|
|
Course Dates
UK Dates | | 14-17 Feb | London enrol | | 10-13 Apr | London enrol | | 12-15 Jun | London enrol | | 24-27 Jul | London enrol | | 11-14 Sep | London enrol | | 30 Oct - 2 Nov | London enrol | US East Coast Dates | | 13-16 Mar | New York enrol* | | 27-30 Mar | Washington, DC enrol* | | 2-5 Apr | Washington, DC enrol* |
*New York and Washington DC Courses – Available online with a run time of 2pm to 9pm BST. For AnyWare enrolments, please register at least 10 days prior to the start of the course.
More Dates and Locations.
|
|
|
|
On-Site &
Custom Training
Bring this or any Learning Tree course to your location or have it customised for your organisation.
|
Course participants configuring SQL Server Agent.
|
|
Average Attendee Evaluation
|
Evaluations in the last 12 months |
|
5 stars:
|
|
76% |
|
4 stars:
|
|
22% |
|
3 stars:
|
|
2% |
|
2 stars:
|
|
0% |
|
1 star:
|
|
0% |
|
"My experiences with Learning Tree—when compared with other training providers I've used—have been better in two ways: First, the layout, the lab and equipment are well ahead of the others. The second advantage is the knowledge of the instructors. Every one that I've had has been great".
– N. Vujnovic
Narroflex, Inc.
|
|
 |
|
E-mail 
Print 
Q&A 
PDF 
Facebook 
Twitter
