Get started with SQL if you haven't yet! And explore SQL queries using the ever popular Microsoft SQL Server.
While Database management is a complicated process, SQL is the cost-efficient database management system. With this powerful and easy-to-use query language, tackle large datasets efficiently.
It has gained popularity in the recent years because of its dynamic and rich analytical capabilities. With this course, get a solid foundation in SQL and design efficient flexible database. Learning Database Development with SQL will help web- and back-end developers create robust SQL relational databases from scratch. This is a useful skill to have when wanting to create web-based applications.
This course will introduce them to all the fundamental and essential concepts of SQL. From designing your database to creating a simple web-application that stores data in a SQL database, learn all the quintessentials with ease. All examples are created by using SQL Server, an open-source RDBMS that can run on many platforms. We start off with a brief introduction to databases and database designs. We will swiftly move on to the fundamentals of SQL server and SQL and help you in creating their own relational databases.
This is the ideal course you need, to get a started with most highly in-demand skills--SQL and database management! Take your first step towards becoming a database administrator or a data analyst today.
Data is a collection of facts and statistics and database is a collection of data. This video helps you get a firm understanding of the components of SQL. Here is what is in store for you:
Now that you have understood the background of SQL, let's learn some of the additional advantages of the same. Here is what is in store for you:
In this video, you will understand how you can start working with database entities and software:
Now that you have understood the representation of all the database entities, let's learn some of the granular concepts of the same:
Now that you have understood all the components of database tables, let's learn some of the additional concepts with regards to the data stored in a database:
Now that you have understood the additional concepts of a database, let's learn how to actually play with data by carrying import and export operations over tables:
We attempt to build a database for the Atlas University, where the students can register for different courses provided by the university. In this video, we will:
Entity-relationship models and entity-relationship diagrams both represent data in our database. Often they are considered the same and misunderstood. In this video, we will:
Normalization is a very integral part of a good database design. In this video, we will:
To know more about SQL Server and its components, please refer the support files provided under the code download section. Learn the different types/ways to log into your SQL Server. Here is what is in store for you:
Now that you know how to log into your database, let's further move on the creation and selection of a database. With this video, we cover the following topics:
After getting a hang of creating and selecting a database, let's learn how to take a backup and restore the database:
SQL is a language that can be used to create, update, and delete data in a database table. This video will talk about the syntax and comments in the structured query language. Here is what is in store for you:
Now that you have understood the background of SQL syntax and comments, let's learn how to implement the same to create tables:
In this video, you will understand how you can create and add constraints to the database to maintain the consistency:
Now that you have understood the consistency constraints and SQL queries, let's learn some more SQL queries such as update and delete. In this video, we will:
Packt has been committed to developer learning since 2004. A lot has changed in software since then - but Packt has remained responsive to these changes, continuing to look forward at the trends and tools defining the way we work and live. And how to put them to work.
With an extensive library of content - more than 4000 books and video courses -Packt's mission is to help developers stay relevant in a rapidly changing world. From new web frameworks and programming languages, to cutting edge data analytics, and DevOps, Packt takes software professionals in every field to what's important to them now.
From skills that will help you to develop and future proof your career to immediate solutions to every day tech challenges, Packt is a go-to resource to make you a better, smarter developer.
Packt Udemy courses continue this tradition, bringing you comprehensive yet concise video courses straight from the experts.