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.
Overview
This course is designed to provide the skills needed to create and alter a MySQL database and query and modify data held within such a database.
It covers the basics of the SQL language as implemented by MySQL. 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.
The delegates will practise:
Prerequisites
There are no formal pre-requisites, although an understanding of databases and exposure to information technology in general would be useful.
We have more than twenty five years experience of delivering high quality training courses, and our methods work for our clients and for ourselves. Our win-win philosophy adds real value to the organisations and people we train.
This course is designed and developed by Oracle, an integrated set of complete application development tools and techniques for any technology platform and Operating System.
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 will compose SQL queries to retrieve desired information from a database. You should have basic computer skills, be familiar with concepts related to database structure and terminology, and want to use SQL to query databases.
The Java SE 8 Oracle Certified Associate (OCA) certification will help you develop a strong understanding of the Java programming language.
This workshop focuses on teaching IT professionals the best practices and skills required to successfully design, build and operate a business intelligence solution using SQL Server 2016 Integration Services, Analysis Services, Reporting Services and Power BI.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy