All courses > Information Technology > Database >

Free online courseDatabase Systems

Duration of the online course: 4 hours and 32 minutes

New course

Master database systems with SQL in this comprehensive course! Learn data basics, relational vs NoSQL databases, SQL queries, transaction management, and more.

Course Description

Welcome to the "Database Systems with SQL" course by Appficial, your gateway to mastering the core principles and practices of database systems. Whether you're an aspiring database administrator, developer, or someone interested in understanding the intricacies of databases, this comprehensive course offers a rich blend of theoretical knowledge and practical skills to help you succeed.

This immersive course, which spans 4 hours and 32 minutes, delves into a wide array of topics under the Information Technology category, with a specific focus on Databases. Designed to provide a thorough understanding of both relational and NoSQL databases, the curriculum begins with foundational concepts and gradually progresses to more advanced subjects.

We start by unraveling the basics with an introduction to data, followed by a thorough overview of databases and database management systems (DBMS). You’ll learn about the critical roles users play in a database environment and gain insights into the nuances of database transactions, ensuring you grasp how to manage data integrity and concurrency.

Understanding the architecture of database systems is crucial, and this course provides a clear comparison between relational and NoSQL databases. You'll explore SQL, the structured query language, and embark on the database design process, covering all phases from analysis to physical design.

The practical part of the course starts with the installation of MySQL Workbench and initiation of a database server. You will get hands-on experience with database models, relational models, tables, columns, rows, various data types, and the crucial concepts of primary and foreign keys. Moreover, you'll delve into SQL commands, constraints, and the powerful SELECT statement to retrieve, manipulate, and aggregate data efficiently.

One essential aspect of databases is their adherence to normalization principles. This course thoroughly explains the First, Second, and Third Normal Form (1NF, 2NF, 3NF), along with Boyce-Codd Normal Form (BCNF) and denormalization techniques, ensuring you can maintain data integrity and optimize performance.

The course also emphasizes advanced query techniques, including inner and outer joins, subqueries, and query optimization. You'll be equipped to construct entity-relationship (ER) diagrams and understand different dependency relationships, vital for effective database design.

As we move further, you'll be introduced to SQL execution with statements for creating, updating, and deleting databases and tables. Learn about table constraints, transactions with commit and rollback, and the significant ACID properties that ensure reliable database transactions.

The course doesn't stop at theoretical aspects but extends to practical programming with databases. You'll explore embedded SQL programming, procedural SQL with PL/SQL, and connecting databases with popular programming languages using MySQL APIs. Hands-on exercises in Python and Java database programming will solidify your understanding, enabling you to implement stored procedures and manage queries effectively.

In an era where data is paramount, understanding Big Data and NoSQL databases becomes indispensable. This course provides an overview of various NoSQL databases, including key-value pairs, wide-column stores, document databases, and graph databases, each tailored to specific data requirements.

To sum up, "Database Systems with SQL" by Appficial is a detailed and practical course that empowers you with essential database skills needed in today's technology-driven world. Although there are no reviews yet, the extensive content promises a robust learning experience that bridges the gap between fundamental concepts and advanced practices in database management. Enroll today and take the first step towards becoming a proficient database professional.

