Database Core Concepts: beginner
- 37 Courses | 35h 21m 48s
- 9 Books | 53h 30m
- Includes Lab
Information is as valuable as gold, but before you master DB administration, you need to understand the ins and outs. Explore the basics of DBs.
COURSES INCLUDED
An Overview of Cloud Databases
Cloud databases are hosted on and often maintained by a cloud platform. The platform manages the hardware, networks, and OS, and users pay for the allocated or consumed resources. Through this course, learn what cloud-hosted databases have to offer, the factors that influence the adoption of a cloud database, and what to watch out for when using such systems. Explore the characteristics of cloud-hosted databases and the benefits and caveats of such services. Next, discover factors to consider when moving to the cloud. Finally, compare SQL and NoSQL systems and learn about some of the most powerful cloud-hosted database services. Upon completion, you'll be able to recognize the elements of different cloud databases and select the best option.
7 videos |
53m
Assessment
Badge
Database Fundamentals: Database Concepts
Most businesses are unable to function without a database, even if it's just a filing cabinet. With more and more data coming from multiple sources comes an increased demand for secure and well-performing databases with adequate storage. Take this course to get a firm understanding of what exactly data means and why a database management system (DBMS) is so important for data management. Examine the origins of data and how it's stored and manipulated. Discover the different DBMS types. And learn about the roles and responsibilities involved in using a DBMS. Furthermore, find out how a DBMS can contribute to providing sound and reliable data. Navigate the MySQL Workbench to see the capabilities of an RDBMS (relational database management system) firsthand. After taking this course, you'll be able to recognize the features and capabilities of a reliable DBMS.
9 videos |
44m
Assessment
Badge
Database Fundamentals: Understanding Relational Database Management Systems
Stored data can be used to derive all kinds of information. And the proper storage and use of data can contribute to better business decisions. Use this course to learn how to use a relational database management system (RDBMS) to retrieve vital information. Explore the purpose of an RDBS. Examine various databases in the marketplace, taking an in-depth look at the history and features of the most popular ones, like Oracle and SQL Server. Work with MySQL Workbench, observing how records relate to tables and how tables are connected. Discover primary database terminology. Learn about organizing data and using normalization to make data retrieval easier. And find out about E.F. Codd's contribution to database evolution. Upon completion, you'll know how to glean new information from data stored in an RDBMS.
12 videos |
1h 5m
Assessment
Badge
Database Fundamentals: Getting Started with SQL
Because a database is only the storage medium, we need to use a different kind of tool in order to work with that stored data. Take this course to learn how to use structured query language (SQL) to manage data in a relational database management system (RDBMS). Perform create, read, update, and delete (CRUD) operations on data using SQL, to make raw data useful. Examine data definition language (DDL) commands that work with database and table objects. Use SQL to add constraints to data in tables, for example, to specify what kind of data gets stored in which column. And explore the repercussions of constraint violation. After completing this course, you will be able to illustrate how SQL can be used within a database to add and secure tables.
12 videos |
55m
Assessment
Badge
Database Fundamentals: Working with SQL Commands
The data stored in a database can be used in a variety of ways. Take this course to explore the power of the database as a tool for storing, manipulating, and retrieving data. Use data definition language (DDL) commands to clarify structures like schema, database, and tables. Learn the most important data manipulation language (DML) commands and execute a data query language (DQL) statement. Finally, explore how tables can be combined via joins and subqueries, producing new information from existing data. Upon completion, you will be comfortable using basic commands to set up and work with databases.
12 videos |
48m
Assessment
Badge
Database Fundamentals: Database Administration Basics
Once a database is part of your IT infrastructure, you need to protect and maintain it. You also have to ensure that it is operating at optimal capacity. This course focuses on the database administrator (DBA), the individual charged with building, maintaining, and backing up the database. Explore key responsibilities and tasks performed by the DBA involving the security, migration, troubleshooting, and configuration of databases. Discover how the role of the DBA compares to that of a database developer. Finally, learn about common maintenance functions performed for a database such as backup and restore, user management, and performance tuning. Upon completion of this course, you'll understand the role of a DBA and how the DBA's day-to-day responsibilities differ from those of a database developer.
10 videos |
54m
Assessment
Badge
SQL Concepts & Queries
Master SQL concepts. Learning the core fundamentals creates a foundation. Discover relational databases and Structured Query Language (SQL) database concepts.
7 videos |
1h
Assessment
Badge
SQL Tables
Master SQL tables. Take your first steps in learning about relational databases and Structured Query Language (SQL) tables. Discover how to manage tables, and queries, including complex tables, changing tables, and deleting tables.
9 videos |
1h
Assessment
Badge
SQL Selecting, Ordering, & Filtering
Manipulating databases is a necessary skill. Explore Structured Query Language (SQL) and dive into the architecture. Discover efficient and easily manageable databases using features like SELECT, data types, UPDATE, and ORDER BY.
9 videos |
55m
Assessment
Badge
Table Design: Tables, Columns, & Numbers
Fundamentals create foundation. Get a clear picture of what SQL is all about. Discover table functions including ALTER and CREATE, as well as column functions and math operators.
13 videos |
1h 16m
Badge
Table Design: Functions & Strings
Master the core functions of SQL strings. Strings are a key component to any database, and you can work magic using fundamental SQL commands. Explore string functions like LENGTH, REVERSE, and TRIM, as well as how to put them together.
8 videos |
40m
Badge
Multiple SQL Tables
Work with multiple tables. Mastering the fundamentals of SQL creates a foundation. Explore multi-table database architecture and design, connecting several tables, using inner/outer joins, and equijoins and non-equijoins.
12 videos |
1h 20m
Badge
Advanced SQL Queries
Master advanced queries. Queries in SQL allow you to manipulate databases like a pro. Discover advanced techniques including subqueries, correlated queries, difficult queries, and learn query tips for better efficiency.
13 videos |
1h 24m
Badge
SQL Views
Discover SQL views. Explore SQL views in detail, defining various views and their management, from creating views to view types, updating, and dropping views.
5 videos |
38m
Assessment
Badge
SQL Transactions
Master SQL transactions. Explore transactions and how to group statements, Transact-SQL, and transaction logs.
8 videos |
1h
Assessment
Badge
SQL Transaction Locks
Master SQL transaction locks. Explore transaction locks and explore the different levels of locking.
5 videos |
40m
Assessment
Badge
SQL Security Architecture
Mastering security is crucial. Explore one of the most important aspects of SQL security. Discover the lock system, levels of security access and management, privileges and rights, and the setup and installation of security architecture.
7 videos |
51m
Assessment
Badge
Architecture Concepts
A database is used by organizations to store their data and to allow their employees to access, update, and manage it. Learn about databases, including types, users, characteristics, architectures, and database models.
11 videos |
1h 14m
Assessment
Badge
Normalization Concepts
Organizations use a Database Management System to manipulate, organize and retrieve data. Learn about these systems, their components, and Dr. Edgar Codd's rules for a database to be considered relational.
13 videos |
1h 23m
Assessment
Badge
Relational Algebra & Calculus
Storing data is important, but it's equally important to be able to manipulate and analyze it using a query language like SQL. Explore relational algebra and calculus, developed by Dr. Edgar Codd for his theory for the relational database.
11 videos |
1h 2m
Assessment
Badge
SQL & Concurrency Concepts
SQL is the main query language used by most DBMSs. Learn how to use SQL to manage data, how transactions and concurrency control ensure data integrity and consistency, and how security is implemented in a relational database.
13 videos |
1h 19m
Assessment
Badge
Concepts & Conceptual Design
Good database design sets the foundation for database implementation and ensures business requirements can be met. Learn how to design a database, including database modeling, the design life cycle, and requirements.
12 videos |
1h 6m
Assessment
Badge
Creating a Conceptual Design
Proper database design ensures the database will perform as expected for its users. Explore conceptual design, entities, relationships, as well as creating and integrating views into an ERD.
10 videos |
57m
Assessment
Badge
Logical Design
The logical design model consists of taking the conceptual diagram and converting it to represent the logical implementation of the database. Explore the entities, attributes, and relationships that exist in the logical model.
11 videos |
1h 17m
Assessment
Badge
Normalization Concepts & Forms
Database normalization allows you to organize data in a way that reduces redundancy and increases integrity. Learn about normalization and the normal forms in database design.
6 videos |
35m
Assessment
Badge
Logical & Physical Design
Learn about the physical database design phase, including transforming entities to tables and attributes to views, as well as implementing views and various types of indexes.
8 videos |
56m
Assessment
Badge
Database Design
A Database Management System, also known as a DBMS, is used to control, store, organize, and retrieve that data. Discover databases, DBMS, and RDBMS, and explore different database models.
9 videos |
1h 14m
Assessment
Badge
DML & Multi-table Queries
A relational database stores data in tables that store data in rows or tuples and columns or attributes. Explore how to use DML statements to query data and manipulate result sets.
10 videos |
1h 10m
Assessment
Badge
Working with Data
Discover how to update and delete data from a SQL Server database and how to use transactions to ensure data and referential integrity.
6 videos |
44m
Assessment
Badge
Components, Procedures, & Functions
The Data Definition Language (DDL) is used to create databases and their components. Discover how to create databases, tables, views, and stored procedures using DDL.
8 videos |
1h 1m
Assessment
Badge
Normalization & Indexes
Data redundancy negatively affects storage, scalability, and responsiveness. Learn how to use database normalization and indexes in SQL Server to counter these negative effects.
7 videos |
44m
Assessment
Badge
Database Security
A major concern for any database administrator is data security. Explore security considerations for SQL Server databases, how to assign permissions to database objects, and how to back up and restore databases.
6 videos |
44m
Assessment
Badge
Non-relational Data: Non-relational Databases
Non-relational (NoSQL) databases are attractive for working with Big Data because they provide a way to store data from different sources in the same document and organize large amounts of diverse and complex data. Use this course to discover the principles behind non-relational databases and NoSQL, explore their benefits, and examine different types of non-relational architectures, such as document, key-value, graph, columnar, and multi-model databases. You'll also get familiar with HBase and NewSQL. After finishing this course, you will be able to identify the suitable NoSQL database required for any given business problem.
12 videos |
46m
Assessment
Badge
Data Architecture Getting Started
In this 12-video course, learners explore how to define data, its lifecycle, the importance of privacy, and SQL and NoSQL database solutions and key data management concepts as they relate to big data. First, look at the relationship between data, information, and analysis. Learn to recognize personally identifiable information (PII), protected health information (PHI), and common data privacy regulations. Then, study the data lifecycle's six phases. Compare and contrast SQL and NoSQL database solutions and look at using Visual Paradigm to create a relational database ERD (entity-relationship diagram). To implement an SQL solution, Microsoft SQL Server is deployed in the Amazon Web Services (AWS) cloud, and a NoSQL solution by deploying DynamoDB in the AWS cloud. Explore definitions of big data and governance. Learners will examine various types of data architecture, including TOGAF (The Open Group Architecture Framework) enterprise architecture. Finally, learners study data analytics and reporting, how organizations can derive value from data they have. The concluding exercise looks at implementing effective data management solutions.
13 videos |
1h 2m
Assessment
Badge
Data Engineering Getting Started
Data engineering is the area of data science that focuses on practical applications of data collection and analysis. This 12-video course helps learners explore distributed systems, batch versus in-memory processing, NoSQL uses, and the various tools available for data management/big data and the ETL (extract, transform, and load) process. Begin with an overview of distributed systems from a data perspective. Then look at differences between batch and in-memory processing. Learn about NoSQL stores and their use, and tools available for data management. Explore ETL-what it is, the process, and the different tools available. Learn to use Talend Open Studio to showcase the ETL concept. Next, examine data modeling and creating a data model in Talend Open Studio. Explore the hierarchy of needs when working with AI and machine learning. In another tutorial, learn how to create a data partition. Then move on to data engineering and best practices, with a look at approaches to building and using data reporting tools. Conclude with an exercise designed to create a data model.
13 videos |
45m
Assessment
Badge
Data Rollbacks: Transaction Rollbacks & Their Impact
In this 9-video course, you will explore the data concepts of transactions, transaction management policies, and rollbacks. Discover how to implement transaction management and rollbacks by using SQL Server. Begin by learning about the concept and characteristics of the rollback process and its impact on transactions. Then take a look at various states of transactions, and prominent types of transactions along with their essential features (distributed and compensating transactions). Moving on, learn about implementing transaction management, along with certain essential elements like commit savepoint and release savepoint using SQL server. Learners recall the various transaction log operations and their characteristics (transaction recovery and transaction replication). You will learn to recognize the Deadlock Management capabilities and features provided by SQL server by using lock monitors and trace. Examine the essential rollback mechanism adopted by SQL server, then see how the SQL server is used to roll back databases to a specific point in time. A concluding exercise involves implementing transaction management and rollbacks by using SQL server.
10 videos |
35m
Assessment
Badge
Data Rollbacks: Transaction Management & Rollbacks in NoSQL
During this 7-video course, learners will explore differences between transaction management by using NoSQL and MongoDB and discover how to implement change data capture in databases and NoSQL. The first tutorial compares the transaction management architecture and capabilities of NoSQL and SQL. Then you will learn how to recognize the transaction management capabilities of MongoDB, along with its impact on consistency and availability. Next, learners will explore how to implement multi-document transaction management by using replica set in MongoDB. Then the course moves on to examine change data capture, which is the process of capturing the change, and learn about the essential SQL Server change data capture features. You will examine the features of change stream in MongoDB, which leads on to creating change streams to enable real-time data change streaming for applications using MongoDB. To conclude the course, an exercise on MongoDB transactions and change streams compares the transaction management architecture and capabilities of NoSQL and SQL.
8 videos |
28m
Assessment
Badge
SHOW MORE
FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.BOOKS INCLUDED
Book
Databases A Beginner's GuideFeaturing clear examples using both Microsoft Access and Oracle, this practical resource provides a strong foundation that will be useful to any of you wanting to learn more about database technology.
7h 25m
By Andrew J. Oppel
Book
SQL for Dummies, 9th EditionCovering everything you need to know to make working with SQL easier than ever, this easy-to-understand guide shows programmers and web developers how to use SQL to build relational databases and get valuable information from them.
7h 28m
By Allen G. Taylor
Book
Fundamental of Database Management SystemA single comprehensive guide for students, teachers and professionals, this practical-oriented book teaches the essentials of DBMS to anyone who wants to become an effective and independent DBMS master.
1h 30m
By Mukesh Negi
Book
Beginning Database Design: From Novice to ProfessionalOffering numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers, this book provides short, easy-to-read explanations of how to get database design right the first time.
4h 15m
By Clare Churcher
Book
Beginning Oracle Database 11g Administration: From Novice to ProfessionalFeaturing not only technical information, but also guidance on work practices that are as vital to your success as technical skills, this book shows you how to become a much better Oracle database administrator than you ever thought possible.
6h 3m
By Iggy Fernandez
Book
Beginning SQL Queries: From Novice to Professional, Second EditionIntroducing all the main techniques and keywords needed to create SQL queries, this book is aimed at intelligent laypeople who need to extract information from a database, and at developers and other IT professionals who are new to SQL.
3h 48m
By Clare Churcher
Book
Fundamentals of Database Management Systems, Second EditionOffering a highly focused and applied approach, this compact, practical introduction emphasizes fundamental database concepts and presents them in a clear, easy-to-understand way.
8h 13m
By Mark L. Gillenson
Book
Concise Guide to Databases: A Practical IntroductionPresenting review and discussion questions, as well as hands-on exercises, this easy-to-read reference provides a comprehensive introduction to databases, opening with a concise history of databases and of data as an organizational asset.
5h 46m
By Paul Crowther, Peter Lake
Book
Database Systems: A Pragmatic Approach, Second EditionProviding a comprehensive, yet concise introduction to database systems, with special emphasis on the relational database model, this book discusses the database as an essential component of a software system, as well as a valuable, mission critical corporate resource.
9h 2m
By Elvis C. Foster, Shripad Godbole
SHOW MORE
FREE ACCESS
SKILL BENCHMARKS INCLUDED
Database Fundamentals Literacy (Beginner Level)
The Database Fundamentals Literacy benchmark will measure your knowledge of the fundamentals of data, databases, DB design, and DBMS. You will be assessed on your skills to recognize RDBMS concepts & terminologies, work with various data providers, use DB commands, and identify the role of the DBA. A learner who scores high on this benchmark demonstrates that they have the skills to set up a database and tables in a normalized form and run queries on them.
25m
| 26 questions
