Learning SQL with Microsoft SQL Server Training Course
Course
In City Of London
Description
-
Type
Course
-
Location
City of london
The course is designed for administrators, developers and database developers.
The objectives of the training:
acquire and strengthen the skills to create and manage databases
knowledge of the syntax and use SQL to retrieve and modify data
apply safety rules in the database
the use of advanced elements (replication, automation, BI)
the use of Microsoft SQL Server capabilities to create complex reports and solutions for developers
Facilities
Location
Start date
Start date
Reviews
Subjects
- Server
- Database Management
- Database
- SQL
- Database training
- Syntax
- Shipping
- Systems
- Programming
- Play
Course programme
Introduction
Installing and Configuring Microsoft SQL Server
Overview of Microsoft SQL Server Features
Overview of Transact-SQL Concepts
Querying a Database using SELECT
Filtering the Data with WHERE
Sorting the Data with ORDER BY
Querying Multiple Tables with Joins
Grouping Data with GROUP BY
Using Aggregate Functions to Perform Calculations on Resulting Data
Filtering Groups with HAVING
Creating a New Database
Understanding the Database Model
Optimizing the Database through Normalization
Enhancing your Queries with Procedures
Writing Functions and Sub-routines
Using Conditions to Control the Flow
Connecting to Microsoft SQL Server through Excel
Troubleshooting
Summary and Conclusion
Learning SQL with Microsoft SQL Server Training Course