Learn about the features that are available in SQL Server; how to design and create a database; and how to build basic queries using Transact-SQL, the language of SQL Server. This introductory course teaches you the fundamentals and gives you a taste of the potential of Microsoft SQL Server 2000. Even developers who've already used Oracle, Sybase, DB2 or other relational database management systems will find this course useful for getting up to speed on SQL Server 2000.
SQL Training Audience:
Developers who need to build database solutions with SQL Server.
SQL Training Prerequisites
Microsoft Access, Visual Basic, Active Server Pages or related development experience.
SQL Training Course duration
2 days
SQL Training Course outline
SQL Server Tour
- SQL Server Editions
- Graphical Tools
- Exploring the Enterprise Manager
- Working with SQL Server Books Online
Installing SQL Server
- Multiple Instances
- Installing an Instance of SQL Server
- Configuring the Server
Designing and Creating a Database
- Relational Database Design Principles
- Implementing the Design
Basic Querying
- Introduction to the Query Analyzer
- Retrieving Data
- Joining Tables
Action Queries
- Modifying Data
- Inserting Data
- Updating Data
- Deleting Data
