Complete SQL and Databases Bootcamp

BY
Udemy

Learn how to use MySQL and PostgreSQL to master the strategies and methodologies involved in data management and database design.

Mode

Online

Fees

₹ 4099

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

The Complete SQL and Databases Bootcamp: Zero to Mastery [2022] certification course is created by Andrei Neagoie, the founder of zerotomastery.io, Mo Binni, a solution architect and instructor, and Zero To Mastery, a learning platform with courses for in-demand skills, and is offered through Udemy, which is intended for learners who want to study modern SQL and database principles to become web developers, ML engineers, or business analysts.

Complete SQL and Databases Bootcamp: Zero to Mastery [2022] online classes begin from the very beginning by teaching the learners SQL and database fundamentals and then progressing into advanced topics to help them make decisions and deal with any data in their organization. Complete SQL and Databases Bootcamp: Zero to Mastery [2022] syllabus aims to provide learners with a practical understanding to guide them about the techniques used to deal with databases and SQL, scale databases, manage them, and even additional material on handling big data, utilizing Redis for caching and connecting PostgreSQL to a Node.js server.

The highlights

  • Certificate of completion
  • Self-paced course
  • 24 hours of pre-recorded video content
  • 59 articles
  • 4 downloadable resources
  • 1 coding exercise

Program offerings

  • Online course
  • Learning resources
  • 30-day money-back guarantee
  • Unlimited access
  • Accessible on mobile devices and tv

Course and certificate fees

Fees information
₹ 4,099
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

Database management Sql knowledge Knowledge of mongodb Machine learning Data science knowledge Knowledge of big data

After completing the Complete SQL and Databases Bootcamp: Zero to Mastery [2022] online certification, learners will gain a better understanding of the advanced concepts associated with SQL and databases. Learners will explore the functionalities of various database management systems like MySQL, PostgreSQL, MongoDB, and NoSQL as well as will learn about various SQL tools like SQL JOINS, SQL queries, and Redis. Learners will study methodologies involved with database management and database design, data efficiency, database sharding, and database replication. Learners will also study how to use SQL for big data operations, data science, and machine learning to make business decisions and market decisions.

The syllabus

Introduction

  • Course Outline
  • Join Our Online Classroom!
  • Exercise: Meet The Community
  • The Big Data Breach At Keiko Corp
  • Monthly Coding Challenges, Free Resources and Guides

History And Story Of Data

  • What Is a Database?
  • I Didn't Learn Anything, Try Again...
  • Database Management System (DBMS)
  • Exercise: Building Amazon
  • Exercise: Building Amazon 2
  • 5 Types Of Databases
  • Exercise: What Is A Database?
  • Section Review

Databases + SQL Fundamentals

  • SQL Playground
  • What Is SQL?
  • What Is A Query?
  • Exercise: Setting Up Your First Database
  • Imperative vs Declarative
  • History of SQL
  • Optional: History of SQL Deep Dive
  • Exercises: The Select Statement
  • SQL Standards
  • What Is A Database? Revisited
  • Database Oriented Approach
  • Exercise: SQL Starter Quiz
  • Database Models
  • Hierarchical And Networking Model
  • Relational Model
  • DBMS Revisited
  • Relational Model Revisited
  • Tables
  • Columns
  • Rows
  • Primary And Foreign Keys
  • OLTP vs OLAP
  • Exercise: OLTP vs OLAP
  • Exercise: Relational Model Quiz
  • Endorsements On LinkedIn

Environment Setup

  • Why PostgreSQL
  • Environment Tooling
  • Having Trouble Registering A Serial Key For ValentinaDB?
  • SQL Tooling Alternatives
  • Command Line 101
  • Getting Help With The Setup
  • Windows Setup
  • Optional: Setting Up Windows For Command Line
  • MAC Setup
  • MAC Commandline tools
  • LINUX Setup
  • Importing The Databases

SQL Deep Dive

  • Query Along
  • Starting With Query
  • Exercise: Simple Queries
  • Renaming Columns
  • Concat Function
  • What Is A Function In SQL?
  • Aggregate Functions
  • Exercise: Aggregate Functions
  • Commenting Your Queries
  • Common SELECT Mistakes
  • Filtering Data
  • AND and OR
  • Exercise: Filtering Data
  • The NOT Keyword
  • Exercise: The Where Clause
  • Comparison Operators
  • Exercise: Comparison Operators
  • Logical Operators
  • Operator Precedence
  • Operator Precedence 2
  • Operator Precedence Extra
  • Exercise: Operator Precedence
  • Checking For NULL Values
  • IS Keyword
  • NULL Coalescing
  • Exercise: Null Value Coalescing
  • 3 Valued Logic
  • Exercise: 3 Valued Logic
  • Between + And
  • Exercise: Between + And
  • IN Keyword
  • Exercise: IN Keyword
  • LIKE
  • Exercise: Like Keyword
  • Dates And Timezones
  • Setting Up Timezones
  • How Do We Format Date And Time?
  • Timestamps
  • Date Functions
  • Date Difference And Casting
  • Age Calculation
  • Extracting Information
  • Intervals
  • Exercise: Date and Timestamp
  • DISTINCT
  • Exercise: Distinct Keyword
  • Sorting Data
  • Exercise Sorting Data
  • Multi Table SELECT
  • Inner Join
  • Self Join
  • Outer Join
  • Less Common Joins
  • Inner-Join Exercises
  • USING Keyword

Advanced SQL

  • GROUP BY
  • Group By Exercises
  • HAVING Keyword
  • Having Exercises
  • Ordering Grouped Data
  • Group By Mental Model
  • Grouping Sets
  • Rollup
  • Window What?
  • Looking Through The Window
  • PARTITION BY
  • Order By Acting Strange
  • Using Framing In Window Function
  • Solving For Current Salary
  • FIRST_VALUE
  • LAST_VALUE
  • SUM
  • ROW_NUMBER
  • Window Function Exercises
  • Conditional Statements
  • Conditional Statement Exercise
  • NULLIF
  • NULLIF Exercise
  • Views...What Are They Good For?
  • View Syntax
  • Using Views
  • Views Exercises
  • Indexes
  • Index Types
  • Index Algorithms
  • Quick Note On Index Algorithms
  • What Are Subqueries?
  • Subqueries vs Joins
  • Subquery Guidelines As Types
  • Using Subqueries
  • Quick Note: Titles For Employees
  • Getting The Latest Salaries
  • Subquery Operators
  • Subquery Exercises

Database Management

  • Before We Get Started
  • Time To Create Some Stuff!
  • Types Of Databases In A RDBMS
  • Default PostgreSQL Database
  • Template Databases
  • Creating A Database
  • Database Organization
  • Roles In Postgres
  • Role Attributes And Creation
  • Creating Users And Configuring Login
  • Privileges
  • Granting Privileges and Role Management
  • Best Practices For Role Management
  • Data Types & Boolean Type
  • Storing Text
  • Storing Numbers
  • Storing Arrays
  • Data Models And Naming Conventions
  • Create Table
  • Extra information on Create Table
  • Column Constraints
  • Table Constraints
  • Regexes!
  • UUID Explained
  • Custom Data Types And Domains
  • Creating The Tables For ZTM
  • Extra information on ALTER TABLE
  • Adding Students And Teachers
  • Creating A Course
  • Adding Feedback To A Course
  • A Tale Of 2 Feedbacks
  • SQL Exercises
  • SQL Quiz
  • Backups And Why They Are Important
  • Backing Up In Postgres
  • Restoring A Database
  • Transactions

Solving The Mystery

  • Clue #1 and #2
  • Getting ready to solve the Mystery!
  • Clue #3
  • Exercise: Solving The First Clues
  • Solution: Solving The First Clues
  • Clue #4
  • Exercise: Clue #4
  • Solution: Clue #4
  • Clue #5 and #6
  • Exercise: Clue #5 and #6
  • Solution: Clue #5 and #6
  • Solving The Mystery

Database Design

  • System Design And SDLC
  • SDLC Phases
  • System Design Deep Dive
  • Top-Down vs Bottom-Up
  • DRIVEME Academy
  • Top Down Design
  • ER Model
  • Step 1: Determining Entities
  • Tooling For Diagramming
  • DRIVEME Academy Entities
  • Step 2: Attributes
  • Relational Model Extended
  • Relational Schema And Instance
  • Super Key and Candidate Key
  • Primary Key and Foreign Key
  • Compound Composite And Surrogate Key
  • DRIVEME Attributes
  • Step 3: Relationships
  • DRIVEME Relationships
  • Step 4: Solving Many To Many
  • Step 5: Subject Areas
  • DRIVEME Subject Areas
  • Exercise: Painting Reservations
  • Exercise: Movie Theatre
  • Bottom Up Design
  • Anomalies
  • Normalization
  • Functional Dependencies
  • Functional Dependencies 2
  • The Normal Forms
  • Going from 0NF to 1NF
  • Going from 1NF to 2NF
  • Going from 2NF to 3NF
  • Boyce-Codd Normal Form
  • Why 4NF And 5NF Are Not Useful
  • Exercise: Database Design Quiz

Database Landscape, Performance and Security

  • Bruno's Request
  • Scalability
  • Sharding
  • Replication
  • Backups
  • Distributed vs Centralized Databases
  • Database Security
  • Exercise: SQL Injection
  • Optional: All About Injections Attacks
  • Optional: Storing Passwords
  • Optional: How To Store Passwords
  • Relational vs NoSQL, PostgreSQL vs MongoDB Databases
  • Future Of Relational Databases
  • Elasticsearch
  • S3 Object Storage
  • Top Databases To Use

Where To Go From Here?

  • Thank You
  • LinkedIn Endorsements
  • Become An Alumni
  • Learning Guideline
  • Coding Challenges
  • Course Review
  • The Final Challenge

Extras: Data Engineering (And the role of Machine Learning)

  • Big Data + Analytics
  • Quick Note: Upcoming Videos
  • Reviewing How We Got Here
  • Data Engineering Introduction
  • What Is Data?
  • What Is A Data Engineer?
  • What Is A Data Engineer 2?
  • What Is A Data Engineer 3?
  • What Is A Data Engineer 4?
  • Types Of Databases
  • Hadoop, HDFS and MapReduce
  • Apache Spark and Apache Flink
  • Kafka and Stream Processing

Extras: Redis

  • Quick Note: Upcoming Videos
  • What Is Caching?
  • Introducing Redis
  • Installing Redis
  • Redis Commands
  • Redis Data Types
  • Redis Hashes
  • Redis Lists
  • Redis Sets and Sorted Sets
  • Section Summary

Extra Bits: Databases In A Web App (with Node.js)

  • Quick Note: Upcoming Videos
  • Setting Up Your Database
  • Connecting To The Database
  • Registering A User Part 1

Bonus Section

  • Bonus Lecture

Instructors

Mr Andrei Neagoie

Mr Andrei Neagoie
Senior Software Developer
Freelancer

Mr Mo Binni

Mr Mo Binni
Solution Architect
Udemy

Articles

Popular Articles

Latest Articles

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books