Databases

Oracle Database 19c: Basic SQL

0

Learn the basics of how to code using SQL in an Oracle 19c Database environment. Learn how to get data in and out of tables, modify data, delete data, and more.Mastering SQL is an essential skill for any Oracle professional and the first step in becoming a true Oracle expert. In this course, Bob Bryla covers the basics required to code using SQL in an Oracle 19c Database environment. Bob covers what you need to know to get data in and out of your database tables, as well as how to modify data. He explains how to leverage SELECT statements, filter and sort rows, use both single- and multiple-row functions, and join tables. He delves into the Oracle data dictionary—a set of tables that provide information about a database—and shows how to query it. Plus, he demonstrates how to efficiently delete data using DML statements. Upon wrapping up this course, you'll have the fundamental skills you need to work with SQL in this popular relational database management system.

SQL Essential Training

0

Learn how to use SQL to manage your database. Explore beginner-level tutorials on creating tables, defining relationships, and manipulating strings with SQL and SQLiteStudio.Knowing how to code and manage relational databases and database-driven applications is a valuable skill for any career in tech. Completely updated for 2019, SQL Essential Training is designed to help users understand the most common language for database wrangling, SQL. All the lessons have been recorded in SQLiteStudio, an intuitive and easy-to-install database manager. Instructor Bill Weinman teaches all the major features of SQL: creating tables; defining relationships; manipulating strings, numbers, and dates; using triggers to automate actions; and using subselects and views. He offers a solid working knowledge of the language and shows how to retrieve and manage data efficiently. The final chapter includes a real-world example of building a simple application using SQL.This course was created by Bill Weinman. We are pleased to offer this training in our library.

Oracle Database 12c: Backup and Recovery

0

Learn how to design and implement backup and recovery strategies that keep the data stored in your Oracle 12c databases safe and secure.Keeping the information in an Oracle database safe from failure is one of the most important tasks of a successful Oracle DBA. In this course, Oracle instructor and consultant David Yahalom covers the theoretical concepts as well as the practical knowledge required to design and implement bulletproof Oracle backup and recovery strategies. Learn how human errors, hardware failures, and even storage loss can affect your database, and how you can leverage the technologies and features built into Oracle 12c to ensure you will never suffer any data loss. Discover how to use various Oracle tools and technologies, including RMAN, Data Pump, Flashback, and hot and cold backups, to protect your database from the inevitable crash.

Become a Database Administrator

0

Database administrators manage and maintain databases. The role may include installation, configuration, management, performance monitoring, security, data recovery, and more. In this learning path, discover database basics, explore data structures, and learn critical database management skills.Learn key database administration skills. Manage databases for improved performance. Explore how databases integrate with applications.

SQL Server 2008 Essential Training

0

Explores all the major features of SQL Server 2008, beginning with core concepts.In SQL Server 2008 Essential Training, Simon Allardice explores all the major features of SQL Server 2008 R2, beginning with core concepts: installing, planning, and building a first database. Explore how Transact-SQL is used to retrieve, update, and insert information, and gain insight into how to effectively administer databases. The course also covers features outside SQL Server's database engine, including technologies that have grown up around it: SQL Server Reporting Services and Integration Services. Exercise files are included with the course.

Write a Song

0

Have you ever had a musical idea, melody, or great lyrical phrase bouncing around your head—but don't know what to do next?This learning path can help you take a great concept and build it out into a song. Learn tips and tricks from the pros to help make songwriting a part of your life and career.Learn the basics of songwriting.Explore songwriting techniques to help your creative process flow more naturally.Transform songwriting into a career or full-time hobby.

SQL Server 2016: Administer a Database Infrastructure

0

Learn how to administer SQL Server 2016, and prepare for the Microsoft MCSA Administering a SQL Database Infrastructure (70-764) certification exam.SQL Server comes with many features for monitoring, securing, optimizing, and supporting your database infrastructure. Learn how to use these features to administer your SQL Server instances, and prepare for the Microsoft MCSA Administering a SQL Database Infrastructure (70-764) certification exam.Adam Wilbert covers four main skill areas required of SQL Server 2016 administrators: configuring access to data, managing backups, monitoring performance, and implementing the high-availability features of the product. Learn about data encryption, access control, role-level security, and dynamic data masking. Use SQL Server auditing to gain insights into the health and performance of your system, and determine upgrade paths. Discover how to back up SQL Server and perform full or partial restores, and monitor activity. Explore indexing and query execution plan management. Plus, learn to configure availability groups to mitigate hardware failure.

SQL: Data Reporting and Analysis

0

Get the data you need for analysis and reporting by writing your own SQL code. Learn how to write basic SQL queries, sort and filter data, and join results from different tables.

