Structured Query Language (SQL) is an American National Standards Institute (ANSI) standard computer language for accessing and manipulating database systems. SQL works with database programs such as Microsoft Access and SQL Server, DB2, Informix, Oracle, and Sybase.
Structured Query Language (SQL) is an American National Standards Institute (ANSI) standard computer language for accessing and manipulating database systems. SQL works with database programs such as Microsoft Access and SQL Server, DB2, Informix, Oracle, and Sybase.
This hands-on course covers basic SQL syntax for individuals with little to no SQL experience. Instruction presents an overview of SQL and how to use SQL statements to retrieve and update data in a database.
Students begin by creating basic select statements, which include using keywords such as SELECT, UPDATE, DELETE, INSERT, WHERE, HAVING, and others. The course also covers intermediate topics, such as table joins, sub-queries, aggregate functions, stored procedures, triggers, cursors and transactional processing, and much more.
What You Can Learn:
For over a century, UCLA Extension has helped prepare people to live better lives through the power of education.
As one of the nation’s oldest, largest and most comprehensive continuing and professional studies providers, UCLA Extension gives you a wide range of options to advance in your career, switch careers, or achieve personal growth.
UCLA Extension offers:
The excellence that comes with a UCLA-approved curriculum
Open enrollment—most courses require no admission decision
Evening, weekend, daytime and online courses
Locations throughout L.A.—Westwood, DTLA, and Woodland Hills
Certificate and specialization programs, transferable undergraduate
degree-credit, and continuing education credits
Custom programs and corporate education, available worldwide
Non-credit courses, workshops, and special events
Courses specifically designed for working adults, college students, and lifelong learners
This course introduces HBase – a NoSQL store on top of Hadoop.  The course is intended for developers who will be using HBase to develop applications,  and administrators who will manage HBase clusters.
This five-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server database. The course focuses on teaching individuals how to use SQL Server product features and tools related to developing a database
You will learn how to complete of an application schema definition by creating database objects such as relational views, sequences, synonyms, indexes and others to compliment the table definitions.
In this course, you will learn the skills required to maintain a Microsoft SQL Server 2012 or 2014 database by focusing on data storage, backup and restoration, importing and exporting data, security, database maintenance and the SQL Server Agent.
This course provides an Oracle developer or administrator the necessary skills to be able to read and manipulate data within an Oracle database. This course is hands-on and includes lab exercises.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy