- Course Outline
- Join Our Online Classroom!
- Exercise: Meet The Community
- The Big Data Breach At Keiko Corp
- Monthly Coding Challenges, Free Resources and Guides
Online
₹ 3,499
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
certificate availability
certificate providing authority
What you will learn
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
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
Senior Software Developer
Freelancer
Mr Mo Binni
Solution Architect
Udemy