動画検索
関連広告
検索結果
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
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
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
Introduction
Relational Databases & SQL
Setting up MySQL
Inserting Data into the Table
Practice Exercises
Aggregation, grouping & pagination in SQL queries
Mapping and Arithmetic Functions
Working with Dates
Combining Tables using Joins
Executing SQL queries using Python and SQL Alchemy
3 step approach to Interview Questions
Interview Q - Apple
Interview Q - Linkedin
Interview Q - Meta
Interview Q - Uber
Interview Q - Amazon
Interview Q - Google
SQL Full Course
What is SQL?
What are ER Diagrams
Types of SQL Commands
How to install MYSQL on Windows?
MYSQL built-in functions Explained
How Group by and Having Clauses Work?
Practical demonstration of Group by and having Clause in MySQL
What are Joins in SQL?
What is an Inner Join?
What is Left Join?
What is the Right Join?
What is a Full outer Join?
What is a Subquery?
Triggers in SQL Explained
What are Stored procedures in SQL?
How to use Views in SQL?
How to use SQL with python
Establishing a connection with SQL Database using Python
How to create SQL tables using python
Inserting and Updating data using Python
Querying tables using SQl commands with python
What is PostgreSQL?
How to insert records in PostgreSQL?
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