SQL for Testers

0

Ground yourself in the basic approaches to testing SQL queries and gain the ability to do deep testing and analysis of back-end problems.The SQL programming language opens the door to deeper and more efficient software testing. SQL allows testers to examine the back end of application, automate testing through scripting, and simplify and speed up data generation. This course provides a quick-start guide to database testing with SQL. Dave Westerveld shows how to choose the right tools, set up a local site, and start validating data using simple SQL table joins. Next, you can learn how to generate test data by creating, updating, and deleting table entries. Finally, learn how to test SQL queries and find bugs in transactions, implement field constraints to prevent future bugs, and use schema validation to improve the quality of your application. Plus, find out how to prevent unauthorized access to data and measure the runtime of your queries to make sure you're not impeding database performance.

Econometric Methods

0

Give brief about course content / curriculum The econometric methods course may introduce the learners to the basics of building, estimating, assessing econometric models. This course covers the following topics: 1. Meaning, Definition, Scope of Econometrics2. Econometric Methodology3. Assumptions and advantages of Ordinary least square (OLS) method of estimation4. Estimation, Evaluation, Interpretation and reporting of econometric models.5. Implications of, detection of and solutions for OLS assumption violations8. Econometrics models with lag variables9. Econometric models and dummy variables10.Applications of Econometric models. 

FileMaker: Relational Database Design

0

Learn how to translate aspects of the real world into the form and language of a relational database.Understanding which data tables to create and how to link them together via relationships is key to mastering the relational database capabilities of FileMaker Pro. In this course, join instructor Cris Ippolite as he shows how to translate aspects of the real world into the form and language of a relational database. Cris begins by reviewing some of the basic concepts of data modeling, introducing tables, key fields, and the relationship graph. After demonstrating how to establish relationships in a database, he discusses using these relationships in portals, in calculations, and while navigating. He also includes three practical data modeling examples to help you grasp how these concepts work in the real world.This course applies to versions of FileMaker Pro from 16 through the most current version.

SQL Server 2014: Installation and Administration

0

Get up to speed on installing and administering the world's most popular database, Microsoft SQL Server 2014.Get up to speed on installing and administering the world's most popular database, Microsoft SQL Server 2014. First, find out how to plan your installation of SQL Server, and get introduced to the various tools you'll use for administration, such as SQL Server Management Studio. Then follow along with guide Ron Davis as he shows how to automate and set up maintenance plans, import and export data, and index databases. Finally, learn about monitoring SQL Server 2014 and keeping your databases—and users—secure.

Learning Oracle Database 12c

0

In this course, database administrators can learn how to configure Oracle Database 12c, and business intelligence developers can learn how to effectively write applications using it.In this course, Oracle expert and author Bob Bryla goes beyond the fundamentals of administering an Oracle database, and dives deep into the skills an Oracle power user needs to know. Bob reviews the database architecture and shows how a database administrator (DBA) can more effectively manage and configure an Oracle database. At the same time, he explains the database's features that enable a business intelligence (BI) developer to effectively write applications using Oracle Database 12c.

Intro to Couchbase for Microsoft SQL Server Experts

0

Learn how to transition your SQL Server experience to the clustered, document-focused NoSQL architecture of Couchbase.As data volumes increase, data management has evolved. One RDBMS no longer fits all. Learn how to transition your SQL Server experience to the clustered, document-focused enterprise NoSQL architecture of Couchbase. This course compares Couchbase and Microsoft SQL Server on many factors, including target workflows, data access methods, indexing, and querying. Instructor Leo Schuman also compares SQL Server tables to Couchbase documents, and shows how to create, read, update, upsert, and delete documents and the fields within them. The aim is to help developers to leverage Couchbase to support the agile, aggregation-oriented demands of modern enterprise development. By the end, you’ll understand the fundamental architecture and data access methods in Couchbase, particularly N1QL (SQL for JSON).This course was created by Couchbase Learning Services. We are honored to host this training in our library.

SQL Server 2017: What's New

0

See what's new and notable in SQL Server 2017, including Linux compatibility and Python scripting.SQL Server 2017 is the start of the new annual release strategy by Microsoft. SQL developers no longer have to wait two or three years for enhancements. See what's new and notable in the 2017 release, in this overview with Adam Wilbert. See the new Linux compatibility in action, as Adam shows how to install SQL Server on Ubuntu, and learn how to use the machine learning services package, which includes R and Python scripting. Then find out how to use graph databases to model many-to-many relationships as nodes and edges. Adam also reviews the smaller enhancements like automatic query performance tuning and the new dynamic management views.