|
|
|
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 organization'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 137 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
- Analyzing 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
- Utilizing 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 denormalizing 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 centralized access
|
<< Back to SQL Server Course List
Related Courses
SQL Server 2008 is a registered trademark of Microsoft Corporation.
|
|
|
Training Dates
| Feb 7 - 10 | Toronto enrol | | Mar 6 - 9 | Ottawa enrol | | May 15 - 18 | Toronto enrol | | Jul 10 - 13 | Ottawa enrol | | Aug 14 - 17 | Toronto enrol | | Oct 30 - Nov 2 | Ottawa enrol | | Nov 20 - 23 | Toronto enrol | US Dates | | Feb 21 - 24 | Los Angeles enrol | | Feb 28 - Mar 2 | Chicago (Schaumburg) enrol | | Mar 13 - 16 | New York enrol | | Mar 27 - 30 | Rockville, MD enrol | | Apr 2 - 5 | Reston, VA enrol | | Apr 10 - 13 | Philadelphia enrol | | Apr 17 - 20 | Dallas enrol |
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 customized for your organization.
|
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
