This class is designed for database users who want to be able to create, read and modify SQL statements for use with their databases.
This class is designed for database users who want to be able to create, read and modify SQL statements for use with their databases. Class exercises and discussion cover —
What SQL is and how it can be used with desktop applications such as Access, Excel and FileMaker,
What SQL can and cannot do,
Ways of writing SQL,
SQL syntax, reading, writing and understanding the language,
The difference between Data Definition Language (DDL) and Data Manipulation Language (DML),
Using an SQL SELECT statement to choose data to be returned from a database,
Working with the SELECT statement: SELECT, FROM, WHERE, ORDER BY,
Specifying conditions for a WHERE clause; using comparison operators, using the IN and LIKE operators,
Using the ORDER BY clause to sort data,
Using JOINs to link tables, different kinds of JOINs,
Introduction to functions in SQL, and
Using SQL to retrieve data, insert, update and delete records.
ComputerImages is a Boston-based computer training and consulting firm that provides instructor-led workshops on most of the widely-used Windows and Macintosh application software. All of our courses feature small class size, hands-on exercises, and an emphasis on student participation.
Helping people use technology is our only business, not a sideline, and we have been doing it for over thirty years. We strive to provide old-fashioned personal attention and customer service in addition to professional excellence in the quality of our work.
Our clients include institutions engaged in almost every area of business, education and the professions, giving us exposure to the many ways in which people work with computers. Over the years we have worked with people from such diverse organizations as Bank of America, Harvard University and the U.S. Social Security Administration.
Candidates for this exam are seeking to prove introductory knowledge of and skills with databases, including relational databases, such as MySql.
You have access to company databases and your job may require you to retrieve data from those databases. Retrieval of information from a database is dependent on precisely ordered logic and specific information.
This class will teach you everything you need to know about SQL and Database Management, from how databases are created and designed to how to extract the business and technical information you need for reporting and analytics.
This course is intended for database professionals with experience in SQL Server 2016 who are looking to update their skills to SQL Server 2017. This course is also for SQL Server 2016 MCSA professionals who are looking to become certified in SQL Server 2017.
You will not only learn about the different types of databases, the languages and designs as well as describe important database concepts using SQL Server 2016. Anyone who is moving into a database role will benefit from taking this course.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy