SQL (Fundamentals)

Course details

SQL Fundamentals Training will provide Students with the basic knowledge and skills to create queries using SQL. It will teach Students how to select, filter and sort data from multiple tables and how to use views and stored procedures.

Course Content

• Introduction to databases and SQL
• Introduction to the SELECT statement
• Calculating data
• Selecting specific rows
• Working with other operators
• Grouping data
• Multi-table queries
• Other SQL front-end applications

Learning Outcomes

Students will gain a good knowledge of concepts related to SQL database structure and terminology.

Who Should Attend

IT Professionals who will be writing queries for use with Microsoft SQL Server 2005, 2008 or 2012. Non-technical ‘power users’ will also benefit from the course if they are comfortable using sophisticated software tools like SQL Server Management Studio.