SQL Archives - WHUZZUP!

[#Script #Coding] A Day in the Life of freeCodeCamp U.S. Staff (A rare in-person meeting)

Posted on Friday April 7, 2023Friday April 7, 2023 by Eric Brooks

A Day in the Life of freeCodeCamp U.S. Staff (A rare in-person meeting)

By freeCodeCamp.org
Published: Mar 07, 2023

“
This web programming course from Harvard University picks up where CS50x leaves off. It dives more deeply into the design and implementation of web apps with Python, JavaScript, and SQL using frameworks like Django, React, and Bootstrap. Topics include database design, scalability, security, and user experience. You will learn how to write and use APIs, create interactive UIs, and leverage cloud services like GitHub and Heroku.

Slides, source code, and more at
https://cs50.harvard.edu/web/2020/

Brian Yu teaches this course.

Watch the original CS50x course: https://youtu.be/8mAITcNt710

Course Contents

(00:00:29) Introduction

(00:02:42) Lecture 0: HTML, CSS

(02:06:14) Lecture 1: Git

(02:59:29) Lecture 2: Python

(04:07:10) Lecture 3: Django

(05:46:15) Lecture 4: SQL, Models, and Migrations

(07:40:21) Lecture 5: JavaScript

(09:31:46) Lecture 6: User Interfaces

(11:12:01) Lecture 7: Testing, CI/CD

(12:45:59) Lecture 8: Scalability and Security

Learn to code for free and get a developer job: https://www.freecodecamp.org

Read hundreds of articles on programming: https://freecodecamp.org/news

[READ MORE]

”

[#Script #Coding] SQL Database App with Windows GUI – Project Tutorial

Posted on Wednesday March 22, 2023Wednesday March 22, 2023 by Eric Brooks

SQL Database App with Windows GUI – Project Tutorial

By freeCodeCamp.org
Published: Mar 16, 2023

“
Learn how to design and use databases. You will create a graphical Windows application with C# that can display and modify data from a mySQL database server.

You need Microsoft Windows to follow along.

@shadsluiter is your instructor for this course. He is a Professor Of Computer Science and Software Development at Grand Canyon University.

Professor Sluiter has more courses here: http://studycoding.org

Contents

Course Outline

Create a new database in mySQL

How to write sql queries

Create a GUI front end app

Create a Data Access Object and connect to a database

Query the database

Add a picture box to display album art

Insert new records into the database

Create a second table and a foreign key

Table joins part a

Table joins part b

Design with UML and ER diagrams

Perform compound select actions

Delete data from a table

Add a video player to the app

Extended Features

(0:00:00) Introduction

(0:04:33) Tools we’ll need

(0:08:49) Creating a new database

(0:12:16) Saving the data

(0:16:04) How to fill in a table

(0:20:26) Select star from albums

(0:23:44) How to delete backticks

(0:27:16) Intro to the series

(0:34:40) How to delete the backticks

(0:37:49) Building the database app

(0:42:22) Start of the demo

(0:46:33) Creating an album class

(0:51:19) Adding two albums to the list

(0:55:11) Connecting the database to the database

(0:58:08) Where does the data source live?

(1:04:42) Setting up the database

(1:07:53) Running the app

(1:10:37) How to create searches

(1:13:55) Programming the new search button

(1:18:12) The problem with parameter queries

(1:21:56) Adding a picture to the screen

(1:26:12) How to test the problem

(1:30:45) Adding new records to the database

(1:39:22) Adding an integer to the database

(1:43:27) Adjusting the column titles

(1:46:13) Execute non-query query

(1:49:06) Creating a foreign key

(1:51:47) Install mysql workbench

(1:55:05) Connecting to the database

(1:59:04) Configuring the tracks table

(2:06:49) We have a problem with Mamp synchronization

(2:10:01) Inserting data into the tracks table

(2:13:08) Selecting items from the database

(2:16:46) Changes to the definition of tracks

(2:20:55) Fixing the problem with the binding source

(2:24:12) Foreign keys and joins

(2:27:36) Selecting from the table

(2:31:15) Changing the query using a join

(2:39:10) Uml diagrams for our current application

(2:41:58) Associative vs aggregation

(2:45:47) Introduction to compound queries

(2:49:53) Fetching the list of all tracks

(2:53:03) Using the delete statement to delete tracks

(2:56:35) The problem with converting an integer to an integer

(3:00:33) Deleting a track by deleting its Id

Learn to code for free and get a developer job: https://www.freecodecamp.org

Read hundreds of articles on programming: https://freecodecamp.org/news

[READ MORE]

”

[#Script #Coding] Harvard CS50’s Web Programming with Python and JavaScript – Full University Course

Posted on Friday March 10, 2023Sunday March 12, 2023 by Eric Brooks

Harvard CS50’s Web Programming with Python and JavaScript – Full University Course

By freeCodeCamp.org
Published: Mar 08, 2023

“
This web programming course from Harvard University picks up where CS50x leaves off. It dives more deeply into the design and implementation of web apps with Python, JavaScript, and SQL using frameworks like Django, React, and Bootstrap. Topics include database design, scalability, security, and user experience. You will learn how to write and use APIs, create interactive UIs, and leverage cloud services like GitHub and Heroku.

Slides, source code, and more at https://cs50.harvard.edu/web/2020/

Brian Yu teaches this course.

Watch the original CS50x course: https://youtu.be/8mAITcNt710

Course Contents

(00:00:29) Introduction

(00:02:42) Lecture 0: HTML, CSS

(02:06:14) Lecture 1: Git

(02:59:29) Lecture 2: Python

(04:07:10) Lecture 3: Django

(05:46:15) Lecture 4: SQL, Models, and Migrations

(07:40:21) Lecture 5: JavaScript

(09:31:46) Lecture 6: User Interfaces

(11:12:01) Lecture 7: Testing, CI/CD

(12:45:59) Lecture 8: Scalability and Security

Learn to code for free and get a developer job: https://www.freecodecamp.org

Read hundreds of articles on programming: https://freecodecamp.org/news

And subscribe for new videos on technology every day: https://youtube.com/subscription_cent…

[READ MORE]

”

[#Script #Coding] NoSQL vs SQL – Which Type of Database Should You Use?

Posted on Tuesday December 27, 2022Tuesday December 27, 2022 by Eric Brooks

NoSQL vs SQL – Which Type of Database Should You Use?

By freeCodeCamp.org
Published: Sep 13, 2022

“
When should you use RDBMS, and when should you use NoSQL?
This course describes the differences between NoSQL and SQL databases as well as when and why to use each kind of database.

Register for a free Astra DB account to use for this tutorial: https://astra.datastax.com/register/s…

Ania Kubow developed this course. Check out her channel: https://www.youtube.com/aniakubow

DataStax provided a grant to made this course possible.

SQL Tutorial – Full Database Course for Beginners on FreeCodeCamp: https://www.youtube.com/watch?v=HXV3z…

NoSQL Database Tutorial – Full Course for Beginners on FreeCodeCamp: https://www.youtube.com/watch?v=xh4gy…

Apache Cassandra Database – Full Course for Beginners on FreeCodeCamp: https://www.youtube.com/watch?v=J-cSy…

Everything You Need to Know About Storage Attached Indexing in Apache Cassandra | DataStax: https://www.youtube.com/watch?v=D9CUk…

Enough CQL To Get You Started – Data Modeling with Apache Cassandra | DataStax: https://www.youtube.com/watch?v=mhHM3…

Contents

Introduction (0:00)

01: What actually is a database (2:17)

03: What is a database management system (5:53)

04: Demo: Creating a database (6:27)

05: Common Database Models (9:21)

06: Relational databases (9:46)

07: SQL (11:33)

08: Non-relational databases (16:33)

09: Pros and Cons: Comparing RDBMS and NoSQL (19:21)

10: Wide Column Database (31:25)

11: Document Database (47:38)

12: Key-Value Database (1:03:51)

13: Multi-Model Databases (1:21:57 )

Use cases: When to use RDBMS or NoSQL (1:23:12)

[READ MORE]

”

[#Script #Coding] SQL Server Performance Essentials – Full Course

Posted on Wednesday December 21, 2022Wednesday December 21, 2022 by Eric Brooks

SQL Server Performance Essentials – Full Course

By freeCodeCamp.org
Published: May 17, 2022

“
In this course, Essentials of SQL Server Performance For Every Developer, you will see how to diagnose what is happening with a slow running SQL statement and what strategies are available to make these statements run faster.

By the end of this course, you as an application developer will have the tools you need to troubleshoot performance problems you may encounter when using SQL Server.

Code, links, Dynamic Views(DMVs), and Database Backups: https://github.com/iCodeMechanic/Esse…

Course from Rajan Arora. Check out his channel: https://www.youtube.com/c/ICodeMechanic

Course Contents

(0:00:00) Introduction

Getting Started

(0:00:53) 1.1 Course Introduction

(0:04:07) 1.2 Why Developers should Understand SQL Performance

(0:06:20) 1.3 Tools you Need

(0:09:30) 1.4 Restore the Sample Database

(0:12:04) 1.5 Table Concept

(0:17:12) 1.6 Index Concept

(0:20:32) 1.7 Summary

Analyzing SQL Statements for Performance

(0:22:12) 2.1 Introduction

(0:24:55) 2.2 Understanding How SQL Server Will Execute a SQL Statement

(0:29:33) 2.3 Reading and Interpreting an Execution Plan for a SQL Statement

(0:39:44) 2.4 Getting Execution Statistics for a SQL Statement

(0:45:29) 2.5 Improving Statement Performance by Adding an Index

(0:52:11) 2.6 Rewriting SQL Statements for Improved Performance

(0:58:32) 2.7 Common Execution Plan Operations

(1:03:50) 2.8 Summary

Building Indexes

(1:07:30) 3.1 Introduction

(1:09:09) 3.2 Index Terminology Refresher

(1:12:11) 3.3 What Should I Index in My Database?

(1:16:16) 3.4 Why Index Column Order Matters

(1:23:39) 3.5 Index Selectivity Explained

(1:36:23) 3.6 LIKE Clauses and Index Selectivity

(1:40:27) 3.7 How Functions in the WHERE Clause Affect Indexes

(1:46:10) 3.8 Include Columns and Covering Indexes

(1:50:40) 3.9 Over-indexing

(1:54:40) 3.10 Interpreting SQL Server Index Recommendations

(1:57:38) 3.11 Summary

Finding Bottlenecks in SQL Server Performance

(2:03:19) 4.1 Introduction

(2:08:36) 4.2 Getting Information About SQL Server Sessions and Resource Usage

(2:12:02) 4.3 Finding What SQL Statements are Currently Executing

(2:18:47) 4.4 Finding the Slowest, Most Expensive SQL Statements

(2:24:13) 4.5 Getting SQL Server’s Recommendations on Missing Indexes

(2:29:38) 4.6 Finding Indexes That are Not Being Used

(2:34:13) 4.7 Summary

Capturing Trace Logs of Application from SQL Server

(2:35:55) 5.1 Introduction

(2:42:03) 5.2 Setting up a SQL Profiler Trace

(2:49:59) 5.3 Running a SQL Profiler Trace

(2:55:22) 5.4 Running a Trace as a Server Side Trace

(3:03:19) 5.5 Introduction to Using Extended Events for SQL Tracing

(3:06:58) 5.6 Setting up an Extended Events Trace Session

(3:16:50) 5.7 Running and Configuring the Display Settings for an Extended Events Trace

(3:20:38) 5.8 Analyzing Extended Events Trace Data

(3:27:10) 5.9 Using Extended Events in SQL Azure

(3:31:36) 5.10 Summary

Apply Common Practices for Better Performance

(3:35:47) 6.1 Introduction

(3:37:17) 6.2 Use Parameterized SQL

(3:42:59) 6.3 Are Stored Procedures Faster Than SQL in Application Code?

(3:43:04) 6.4 Commit Behavior and Performance

(3:50:16) 6.5 Object Relational Mappers Just Generate SQL

(3:53:19) 6.6 Solving the N+1 Selects Problem

(3:59:56) 6.7 Summary

[READ MORE]

”