Conteúdo do Curso

  • Video class: Database Systems - Intro to Data

    0h02m

  • Exercise: Which of the following factors is NOT mentioned as a way in which data can vary?

  • Video class: Database Systems - Intro to Databases and DBMS

    0h02m

  • Video class: Database Systems - User Roles

    0h01m

  • Exercise: Which role is primarily responsible for creating the structure and defining the format of data elements in a database?

  • Video class: Database Systems - Intro to Transactions

    0h02m

  • Video class: Database Systems - Intro to Architecture

    0h01m

  • Exercise: In a database system architecture, what is the primary role of the query processor?

  • Video class: Database Systems - Relational vs NoSQL Databases

    0h02m

  • Video class: Database Systems - What is SQL - Structured Query Language

    0h02m

  • Exercise: What is the primary function of SQL in the context of databases?

  • Video class: Database Systems - Database Design Process - Analysis, Logical and Physical Phase

    0h04m

  • Video class: Database Systems - Installing MySQL Workbench and Starting the Database Server

    0h05m

  • Exercise: What is the primary difference between MySQL Community Edition and MySQL Enterprise Edition?

  • Video class: Database Systems - Database Model and Relational Model

    0h03m

  • Video class: Database Systems - Intro to Tables, Columns, and Rows

    0h01m

  • Exercise: In a relational database, what is the role of a column?

  • Video class: Database Systems - Data Types

    0h02m

  • Video class: Database Systems - Structural Rules and Data Independence

    0h01m

  • Exercise: Which of the following statements about the normalization process in database tables is NOT correct?

  • Video class: Database Systems - NULL Values

    0h02m

  • Video class: Database Systems - Primary Keys and Foreign Keys

    0h03m

  • Exercise: What is a composite primary key in a SQL database?

  • Video class: Database Systems - Referential Integrity on Primary and Foreign Keys

    0h01m

  • Video class: Database Systems - Inner and Outer Joins

    0h04m

  • Exercise: What type of SQL join selects all rows from the left table, and only the matching rows from the right table?

  • Video class: Database Systems - View Tables

    0h04m

  • Video class: Database Systems - Normization - 1NF, 2NF and 3NF Normal Form

    0h04m

  • Exercise: Which of the following describes the condition for a table to be in the third normal form (3NF)?

  • Video class: Database Systems - Relational Algebra and Query Optimization

    0h02m

This free course includes:

4 hours and 32 minutes of online video course

Exercises to train your knowledge

Certificate of course completion

100% free, from content to certificate
QR Code - Baixar Cursa - Cursos Online

This online course can only be accessed through the Cursa App. Download it using the QR code or the links below:

This online course can only be accessed through the Cursa app. Install it using the links below:

Get it on Google Play Get it on App Store

  • Study for free!

    Here you never pay! Not even for the certificate, because everything in the app is 100% free!

  • Improve your resume!

    There are more than 4,000 free courses for you to study anything that interests you!

  • Free Digital Certificate!

    Complete the course and issue your internationally recognized Digital Certificate free of charge.

More free courses at Database

Free Course Image MongoDB
Free CourseMongoDB

5

(1)

0h36m
5 exercises
Free Course Image MySQL
Free CourseMySQL

5

(2)

1h11m
10 exercises
Free Course Image Database
Free CourseDatabase

4.71

(42)

17h34m
25 exercises
Free Course Image MySQL database
Free CourseMySQL database

4.71

(129)

3h40m
5 exercises
Free Course Image PosgresSQL
Free Course PosgresSQL

4.7

(10)

4h14m
27 exercises
Free Course Image SQL Server tutorial for beginners
Free CourseSQL Server tutorial for beginners

4.55

(49)

26h59m
28 exercises
Free Course Image MongoDB Tutorial For Beginners
Free CourseMongoDB Tutorial For Beginners

4

(4)

3h06m
28 exercises
Free Course Image Complete MongoDB Tutorial
Free CourseComplete MongoDB Tutorial

4

(1)

2h53m
25 exercises
Free Course Image MongoDB full course
Free CourseMongoDB full course

3.17

(6)

7h50m
1 exercises
Free Course Image Databases
Free CourseDatabases

New course

11h08m
8 exercises

Free text courses

Free ebook
Complete MySQL Database course from basic to advanced

5

(2)

71 pages4h25m

Free ebook
Creation and maintenance of MongoDB database from basic to advanced

5

(1)

88 pages5h21m

Download the App now to have access to + 3300 free courses, exercises, certificates and lots of content without paying anything!

  • 100% free online courses from start to finish

    Thousands of online video courses, audio or text courses.

  • More than 48 thousand free exercises

    To test your knowledge during online courses

  • Valid free Digital Certificate with QR Code

    Generated directly from your cell phone's photo gallery and sent to your email

QR Code - Baixar Cursa - Cursos Online

Download our app via QR Code or the links below::.

Get it on Google Play Get it on App Store
Cursa app on the ebook screen, the video course screen and the course exercises screen, plus the course completion certificate

+ 6.5 million
students

Free and Valid
Certificate with QR Code

48 thousand free
exercises

4.8/5 rating in
app stores

Free courses in
video, audio and text

Information Technology330 courses Web Development, 45 courses | Programming Languages ( Python, Ruby, Java, C ), 37 courses | Office productivity, 34 courses | Cyber Security, 13 courses | App Development, 30 courses | Database, 29 courses | Software testing, 13 courses | Artificial Intelligence, 24 courses | Web Servers and Cloud Computing, 18 courses | Data Science and Business Intelligence, 7 courses | Backend development, 15 courses | Programming logic, 7 courses | IT Tools, 17 courses | Maintenance of computers and notebooks, 4 courses | Operational Systems, 9 courses | Basic informatics, 11 courses | Game development, 17 courses |
Languages196 courses English, 27 courses | French, 25 courses | Spanish, 27 courses | German, 26 courses | Japanese, 20 courses | Italian, 15 courses | Korean, 15 courses | Chinese / Mandarin, 12 courses | Portuguese, 8 courses | Sign language, 9 courses | Russian, 8 courses | Polish, 4 courses |
Business administration140 courses Digital Marketing, 29 courses | Entrepreneurship, 13 courses | Human resources, 9 courses | Investments, 18 courses | Project management, 13 courses | Business Skills, 3 courses | Accounting, 11 courses | Ecommerce and Sales, 13 courses | Corporate Finances, 9 courses | Purchasing management, 5 courses | Political, 11 courses | Management, 6 courses |
Professional courses224 courses Electrician, 20 courses | Customer Service, 13 courses | Culinary, 30 courses | Engineering and Mechanics, 14 courses | Logistics and Supply chain, 8 courses | Construction, 20 courses | Fashion, cutting and sewing, 16 courses | Car and Motorcycle Repairs, 13 courses | Cashier and Bank teller, 5 courses | Mobile phone repairs, 4 courses | Welding, 8 courses | Property and Private Security, 7 courses | Refrigeration and air conditioning, 10 courses | Journalism, 6 courses | Woodworking, 10 courses | Realtor, 10 courses | Farming, 8 courses | Crafts, 9 courses | Other Professions, 12 courses |
Health124 courses First aid, 11 courses | Nutrition and weight loss, 15 courses | Physiotherapy, 16 courses | Nursing, 11 courses | Psychology, 19 courses | Physical Exercises to a Health Life, 9 courses | Anatomy, 17 courses | Pharmacology, 10 courses | Child Care, 2 courses | Physiology, 9 courses | Others in Health and Medicine, 5 courses |
Design and Art102 courses Graphic design, 21 courses | UX - User Experience, 24 courses | Image editing, 12 courses | Drawing and Painting, 17 courses | Architectural design, 11 courses | Video edition, 15 courses | Video animations, 2 courses |
Basic studies120 courses Physics, 10 courses | Algebra, 12 courses | Biology, 10 courses | Logical Reasoning, 5 courses | Statistics, 11 courses | Chemistry, 8 courses | Calculus, 11 courses | Geography, 10 courses | Philosophy, 3 courses | Trigonometry, 8 courses | Literature, 5 courses | Geometry, 10 courses | History, 5 courses | Economics, 8 courses | Sociology, 4 courses |
Instruments and Vocal93 courses Sing, 15 courses | Guitar, 9 courses | Piano, 13 courses | Music production and DJ mixing, 10 courses | Flute, 8 courses | Drums, 7 courses | Violin, 7 courses | Eletric Guitar, 9 courses | Bass, 7 courses | Saxophone and Clarinet, 7 courses | Ukulele, 1 courses |
Esthetics48 courses Makeup, 6 courses | Nails, manicure and pedicure, 8 courses | Skin care, 9 courses | Barbershop, 11 courses | Eyebrow design, 9 courses | Hair care, 6 courses |
Others71 courses Sports, 19 courses | Photography, 11 courses | Massage therapy, 5 courses | Astronomy, 5 courses | Astrology, 4 courses | Youtuber, 3 courses | Magic and Hypnosis, 2 courses | Table and Card games, 5 courses | Robotics, 5 courses | Theology, 3 courses | Theater and Film making, 4 courses | Dance, 5 courses |

This site and the application have been developed with the goal of helping people find free courses more easily, because there are many good and free content on youtube, but many people are not aware of this.
[email protected]

MEDEIROS TECNOLOGIA LTDA - CNPJ 24.471.978/0001-08

Access in other languages:

Spanish French Portuguese Hindi

Night mode

Get it on Google Play Get it on App Store
DMCA.com Protection Status