Σ Sigma Hosting is mainly a video tutorial website

Σ Sigma Hosting is mainly a video tutorial website that make it easier for you to search within the transcript of videos for solutions of problems you might face during your journey in dealing with different webhosting companies. So, we are very sorry if the text is not well organized and we may work on it in the future but for now we hope you get the benefit mainly from the video then you may need to have a look on the transcript. Thanks for your understanding 🙂

are you ready to learn how to create manage and edit databases and Wix wait for it wait for it we've got to do our database dance boom but doot doot doot BAM all right guys quick warning before we jump into it I tend to speak at 80 words per minute with occasional gusts up to 500 words per minute so if you get lost at any point our kindly ask that you rewind rewash it just to make sure you got it and if you still didn't get it go ahead and comment down below so I can help and answer your question but what are we waiting for you're here to learn how to create and manage and edit those databases and Wix so let's jump in oh did you catch me still doing my database dance I'm excited hey listen I know you want to get into the video but I've got one quick ask of you can you go ahead and smash that subscribe button in the bottom right of this video and turn those Bell notifications on why because you'll instantly plug into an amazing wakes nation community of 33,000 plus like-minded entrepreneurs looking to do exactly what you're looking to do which is to grow your presence online build your infrastructure on Wix so you can grow your revenue and increase your impact on the world I know that sounds enticing to you because that's what you're looking to do so smash that subscribe button to be part of a community that's looking to do that same exact thing alright now let's go make some data bases the year is 2020 just like my vision so I'm protecting there with these blue light glasses as we dive into the laptop and on screen in the editor so that's right pull up your editor let's get into it because it's time to start creating databases alright so we're here in the editor now the next question is how do we even activate the tools to allow us to create the database what you're gonna do is you're gonna scroll up here to dev mode and you're gonna turn on dev mode once you turn on dev mode you'll get a nice welcome to corvid video I'm gonna X out because I've been welcomed to corporate I can't count how many times because I've built many sites here and Wix but Corbitt is an awesome tool then what you're gonna notice this is a new feature that Wix has added to increase your productivity and speed at which you create databases manage data databases and edit databases over here on the Left you'll see this little Content Manager go ahead and click on that because this is now where you're gonna be able to manage your databases from that's right no more having to worry about you know pulling out that tree over here on the left with the corporate tools you can still go that route but this route is a little bit cleaner and easier and then you're gonna see three tabs Content Manager add content element and learn more today we're going to be in that Content Manager tab this content manager is where all of your collections or databases are going to be contained what you're going to do to create a database is you're going to go ahead and create new collection when you do that this is going to be the start of the database creation process it will introduce you to content collections and then you're going to press start creating you can either choose a preset or start from scratch let me give you the benefits if you use a preset you'll already get dynamic pages set up ready for you to use with that collection so if you already know you're gonna need dynamic pages with this database you're about to create might as well use the preset and it'll already have the data sets on those pages too however if you're not sure what the destiny of this database looks like for you go ahead and start from scratch it's not hard to add the data set and create a dynamic page literally two clicks but it's completely up to you I'm gonna start from scratch just because we're focusing solely on databases today not dynamic pages when I click start from scratch it will have me create collection first things first you need to name your database make sure you give this database a name that's going to be recognizable to you internally so that way you can say okay this is where my user profile pages are stored okay this is where my new leads are stored whatever that title is make sure it's recognizable to you or anyone on your team internally otherwise you're gonna have to jump through a whole bunch of databases whether that's in your dashboard or any editor trying to remember which one has which content so I'm just gonna title this user profile page and the collection ID this is going to be the ID that's used in the code so you're gonna want to make sure this is unique I recommend just keeping it the same name as the database just know that you won't be able to create another ID for your code that's exactly the same as this one otherwise it'll contradict the code and your code won't work so just keep that in mind once you do that you're going to choose what this collection is used for so what this database used for in this particular case I set user profile page so you can come in here and you can actually set the permissions of your database site content means anyone can view content from this form submission anyone can update or upload content into this database a member generated content this means only members can submit and modify the data members only content means only members can view the data members only form submission means only members can actually upload into the database not edit just upload into the database and then you have private data this is simply for admins only so that means only you will be able to say see the data contained in here and lastly custom use I almost always choose custom use call me crazy because some of these other preset permissions would work perfectly fine but maybe I'm a little anal and I just have to do it myself maybe I don't know maybe that's me but I'm gonna press custom use when I do that it's then gonna have us set up custom permissions this is where you can choose who can read content from this collection since it's a user profile page I'm going under the assumption that this is maybe a social network that someone has to register for in order to access content to view it and to also post it so with that in that in mind who can read content from this collection site members these people have to be registered in order to access the content who can create content site members they have to be registered now this is where it switches a little bit who can update content from this collection I'm gonna choose site member author which means the person that originally created the piece of content is the person that can update it or modify it this is no Wikipedia here that anyone could come in and change Abraham Lincoln's birthday to February 19 2020 god that's not when he's born okay so we're gonna move on from that and we're also gonna choose site member author the same person that originally created the content has the ability to delete the content know as the admin do you have to back in to also view the content as well in the databases but I'm going under the assumption that's this this is some type of membership social network style web site then I'm going to set and create election which is gonna work it's magic like it always does and it pops open our blinked collection here there's nothing in here other than one field which is titled this is a default field within the Wix databases it cannot be removed it cannot be deleted you can use it if you'd like to but it cannot be moved it cannot be deleted and it also won't impact anything either so just because it's in there doesn't mean you have to use it you don't have to use it and you can still display all of your other data perfectly fine no worries it's up to you but once we've got into our database here I want to first draw your attention because this tutorial was about creating a database and then managing and editing the database as well so what I first want to draw your attention to is up at the top you'll see sandbox and you'll see live there is a difference between sandbox and live sandbox is think of it as your testing playground this is your database to test stuff in to see if it works in the editor to make sure you're on track make sure everything is copasetic your live database is where your actual live data lives this is on your publish site whatever data moves into the live database is gonna be published this includes your members as well so any members that register on your published website are gonna be contained in the live database so you need to know the distinction between the two because if you make changes in sandbox and you want them to carry over to live you have to sync them to live and you can sync those changes to live by going over here to this sync button clicking sync and then you'll see your sync options you can copy all items that are in your sandbox database over to live which means everything the sandbox will go to live you can copy only selected items so if you only want a few of the items from your sandbox going to live you can copy a few or you can replace all of your items from live to your sandbox so you can test with live data in its sandbox environment in a testing environment rather than manipulating the live environment that's actually going to real changes to people's data so that's what those are that's how they work you do have the ability to sync but I wanted to draw your attention to that first and foremost now we named this database user profile page I'm going to go under the assumption and you can add as many or as little fields as you want in a Wix database however I'm going under the assumption we're going to have a few key fields for a profile page and Wix name profile picture bio and well those are the three I'm gonna go forth name profile picture bio we're not creating the dynamic page in here so we don't have to go all elaborate I'm showing you strictly how to use this so with that said to create your first field what you're gonna do is you're gonna press add field this little plus button you're then going to name the field make sure you name the field something that you can recognize internally that is clearly indicating what type of data is in that field I'm gonna name this full name the field type it is going to be a text field why because people are entering their name that is text that's nothing else is no other media content type and then we're gonna press add perfect now we've got our full name we're gonna press add again because we want them to upload a profile picture I'm gonna name this field profile picture the field type on this is not going to be text it is going to be image and we are gonna press add why because they're uploading an image of themselves a profile picture and then lastly we are going to add bio that's not how you spell bio but this is you can have this be a text field if you want just know that however you display the text on your dynamic page and whatever text styling you do on the dynamic page is gonna be how the bio looks if you want to give more control to the actual content user or the member themselves as far as styling those between fonts bolding italicizing s– media stuff like that you would change it to rich text in rich text I'll show you right here if you double-click on this view in the database you can see you have styling options to actually style the content which is still text the text in this particular field so you can go ahead and change the sizing of the font the color of the font the boldness highlighting you can link you can create bullets you can shift alignment you can do all those things with rich text with a regular text field you cannot so that's how I would tell you to note that so that's important to know then just for some reference if we look at some of the field types a couple of other types of fields you can enter our reference fields this is where you'll reference another database so data from another database and you're referencing it this is typically when you get a little bit more sophisticated and you've got lots of databases working together that's where reference field comes into play a number this would be like a phone number you know monthly budget number in that sense address this is a physical address it'll pull from Google Maps if you get the API key from Google which you can do either way it'll still pull location audio straightforward this is audio files boolean's this is like little check boxes yes no those are boolean's date and time it's literally a date and time picker it's actually a pretty intuitive for a bus looking feature on which people can pick a date and time for instance if you wanted people to go through your checkout process and schedule a delivery date and time there you go key features file this can be like a PDF that's a file image we just did image media gallery this could be you know pictures in a gallery rich text we just did that tags this is pretty cool you can create unique tags so people can click one tag and then see all the content related to that particular tag in the database on a page down time again straightforward so maybe people can schedule a delivery day time or they can just schedule a time with you that's time-related then you have URL straight forward this is a link and then lastly video they can upload video into the database however right now only works in a strip and that's about the only use you can go about creating and uploading videos from YouTube and Vimeo and looking making it look more native if you follow my tutorial up in the card there but those are all the different field types in the database that you can add so right now we've created the database I've kind of showed you how to manage edit the database a little bit what I wanted to next draw your attention to is import/export so import/export over here on the right you can actually import data from a file so from like an Excel document if you've got already all of these fields matched up fields name field names matched up to what they already are in your database in a whole excel doc you can save yourself a whole lot of time rather than manually updating that data just import your excel doc and it'll pull all the data and put it all range into the columns for you or you can export so if you want to take the data that you've been collecting from your Wix database and pull it out so that way you can review it in Excel and have more data manipulation and data analysis you can do that as well so that's another thing to take into account you can always change the permissions of your database by clicking back on this permissions tab if you right realize hey this is not the type of permissions I want I want anybody to be able to view the content you would simply come back in here and change this to anyone and then press save and then your permissions are updated hooks this gives a little bit more complicated you can use hooks to pull from custom JavaScript we're not going to get into that in this particular video and then you've got visible fields over here so you see right now ID owner created a updated date these are all fields that are not currently visible if you wanted to make them visible you just simply check them on and these are internal Wix fields so Wix tracks this information when was the data created when was the data unedited who's the owner of that data what's the ID of that owner that has that data and those are all fields that are tracked by which but typically aren't displayed you can display them if you want after that you can sort your data so you can sort from eight as you can sort of short from Z to a you can sort from newest to oldest or you can add a custom sort and then in addition to that you can filter data so you can add a filter you can choose a field maybe you want to choose full-name and you want full name contains Michael and then if we had any Michael's in this database when we press add filter what would happen is the database would only display people with the full name that contains Michael in it and you would see all the Michaels in your database and that's how you filter the database so overall we've created our database we managed it we're editing it and the last thing I want to show you is another place you can access your database within Wix without having to be in the editor so you've got your database here you're good you're done I'm gonna go ahead and press publish and now what we can do I'm actually going to edit the name of the site to edit testing DB and I'm gonna press check done and then I'm gonna go ahead and publish that puppy again now what we can do is we can actually access our database from our Wix dashboard as well so if we go into our Wix dashboard for our particular site that we've just created instead of having to go into the editor every time you want to create well actually you have to go in the editor usually to create but instead of having to go in the editor to manage and edit data all the time what you can do is from your dashboard you can actually scroll down and you can see database on this left sidebar you can click it and then you'll see and it's got a new gallery view which is kind of cool you'll see all of your current content manager and all of your collections all of your databases in here and you can actually open the collection straight from your dashboard you can alter also a filter between your live in your sandbox database know by default when you enter through the Wix dashboard it is going to your live database so if you want to make sure you manipulate from sandbox click sandbox however you have to manage your sandbox in the edit it's only the live database that you'll be able to manipulate from your dashboard but you can choose to view all the data in here and you can see it's the same type of style as in the dashboard and you can choose to manage fields you can change the view if you want it to be more of a list or a gallery you can do that or you can keep it as a table and you can even add new database items by going up here or you can import or export from the live database as well and just like that that is how you create manage and update databases and Wix let's get our database dance on in a like button down below because we're a high-energy and this was a helpful video and now you feel inspired and motivated to go out there and make it happen we're out database database there you have that we just created edited and manage databases in Wix my name is MPs from Wix training academy I appreciate you watching this video if you enjoyed it I would ask that you drop the like down below you saw that some of my words had gusts up to 500 words a minute so if you didn't catch something or you need some clarification comment down below and lastly I would kindly ask if this is a community Wix nation that you'd like to be a part of that you smash that subscribe button right down in the bottom right this video that's right take your mouse there to do hit that subscribe button the bottom rights not hard to do when I upload fun quality which string and content that's obviously going to benefit you and you'll plug into thirty two thousand plus like-minded entrepreneurs looking to do exactly what you're looking to do which is to grow your presence online build your infrastructure on Wix so you can increase your revenue and increase your impact on the world sounds pretty awesome to me I'm not sure about you thanks again for watching I'll catch you on our next one .

Video Discription

How To Create, Manage & Edit Corvid Databases in Wix | Wix Corvid Tutorial | In this video I’m going to show you how to create, manage and edit databases in Wix. We are going to go through step-by-step on how to create your Wix database, manage the data in the database and edit your Corvid databases.

Corvid by Wix is a powerful interface built into the Wix editor that will allow you to accomplish things like creating databases, building custom registration and login sequences and even building social networks in Wix.

Video Outline:
-Database Dance
-Creating Your Database in Wix
-Managing Corvid Database Permissions
-Adding & Editing Fields in Wix Databases
-Difference Between Sandbox & Live Databases in Wix
-Accessing Your Wix Database From Your Dashboard

After building many databases in Wix and discovering the process entailed to create some sophisticated elements, I wanted to share my knowledge with you!

Grow your revenue & Increase your impact on the world

VIDEO & CHANNEL RESOURCES:

Sign up to your Free Wix Training Academy here:

BECOME A WIX NATION INNER CIRCLE MEMBER (LIMITED TO 10):

GET YOUR WIX ACCOUNT & HOSTING:

MUST-HAVE TOOL FOR YOUTUBE CHANNELS:

Watch more videos on my Wix Training Academy YouTube Channel:

WIX TRAINING + DIGITAL ENTREPRENEUR PLAYLISTS:

"Wix Ecommerce: The Ultimate Guide To Building An Online Store in Wix:

“Building A Social Network in Wix: The Non-Coding Founder's Guide”:

“Corvid by Wix Training Tutorials”:

“Wix My Website”:

“Ascend by Wix: Training Tutorials”:

NEW TO THE CHANNEL? START BY WATCHING THESE VIDEOS:

“Open Q&A”:

“8 Underrated Wix Features You Probably Don't Know About ”:

“5 Ways To Obtain Funding For Your Business”:

“How to Create Wix Code Databases & Dynamic Pages: Wix.com”:

“Wix My Website Welcome Video”:

__________

CONSULTING: Want to work 1-on-1 with MPS to work through online business strategy, Wix strategy or YouTube strategy? We are now accepting applications for new clients. You can apply here:

DONE FOR YOU WEB DEVELOPMENT. Want to have a professional website developed? I am now accepting applications for new clients. I specialize in Corvid/Wix Code Development projects on Wix. If you'd like to hire me for your project, you can submit your application here:
——————–
Stay Connected:
Email: info@wixmywebsite.com
Twitter:
Subscribe:
Hire Michael:

MPS Message: I wanted to make sure you are aware that this video description contains affiliate links. It is completely up to you whether you utilize these links. Just know that if you use these links, there is no difference to you, but it does partially support this channel 🙂