Overview
Course Description
In the course, students will learn about different database technologies. They will learn theory, techniques, and tools for creating databases, data structures, and web applications. Students will develop applications with MS SQL Server and MySQL and learn to analyze and troubleshoot systems. In addition, students will learn how to create databases and forms.Databases can be used to analyze large datasets.
What you'll learn
- How to create pipelines. It will also teach you how to analyze datasets and write queries.
- How to design, manage, and update database systems..
- How to write databases and database applications, including SQL compliance and data modelling.
- How to manage multi-user databases and share enterprise data.
- How to use the tools and knowledge to implement SQL and other databases and to design and maintain management dashboards.
Course Content
An Overview of the Database Management System
-
Lecture 1.1 What is database? 
02:53
-
Lecture 1.2 Why database?
02:53
-
Lecture 1.3 Database system, Database Management system
02:53
-
Lecture 1.4 Advantages of DBMS
02:53
An Architecture of the Database System
-
Lecture 2.1 Three levels of architecture, Logical View
02:53
-
Lecture 2.2 Physical View, Conceptual View, Logical Data independence
02:53
-
Lecture 2.3 Physical Data Independence
02:53
Relational Database Management System (RDBMS)
-
Lecture 3.1 Introduction, RDBMS terminology, Relational Model
02:53
-
Lecture 3.2 base tables, keys, primary key, foreign key
02:53
-
Lecture 3.3 Constraints, Codd Rules
02:53
Database Design
-
Lecture 4.1 Normalization
02:53
-
Lecture 4.2 Normal Forms-1NF, 2NF, 3NF, BCNF 4NF and 5NF
02:53
-
Lecture 4.3 Providing Aesthetics to Slides & Printing
02:53
-
Lecture 4.4 E-R Diagram
02:53
-
Lecture 4.5 Mapping ER-diagram to database tables.
02:53
Maria DB
-
Lecture 5.1 Introduction to Maria DB, Data Types
02:53
-
Lecture 5.2 SQL Commands, Create, Insert, Update, Delete
02:53
-
Lecture 5.3 SQL functions, Indexing, key, Primary key, Foreign key
02:53
Manipulating Data with Maria DB
-
Lecture 6.1 SQL Statements, Select, like clause, group by
02:53
-
Lecture 6.2 order by, joins-left join, Natural join, Right join
02:53
-
Lecture 6.3 Backup and restore commands
02:53
NoSQL Database Technology
-
Lecture 7.1 Introduction to NoSQL Databases,
02:53
-
Lecture 7.2 NoSQL Features
02:53
-
Lecture 7.3 Architecture of MongoDB
02:53
-
Lecture 7.4 JSON File Format For Storing Documents
02:53
Selecting the Right Database
-
Lecture 8.1 Selection of right databases, RDBMS
02:53
-
Lecture 8.2 Data Size, Type of Data, Frequency of Accessing Data
02:53
-
Lecture 8.3 Business needs, Type of Application
02:53
Overview of Futureskills and Cyber Security
-
Lecture 9.1 Introduction to Internet of Things
02:53
-
Lecture 9.2 Big Data Analytics
02:53
-
Lecture 9.3 Cloud Computing
02:53
-
Lecture 9.4 Virtual Reality
02:53
-
Lecture 9.5 Artificial Intelligence
02:53
-
Lecture 9.6 Blockchain Technology
02:53
-
Lecture 9.7 3D Printing/ Additive Manufacturing
02:53
-
Lecture 9.8 Robotics Process Automation
02:53
-
Lecture 9.9 Cyber
Security
02:53
About Us
TECHINAUT
A LEVEL
100+ Courses
20+ Faculty
Industry Expert
45000+ students enrolled
UI/UX Designer, with 7+ Years Experience. Guarantee of High Quality Work.
Skills: Web Design, UI Design, UX/UI Design, Mobile Design, User Interface Design, Sketch, Photoshop, GUI, Html, Css, Grid Systems, Typography, Minimal, Template, English, Bootstrap, Responsive Web Design, Pixel Perfect, Graphic Design, Corporate, Creative, Flat, Luxury and much more.
Available for:
- 1. Full Time Office Work
- 2. Remote Work
- 3. Freelance
- 4. Contract
- 5. Worldwide
Reviews
Nicole Brown
UX/UI Designer
“ This is the second Photoshop course I have completed with Cristian. Worth every penny and recommend it highly. To get the most out of this course, its best to to take the Beginner to Advanced course first. The sound and video quality is of a good standard. Thank you Cristian. “
Reply
Includes
120 hours on-demand video- 69 downloadable resources
Full lifetime access
Access on mobile and TV
Assignments
Certificate of Completion
Includes
Enrolled: 100+ students
Duration: 120 hours
Chapters: 9
Video: 120 hours
Level: Beginner
Post A comment