SQL Server 2008 - Expert
Work through SQL Server 2008 in self-paced lessons: navigate Management Studio, create databases and tables, add constraints and indexes, write SELECT and multi-table queries, and build views and stored procedures with T-SQL.
About this course
Work through SQL Server 2008 in self-paced lessons: navigate Management Studio, create databases and tables, add constraints and indexes, write SELECT and multi-table queries, and build views and stored procedures with T-SQL.
Curriculum
- Introduction
- Overview: What is SQL Server?
- Connecting to the Server
- Working in the Management Studio
- Template Explorer
- Using Tools
- Understanding Window, Community, and Help Tabs
- Using Toolbars
- Using Object Explorer
- Opening a Table
- Transacting SQL
- Creating Databases with the Database Wizard
- Creating Tables Manually
- Understanding the 7 Basic Data Type Categories
- Using the Table We Created
- Creating Tables Using T-SQL
- Adding Constraints
- Understanding Indexes
- Altering the Table Design
- The Basic SELECT Statement
- The FROM Clause
- The WHERE Clause
- The ORDER Clause
- MS-SQL Query Method
- Using a WHERE Clause to Link Tables
- Ansi-SQL Method
- Joining Tables: Inner Join
- Query Designer
- Ambiguous Column Name
- Table Aliases
- Joining Tables: Left Outer Join
- Joining Tables: Right Outer Join
- A Tip for Building a New Query
- Overview
- Creating a View
- Creating a View Using T-SQL
- Creating Simple Stored Procedures
- Using Arguments
- Executing Stored Procedures
- Conclusion
Who it's for
Users who want hands-on command of SQL Server databases and T-SQL queries.
Before you start
No formal prerequisites. Bring curiosity and a willingness to practise.
Related courses
More in Programming & Web Development →Advanced Java 9
Programming & Web Development
View course →Android Studio Development Essentials
Programming & Web Development
View course →Blockchain: An Overview for Business Professionals
Programming & Web Development
View course →Computer Vision with Python OpenCV
Programming & Web Development
View course →Database Design - Beginner
Programming & Web Development
View course →Flask Development with Python
Programming & Web Development
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.