動画検索
関連広告
検索結果
Introduction
Why learn SQL?
What is SQL?
What is a database?
Relational database management systems
Install Microsoft SQL Server
Install SQL Server Management Studio
Connect to server
Object Explorer
Restore sample database
Tables
Primary keys
Database diagrams
Data types
Select
Filtering with where
Inner join & outer join
Order by
Functions including getdate, sum, count
Group by
Bonus: Query designer
Wrap up
SQL Full Course
Introduction to DBMS
Basics: SQL Tables
Installation of SQL Server
Creating a table in SQL
Select Statement Syntax in SQL
Functions in SQL
Statements in SQL
Except Operator in SQL
Views in SQL
Types of user-defined Functions
Case Statement in SQL
Exception Handling in SQL
Types of DBA
Editions of SQL Server
SQL Server System Databases
Recovery Models
Backup models in SSMS
SQL Server OS Related DMV's
Starting Activity Monitor
Ensuring Data Integrity
Fragmentation
How to become an SQL Developer
SQL vs MySQL
SQL Interview Questions & Answers
Start
Introduction
Introduction to SQL
Installing SQL Server
SQL Keyword Command Language and Hierarchy
Connecting to a SQL Database
Creating and Saving a Query
Using One or More Query Conditions
Applying AND OR Operators
NULL NOT NULL
Range of Values
Querying Data Using Wildcard Characters
Formatting Query Data Results
Performing Date Calculations - DateDifDateAdd
Summarizing Data Using Aggregate Functions AVG COUNT SUM min max
Manipulating Text Results with String Functions CONCAT_SUBSTR
Sorting Data Order BY and GROUPBY
RANK and HAVING
Mathematical Financial Expressions
PIVOT
JOIN
Union ALL
Except Clause
Sub Queries
Conclusion
Welcome
What is SQL
The Basics
Comparisons
Wildcards
Alias: AS
Operations
Aggregation
NULL Values
JOINS
Practice Problem 5
Setup PostgreSQL
Data Types
Manipulate Tables
Date Functions
Problem Problem 6
SubQueries and CTEs
Practice Problem 7
Practice Problem 8
About the Project
Query 1 - Top Paying Jobs
Query 2 - Top Paying Job's Skills
Query 4 - Top Paying Skills
Query 5 - Most Optimal Skills
Share on LinkedIn
0. SQL is King
1. The Legend of Ted Codd
2. ORM Magic
3. What is a RDBMS?
4. Draw SQL Diagrams
5. Schemas, Datatypes, & Constraints
6. Be Normalized
7. Install MySQL on Windows/Mac
8. Create a New Database
9. SQLTools VS Code Extension
10. --comments
11. Basic SQL Syntax
12. Primary Key
13. Varchar vs Text
14. INSERT New Data
15. Read or SELECT Data
16. LIMIT & ORDER
17. Filtering with WHERE
18. LIKE pattern matching
19. INDEX for read speed
20. JOIN a relationship
21. Alias AS
22. JOIN through a middle man
23. DROP a video
Introduction to SQL Full Course
Agenda
What is SQL
Basic SQL Queries
Normalization in SQL
Triggers in SQL
Joins in SQL
Functions in SQL
Stored procedure
SQL vs MySQL
SQL vs NoSQL
SQL Interview Question & Answers
PostgreSQL
SQL Command Categories
ER Diagram
Constraints in Database
Normalization
DML Commands
Joins in SQL
Views in SQL
DCL Commands
Features of SQL Server
DDL Commands in SQL
Operators
SQL Server Interview Question & Answer