Ending In:
$1,600
97% off
Courses
8
Lessons
169
Courses
8
Lessons
169
What's Included
SQL for Beginners with Microsoft SQL Server Database
$200 Value
SQL Fundamentals for Marketing, Digital & Web Analytics
$200 Value
Master C# & SQL by Building Applications
$200 Value
MySQL Database Development Mastery
$200 Value
Modern PHP Web Development with MySQL, GitHub & Heroku
$200 Value
Professional Azure SQL Managed Database Administration (Third Edition)
$200 Value
PostgreSQL 13 Cookbook
$200 Value
Snowflake Cookbook
$200 Value
Product Details
Access
Lifetime
Content
2.0 hours
Lessons
26
SQL for Beginners with Microsoft SQL Server Database
A Step-by-Step Practical Guide for Learning SQL & Microsoft SQL Server
By Packt Publishing | in Online Courses
SQL is a powerful tool you can use to manage your data. This course will teach you how to extract data on your own and give you the confidence to use SQL with Microsoft SQL Server to pull data for conducting marketing analysis without relying on anyone.
4.8/5 average rating:
★ ★ ★ ★
★
- Access 26 lectures & 2 hours of content 24/7
- Know the difference between the query language & the databases
- Understand the SQL Server Structure
- Learn how to insert & delete values in a table using SQL Statements
Packt Publishing | Tech Knowledge in Motion
4.0/5 Instructor Rating:
★ ★ ★ ★
★
Packt’s mission is to help the world put software to work in new ways, through the delivery of effective learning and information services to IT professionals. Working towards that vision, it has published over 4,000 books and videos so far, providing IT professionals with the actionable knowledge they need to get the job done–whether that’s specific learning on an emerging technology or optimizing key skills in more established tools.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop or mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: beginner
- Updates included
- Have questions on how digital purchases work? Learn more here
Requirements
- Basic computer skills
- Basic understanding of marketing
- Basic understanding of marketing, web or digital analytics
Course Outline
Your First Program
Introduction
- Introduction - 1:47
- Installing the SQL Server - 3:01
- Understanding the SQL Server Structure - 4:25
- What is Normalization? - 4:26
- Restoring a Backup Database with AdventureWorks - 3:39
Finding Data in the Database
- SQL Query to Select Data from a Table - 12:39
- Selecting Top N records - 5:04
- Narrowing Down the Result Set with the WHERE Clause - 7:20
- Pattern Matching Using LIKE in the WHERE Clause - 4:46
- Specifying Multiple Values from a Column Using IN in the WHERE Clause - 5:05
- Sorting the Result Set - 4:48
- Selecting a Unique Result Set - 3:08
- Joining Multiple Tables to Get the Desired Result Set - 10:25
- Using Aliases in SQL - 7:38
- Aggregating the Data in SQL - COUNT, MIN, and MAX - 12:57
- Aggregating the Data in SQL - SUM and AVG - 4:05
- Identifying Null Values Using an Aggregate function - 3:52
- Using Aggregate Functions in the WHERE Clause - 4:04
Manipulating Data Using the SELECT Statement
- Combining Multiple Columns and String Values - 4:39
- Extracting Characters from a String - Learn LEFT, RIGHT, and SUBSTRING Functions - 5:19
- Finding the Length of a String/Column and Position of a Character in a Column - 3:57
Other Key SQL Statements
- Inserting Values in a Table Using SQL Statements - 5:03
- Updating Records in a Table Using SQL Statements - 4:45
- Deleting Records from a Table Using SQL Statements - 3:26
- Outer Join - Left and Right - 7:06
Conclusion
- Conclusion - 0:16
Access
Lifetime
Content
1.0 hours
Lessons
22
SQL Fundamentals for Marketing, Digital & Web Analytics
Pull Data for Conducting Marketing Analysis Using SQL
By Packt Publishing | in Online Courses
Marketers and digital analysts generally depend on tools or the IT department to help them pull data for marketing decisions. This video course will teach you how to extract data on your own, enabling you to use SQL confidently to pull data for conducting marketing analysis independently.
4.5/5 average rating:
★ ★ ★ ★
★
- Access 22 lectures & 1 hour of content 24/7
- Write your first statement to select the data
- Learn how to use numeric & data values
- Discover how to aggregate the data to do sum & count
Packt Publishing | Tech Knowledge in Motion
4.0/5 Instructor Rating:
★ ★ ★ ★
★
Packt’s mission is to help the world put software to work in new ways, through the delivery of effective learning and information services to IT professionals. Working towards that vision, it has published over 4,000 books and videos so far, providing IT professionals with the actionable knowledge they need to get the job done–whether that’s specific learning on an emerging technology or optimizing key skills in more established tools.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop or mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: beginner
- Updates included
- Have questions on how digital purchases work? Learn more here
Requirements
- Any device with basic specifications
Course Outline
- Introduction
- Introduction - 1:20
- Installation and Overview of SQL environment
- Installing MySQL - 3:35
- MySQL interface - 1:22
- Database Fundamentals
- How databases are structured - 3:09
- Understanding a schema in MySQL - 2:58
- Selecting the data
- Write your first statement to select the data - 2:39
- Narrowing down your result set with WHERE clause - 5:33
- Sorting your result set - 4:01
- Using Numeric and Date Values to narrow down your result set - 3:25
- Other key SQL statements
- Adding new records to the database - 1:07
- Updating existing records - 3:23
- Deleting records - 3:41
- Some advanced select statements
- Aggregating the data to do sum and count - 4:32
- Joining multiple tables to get the desired result set - 6:44
- Marketing use cases
- Who are the top or bottom customers? - 7:31
- How many products do we have in each category? - 5:09
- Using data from the database in other programs
- Exporting data to CSV or Excel file - 2:04
- Connecting with Data Visualization Tool (Tableau) - 3:18
- Database manipulation
- Creating a table - 11:11
- Few more table manipulation commands - 8:53
- Importing data from a CSV file - Example uses Affiliate data - 2:58
- Importing data from Excel to MySQL - 4:04
Access
Lifetime
Content
6.0 hours
Lessons
54
Master C# & SQL by Building Applications
Become a Better Software Developer by Learning How to Build Real-World Applications
By Packt Publishing | in Online Courses
C# forms the backbone of many popular video games and web, mobile, and desktop applications, while SQL is essential for database creation and management. So much can be achieved in the world of technology if both C# and SQL are merged. This video course will teach you how to bring C# and SQL together to build robust real-world applications. By the end of this course, you’ll have developed the essential C# and SQL skills needed to build real-world applications.
4.4/5 average rating:
★ ★ ★ ★
★
- Access 54 lectures & 6 hours of content 24/7
- Create an application database & tables
- Define SqIConnection, SqICommand, & SqIDataReader
- Master the application commands
- Learn how to create a worksheet creator
Packt Publishing | Tech Knowledge in Motion
4.0/5 Instructor Rating:
★ ★ ★ ★
★
Packt’s mission is to help the world put software to work in new ways, through the delivery of effective learning and information services to IT professionals. Working towards that vision, it has published over 4,000 books and videos so far, providing IT professionals with the actionable knowledge they need to get the job done–whether that’s specific learning on an emerging technology or optimizing key skills in more established tools.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop or mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: beginner
- Updates included
- Have questions on how digital purchases work? Learn more here
Requirements
- Any device with basic specifications
Course Outline
- Welcome
- Introduction to the Course - 1:16
- Setup
- Downloading and Installing the Visual Studio 2019 Community - 4:06
- Downloading and Installing the SQL Server 2019 - 2:09
- Downloading and Installing SSMS 18 - 4:11
- Customer Order Viewer
- Customer Requirements - 2:44
- SQL Server Database Objects - 2:59
- Creating an Application Database and Tables - 11:30
- Giving Values to Tables - 4:20
- Quick Side Note - 8:22
- SQL Views - 1:47
- Creating an Application View - 7:17
- Exploring the Server Explorer - 4:19
- What is SqlConnection? - 4:10
- What is SqlCommand? - 1:34
- What is SqlDataReader? - 3:32
- Creating the Application Models - 5:02
- Creating the Application Commands - 18:58
- Putting Everything Together and Testing - 9:05
- Customer Order Viewer 2.0
- Customer Requirements - 0:27
- SQL Alter - 1:04
- Altering a Table - 4:23
- SQL UDDT and SPROCs - 2:11
- Creating the Application UDDT and SPROCs - 21:47
- Creating More SPROCs - 3:01
- What is Dapper? - 0:42
- Creating the Application Models - 6:22
- Creating the Application Commands - 12:48
- Putting Everything Together and Testing - 24:34
- Course Report Emailer
- Customer Requirements - 1:50
- Creating an Application Database and Tables - 2:20
- Giving Values to Tables - 0:52
- Creating an Application View - 3:01
- Creating the Application SPROC - 3:00
- Creating the Application Models - 4:38
- Creating the Application Commands - 6:09
- What is JSON? - 8:17
- What is DataTable? - 6:26
- What is Open XML SDK? - 1:30
- Creating the Worksheet Creator - Part I - 16:10
- Creating the Worksheet Creator - Part II - 10:53
- Creating the Emailer - 9:30
- Putting EverythingTogether and Testing - 6:54
- Course Manager
- Customer Requirements - 0:41
- Altering the Needed Table - 2:37
- Creating the Application SPROCs - 12:28
- What is WPF and XAML? - 1:51
- What is MVVM? - 4:33
- Cleanup and Creating the Startup - 11:49
- Creating the Application Models - 2:47
- Creating the Application Commands - 12:28
- Using Mockup to Create View - 15:15
- Enhancing the ViewModel - Part I - 12:57
- Enhancing the ViewModel - Part II - 16:44
- Putting Everything Together and Testing - 11:25
Access
Lifetime
Content
4.0 hours
Lessons
25
MySQL Database Development Mastery
Learn Fundamental Database Development Techniques with MySQL Server & MySQL Workbench
By Packt Publishing | in Online Courses
MySQL is a database that is used by the biggest social media platforms, such as Facebook, Twitter, and YouTube. Thanks to its performance, reliability, and ease-of-use, MySQL has become one of the most popular open-source databases. This course will help you get to grips with the fundamentals of the two most powerful MySQL assets—MySQL Server and MySQL Workbench—for effectively designing and maintaining databases.
4.5/5 average rating:
★ ★ ★ ★
★
- Access 25 lectures & 4 hours of content 24/7
- Explore the concepts of manipulating data & tables with MySQL queries
- Discover how to connect, create, & remove a database
- Insert data into the table using SQL scripts & Workbench
- Learn how to select, update, & delete data in the table
- Understand the importance of relationships, foreign keys, & normalization in MySQL
Packt Publishing | Tech Knowledge in Motion
4.0/5 Instructor Rating:
★ ★ ★ ★
★
Packt’s mission is to help the world put software to work in new ways, through the delivery of effective learning and information services to IT professionals. Working towards that vision, it has published over 4,000 books and videos so far, providing IT professionals with the actionable knowledge they need to get the job done–whether that’s specific learning on an emerging technology or optimizing key skills in more established tools.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop or mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: beginner
- Updates included
- Have questions on how digital purchases work? Learn more here
Requirements
- Any device with basic specifications
Course Outline
- Introduction
- Introduction to MySQL Server and its Databases - 6:33
- Downloading and Installing MySQL and MySQL Workbench - 12:23
- Manipulating Tables and Data – CRUD Operations
- Creating and Connecting to a Database - 12:50
- Dropping or Removing a Database - 3:40
- Creating an SQL Database Table - 22:59
- Inserting Data into the Table with an SQL Script - 8:49
- Inserting Data into the Table with Workbench - 9:04
- Selecting Data from the Table with an SQL Script - 8:09
- Selecting Data with Filters - 19:53
- Updating Data in the Table - 8:33
- Deleting Data from the Table - 10:20
- Reverse Engineering a Database into a Model - 6:54
- Forward Engineering a Data Model into a Database - 11:44
- Relationships and Foreign Keys
- What are Relationships, Foreign Keys, and Normalization? - 10:49
- Creating Relationships with Data Modelling - 15:28
- Creating Relationships with the Workbench Table Design Tool - 20:24
- Inserting Records in Related Tables - 8:55
- Running Queries on Related Tables (INNER JOIN) - 15:21
- LEFT, RIGHT, and CROSS JOINS - 7:07
- Aggregate Functions
- Grouping Data using the SQL GROUP BY Clause - 9:52
- SQL AVG Aggregate Function - 9:00
- SQL COUNT Aggregate Function - 7:45
- SQL MIN and MAX Aggregate Functions - 2:53
- SQL SUM Aggregate Function - 5:18
- Splitting Groups Using the HAVING Clause - 4:33
Access
Lifetime
Content
6.0 hours
Lessons
39
Modern PHP Web Development with MySQL, GitHub & Heroku
Be Well-Versed with PHP & Build a Data-Driven Web Application
By Packt Publishing | in Online Courses
With PHP, you can easily develop a robust web application in no time. Even non-programmers and beginners find PHP a great tool to get started with web development. This course will take you through the process of building an amazing web application in PHP. By the end of this course, you will be well-versed in PHP and will have developed the essential skills needed to build a data-driven web application.
4.7/5 average rating:
★ ★ ★ ★
★
- Access 39 lectures & 6 hours of content 24/7
- Install Visual Studio Code on your machines
- Build your own GitHub & Heroku account
- Discover how PHP works
- Learn the steps for publishing a website to Heroku
Packt Publishing | Tech Knowledge in Motion
4.0/5 Instructor Rating:
★ ★ ★ ★
★
Packt’s mission is to help the world put software to work in new ways, through the delivery of effective learning and information services to IT professionals. Working towards that vision, it has published over 4,000 books and videos so far, providing IT professionals with the actionable knowledge they need to get the job done–whether that’s specific learning on an emerging technology or optimizing key skills in more established tools.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop or mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: beginner
- Updates included
- Have questions on how digital purchases work? Learn more here
Requirements
- Any device with basic specifications
Course Outline
- Introduction
- Introduction - 5:54
- Environment Configuration
- Setting up the PHP Environment using XAMPP - 15:39
- Installing Composer Package Manager - 2:59
- Visual Studio Code - Web Development Add-ons - 11:31
- Creating a GitHub Account - 13:01
- Creating a Heroku Account - 8:02
- PHP Basics and Syntax
- How PHP Works? - 28:53
- If...Else Statements - 18:55
- Switch Statements - 9:07
- For Loop - 10:27
- While and Do...While Loops - 14:20
- PHP Arrays and Manipulation - 13:21
- String Manipulation Functions - 55:24
- Date and Time Manipulation Functions - 14:56
- User Defined Functions - 44:30
- PHP Include and Require - 22:08
- PHP Website Layout - With Bootstrap - 22:48
- Adding a Project to GitHub - 8:24
- Publishing a Website to Heroku - 20:09
- PHP Forms and MySQL and User Authentication
- Project and Website Setup - 20:52
- Creating a Bootstrap 4 Form
- PHP Form - $_GET Action
- PHP Form - $_POST Action
- Designing a Database with phpMyAdmin
- Connecting to a Database using PHP Data Objects (PDO)
- Saving Records to Database
- Viewing Database Records
- Viewing Record Details
- Updating Database Records
- Deleting Database Records
- Final Touches: Form Validation, Error Messages, Success Messages
- Adding a Project to GitHub
- Creating Heroku App and a Remote Database
- Setting up Authentication Tables in a Database
- Setting up Login and Authentication
- Controlling User Access
- Sending Confirmation Emails
- Uploading Profile Pictures
- Final Touches
Access
Lifetime
Content
1.0 hours
Lessons
1
Professional Azure SQL Managed Database Administration (Third Edition)
Master Your Skills to Efficiently Manage & maintain Data on the Cloud
By Packt Publishing | in Online Courses
Despite being the cloud version of SQL Server, Azure SQL Database and Azure SQL Managed Instance stands out in various aspects when it comes to management, maintenance, and administration. Updated with the latest Azure features, Professional Azure SQL Managed Database Administration continues to be a comprehensive guide for becoming proficient in data management.
By the end of this book, you will have mastered the key aspects of an Azure SQL database and Azure SQL managed instance, including migration, backup restorations, performance optimization, high availability, and disaster recovery.
4.2/5 average rating:
★ ★ ★ ★
★
- Access 1 lecture & 1 hour of content 24/7
- Master the key aspects of an Azure SQL database & Azure SQL
- Manage & scale multiple SQL databases using elastic pools
- Implement a disaster recovery solution using standard & active geo-replication
- Explore the key features of databases
Packt Publishing | Tech Knowledge in Motion
4.0/5 Instructor Rating:
★ ★ ★ ★
★
Packt’s mission is to help the world put software to work in new ways, through the delivery of effective learning and information services to IT professionals. Working towards that vision, it has published over 4,000 books and videos so far, providing IT professionals with the actionable knowledge they need to get the job done–whether that’s specific learning on an emerging technology or optimizing key skills in more established tools.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop or mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: beginner
- Updates included
- Have questions on how digital purchases work? Learn more here
Requirements
- Any device with basic specifications
Course Outline
- Professional Azure SQL Managed Database Administration - Third Edition
- Professional Azure SQL Managed Database Administration - Third Edition
Access
Lifetime
Content
1.0 hours
Lessons
1
PostgreSQL 13 Cookbook
Build & Design Efficient Databases for Your Application
By Packt Publishing | in Online Courses
PostgreSQL has become the most advanced open-source database on the market. This book follows a step-by-step approach, guiding you effectively in deploying PostgreSQL in production environments. By the end of this book, you’ll be well-versed with the essential PostgreSQL 13 features to build enterprise relational databases.
4.6/5 average rating:
★ ★ ★ ★
★
- Access 1 lecture & 1 hour of content 24/7
- Learn how to manage a PostgreSQL cluster
- Explore replication features for high availability
- Build your own secure PostgreSQL server
- Learn how to perform PostgreSQL upgrades during downtime
Packt Publishing | Tech Knowledge in Motion
4.0/5 Instructor Rating:
★ ★ ★ ★
★
Packt’s mission is to help the world put software to work in new ways, through the delivery of effective learning and information services to IT professionals. Working towards that vision, it has published over 4,000 books and videos so far, providing IT professionals with the actionable knowledge they need to get the job done–whether that’s specific learning on an emerging technology or optimizing key skills in more established tools.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop or mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: beginner
- Updates included
- Have questions on how digital purchases work? Learn more here
Requirements
- Any device with basic specifications
Access
Lifetime
Content
1.0 hours
Lessons
1
Snowflake Cookbook
Acquire the Necessary Skills to Start Implementing Snowflake Based Solutions
By Packt Publishing | in Online Courses
Snowflake is a unique cloud-based data warehousing platform built from scratch to perform data management on the cloud. This book introduces you to Snowflake's unique architecture, which places it at the forefront of cloud data warehouses. By the end of this Snowflake book, you will be well-versed in Snowflake's architecture for building modern analytical solutions and understand best practices for solving commonly faced problems using practical recipes.
4.5/5 average rating:
★ ★ ★ ★
★
- Access 1 lecture & 1 hour of content 24/7
- Discover how Snowflake allows extensive scaling through the virtual warehouses
- Learn how to configure a virtual warehouse for optimizing cost & performance
- Discover how Snowflake integrates with other technologies for staging & loading data
- Create modern data solutions & pipelines designed to provide high performance and scalability
Packt Publishing | Tech Knowledge in Motion
4.0/5 Instructor Rating:
★ ★ ★ ★
★
Packt’s mission is to help the world put software to work in new ways, through the delivery of effective learning and information services to IT professionals. Working towards that vision, it has published over 4,000 books and videos so far, providing IT professionals with the actionable knowledge they need to get the job done–whether that’s specific learning on an emerging technology or optimizing key skills in more established tools.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop or mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: beginner
- Updates included
- Have questions on how digital purchases work? Learn more here
Requirements
- Any device with basic specifications
Terms
- Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.