1 Welcome to the course.mp4 (23.39 MB)
MP4
10 Azure data studio.mp4 (23.98 MB)
MP4
2 What you will learn.mp4 (10.8 MB)
MP4
3 How to learn the course.mp4 (26.12 MB)
MP4
4 SQL server versions.mp4 (24.83 MB)
MP4
5 Install SQL server.mp4 (86.14 MB)
MP4
6 How to set up SQL server in the cloud on Azure.mp4 (94.28 MB)
MP4
7 Install management studio.mp4 (32.56 MB)
MP4
8 Install adventure works.mp4 (32.21 MB)
MP4
9 How to use management studio.mp4 (121.38 MB)
MP4
1 Introduction.mp4 (5.32 MB)
MP4
2 JSON structure and JSON path.mp4 (48.58 MB)
MP4
3 JSON functions.mp4 (30.01 MB)
MP4
4 JSON function and path - examples.mp4 (112.73 MB)
MP4
5 Convert a table to JSON.mp4 (109.96 MB)
MP4
6 Convert JSON to a table.mp4 (58.47 MB)
MP4
1 Course review and what is next.mp4 (25.96 MB)
MP4
1 Introduction.mp4 (13.68 MB)
MP4
10 LIKE function and wildcards.mp4 (28.04 MB)
MP4
11 LIKE function and wildcard – examples.mp4 (56.2 MB)
MP4
12 Order of precedence.mp4 (51.16 MB)
MP4
2 Select data from a table.mp4 (57.64 MB)
MP4
3 Sort selected data.mp4 (77.17 MB)
MP4
4 Data types.mp4 (60.78 MB)
MP4
5 WHERE clause with comparison operators.mp4 (88.91 MB)
MP4
6 Logical operators and NULL values.mp4 (32.45 MB)
MP4
7 Logical operators and NULL values – example.mp4 (64.8 MB)
MP4
8 BETWEEN and IN functions.mp4 (20.85 MB)
MP4
9 BETWEEN and IN function – examples.mp4 (99.22 MB)
MP4
1 Introduction.mp4 (13.97 MB)
MP4
10 Converting data types.mp4 (10.88 MB)
MP4
11 Converting data type - examples.mp4 (149.17 MB)
MP4
12 Decision logic.mp4 (82.59 MB)
MP4
2 Text concatenation and maths operators.mp4 (54.16 MB)
MP4
3 String functions.mp4 (45.08 MB)
MP4
4 String function – examples.mp4 (129.69 MB)
MP4
5 Date functions.mp4 (118.44 MB)
MP4
6 Trigonometric functions.mp4 (28.58 MB)
MP4
7 Trigonometric function – examples.mp4 (34.28 MB)
MP4
8 General maths functions.mp4 (29.19 MB)
MP4
9 General maths function – examples.mp4 (81.4 MB)
MP4
1 Introduction.mp4 (7.08 MB)
MP4
2 Aggregating and grouping data.mp4 (33.2 MB)
MP4
3 Aggregating and grouping data – examples.mp4 (54.98 MB)
MP4
4 Subqueries.mp4 (24.18 MB)
MP4
5 Subquery – examples.mp4 (72.53 MB)
MP4
6 Windows functions.mp4 (36.16 MB)
MP4
7 Windows function – examples.mp4 (144.35 MB)
MP4
1 Introduction.mp4 (6.13 MB)
MP4
10 Union and union all.mp4 (83.05 MB)
MP4
2 Primary and foreign keys.mp4 (25.06 MB)
MP4
3 Table relationships and cardinality.mp4 (53.89 MB)
MP4
4 Inner join.mp4 (25.1 MB)
MP4
5 Inner join - examples.mp4 (81.5 MB)
MP4
6 Left and right outer joins.mp4 (25.04 MB)
MP4
7 Left and right outer join - examples.mp4 (48.69 MB)
MP4
8 Full outer and cross joins.mp4 (26.45 MB)
MP4
9 Full outer and cross join - examples.mp4 (60.48 MB)
MP4
1 Introduction.mp4 (4.42 MB)
MP4
2 OLTP and normalisation.mp4 (59.92 MB)
MP4
3 OLAP and star and snowflake architecture.mp4 (36.43 MB)
MP4
1 Indroduction.mp4 (23.13 MB)
MP4
10 Foreign key constraints.mp4 (115.47 MB)
MP4
11 Indexes.mp4 (154.73 MB)
MP4
12 CTE's (common table expressions).mp4 (142.96 MB)
MP4
2 Databases - create and drop.mp4 (64.11 MB)
MP4
3 Schemas - create and drop.mp4 (53.12 MB)
MP4
4 Tables - create and drop.mp4 (89.5 MB)
MP4
5 Columns - add, alter, and drop.mp4 (109.9 MB)
MP4
6 Column constraints – create.mp4 (93.99 MB)
MP4
7 Column constraints – alter.mp4 (66.44 MB)
MP4
8 Column constraints – drop.mp4 (22.56 MB)
MP4
9 Primary key constraints.mp4 (111.48 MB)
MP4
1 Introduction.mp4 (3.86 MB)
MP4
2 Fast track route - restore backup file.mp4 (17.96 MB)
MP4
3 Insert data.mp4 (127 MB)
MP4
4 Update data.mp4 (90.09 MB)
MP4
5 Delete and truncate data.mp4 (62.48 MB)
MP4
1 Introduction.mp4 (11.78 MB)
MP4
10 XML.mp4 (77.53 MB)
MP4
11 Trigger introduction and syntax.mp4 (41.3 MB)
MP4
12 Trigger DML example.mp4 (99.6 MB)
MP4
13 Trigger DDL example.mp4 (101.92 MB)
MP4
2 Views.mp4 (56.7 MB)
MP4
3 Stored procedures and parameters.mp4 (96.11 MB)
MP4
4 Stored procedures with return values.mp4 (171.37 MB)
MP4
5 Functions – scalar.mp4 (59.04 MB)
MP4
6 Functions - table valued.mp4 (117.42 MB)
MP4
7 Locks, concurrency, ACID and transactions.mp4 (30.61 MB)
MP4
8 Transactions.mp4 (69.5 MB)
MP4
9 Cursors.mp4 (103.65 MB)
MP4