You can use SQL to retrieve information from your corporate database (providing, of course, that you understand its structure). This two-day introductory course will show you how to create tables in SQL Server, and then how to write SQL to extract information from them.
You can use SQL to retrieve information from your corporate database (providing, of course, that you understand its structure). This two-day introductory course will show you how to create tables in SQL Server, and then how to write SQL to extract information from them.
You'll learn about the WHERE clause (for setting criteria); the ORDER BY clause; how to aggregate data using GROUP BY; and how to create inner, outer and full joins!
There aren't any pre-requisites for this course, although you'll find it easier if you've already seen a relational database (one with lots of tables joined together). The course uses SQL Server Management Studio, although if you're booking an onsite SQL course we will on request use Azure Data Studio instead.
We deliver top-quality Microsoft training to UK business users. The vast majority of our training is provided for business and organisations in the UK. We don't have any single typical client or course delegate, although most of the people on our courses are office workers.
This Oracle Database 19c Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle database.
Apache Cassandra Training is offered by London IT Training.London IT Training offer a spectrum of courses that have been designed by experts to give you the most sought after IT skills within the UK jobs market.
Teradata is a data warehousing solution used to handle massive data warehouse operations. Participants will obtain in-depth knowledge of Teradata’s database architecture, as well as the product’s capabilities and benefits, throughout this Teradata certification course.
This course will provide delegates with the skills needed to create complex queries, create macros to automate tasks, enhance forms and reports and use the Access programming language Visual Basic for Applications (VBA), enabling delegates to really take control of their databases.
The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Query Browser. The basic SQL statements,including the use of SQL functions and the basic table and view handling statements are introduced.
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy