This instructor-led, hands-on course, will teach you how to compose SQL queries to retrieve desired information from a database. The course is geared for individuals familiar with concepts related to database structure and terminology and who want to use SQL to query databases.
This instructor-led, hands-on course, will teach you how to compose SQL queries to retrieve desired information from a database. The course is geared for individuals familiar with concepts related to database structure and terminology and who want to use SQL to query databases.
Course Objectives
Connect to the SQL Server database and execute a simple query
Include a search condition in a simple query
Use various functions to perform calculations on data
Organize data obtained from a query before it is displayed on-screen
Retrieve data from tables
Format an output, save a result, and generate a report
Softek offers a variety of software courses to increase efficiency, improve performance, and build capacity. Locate a course using the quick menus and then click the specific course link to view details.
Many of these courses are offered regularly on Softek's Public Course Schedule. If you have a group of students, Softek can deliver any course as a private group training online, at your location, or ours. Contact us for private group pricing.
SQL (short for "Structured Query Language") is the standard language for accessing, inputting and manipulating data in relational databases.
MySQL Introduction will allow you to work with databases by identifying the fundamental concepts of databases, creating a preliminary database design, applying normalization techniques, and familiarizing yourself with relational database management systems. Using various SQL commands, indexes
In this course, you’ll master the skills needed to write Transact-SQL SELECT statements accessing one or more tables. You’ll also learn the various techniques for combining data, filtering the results and how to control and format the statement output.
Students will develop a business application using database software such as Microsoft Access. Students will be required to demonstrate skills such as team building, work ethic, communications, documentation, and adaptability.
This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy