Learn the fundamentals of database management, SQL programming, and data analysis in Los Angeles with hands-on database classes. Gain the skills to design, create, and manage databases, and master the art of querying and manipulating data using SQL.
1 class has spots left
Learning the SQL language is one of the most basic tasks required for the use of a relational database. SQL proficiency is essential for business users, database developers, database administrators and any other database professional. This course introduces the basics of the SQL language and the Oracle Relational Database Management System (RDBMS). One will become acquainted with the differences in the working environment between a traditional on-premise...
ONLC Training Centers @ 11400 W Olympic Blvd, Los Angeles, CA
This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461. Audience Profile This course is intended for Database Administrators, Database Developers, and...
MySQL® is the open source community's most popular Relational Database Management System (RDBMS) offering, and is a key part of LAMP – Linux™, Apache™, MySQL®, PHP/Perl/Python®. Many Fortune 500 companies adopt MySQL to reap the benefits of an open source, platform-independent RDMS, such as simplifying conversion from other platforms and lowering database Total Cost of Ownership by 90%. This class encourages the student to explore database...
Thousands of classes & experiences. No expiration. Gift an experience this holiday season and make it a memorable one. Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Explore private group events and team building activities ranging from cooking to art, escape rooms, trivia, and more
Explore Coding Private Group EventsONLC Training Centers @ 7700 Irvine Center Dr, Los Angeles, CA
This Oracle 11g courseware training guide book will allow the student to gain the skills necessary for day-to-day administration of an Oracle database. This course is the starting point for Oracle database administrators and also sets the foundation for advanced administrator training and certification. Audience The primary target audience for this course is Oracle database administrators. Oracle web server and application server administrators,...
Enabling analysts to broaden their SQL skills to retrieve and manipulate data from multiple sources into timely, cohesive, informative analysis. Takeaways We will be going over the following: JOIN and UNION with Aliasing Primary and Foreign Keys Aggregation and Functions Complex JOINs with multiple tables NULL values and related SQL functions GROUP BY combined with HAVING CASE and COALESCE Preparation This course will occur completely...
ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA
Explore the fundamentals of MySQL, database querying techniques, and programming stored routines in this course tailored for application and web developers. Unlock the power of MySQL 8.0 and enhance your database management skills.
ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA
This two-day course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. Audience Profile This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes...
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 incorporates material from the Official Microsoft Learning Product 20462: Administering Microsoft SQL Server. It covers the skills and knowledge measured by Exam 70-462 and along with on-the-job...
Hands On Technology Transfer, Inc. @ (Exact location to be announced), Los Angeles, CA
All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility. Full Course Name: SQL Server 2017 Business Intelligence Application Development (SSRS, SSIS, SSAS) This hands-on course introduces the SQL Server 2017 Business Intelligence Suite, including Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS). Students will complete hands-on exercises creating a number of reports...
Hands On Technology Transfer, Inc. @ (Exact location to be announced), Los Angeles, CA
All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility. This course introduces Microsoft's SQL Server Reporting Services 2017 (SSRS) utility. All reports are developed utilizing SQL Server Data Tools (SSDT), however Report Designer is also introduced. Students will complete hands-on exercises creating a number of reports including table-based, cross tabular and forms based designs. Reports utilizing...
This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL...
This three-day instructor-led course provides students with the knowledge and skills to upgrade their SQL Server 2000 database administration (DBA) skills to SQL Server 2008 DBA skills. Please note that there is no certification exam related to this course. Audience Profile This course is intended for IT professionals who administer and maintain SQL Server databases. At Course Completion After completing this course, students will be able to:...
This three-day instructor-led course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution. Audience The primary audience for this course is individuals who design and maintain...
The focus of this five-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining. Note: This course is designed for customers who are interested in learning SQL Server 2012...
Builder 3.0. The training environment includes SQL 2008R2, SQL Express 2012 and SQL 2012 Standard and Enterprise so that the students can utilize Report Builder 3.0 and generate reports from multiple sources to investigate the different features of each release. The course covers the Report Builder 3.0 wizards, basics of report design, intermediate reports with report parameters and report expressions, report visualizations including graphs, charts,...
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product features and tools related to maintaining a database. Audience Profile The primary audience for this course is individuals who administer and maintain SQL Server databases. This course can also be helpful for individuals who develop...
This five-day instructor-led course is intended for Microsoft SQL Server database developers who are responsible for implementing a database on SQL Server 2008 R2. In this course, students learn the skills and best practices on how to use SQL Server 2008 R2 product features and tools related to implementing a database server. Audience Profile This course is intended for IT Professionals who want to become skilled on SQL Server 2008 R2 product features...
ONLC Training Centers @ 7700 Irvine Center Dr, Los Angeles, CA
The focus of this five-day instructor-led course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies. It describes how to consolidate SQL Server workloads, work with both on-premises and Microsoft Azure cloud-based solutions, and how to plan and implement high availability and disaster recovery solutions. Note This course is designed for customers who are interested...
This three-day instructor-led course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages. Audience This course is intended for information technology (IT) professionals and developers who need to implement data transfer or extract, transform, and load (ETL) solutions by using Microsoft SQL Server 2008 Integration Services. At...
This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008. Audience This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries. At Course Completion After completing this course, students will be able to: • Describe the uses of and ways to execute the Transact-SQL...
Try removing some filters.
Database Training in Los Angeles are rated 4.3 stars based on 2,663 verified reviews from actual CourseHorse.com purchasers.
Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!
Maximize your savings with every purchase. Unlock rewards on every transaction, ensuring you get the most value out of your experience!
Enjoy hassle-free transactions without worrying about additional charges. With us, what you see is what you pay - no surprises!
Discover a curated selection of courses handpicked by experts in the field. Dive into quality content that suits your learning needs and interests!
More in Coding
Get special date and rate options for your group. Submit the form below and we'll get back to you within 2 business hours with pricing and availability.