Companies Home Search Profile

Complete SQL and Databases Bootcamp

Focused View

Andrei Neagoie,Mo Binni

23:55:29

30 View
  • 1 - Course Outline.mp4
    07:51
  • 2 - Join Our Online Classroom.mp4
    04:01
  • 3 - Exercise Meet Your Classmates and Instructor.html
  • 4 - The Big Data Breach At Keiko Corp.mp4
    02:23
  • 5 - Monthly Coding Challenges Free Resources and Guides.html
  • 6 - What Is a Database.mp4
    05:57
  • 7 - Drum Memory.txt
  • 7 - I Didnt Learn Anything Try Again.mp4
    06:35
  • 8 - Database Management System DBMS.mp4
    07:44
  • 9 - Exercise Building Amazon.mp4
    05:34
  • 9 - SQL Playground.txt
  • 10 - Exercise Building Amazon 2.mp4
    05:28
  • 11 - 5 Types Of Databases.mp4
    05:37
  • 11 - Database Types Deep Dive.txt
  • 12 - Exercise What Is A Database.mp4
    01:11
  • 13 - Section Review.mp4
    01:29
  • 14 - SQL Playground.mp4
    01:54
  • 15 - What Is SQL.mp4
    02:17
  • 16 - Try This Fiddle.txt
  • 16 - What Is A Query.mp4
    06:27
  • 17 - Exercise Setting Up Your First Database.html
  • 18 - Imperative vs Declarative.mp4
    03:24
  • 19 - History of SQL.mp4
    02:21
  • 20 - Optional History of SQL Deep Dive.html
  • 21 - Exercises The Select Statement.html
  • 22 - SQL Standards.mp4
    04:25
  • 23 - What Is A Database Revisited.mp4
    05:36
  • 24 - Database Oriented Approach.mp4
    06:51
  • 25 - Exercise SQL Starter Quiz.html
  • 26 - Database Models.mp4
    01:21
  • 27 - Hierarchical And Networking Model.mp4
    08:03
  • 28 - Relational Model.mp4
    07:17
  • 29 - 12 Rules of Codd.txt
  • 29 - DBMS Revisited.mp4
    13:56
  • 30 - Relational Model Revisited.mp4
    01:07
  • 31 - Tables.mp4
    03:45
  • 32 - Columns.mp4
    04:07
  • 33 - Rows.mp4
    02:27
  • 34 - Primary And Foreign Keys.mp4
    05:03
  • 35 - OLTP vs OLAP.mp4
    03:16
  • 36 - Exercise OLTP vs OLAP.mp4
    03:21
  • 37 - Exercise Relational Model Quiz.html
  • 38 - Endorsements On LinkedIN.html
  • 39 - Why PostgreSQL.mp4
    01:52
  • 39 - Why Postgres is the worlds best database.txt
  • 40 - Environment Tooling.mp4
    03:10
  • 40 - Valentina Studio.txt
  • 41 - Having Trouble Registering A Serial Key For ValentinaDB.html
  • 42 - SQL Tooling Alternatives.html
  • 43 - Commandline 101 Linux.txt
  • 43 - Commandline 101 Windows.txt
  • 43 - Commandline 101 mac.txt
  • 43 - Command Line 101.mp4
    05:21
  • 44 - Getting Help With The Setup.html
  • 45 - Enterprise DB installer.txt
  • 45 - WINDOWS Setup.mp4
    04:53
  • 45 - What is the bonjour service.txt
  • 46 - Optional Setting Up Windows For Command Line.mp4
    04:27
  • 47 - MAC Setup.mp4
    06:30
  • 47 - Postgres App.txt
  • 48 - MAC Commandline tools.html
  • 49 - LINUX Setup.mp4
    05:36
  • 49 - Postgres Linux installation.txt
  • 49 - What are virtual machines.txt
  • 50 - Data.zip
  • 50 - Importing The Databases.mp4
    06:03
  • 51 - Exercise Imposter Syndrome.mp4
    02:56
  • 52 - Query Along.html
  • 53 - Starting With Query.mp4
    05:15
  • 54 - Exercise Simple Queries.mp4
    10:10
  • 55 - Changing Column Names in a SELECT Query.mp4
    03:19
  • 56 - Concat Function.mp4
    04:51
  • 57 - What Is A Function In SQL.mp4
    06:46
  • 58 - Aggregate Functions.mp4
    05:19
  • 58 - Aggregate Functions.txt
  • 59 - Exercise Aggregate Functions.html
  • 60 - Commenting Your Queries.mp4
    09:32
  • 60 - Make comments the most important code you write.txt
  • 61 - Common SELECT Mistakes.mp4
    08:28
  • 62 - Filtering Data.mp4
    05:44
  • 63 - AND and OR.mp4
    14:15
  • 64 - Exercise Filtering Data.mp4
    07:56
  • 65 - The NOT Keyword.mp4
    07:19
  • 66 - Exercise The Where Clause.html
  • 67 - Comparison Operators.mp4
    06:02
  • 67 - Comparison Operators.txt
  • 68 - Exercise Comparison Operators.html
  • 69 - Logical Operators.mp4
    07:32
  • 70 - Expression Evaluation Rules.txt
  • 70 - Operator Precedence.mp4
    09:38
  • 70 - Operator Precedence.txt
  • 71 - Operator Precedence 2.mp4
    11:31
  • 72 - Operator Precedence Extra.html
  • 73 - Exercise Operator Precedence.html
  • 74 - Checking For NULL Values.mp4
    12:01
  • 75 - IS Keyword.mp4
    13:42
  • 76 - NULL Coalescing.mp4
    07:12
  • 77 - Exercise Null Value Coalescing.html
  • 78 - 3 Valued Logic.mp4
    12:24
  • 79 - Exercise 3 Valued Logic.html
  • 80 - BETWEEN AND.mp4
    02:06
  • 81 - Exercise BETWEEN AND.html
  • 82 - IN Keyword.mp4
    03:24
  • 83 - Exercise IN Keyword.html
  • 84 - LIKE.mp4
    13:18
  • 85 - Exercise Like Keyword.html
  • 86 - Dates And Timezones.mp4
    12:53
  • 86 - UTC is enough right.txt
  • 87 - Setting Up Timezones.mp4
    03:37
  • 88 - How Do We Format Date And Time.mp4
    06:15
  • 89 - Timestamps.mp4
    10:27
  • 90 - Date Functions.mp4
    04:52
  • 91 - Date Difference And Casting.mp4
    01:47
  • 92 - Age Calculation.mp4
    02:09
  • 93 - Extracting Information.mp4
    02:51
  • 94 - Intervals.mp4
    03:13
  • 95 - Exercise Date and Timestamp.html
  • 96 - DISTINCT.mp4
    04:11
  • 97 - Exercise Distinct Keyword.html
  • 98 - Sorting Data.mp4
    06:17
  • 99 - Exercise Sorting Data.html
  • 100 - Multi Table SELECT.mp4
    10:47
  • 101 - Inner Join.mp4
    19:42
  • 102 - Self Join.mp4
    04:54
  • 103 - Outer Join.mp4
    11:30
  • 104 - DBFiddle.txt
  • 104 - Less Common Joins.mp4
    06:36
  • 105 - InnerJoin Exercises.html
  • 106 - USING Keyword.mp4
    04:29
  • 107 - GROUP BY.mp4
    14:43
  • 108 - Group By Exercises.html
  • 109 - HAVING Keyword.mp4
    07:38
  • 110 - Having Exercises.html
  • 111 - Ordering Grouped Data.mp4
    01:44
  • 112 - Group By Mental Model.mp4
    12:10
  • 113 - Grouping Sets.mp4
    09:29
  • 113 - exercises.txt
  • 113 - solution.txt
  • 114 - Complex Groupings.txt
  • 114 - Rollup.mp4
    07:17
  • 115 - Window What.mp4
    03:30
  • 116 - Looking Through The Window.mp4
    08:52
  • 116 - Window function.txt
  • 117 - PARTITION BY.mp4
    05:50
  • 118 - Order By Acting Strange.mp4
    05:35
  • 119 - Using Framing In Window Function.mp4
    14:12
  • 120 - Solving For Current Salary.mp4
    10:49
  • 121 - FIRSTVALUE.mp4
    05:48
  • 122 - LASTVALUE.mp4
    04:03
  • 123 - SUM.mp4
    05:32
  • 124 - ROWNUMBER.mp4
    03:03
  • 125 - Window Function Exercises.html
  • 126 - Conditional Statements.mp4
    06:14
  • 127 - Conditional Statement Exercise.html
  • 128 - NULLIF.mp4
    02:26
  • 129 - NULLIF Exercise.html
  • 130 - ViewsWhat Are They Good For.mp4
    03:41
  • 131 - View Syntax.mp4
    05:36
  • 132 - Using Views.mp4
    12:24
  • 133 - Views Exercises.html
  • 134 - Indexes.mp4
    11:09
  • 134 - Poor indexing a performance killer.txt
  • 135 - Index Types.mp4
    10:28
  • 135 - Index Types.txt
  • 136 - Index Algorithms.mp4
    10:28
  • 137 - Quick Note On Index Algorithms.html
  • 138 - What Are Subqueries.mp4
    08:18
  • 139 - Subqueries vs Joins.mp4
    08:47
  • 140 - Subquery Guidelines As Types.mp4
    11:17
  • 141 - Using Subqueries.mp4
    11:26
  • 142 - Quick Note Titles For Employees.html
  • 143 - Getting The Latest Salaries.mp4
    14:19
  • 144 - Subquery Operators.mp4
    09:00
  • 145 - Subquery Exercises.html
  • 146 - Before We Get Started.html
  • 147 - Time To Create Some Stuff.mp4
    09:56
  • 148 - Types Of Databases In A RDBMS.mp4
    04:18
  • 149 - Default PostgreSQL Database.mp4
    07:38
  • 150 - Template Databases.mp4
    06:41
  • 151 - Creating A Database.mp4
    04:41
  • 152 - Database Organization.mp4
    07:09
  • 153 - Roles In Postgres.mp4
    03:45
  • 154 - Role Attributes And Creation.mp4
    04:52
  • 155 - Creating Users And Configuring Login.mp4
    13:44
  • 156 - Privileges.mp4
    03:51
  • 157 - Granting Privileges and Role Management.mp4
    06:23
  • 158 - Best Practices For Role Management.mp4
    04:22
  • 159 - Data Types & Boolean Type.mp4
    07:36
  • 160 - Storing Text.mp4
    05:19
  • 161 - Storing Numbers.mp4
    07:16
  • 162 - Storing Arrays.mp4
    04:20
  • 163 - Data Models And Naming Conventions.mp4
    10:54
  • 164 - CREATE TABLE.mp4
    08:56
  • 165 - Create Table documentation.txt
  • 165 - Extra information on CREATE TABLE.html
  • 166 - Column Constraints.mp4
    05:49
  • 166 - The importance of constraints.txt
  • 167 - Table Constraints.mp4
    11:42
  • 168 - Regexes.html
  • 169 - UUID Explained.mp4
    05:47
  • 170 - Custom Data Types And Domains.mp4
    06:07
  • 171 - Creating The Tables For ZTM.mp4
    11:52
  • 172 - Alter Table documentation.txt
  • 172 - Extra information on ALTER TABLE.html
  • 173 - Adding Students And Teachers.mp4
    08:07
  • 173 - Postgres INSERT syntax.txt
  • 174 - Creating A Course.mp4
    12:31
  • 175 - Adding Feedback To A Course.mp4
    06:49
  • 176 - A Tale Of 2 Feedbacks.mp4
    09:03
  • 177 - SQL Exercises.html
  • 178 - SQL Quiz.html
  • 178 - SQL quiz.txt
  • 179 - Backups And Why They Are Important.mp4
    23:19
  • 180 - Backing Up In Postgres.mp4
    07:42
  • 180 - Postgres backup and restore.txt
  • 180 - pgBackRest.txt
  • 181 - Restoring A Database.mp4
    06:15
  • 182 - Transactions.mp4
    18:15
  • 183 - Clue 1 and 2.mp4
    01:45
  • 184 - Getting ready to solve the Mystery.html
  • 184 - data.zip
  • 184 - movremployees.zip
  • 184 - schema.zip
  • 185 - Clue 3.mp4
    00:47
  • 186 - Exercise Solving The First Clues.html
  • 187 - Solution Solving The First Clues.mp4
    05:25
  • 188 - Clue 4.mp4
    00:27
  • 189 - Exercise Clue 4.html
  • 190 - Solution Clue 4.mp4
    01:02
  • 191 - Clue 5 and 6.mp4
    01:13
  • 192 - Exercise Clue 5 and 6.html
  • 193 - Solution Clue 5 and 6.mp4
    05:46
  • 194 - Solving The Mystery.mp4
    02:52
  • 195 - System Design And SDLC.mp4
    09:49
  • 196 - SDLC Phases.mp4
    06:00
  • 197 - System Design Deep Dive.mp4
    05:57
  • 198 - Top.mp4
    06:28
  • 199 - DRIVEME Academy.mp4
    06:41
  • 200 - Top Down Design.mp4
    04:41
  • 201 - ER Model.mp4
    05:10
  • 202 - Step 1 Determining Entities.mp4
    03:34
  • 203 - Tooling For Diagramming.mp4
    03:28
  • 204 - DRIVEME Academy Entities.mp4
    13:54
  • 205 - Step 2 Attributes.mp4
    03:04
  • 206 - Relational Model Extended.mp4
    01:09
  • 207 - Relational Schema And Instance.mp4
    02:37
  • 208 - Super Key and Candidate Key.mp4
    06:22
  • 209 - Primary Key and Foreign Key.mp4
    07:33
  • 210 - Compound Composite And Surrogate Key.mp4
    04:07
  • 211 - DRIVEME Attributes.mp4
    11:56
  • 212 - Step 3 Relationships.mp4
    12:05
  • 213 - DRIVEME Relationships.mp4
    12:29
  • 214 - Step 4 Solving Many To Many.mp4
    09:27
  • 215 - Step 5 Subject Areas.mp4
    02:44
  • 216 - DRIVEME Subject Areas.mp4
    02:55
  • 217 - Exercise Painting Reservations.mp4
    09:17
  • 218 - Exercise Movie Theatre.mp4
    05:06
  • 219 - Bottom Up Design.mp4
    05:17
  • 220 - Anomalies.mp4
    10:29
  • 221 - Normalization.mp4
    07:14
  • 222 - Functional Dependencies.mp4
    06:35
  • 223 - Functional Dependencies 2.mp4
    06:11
  • 224 - Simple guide to normalization.txt
  • 224 - The Normal Forms.mp4
    04:32
  • 224 - Useful summary of normalization.txt
  • 225 - Going from 0NF to 1NF.mp4
    08:09
  • 226 - Going from 1NF to 2NF.mp4
    05:47
  • 227 - Going from 2NF to 3NF.mp4
    08:30
  • 228 - Boyce.mp4
    09:01
  • 229 - 4th normal form.txt
  • 229 - 5th normal form.txt
  • 229 - Why 4NF And 5NF Are Not Useful.mp4
    05:57
  • 230 - Exercise Database Design Quiz.html
  • 231 - Brunos Request.mp4
    01:36
  • 232 - Scalability.mp4
    04:19
  • 233 - Sharding.mp4
    03:04
  • 234 - Replication.mp4
    04:56
  • 235 - Backups.mp4
    02:15
  • 236 - Distributed vs Centralized Databases.mp4
    03:41
  • 237 - Database Security.mp4
    04:02
  • 238 - Exercise SQL Injection.html
  • 239 - Optional All About Injections Attacks.mp4
    19:42
  • 240 - Optional Storing Passwords.mp4
    10:54
  • 241 - Optional How To Store Passwords.html
  • 242 - Relational vs NoSQL PostgreSQL vs MongoDB Databases.mp4
    10:35
  • 243 - Future Of Relational Databases.mp4
    01:47
  • 244 - Elasticsearch.mp4
    03:48
  • 245 - S3 Object Storage.mp4
    01:48
  • 246 - Top Databases To Use.mp4
    04:42
  • 1 - Course Review.html
  • 1 - The Final Challenge.html
  • 247 - Thank You.mp4
    01:14
  • 248 - LinkedIn Endorsements.html
  • 249 - Become An Alumni.html
  • 250 - Learning Guideline.html
  • 251 - Coding Challenges.html
  • 252 - Big Data Analytics.mp4
    02:31
  • 253 - Quick Note Upcoming Videos.html
  • 254 - Reviewing How We Got Here.mp4
    06:03
  • 255 - Data Engineering Introduction.mp4
    03:24
  • 256 - What Is Data.mp4
    06:42
  • 257 - What Is A Data Engineer.mp4
    04:20
  • 258 - What Is A Data Engineer 2.mp4
    05:35
  • 259 - What Is A Data Engineer 3.mp4
    05:03
  • 260 - What Is A Data Engineer 4.mp4
    03:22
  • 261 - Types Of Databases.mp4
    06:50
  • 262 - Hadoop HDFS and MapReduce.mp4
    04:22
  • 263 - Apache Spark and Apache Flink.mp4
    02:07
  • 264 - Kafka and Stream Processing.mp4
    04:33
  • 265 - Quick Note Upcoming Videos.html
  • 266 - What Is Caching.mp4
    06:58
  • 267 - Introducing Redis.mp4
    06:31
  • 268 - Installing Redis.mp4
    04:47
  • 269 - Redis Commands.mp4
    05:57
  • 270 - Redis Data Types.mp4
    01:59
  • 271 - Redis Hashes.mp4
    02:00
  • 272 - Redis Lists.mp4
    03:55
  • 273 - Redis Sets and Sorted Sets.mp4
    06:11
  • 274 - Section Summary.mp4
    03:00
  • 275 - Quick Note Upcoming Videos.html
  • 276 - Setting Up Your Database.mp4
    08:51
  • 277 - Connecting To The Database.mp4
    07:06
  • 278 - Registering A User Part 1.mp4
    04:50
  • 279 - Bonus Lecture.html
  • Description


    Master SQL, Database Management & Design and learn to work with databases like PostgreSQL, MySQL + more. With Exercises!

    What You'll Learn?


    • Become an expert in SQL and Database Concepts
    • Understand SQL vs NoSQL, MongoDB vs MySQL vs PostgreSQL
    • Add SQL, PostgreSQL, MySQL, Redis, Database Management/Design to your resume
    • Learn to perform efficient and performant SQL queries using best practices
    • Learn how Machine Learning, Data Science and Data Engineers use Big Data and databases
    • Apply for SQL developer, Database Administrator, Business Analyst, Backend Developer and Business Intelligence roles
    • Use the right SQL features to work with data efficiently and solve database problems
    • Database best practices to design and manage your company data
    • Learn to make business and market decisions based on user data
    • Learn how to scale databases by using things like Sharding, Replication, etc...
    • Create your own databases while using SQL to interact with the data
    • Use real-world data to generate insights and reports using SQL
    • Tons of exercises to practice what you learn and test your knowledge
    • Help Sales/Marketing/Product managers make better decisions based on data analysis
    • Advanced SQL topics like indexes, aggregates, caching to make your database queries efficient
    • Learn how databases are used in Web & Mobile Applications, Machine Learning and other fields
    • Learn how to handle user passwords and keep data safe
    • Work with SQL across multiple tables and multiple databases
    • Learn to use Redis for fast memory storage
    • Master SQL joins

    Who is this for?


  • Both beginner and advanced professionals looking to learn modern SQL and Database principles
  • Professionals who are working with or will be working with databases and want to learn to work smart and efficiently using best practices
  • Everyone who is interested in one of the most in demand tech skill that will be around for many years to come: SQL
  • Developers, Data Scientists, Machine Learning Engineers, Business Analysts, Product Managers, Sales/Marketers, and anyone who uses data to make business decisions
  • Anyone interested in learning more about SQL, PostgreSQL, or basic data analysis to boost your resume
  • What You Need to Know?


  • No prior tech experience is required. We will start from absolute zero!
  • You can use ANY operating system with this course: Windows, macOS, Linux. All users are all welcome!
  • Get ready to do tons of exercises and learn to love Databases and SQL!
  • More details


    Description

    Just launched with all modern SQL and Databases (PostgreSQL, MySQL, + more) features! Join a live online community of over 900,000+ students and a course taught by industry experts that have actually worked both in Silicon Valley and Toronto managing databases. This is one of the most in demand tech skills in the world right now with SQL being used for many years to come (it has been around since the 1970s and going stronger than ever)!

    Using the latest best practices in SQL, Database Management and Database Design, this course is focused on efficiency. Never spend time on confusing, out of date, incomplete tutorials anymore. Graduates of Andrei’s courses are now working at Google, Tesla, Amazon, Apple, IBM, JP Morgan, Meta, + other top tech companies.


    We guarantee you this is the most comprehensive online resource on Databases like PostgreSQL and MySQL. This project and exercise based course will introduce you to all of the modern toolchain of an SQL developer or anyone using a database in the workplace (Product Manager, Business Analyst/Intelligence, Data Analyst, Data Scientists, Machine Learning Engineer, Web Developer, Mobile Developer + any role requiring insights from data). Along the way, we will learn practical and real world skills that will get you hired.


    The curriculum is going to be very hands on as we walk you from start to finish of working with databases and SQL, all the way into learning how to scale databases, how to manage them, and even bonus material on working with Big Data, Caching using Redis, and connecting PostgreSQL to a Node.js server. We even talk about pros and cons of choosing an SQL Database vs NoSQL like MongoDB. We will start from the very beginning by teaching you SQL and Database Fundamentals and then going into advanced topics so you can make good decisions and work with any data that your company has no matter how complex!

    The topics covered are:

    - NoSQL (MongoDB) vs PostgreSQL, MySQL vs NewSQL

    - SQL Theory And Concepts

    - The Relational Model

    - SQL Basics

    - SQL Functions

    - Data Modification Language / DML

    - Data Query Language / DQL

    - Subqueries

    - Indexes

    - SQL Filtering / WHERE Statement

    - 3 Valued Logic

    - SQL JOINS

    - Window Functions

    - Date Filtering and Timestamps

    - SQL Aggregate Functions

    - SQL Operator Precedense

    - SQL ORDER BY

    - SQL GROUP BY

    - SQL Top Down Design

    - SQL Bottom Up Design

    - SQL Entity Relationship Diagram

    - SQL Normalization

    - Database Types

    - The role of a DBMS

    - Multi Table SELECT

    - The Software Development Lifecycle / SDLC

    - POSTGRES Role Management

    - POSTGRES Permission Management

    - POSTGRES Backup Strategies

    - POSTGRES Transaction Management/ SQL Transactions

    - POSTGRES/SQL Data Types

    - SQL Views

    - Redis Database

    - Elasticsearch

    - Connecting A Database To A Server/Web App (Node.js)

    - Data Engineering (Kafka, Hadoop, etc...)

    - Sharding

    - Replication

    - Backups

    - Vertical + Horizontal Scaling

    - Distributed vs Centralized Databases

    - Big Data + Analytics

    - Database Security (SQL Injections, Access Control, etc...)

    + more


    With SQL you will be able to work with all databases like: PostgreSQL, MySQL, Oracle SQL, Microsoft SQL Server, IBM DB2, SQLite, MariaDB, Amazon Redshift, Presto, Apache Hive with Hadoop, and many many more because SQL is everywhere!


    You see, data is everywhere and it is the most valuable asset in the world. All the top companies need people that can work with data. That is where this course comes in. Unlike most tutorials out there, this course encompasses many fields working with many databases. Whether you want to get into the tech industry, you’re a mobile or web developer, a data scientist, a machine learning engineer, a business analyst, even sales and marketing or you have your own company. Any role that requires you to work with data will need to know this valuable skill that is SQL (how to interact with databases, analyze, and use data).


    Here is the thing though. There are many courses on this topic.


    Let me tell you 3 reasons why this course is different from any other SQL/PostgreSQL/MySQL/Database tutorial online:


    1. In this course you will learn to work with not just 1 but many Databases like MySQL, PostgreSQL, Microsoft Server, Redis, and so much more. No prior programming or technical experience is necessary. We take you from absolute zero, all the way to mastery. We will go above and beyond to not just teach you SQL commands but to teach you advanced techniques, best practices, database design and how to think about performance, security, and scalability.


    2. This course is taught by actual professionals who have experience and have worked with databases for some of the largest companies in the world. Mo is a super star when it comes SQL. He has built software for the European Union, launched products for 5 Fortune 500 companies, and has consulted at Google. Andrei has worked on enterprise level apps for large tech firms in Silicon Valley as well as Toronto and has also taught others tech skills that got them into big companies like Google. By having both Andrei and Mo teach, you get to see different perspective and learn from 2 engineers as if you are working at a company together.


    3. We are going to have fun here. The course starts off with you getting hired at Keiko Corp to investigate their recent Database breach. Because we believe in learning by doing, you will be doing tons of real life assignments and exercises along the way, and eventually get to the point where you can help Keiko Corp solve their mystery by looking at their databases and analyzing hidden information. Our goals is that everyone has fun and is successful after completing the course :)


    This course is not about making you just watch along without understanding the principles so that when you are done with the course you don’t know what to do other than watch another tutorial. No! This course will push you and challenge you to go from an absolute beginner in SQL and Databases to someone that is in the top 10% of SQL and Database experts!


    Taught By:

    Andrei is the instructor of the highest rated Development courses on Udemy as well as one of the fastest growing. His graduates have moved on to work for some of the biggest tech companies around the world like Apple, Google, Tesla, Amazon, JP Morgan, IBM, UNIQLO etc... He has been working as a senior software developer in Silicon Valley and Toronto for many years, and is now taking all that he has learned, to teach programming skills and to help you discover the amazing career opportunities that being a developer allows in life.

    Having been a self taught programmer, he understands that there is an overwhelming number of online courses, tutorials and books that are overly verbose and inadequate at teaching proper skills. Most people feel paralyzed and don't know where to start when learning a complex subject matter, or even worse, most people don't have $20,000 to spend on a coding bootcamp. Programming skills should be affordable and open to all. An education material should teach real life skills that are current and they should not waste a student's valuable time. Having learned important lessons from working for Fortune 500 companies, tech startups, to even founding his own business, he is now dedicating 100% of his time to teaching others valuable software development skills in order to take control of their life and work in an exciting industry with infinite possibilities.

    Andrei promises you that there are no other courses out there as comprehensive and as well explained. He believes that in order to learn anything of value, you need to start with the foundation and develop the roots of the tree. Only from there will you be able to learn concepts and specific skills(leaves) that connect to the foundation. Learning becomes exponential when structured in this way.

    Taking his experience in educational psychology and coding, Andrei's courses will take you on an understanding of complex subjects that you never thought would be possible.


    Mo is a Solutions Architect with over 7 years of experience in Software Architecture and Development. Having worked as a consultant for the majority of his career, he has seen it all.

    He has worked on global applications for multi-nationals, governments and Fortune 500 companies.


    Throughout his career he has seen every type of developer and development practice, and the one thing that he believes more than anything is that software development is a pragmatic team sport. Go fast alone, go far together!

    My main goal with instructing is to teach the foundational knowledge to set you up for life-long learning. Software and development practices change often, but when you have the right foundation adapting to the constant change becomes easy!


    See you inside the courses!

    Who this course is for:

    • Both beginner and advanced professionals looking to learn modern SQL and Database principles
    • Professionals who are working with or will be working with databases and want to learn to work smart and efficiently using best practices
    • Everyone who is interested in one of the most in demand tech skill that will be around for many years to come: SQL
    • Developers, Data Scientists, Machine Learning Engineers, Business Analysts, Product Managers, Sales/Marketers, and anyone who uses data to make business decisions
    • Anyone interested in learning more about SQL, PostgreSQL, or basic data analysis to boost your resume

    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    Category
    Andrei Neagoie
    Andrei Neagoie
    Instructor's Courses
    Andrei is the instructor of some of the highest rated programming and technical courses online. He no longer teaches on Udemy. Instead, he is now the founder of ZTM Academy which is one of the fastest growing education platforms in the world. ZTM Academy is known for having some of the best instructors and success rates for students.
    Mo is a Solutions Architect with over 7 years of experience in Software Architecture and Development. Having worked as a consultant for the majority of his career, he has seen it all.He has worked on global applications for multi-nationals, governments and  Fortune 500 companies.Throughout his career he has seen every type of developer and development practice, and the one thing that he believes more than anything is that software development is a pragmatic team sport. Go fast alone, go far together!My main goal with instructing is to teach the foundational knowledge to set you up for life-long learning. Software and development practices change often, but when you have the right foundation adapting to the constant change becomes easy!
    Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
    • language english
    • Training sessions 222
    • duration 23:55:29
    • English subtitles has
    • Release Date 2024/03/22