Database Core Concepts: Beginner

  • 36 Courses | 36h 20m 29s
  • 9 Books | 53h 30m
  • Includes Lab
Likes 120 Likes 120
 
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.

GETTING STARTED

Database Fundamentals: Database Concepts

  • Playable
    1. 
    Course Overview
    1m 52s
    NOW PLAYING
  • Playable
    2. 
    The Origin of Data
    3m 9s
    UP NEXT

COURSES INCLUDED

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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 | 55m available 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 3m has Assessment available 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 4m has Assessment available 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 | 58m has Assessment available 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 19m available 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 | 41m available 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 23m available 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 28m available 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 | 40m has Assessment available Badge
SQL Transactions
Master SQL transactions. Explore transactions and how to group statements, Transact-SQL, and transaction logs.
8 videos | 1h 4m has Assessment available Badge
SQL Transaction Locks
Master SQL transaction locks. Explore transaction locks and explore the different levels of locking.
5 videos | 42m has Assessment available 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 | 54m has Assessment available 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 19m has Assessment available 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 29m has Assessment available 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 7m has Assessment available 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 has Assessment available 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 12m has Assessment available 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 | 1h 1m has Assessment available 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 23m has Assessment available 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 | 38m has Assessment available 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 | 1h has Assessment available 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 18m has Assessment available 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 14m has Assessment available 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 | 46m has Assessment available 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 4m has Assessment available 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 | 47m has Assessment available 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 | 46m has Assessment available 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 has Assessment available 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 8m has Assessment available 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 | 50m has Assessment available 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 | 39m has Assessment available 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 | 31m has Assessment available 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 Guide
Featuring 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.
Book Duration 7h 25m Book Authors By Andrew J. Oppel

Book

SQL for Dummies, 9th Edition
Covering 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.
Book Duration 7h 28m Book Authors By Allen G. Taylor

Book

Fundamental of Database Management System
A 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.
Book Duration 1h 30m Book Authors By Mukesh Negi

Book

Beginning Database Design: From Novice to Professional
Offering 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.
Book Duration 4h 15m Book Authors By Clare Churcher

Book

Beginning Oracle Database 11g Administration: From Novice to Professional
Featuring 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.
Book Duration 6h 3m Book Authors By Iggy Fernandez

Book

Beginning SQL Queries: From Novice to Professional, Second Edition
Introducing 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.
Book Duration 3h 48m Book Authors By Clare Churcher

Book

Fundamentals of Database Management Systems, Second Edition
Offering a highly focused and applied approach, this compact, practical introduction emphasizes fundamental database concepts and presents them in a clear, easy-to-understand way.
Book Duration 8h 13m Book Authors By Mark L. Gillenson

Book

Concise Guide to Databases: A Practical Introduction
Presenting 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.
Book Duration 5h 46m Book Authors By Paul Crowther, Peter Lake

Book

Database Systems: A Pragmatic Approach, Second Edition
Providing 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.
Book Duration 9h 2m Book Authors By Elvis C. Foster, Shripad Godbole
SHOW MORE
FREE ACCESS