English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 7 Hours | 6.31 GB
Learn MySQL, POSTGRES, SQLite, and Microsoft SQL Server The Fast and Easy Way!
In this course we’ll learn the MySQL Database, the POSTGRES Database, the SQLite Database, and the Microsoft SQL Server from an absolute Beginner level all the way to Advanced in no time at all!
This course is aimed at the absolute beginner, you don’t need any coding or database experience at all!
We’ll start out by downloading and installing each of these databases – all for free. This will give you all the tools you need to start writing and running code for your databases.
Then, we’ll dive into very basic database concepts. Things like:
- What Is A Database
- How To Install Each Database
- How To Install Git Bash Terminal
- How To Connect To Your Database
- How To Create A Database
After that, we’ll move into more intermediate topics like:
- How To Create A Table
- How To Insert One Record Into Table
- How To Insert Many Records Into Table
- Understanding Data Types
- How To Select Data From Table
- How To Format Our Results
- How To Use The Where Clause
- How To Use The Like Clause and Wildcards
- How To Use AND and OR
- How To Updating Records
- How To Limit and Order Results
- How To Delete Records
- How To Delete (Drop) A Table And Backups
Finally we’ll finish up with more advanced topics like:
- Foreign Keys
- Inner Joins
- Join Where Hacks
- And More…
We’ll learn all of those things for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server. We’ll start with MySQL, and then move over to PostgreSQL, then hit SQLite before finishing up with Microsoft SQL Server. This is a bundle course of four of my other popular courses.
These databases are four of the greatest databases to learn, and learning has never been this easy! They’re the most popular and in demand for a reason! Let’s learn some databases!
What you’ll learn
- Understand how to use MySQL Databases With Python
- Understand how to use PostgreSQL Database with PgAdmin 4
- Understand how to use SQLite Databases With Python
- Understand and Use Microsoft SQL Server
- Understand the basics of what a Database can do
- You’ll Learn How To Create a Database and Table
- How to put data in and take data out
- How to update and delete data from the database
- How to explore what’s in the database whenever you want
- How to create basic reports with the data from your database
Table of Contents
Introduction
1 Introduction
2 First Things First How To Get Support Fast!
Using MySQL Databases With Python
3 Introduction
4 Create A Database
5 Create A Table
6 Insert One Record Into Table
7 Insert Many Records Into Table
8 Understanding Data Types
9 Select Data From Table
10 Format Our Results
11 The Where Clause
12 The Like Clause and Wildcards
13 Using AND and OR
14 What Is A Database
15 Updating Records
16 Limit and Ordering
17 Delete Records
18 Delete (Drop) A Table And Backups
19 Install Python
20 Install Git Bash Terminal
21 Download MySQL
22 Install MySQL and Workbench
23 Install MySQL Connector
24 Connect to Database in Python
25 Explore MySQL Workbench
Intro To PostgreSQL Databases With PgAdmin For Beginners
26 Introduction
27 PostgreSQL AND OR NOT
28 PostgreSQL Order By
29 PostgreSQL Insert Into
30 PostgreSQL Update
31 PostgreSQL Delete
32 PostgreSQL Limit
33 pgAdmin Menu Walkthru
34 PostgreSQL Foreign Keys
35 PostgreSQL Inner Join
36 PostgreSQL Join Where Hack
37 Installing pgAdmin and PostgreSQL
38 PostgreSQL Delete Table
39 PostgreSQL Import and Export Tables
40 PostgreSQL Backup and Restore Database
41 What Is A Database
42 pgAdmin Overview
43 Create Table Columns
44 Add Data To A Table
45 PostgreSQL Select Statements
46 PostgreSQL Where Clause
47 PostgreSQL Wildcards
Intro To SQLite Databases for Python Programming
48 Introduction
49 Primary Key ID
50 Where Clause
51 Update Records
52 Delete Records
53 Order Results By
54 And Or
55 Limiting Results
56 Drop Table
57 Our App – Show All Function
58 Our App – Add A Record Function
59 Install Python
60 Our App – Delete a Record Function
61 Our App – Add Many Records Function
62 Our App – Where Clause Function
63 Install Sublime Text And Git Bash Terminal
64 Create SQLite Connection
65 Create A Database Table
66 Insert One Record Into The Table
67 Insert Many Records Into The Table
68 Query and Fetchall
69 Format Results
Learn SQL With Microsoft SQL Server
70 Introduction
71 Adding Data To A Table
72 Intro To SQL
73 Select Statements
74 Where Clause
75 And or Not
76 Order By
77 Group By
78 The Having Clause
79 The Top Clause
80 Select Distinct
81 Database Concepts
82 Union
83 Functions
84 Insert Statement
85 Update Statement
86 Delete Statement
87 Alter Table
88 Null
89 Creating A Table
90 Drop Table
91 Primary Key
92 Data Types
93 Intro To Joining Tables
94 Inner Join
95 Left, Right, and Outer Join
96 Indexing
97 Download and Install SQL Server
98 SQL Server Download Update
99 Download and Install SSMS
100 Connect To Server
101 System Databases
102 Creating a Database and Table
Conclusion
103 Bonus Lecture
Resolve the captcha to access the links!