Setup Menus in Admin Panel

Course Curriculum

SQL & Database Design A-Z - Course Details
0.0 SQL & Database Design A-Z – Course Details 00:00:00
1.1 Intro Video
1.1 Intro Video 00:00:00
2.1 Welcome to this section! This is what you will learn
2.1 Welcome to this section! This is what you will learn 00:00:00
2.2 Installation PostgreSQL & PGAdmin 4 for Windows
2.2 Installation PostgreSQL & PGAdmin 4 for Windows 00:00:00
2.3 Installation PostgreSQL & PGAdmin 4 for Mac
2.3 Installation PostgreSQL & PGAdmin 4 for Mac 00:00:00
2.4 Installation MS SQL Server & MS SQL Server Management Studio (SSMS) for Windows
2.4 Installation MS SQL Server & MS SQL Server Management Studio (SSMS) for Windows 00:00:00
3.1 Welcome to this section! This is what you will learn
3.2 Welcome to this section! This is what you will learn
3.2 Welcome to this section! This is what you will learn 00:00:00
3.3 Upload consumer complaints
3.3 Upload consumer complaints 00:00:00
3.4 Getting to know the PGAdmin
3.4 Getting to know the PGAdmin 00:00:00
3.5 Upload consumer complaints MS SQL
3.5 Upload consumer complaints MS SQL 00:00:00
3.6 Getting to know MS SQL Server
3.6 Getting to know MS SQL Server 00:00:00
4.1 Welcome to this section! This is what you will learn
4.1 Welcome to this section! This is what you will learn 00:00:00
4.2 Theory select Query
4.2 Theory select Query 00:00:00
4.3 Time to write your first Query in PostgreSQL
4.3 Time to write your first Query in PostgreSQL 00:00:00
4.4 Adding a filter using Where in PostgreSQL
4.4 Adding a filter using Where in PostgreSQL 00:00:00
4.5 Logical conditions AND, OR in PostgreSQL
4.5 Logical conditions AND, OR in PostgreSQL 00:00:00
4.6 Using wildcards % and _ (Advanced tutorial)
4.6 Using wildcards % and _ (Advanced tutorial) 00:00:00
4.7 Comments in SQL
4.7 Comments in SQL 00:00:00
4.8 Getting to write your first Query MS SQL
4.8 Getting to write your first Query MS SQL 00:00:00
4.9 Where MS SQL
4.9 Where MS SQL 00:00:00
4.10 Logical conditions, AND OR MS SQL
4.10 Logical conditions, AND OR MS SQL 00:00:00
4.11 Using wildcards MS SQL
4.11 Using wildcards MS SQL 00:00:00
4.12 Comments in SQL MS SQL
4.12 Comments in SQL MS SQL 00:00:00
5.1 Welcome to this section! This is what you will learn
5.1 Welcome to this section! This is what you will learn 00:00:00
5.2 The Challenge Analyzing console games sales
5.2 The Challenge Analyzing console games sales 00:00:00
5.3 Uploading console games dataset
5.3 Uploading console games dataset 00:00:00
5.4 Working with arithmetic data types
5.4 Working with arithmetic data types 00:00:00
5.5 Order by
5.5 Order by 00:00:00
5.6 Working with VARCHARS
5.6 Working with VARCHARS 00:00:00
5.7 Working with DATES
5.7 Working with DATES 00:00:00
5.8 Implicit data conversion in SQL
5.8 Implicit data conversion in SQL 00:00:00
5.9 Working with NULL
5.9 Working with NULL 00:00:00
5.10 Uploading console games dataset MS SQL
5.10 Uploading console games dataset MS SQL 00:00:00
5.11 Working with arithmetic data types MS SQL
5.11 Working with arithmetic data types MS SQL 00:00:00
5.12 Order by MS SQL
5.12 Order by MS SQL 00:00:00
5.13 Working with VARCHAR MS SQL
5.13 Working with VARCHAR MS SQL 00:00:00
5.14 Working with DATES MS SQL
5.14 Working with DATES MS SQL 00:00:00
5.15 Implicit data conversion MS SQL
5.15 Implicit data conversion MS SQL 00:00:00
6.1 Welcome to this section! This is what you will learn
6.1 Welcome to this section! This is what you will learn 00:00:00
6.2 Structured vs unstructured data
6.2 Structured vs unstructured data 00:00:00
6.3 Elements of a Database
6.3 Elements of a Database 00:00:00
6.4 Relational keys
6.4 Relational keys 00:00:00
6.5 Relational Database
6.5 Relational Database 00:00:00
6.6 Functional dependency
6.6 Functional dependency 00:00:00
7.1 Welcome to this section! This is what you will learn
7.1 Welcome to this section! This is what you will learn 00:00:00
7.2 Types of JOINS
7.2 Types of JOINS 00:00:00
7.3 Duplicates in JOINS
7.3 Duplicates in JOINS 00:00:00
7.4 Joining on multiple fields
7.4 Joining on multiple fields 00:00:00
7.5 The Challenge The vet's Clinic
7.5 The Challenge The vet’s Clinic 00:00:00
7.6 Upload the data
7.6 Upload the data 00:00:00
7.7 Your first LEFT OUTER JOIN
7.7 Your first LEFT OUTER JOIN 00:00:00
7.8 JOINS tips & tricks
7.8 JOINS tips & tricks 00:00:00
7.9 INNER JOIN
7.9 INNER JOIN 00:00:00
7.10 Full OUTER JOIN
7.10 Full OUTER JOIN 00:00:00
7.11 JOINING on multiple fields (Practice)
7.11 JOINING on multiple fields (Practice) 00:00:00
7.12 Complex JOINS
7.12 Complex JOINS 00:00:00
7.13 Cleaning up your JOIN
7.13 Cleaning up your JOIN 00:00:00
7.14 Cross JOIN (Advanced tutorial)
7.14 Cross JOIN (Advanced tutorial) 00:00:00
7.15 Upload the data – MS SQL
7.15 Upload the data – MS SQL 00:00:00
7.16 Your first LEFT OUTER JOIN – MS SQL
7.16 Your first LEFT OUTER JOIN – MS SQL 00:00:00
7.17 JOINS tips & tricks – MS SQL
7.17 JOINS tips & tricks – MS SQL 00:00:00
7.18 INNER JOIN – MS SQL
7.18 INNER JOIN – MS SQL 00:00:00
7.19 Full OUTER JOIN – MS SQL
7.19 Full OUTER JOIN – MS SQL 00:00:00
7.20 Joining on multiple fields (Practice) – MS SQL
7.20 Joining on multiple fields (Practice) – MS SQL 00:00:00
7.21 Complex JOINS – MS SQL
7.21 Complex JOINS – MS SQL 00:00:00
7.22 Cleaning up your JOIN – MS SQL
7.22 Cleaning up your JOIN – MS SQL 00:00:00
7.23 Cross JOIN (Advanced tutorial) – MS SQL
7.23 Cross JOIN (Advanced tutorial) – MS SQL 00:00:00
8.1 Welcome to this section! This is what you will learn
8.1 Welcome to this section! This is what you will learn 00:00:00
8.2 Create database
8.2 Create database 00:00:00
8.3 Create table
8.3 Create table 00:00:00
8.4 Insert data
8.4 Insert data 00:00:00
8.5 Alter table
8.5 Alter table 00:00:00
8.6 Drop table
8.6 Drop table 00:00:00
8.7 Create database MS SQL
8.7 Create database MS SQL 00:00:00
8.8 Create table MS SQL
8.8 Create table MS SQL 00:00:00
8.9 Insert data MS SQL
8.9 Insert data MS SQL 00:00:00
8.10 Alter table MS SQL
8.10 Alter table MS SQL 00:00:00
8.11 Drop table MS SQL
8.11 Drop table MS SQL 00:00:00
9.1 Welcome to this section! This is what you will learn
9.1 Welcome to this section! This is what you will learn 00:00:00
9.2 What is database normalization
9.2 What is database normalization 00:00:00
9.3 Prime and non-prime attributes
9.3 Prime and non-prime attributes 00:00:00
9.4 First Normal Form (1NF)
9.4 First Normal Form (1NF) 00:00:00
9.5 Second Normal Form (2NF)
9.5 Second Normal Form (2NF) 00:00:00
9.6 Third Normal Form (3NF)
9.6 Third Normal Form (3NF) 00:00:00
9.7 The Challenge Online clothing store (OLTP Database)
9.7 The Challenge Online clothing store (OLTP Database) 00:00:00
9.8 Upload the data
9.8 Upload the data 00:00:00
9.9 Normalization 1NF Investigation
9.9 Normalization 1NF Investigation 00:00:00
9.10 Normalization 1NF Investigation - MS SQL
9.10 Normalization 1NF Investigation – MS SQL 00:00:00
9.11 Normalization 2NF Investigation
9.11 Normalization 2NF Investigation 00:00:00
9.12 Normalization 2NF Modification - MS SQL
9.12 Normalization 2NF Modification – MS SQL 00:00:00
9.14 Normalization 3NF Modification
9.14 Normalization 3NF Modification 00:00:00
9.15 Normalization 3NF Investigation
9.15 Normalization 3NF Investigation 00:00:00
9.16 Normalization 3NF Investigation - MS SQL
9.16 Normalization 3NF Investigation – MS SQL 00:00:00
9.17 Normalization 3NF Modification - MS SQL
9.17 Normalization 3NF Modification – MS SQL 00:00:00
9.18 Upload the data - MS SQL
9.18 Upload the data – MS SQL 00:00:00
10.1 Module 10 - Bonus Lectures
10.1 Module 10 – Bonus Lectures 00:00:00
SQL & Database Design A-Z Course Details
SQL & Database Design A-Z Course Details 00:00:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

PRIVATE COURSE
  • PRIVATE
  • 1 week, 3 days
1 STUDENTS ENROLLED
Copyright @2019