Scheduled Dates (sort by: location | date) |
Request availability or book by selecting a date: Central London
City
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.
|
Course Overview Microsoft's SQL Server 2000 offers increased ease of use and scalability, XML integration, and improved data transformation and analysis services. The ability to understand and capitalise on these features is vital to today's fast-paced businesses. In this hands-on course, you explore many of the SQL Server 2000 capabilities using the graphical tools provided by Microsoft. You gain a solid foundation on which to build specific SQL Server 2000 database development or administration skills. Audience This course is valuable for those who are new to SQL Server, as well as those evaluating SQL Server. Familiarity with relational databases is helpful. Skills Gained - Utilise the key components of SQL Server 2000
- Implement a database schema with SQL Server Enterprise Manager
- Retrieve and modify data with SQL tools
- Administer databases with wizards
- Replicate data between databases
- Perform multidimensional data analysis using Analysis Services and Microsoft Excel
- Query SQL Server from the Web using XML
- Migrate data from diverse sources with DTS
Course Outline SQL Server 2000 Overview Overview of database concepts - Client/Server
- RDBMS
- Entity relationship diagramming
SQL Server components - Database engine
- SQL Server Agent
- Analysis Services
- Data Transformation Services (DTS)
SQL Server editions - Personal
- Server
- Enterprise
- Desktop Engine
- Windows CE
Client tools - Enterprise Manager
- Query Analyzer
- Query Designer
- Wizards
Constructing a Database Schema with Enterprise Manager Using the Create Database Wizard - Selecting file name and locations
- Determining file size and growth parameters
Designing tables - Choosing appropriate datatypes
- Identifying primary keys
- Adding and removing columns
- Applying declarative constraints
Developing Database Applications Retrieving data - Creating SQL queries
- Sorting and selecting result sets
- Joining tables
- Aggregating data
- Defining and using full-text indexes
Modifying data - Adding and deleting rows
- Updating existing rows
Storing query definitions - Creating views with Query Designer
- Selecting data from a view
- Building a stored procedure with wizards
- Invoking stored procedures in Query Analyzer
Administering Databases Setting up security - Adding SQL Server logins with the Login Wizard
- Authorising access to databases
- Granting and revoking permissions
- Assigning administrator roles
Maintaining the database - Backing up and recovering databases
- Database Maintenance Plan Wizard
Automating administration procedures - Scheduling jobs
- Responding to events using alerts
- Defining operators
- Reporting job success or failure
Transferring Data Migrating data with DTS - Importing data into SQL Server
- Upsizing Access databases
- Exporting data to text or CSV format
Replicating databases - Replication strategies
- Subscribing to a publishing server
- Empowering mobile users with merge replication
- Resolving conflicts using priorities
Publishing Data on the Web Web Assistant Wizard - Building static Web pages using templates
- Triggering a Web page refresh
Streamlining Web development with XML - Creating a Virtual Directory
- Generating XML from HTTP
Moving Beyond the Database Analysis services - Storing multidimensional data
- Browsing cubes in Microsoft Excel
Microsoft SQL Server 2000 Reporting Services - Authoring and deploying reports
- Viewing reports from a Web site
How to make a booking for the SQ00-I4 course
|
